Endless Power - Effortlessly
SQL for ArcGIS® Pro delivers effortless access to a world of spatial data - your world - within an integrated system that features point and click ease to hundreds of functions. Data that powers decisions, wealth creation and success in today's world is spatial data
and SQL for ArcGIS Pro delivers the seamless capability to manage and understand that data. Never before has so much power with such outstanding ease of use been so affordable:
"The interface is just superb, albeit with the usual short learning curve. (It's way easier than photoshop)" - Forum post
Enjoy Parallel Speed
Fast GIS is fun GIS, the faster the better. SQL for ArcGIS Pro is built upon Manifold's massively parallel Radian® spatial database platform, by far the world's richest, fastest and most powerful desktop spatial data engineering engine. Radian technology guarantees phenomenal power and speed even with big data and all with bulletproof reliability. Running in Advanced mode with native storage, SQL for ArcGIS Pro never crashes.
Combining in seconds 4.3 GB of separate cadastral drawings for 17 counties: "What is most impressive for me is not the 40 sec to do the merge but the ~15 min it took me to figure out what to do, import the shp files and put in a map, have some confidence IDs and indexing capability are there to bring in more data fields later, and press the button to do the merge. Even if GDAL or ArcGIS merge as fast it would take me forever to figure out how to do it with them." - Forum post
Running in Advanced mode to work in native storage, data in an SQL for ArcGIS Pro project is fast. Really fast. No need to wait minutes for a large table, image or drawing to display. SQL for ArcGIS Pro opens 100 GB images instantly and allows you to pan and zoom effortlessly with zero delay. Likewise with very large vector datasets such as drawings or maps where SQL for ArcGIS Pro opens the project instantly and will render a huge drawing in seconds when other systems take minutes. As you zoom in SQL for ArcGIS Pro will render scenes instantly.
No need to risk safe workflow by hesitating to save a project because you know it will take a long time. You can open a 100 GB project, make extensive changes and then save the project instantly as well. The project is already saved before your finger comes up off the click of the mouse.
"Perfect!!!! Incredibly easy with [SQL for ArcGIS Pro]. I found a way to do it in a different package. It took an hour just to understand the process. [SQL for ArcGIS Pro] took 5 mins from start to finish." - Forum post
SQL Intelligence for Easy Connections
SQL for ArcGIS Pro applies a treasure trove of knowledge, experience and street-smart savvy when connecting to hundreds of different database servers, web data sources, file databases and file formats. With a point and a click the data you want is accessed and available to you because SQL for ArcGIS Pro knows the tricky details involved in so many different sources. Several different file formats use the same three-letter extension? No problem, as SQL for ArcGIS Pro can tell them apart and will automatically use the right dataport to connect.
SQL for ArcGIS Pro knows basically all projections everywhere. Automatic support for thousands and thousands of different coordinate systems, all of EPSG and a seeming infinity of others has all your needs covered. SQL for ArcGIS Pro also uses parallel processing to re-project data on the fly, even read-only data, to show data in different projections together at the same time when visualizing data in Advanced mode. Automatically. No need to alter the source data.
The image above shows terrain elevation data for the Mount St. Helens volcano crater region in Latitude / Longitude mixed with two different a Google image server layers in pseudo-Mercator. Everything lines up perfectly. SQL for ArcGIS Pro does it all for you. Automatically.
Raw Speed Makes it Easy
Fast is easy and slow is hard. Just say no to slow. SQL for ArcGIS Pro automatically uses every CPU and every CPU core in your system for CPU parallelism and if you have a GPU will automatically apply GPU acceleration to run massively parallel computations using thousands of GPU cores. SQL for ArcGIS Pro always runs parallel for maximum possible speed. It's the fastest SQL you've ever seen on a desktop, so fast it runs rings around python scripts.
No Need to Learn Parallel Programming
Run parallel code without learning anything about how to code parallel algorithms. SQL for ArcGIS Pro automatically applies CPU parallelism everywhere, using every CPU core you have in every statement, every operator and every function. SQL for ArcGIS Pro also revolutionizes the use of massively parallel GPU acceleration by automatically parallelizing SQL both for CPU parallelism and GPU paralleism. GPU acceleration works everywhere in SQL where worthwhile work arises: in the SELECT list, in WHERE, in EXECUTE, ...everywhere. You don't have to learn programming environments like CUDA. Use the same SQL you already know and SQL for ArcGIS Pro automatically parallelizes it to use GPGPU. If you don't have a GPU SQL for ArcGIS Pro automatically falls back to CPU parallelism with no need to edit code or change any SQL. It's all automatic.
Automatic, Dynamic Previews - See before you Do
Using the Select or Transform panes in Advanced mode, see what a point-and-click template or an SQL expression will do before you commit the change. Visual previews throughout SQL for ArcGIS Pro - tables, images, drawings, maps - prevent errors and wasted workflow. The images above show how a point and click Buffers template is previewed in
bluepreview color in a map. As we change buffer settings in the transform dialog the preview in the map automatically changes. Besides avoiding errors, that makes it easy to pick exactly the right buffer setting for what we want to do.
SQL for ArcGIS Pro provides lavishly illustrated documentation that explains the entire system with hundreds of step-by-step, illustrated examples. Screenshots and diagrams make it easy to understand and apply sophisticated concepts.
"I’m using and loving [SQL for ArcGIS Pro]!!!" - Forum post
SQL for ArcGIS Pro Writes SQL for You
You know those "Hello, World" moments when you really would like to see how it's done in a new system, to learn how to cut through infrastructure and do what you want? SQL for ArcGIS Pro makes that easy for you by automatically writing SQL to show you how it's done.
Want to see how a point-and-click template works? Click the Edit Query button and SQL for ArcGIS Pro launches a command window loaded with the SQL the template executes so you can see what functions are being used. It's a live query, so you can customize the SQL as you like or copy and paste into new queries.
virtuoso Spatial SQL Functions
SQL for ArcGIS Pro provides every tool you need to blend, transform, analyze and manipulate the world's most complex spatial data in a flash. SQL for ArcGIS Pro's sophisticated parallelized spatial operators, like topology and spatial overlays, work with mixed objects, pathological geometry and do not require special data cleaning or simplification before use. Hundreds of specialized SQL functions are waiting for you patiently on the shelf, tucked unobtrusively out of the way but bristling with power, ready to work for you when your SQL calls them into play.
Scripting Built In
Every SQL for ArcGIS Pro installation includes support for 10 different programming languages, so scripting is always at your fingertips. SQL for ArcGIS Pro automatically provides programming in C#, JScript, JScript.NET, VB.NET and VBScript that are part of SQL for ArcGIS Pro's Microsoft environment, with IronPython and IronRuby automatically added to SQL for ArcGIS Pro menus when installed. SQL for ArcGIS Pro also supports F#, PerlScript and PythonScript when installed.
See Everything - All the Web Sources
The world's spatial data - your spatial data - hangs out in a host of database servers, file databases, web server sources and file formats. SQL for ArcGIS Pro connects to them all, including multiple sources at the same time. Better still SQL for ArcGIS Pro connects automatically to a vast range of web servers that provide data and images on the fly. Petabytes of data - at your beck and call. SQL for ArcGIS Pro connects to geocoding servers for geocoding addresses. SQL for ArcGIS Pro connects to image servers to provide street maps and satellite imagery, like Bing, Google, Here, NearMaps, OpenStreet Maps, WikiMapia, MapQuest and Yandex. SQL for ArcGIS Pro connects to hundreds of thousands of servers using protocols like ESRI ArcGIS REST, ECWP, OSM, TMS, WFS, WMS and WMTS. Use SQL for ArcGIS Pro and see the world.
Formatting On the Fly
SQL for ArcGIS Pro can format and style images and drawings on the fly, even from read-only web servers like Bing and Google. Combine and manipulate channels, apply hill shading and automatically calculate statistics and intervals to apply palettes to images. Apply thematic formatting to drawings all without changing the data.
Install one package and you have it all at your fingertips. No need to buy expensive extras or to struggle to integrate separate products. SQL for ArcGIS Pro includes everything, right out of the box. All the extras are already built-in. Launch SQL for ArcGIS Pro and you can do it all right away.
SQL for ArcGIS Pro was built from the ground up by a single, professional team as a totally seamless and superlatively complete package that saves you time and money. No need to figure out a jigsaw puzzle of quirky packages and no need to spend days playing software developer. Total integration and legendary Manifold quality set you free to focus on your business.
Feel at Home
SQL for ArcGIS Pro speaks your language. The ui.zip file provides a collection of localization files created by users. It includes files for Arabic, Bengali, Chinese (simplified, Mandarin), Dutch, Estonian, Filipino (Tagalog), French, German, Hindi, Japanese, Portuguese, Russian, Spanish, and Turkish languages. See the localization page for how to install. It's easy to add a new language!
"I have started to finally put v9 in my work and I must say "WOW" at least 10 times a day. It just keeps getting better and better." - Forum post
"I am currently doing some computer vision work and am using [SQL for ArcGIS Pro] for non-GIS work. I just want to say that it works extremely well. I was using it yesterday to read json files and [SQL for ArcGIS Pro] pulls them in and converts them to useful tabular format better than any of the other tools that I use. [SQL for ArcGIS Pro] also has always been in my toolkit for cleaning up messy attribute tables. It is more heavy duty than ms-access and has a lot of additional functionality. Just a shout-out to the team. Thanks for your good work!" - Forum post
"... when I said "Radian is much faster than PostgresSQL with uncomplicated SQL." I was thinking about the time I spend trying to get PostgresSQL server working rather than how fast queries work. When I succeed I find [simple queries] work similarly fast if key field indexes are set up in both... For dweebs like me having to run a database server on your home computer is daunting so a program that has its own database functionality internal and local is much faster in terms of real effort time." - Forum post
"If PGAdmin or Spatialite had just what [SQL for ArcGIS Pro] has in it now in terms of GUI, it would be transformational. Simply stated, [SQL for ArcGIS Pro] offers something that doesn't exist in the GIS field (or better yet, spatial analytics field - or maybe data mining field)." - User post on beta forum.
Buy Now via the Online Store
Buy SQL for ArcGIS® Pro on the Online Store. The store is open 24 hours / seven days a week / every day of the year. Orders are processed immediately with a serial number sent out by email in seconds. Enjoy the world's best desktop spatial SQL today!
Manifold® products deliver quality, performance and value in the world's most sophisticated, most modern and most powerful spatial products for SQL, GIS, ETL, DBMS, and Data Science. Total integration ensures ease of use, amazing speed, and unbeatably low cost of ownership. Tell your friends!