Radian Studio


Some Templates

  • Absolute Value
  • Areas
  • Arithmetic Functions
  • Aspect
  • Logarithms
  • Bessel Functions
  • Between
  • Binary Functions
  • Blur
  • Boolean Functions
  • Bounds
  • Branch
  • Buffer
  • Ceilings
  • Center Functions
  • Compare Order
  • Complementary Error Function
  • Compose Circle
  • Compose GML
  • Compose GeoJSON
  • Compose Point with Z
  • Compose Point
  • Compose Rectangle
  • Compose Segment
  • Compose Triangle
  • Compose WKT
  • Concatenate
  • Convert to Area
  • Convert to Line
  • Convert to Point
  • Convex Hull
  • Date Functions
  • Decompose to Branches
  • Decompose to Coordinates
  • Decompose to Segments
  • Direction Blur
  • Direction Edges
  • Distance
  • Edges
  • Enclosing Box
  • Error Function
  • Escape, JSON
  • Exponent
  • Floors
  • Fractional Parts
  • Gamma Function
  • Gaussian Blur
  • Geoms with Curves
  • Geoms with Z
  • Hyperbolic Trig
  • Hypotenuse
  • Is NULL
  • Is not NULL
  • JSON Array
  • JSON Boolean
  • JSON Number
  • JSON Object
  • JSON String
  • Length
  • Like
  • Linearize
  • Log-gamma Function
  • Lower Case
  • Merge Areas
  • Merge Lines
  • Merge Points
  • Modulo
  • Multiply
  • Negate
  • Noise
  • Normalize Topology
  • Normalize
  • Number of Branches
  • Number of Characters
  • Number of Coordinates
  • Number of Regexp Matches
  • Orthogonalize
  • Pad Functions
  • Parse GML Coordinate System
  • Parse GML
  • Parse GeoJSON Coordinate System
  • Parse GeoJSON
  • Parse WKB
  • Parse WKT
  • Points
  • Power Functions
  • Reciprocal Cube Root
  • Reciprocal Square Root
  • Regexp Match
  • Remove Curves
  • Remove Z
  • Replace Regexp
  • Reverse Text
  • Rotate
  • Round
  • Scale
  • Segmentize
  • Set Z
  • Sharpen
  • Shift
  • <
  • Slope
  • Smooth
  • Subtract
  • Tangent
  • Text Contains
  • Text Cut
  • Text Ends with
  • Text Matches Regexp
  • Text Position, Nth
  • Text Position
  • Text Sounds like
  • Text Starts with
  • Text at End
  • Text at Start
  • Title Case
  • Translate Characters
  • Trigonometry
  • Trim
  • Truncate
  • Unescape JSON
  • Union Areas
  • Union Boxes
  • Upper Case
  • Vector Value
  • Voronoi Diagram
  • and many more...

Spatial SQL

The Wonders of SQL

Spatial and Non-Spatial Data

Data that powers decisions, wealth creation and success in today's world is not your grandfather's data: today you need seamless capability to manage and understand data in the context of location - spatial data. Classic database engines are great for traditional data but they lack features and architecture required by today's spatial data. Classic DBMS cannot match the power, convenience and performance of Radian machinery purpose-built to master spatial data demands.

It's a Database World

Far more than just a client, the Radian engine provides a massively powerful database and SQL query engine built for large, complex transactions characteristic of spatial data and spatial data engineering. The Radian SQL query engine and database were created from the ground up for automatic, massive parallelism in everything. Radian's raw speed and massively parallel performance to keep up with big data servers as a client and to accomplish spatial engineering magic on the desktop in seconds or minutes and not hours or days with today's spatial data. You cannot glue such power onto legacy software: it must be designed in and built as an integrated system from the very first line of code.

Our Kind of Data

The Radian database engine was designed from the ground up to handle spatial data in all the forms you will need: vector data, raster data, curvilinear objects, Z data, multichannel data and any pixel type. Specialized infrastructure, like an exceptionally rich selection of dedicated indexes, guarantees the fastest possible pipeline between parallel data access and massively parallel algorithms. Radian's SQL query engine optimizes automatically for the special needs of spatial data types and parallel algorithms. It's all under the hood so when you step on the gas the system roars. Point it where you want to go and Radian does the rest.

Be Friends with Everybody

The world's spatial data - your spatial data - hangs out in a host of database servers, file databases, web server sources and file formats. Radian connects to them all. Better still Radian connects to and works with multiple sources. Transfer and blend data from multiple sources at once. Write SQL in Radian to move data directly from PostgreSQL into SQLite:

SELECT * INTO [sqlite_connection]::[roadtable]
FROM [postgres_connection]::[public.roads]

Everything is Exposed

Radian exposes all aspects of data manipulation to the database. All metadata and properties, all tiles and geometry, every pixel and every coordinate system, every attribute, every property, every bit of metadata, all of it is at your fingertips to manipulate with SQL or with dialogs. Extensive functions for coordinate systems and other infrastructure make it easy to hammer vast quantities of data into exactly the form you desire, with surgical precision. Complex formatting applied to one image that you want in another? Easy - copy and paste the style value from one to the other in the metadata table. Use a dialog, cobble up some SQL or call a script to do that for thousands of images at once. Everything is possible.

Everything is Parallel

Automatically use every core

Superior spatial database engineering requires parallel power, and parallelism cannot be glued on to non-parallel code. It has to be built-in from the ground up. Radian was created from the ground up as an always-on, fundamentally parallel system. The Radian database engine is a parallel engine and Radian SQL automatically runs parallel by default. That's what the THREADS statement specifies, how many THREADS to launch. By default it is what the SystemCpuCount() function reports, the total number of CPUs and CPU cores available. 32 cores? Radian uses them all.

Supercomputer Speed with GPU

GPU acceleration works everywhere in Radian SQL where worthwhile work arises: in the SELECT list, in WHERE, in EXECUTE, ...everywhere. For example, if you add to a table a computed field that combines multiple tiles together, that computed field will use GPGPU. If you do some tile math in a FUNCTION, that FUNCTION will use GPGPU as well.

You don't have to write something special or learn programming environments like CUDA. Use the same SQL you already know and Radian automatically parallelizes it to use GPGPU.

When you write something like SELECT tilea + tileb ∗ 5 + tilec ∗ 8 FROM ..., the Radian engine takes the expression with three additions and two multiplications, generates GPGPU code for that function in a Just In Time, JIT manner and uploads the resulting code to GPGPU to execute the computations. Radian will often do in seconds what takes non-Radian software minutes or even hours.

Pluggable Scripts

Mix and match scripts with SQL to achieve any task: Radian includes built-in V8 Javascript, C#, JScript, JScript.NET, VB.NET and VBScript plus automatic support for IronPython, IronRuby, F#, PerlScript and PythonScript when installed. Write a function in C# and call it from SQL. Launch a query within a Python script. Use whatever is easiest and works for you.

virtuoso Spatial Functions

Whatever your tool does not provide you get to write yourself. Radin provides every tool you need to blend, transform, analyze and manipulate the world's most complex spatial data in a flash. Radian'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 Radian 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.

Our Place or Yours?

Execute queries that mix and match Radian functions and SQL with what an external query engine can do: Use Radian within Oracle or vice versa. Radian slices queries for dispatch where you want.

"Yes, I shall take credit as being the first living human to ever do this (I feel just like Neil Armstrong, or Rosa Parks). OK, that's a bit of stretch :-) But, think about what we are doing: 1. I've written a SQLite/spatiaLite query (it could have easily been PostGIS, Oracle, SQLServer) [...] 2. I am selecting the result of the SQLite query and combining it with a Radian spatial function. 3. The result is being selected back into a SQLite table. This is an excellent example of how Radian really can be a Rosetta Stone to all the different packages out there, in a truly unique way. What other product can pull this off ?" See the video at this blog link: One of the coolest GIS features I’ve ever seen

Location, Location, Location

Automatic support for over 6500 different coordinate systems and over 1500 coordinate system transformations, including all of EPSG and numerous other spatial reference systems. SQL and Template functions provide full convertability between GeoJSON, WKB, WKT, GML and other systems as well as extensive support for parallelized coordinate system transformations for rasters and vectors.

Perfect Precision

Exceptionally high precision coordinate system and base coordinate system transformations including all standard high precision routines used worldwide.

Radian 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? Radian 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 Radian 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.

SQL Everywhere

You can use snippets of SQL everywhere in Radian. When a point-and-click combo box allows you to pick a field you can write an SQL expression into that combo box to customize what the dialog does.

Maybe we want to copy a value into a field from a Date field but instead of copying the Date we want to copy the day of the month, but as a text value. No problem - we write CAST(DateTimeDay([Date]) AS NVARCHAR) into the combo box instead of simply choosing the Date field. We not only get the day of the month, we also CAST it into text form.

Nothing is Too Complicated

If you are doing computations Radian massively parallel GPU power is fast. Really fast. Gains are usually from 20 times faster to 100 times faster running typical computations on low end, dirt cheap GPU cards. Running complex computations on faster cards, performance is often 100 to 200 times faster than using CPU alone. It's fairly common to do in a second or two what takes more than five minutes without Radian.

If your time is worth more than minimum wage and you're doing anything that requires your machine to think at a higher level than your coffee pot timer, you'll often pay back the cost of a Radian license the first time you use it for anything serious. It's that fast. Nothing else comes close.

Why does this page have a photo of Sainte Chapelle? Because Sainte Chapelle is perfect, the highest and best implementation of Gothic aspirations in architecture. Radian SQL is like that too - not perfect like Sainte Chapelle, but for spatial work head and shoulders above all else and devoted to honoring the mighty idea that is SQL. Try it and see if you agree.


Buy Now via the Online Store

Buy Manifold products on the Online Store. The store is open 24 hours / seven days a week / every day of the year. Orders are processed immediately with serial number email sent out in seconds. Use Manifold products today!

 Click to begin shopping


The Big List

Tired of "spatial" SQL products that provide a handful of functions? That's not Radian. Radian has you covered for every possible need with a vast selection of SQL statements, operators and functions. Manifold's spatial experts with decades of experience in spatial engineering have provided everything that everyone from a novice to maximum expert will want, all neatly organized within the query builder with easy filtration to find just the right function for a task. Following is the big list of most, but not all, of what you get in SQL with Radian.

  • ALTER
  • ADD PROPERTY
  • DROP PROPERTY
  • ALTER TABLE
  • ADD
  • ADD CONSTRAINT
  • ADD INDEX
  • DROP
  • DROP CONSTRAINT
  • DROP INDEX
  • RENAME
  • RENAME CONSTRAINT
  • RENAME INDEX
  • CREATE
  • PROPERTY
  • CREATE DATASOURCE
  • CREATE ROOT
  • CREATE TABLE
  • CONSTRAINT
  • INDEX
  • ASC/DESC
  • COLLATE
  • CASE/NOCASE
  • ACCENT/NOACCENT
  • SYMBOLS/NOSYMBOLS
  • TILEREDUCE
  • DELETE FROM
  • DROP ROOT
  • DROP TABLE
  • EXECUTE WITH
  • FUNCTION
  • ENTRY
  • ENTRYSCHEMA
  • INSERT INTO
  • PRAGMA
  • PRAGMA PUSH
  • PRAGMA POP
  • RENAME TABLE
  • SELECT
  • DISTINCT
  • COLLECT
  • WHERE
  • ORDER BY
  • OFFSET
  • FETCH
  • INTO
  • GROUP BY
  • BATCH
  • THREADS
  • UNION EX /INTER
  • UPDATE
  • USE CHILD
  • USE PARENT
  • VALUES
  • MOD
  • DIV
  • BITNOT
  • BITAND
  • BITOR
  • BITXOR
  • LIKE
  • BETWEEN
  • IN
  • IS NULL
  • NOT
  • AND
  • OR
  • XOR
  • CAST
  • CASTV
  • CASE WHEN
  • CASE
  • EXISTS
  • Avg
  • Corr
  • Count
  • Covar
  • CovarPop
  • First
  • GeomMergeAreas
  • GeomMergeLines
  • GeomMergePoints
  • GeomUnionAreas
  • GeomUnionBoxes
  • JoinAnd
  • JoinBitAnd
  • JoinBitOr
  • JoinBitXor
  • JoinOr
  • JoinXor
  • Last
  • Max
  • Median
  • Min
  • StDev
  • StDevPop
  • StringJoinTokens
  • Sum
  • Var
  • VarPop
  • Abs
  • Acos
  • Acosh
  • Asin
  • Asinh
  • Atan
  • Atan2
  • Atanh
  • BinaryWkbGeom
  • Cbrt
  • Ceil
  • CeilDecs
  • Chr
  • Coalesce
  • Collate
  • Compare
  • ComponentCoordSystem
  • ComponentName
  • ComponentPath
  • ComponentProperty
  • ComponentType
  • CoordConvert
  • CoordConvertPoint
  • CoordConvertPoint3
  • CoordConvertTile
  • CoordConvertTrace
  • CoordConverterIsIdentity
  • CoordConverterIsScaleShift
  • CoordConverterIsXYZ
  • CoordConverterMake
  • CoordConverterSteps
  • CoordDatum
  • CoordDatumDefault
  • CoordDatumEpsg
  • CoordDatumParameters
  • CoordDatums
  • CoordSystem
  • CoordSystemDefault
  • CoordSystemDefaultLatLon
  • CoordSystemEpsg
  • CoordSystemOverride
  • CoordSystemParse
  • CoordSystemParseEpsg
  • CoordSystemParseOverrides
  • CoordSystemParseSrid
  • CoordSystemParseSridSubtype
  • CoordSystems
  • CoordSystemTypeParameters
  • CoordSystemTypes
  • CoordTransform
  • CoordTransformEpsg
  • CoordTransforms
  • CoordTransformTypeParameters
  • CoordTransformTypes
  • CoordUnit
  • CoordUnitByName
  • CoordUnitDefault
  • CoordUnitDefaultLatLon
  • CoordUnitEpsg
  • CoordUnits
  • Cos
  • Cosh
  • DataLength
  • DateTimeDay
  • DateTimeHour
  • DateTimeMillisecond
  • DateTimeMinute
  • DateTimeMonth
  • DateTimeSecond
  • DateTimeYear
  • Erf
  • Erfc
  • Exp
  • Exp10
  • Exp2
  • Expm1
  • Floor
  • FloorDecs
  • Fract
  • FractDecs
  • GeocodeAddress
  • GeocodeAddressMatches
  • GeocodeAddressSupported
  • GeocodeLocationMatches
  • GeocodeLocationSupported
  • GeomAdjacent
  • GeomArea
  • GeomBounds
  • GeomBox
  • GeomBranch
  • GeomBranchCount
  • GeomBranchFirst
  • GeomBranchLast
  • GeomBuffer
  • GeomCenter
  • GeomCenterInner
  • GeomCenterWeight
  • GeomClip
  • GeomContains
  • GeomConvertToArea
  • GeomConvertToLine
  • GeomConvertToPoint
  • GeomConvexHull
  • GeomCoordCount
  • GeomCoordXY
  • GeomCoordXYZ
  • GeomDistance
  • GeomDistancePoint
  • GeomDistancePoint3
  • GeomGml
  • GeomHasCurves
  • GeomHasZ
  • GeomIntersects
  • GeomIsArea
  • GeomIsLine
  • GeomIsNormalized
  • GeomIsPoint
  • GeomJsonGeo
  • GeomLength
  • GeomLinearize
  • GeomMakeCircle
  • GeomMakePoint
  • GeomMakePoint3
  • GeomMakeRect
  • GeomMakeRectDiagonal
  • GeomMakeSegment
  • GeomMakeSegment3
  • GeomMakeTriangle
  • GeomMakeTriangle3
  • GeomMergeAreasPair
  • GeomMergeLinesPair
  • GeomMergePointsPair
  • GeomNormalize
  • GeomNormalizeTopology
  • GeomOrtho
  • GeomOverlayAdjacent
  • GeomOverlayContained
  • GeomOverlayContaining
  • GeomOverlayIntersecting
  • GeomOverlayTopologyIdentity
  • GeomOverlayTopologyIntersect
  • GeomOverlayTopologyUnion
  • GeomOverlayTopologyUpdate
  • GeomOverlayTouching
  • GeomRemoveCurves
  • GeomRemoveZ
  • GeomRotate
  • GeomScaleShift
  • GeomScaleShiftZ
  • GeomScaleToSystem
  • GeomScaleToSystemCff
  • GeomScaleToUnits
  • GeomScaleToUnitsCff
  • GeomSegmentize
  • GeomSetZ
  • GeomSmooth
  • GeomToBranches
  • GeomToCoords
  • GeomToSegments
  • GeomToShapes
  • GeomToShapesEsri
  • GeomTouches
  • GeomTriangulate
  • GeomTriangulateLines
  • GeomType
  • GeomUnionAreasPair
  • GeomUnionBoxesPair
  • GeomVoronoi
  • GeomVoronoiLines
  • GeomVoronoiPoints
  • GeomWithin
  • GeomWkb
  • GeomWkt
  • Hypot
  • J0
  • J1
  • Jn
  • Lgamma
  • Log
  • Log10
  • Log1p
  • Log2
  • NullIf
  • PragmaValue
  • Rcbrt
  • Round
  • RoundDecs
  • Rsqrt
  • Selection
  • SelectionForWindow
  • SelectionIsEmpty
  • SelectionIsInverted
  • SelectionKeys
  • Sign
  • Sin
  • Sinh
  • Sqrt
  • StringCompareCollate
  • StringCompareKeyCollate
  • StringContains
  • StringContainsCollate
  • StringEndsWith
  • StringEndsWithCollate
  • StringEscape
  • StringEscapeEncode
  • StringEscapeJson
  • StringFind
  • StringFindCollate
  • StringFindNth
  • StringFindNthCollate
  • StringGmlCoordSystem
  • StringGmlGeom
  • StringJsonArray
  • StringJsonBoolean
  • StringJsonGeoCoordSystem
  • StringJsonGeoGeom
  • StringJsonNumber
  • StringJsonObject
  • StringJsonValue
  • StringLength
  • StringPadEnd
  • StringPadStart
  • StringRegexpCount
  • StringRegexpFind
  • StringRegexpFindNth
  • StringRegexpMatches
  • StringRegexpReplace
  • StringRegexpReplaceNth
  • StringRegexpSubstring
  • StringRegexpSubstringNth
  • StringReplace
  • StringReplaceCollate
  • StringReplaceNth
  • StringReplaceNthCollate
  • StringReverse
  • StringSoundex
  • StringStartsWith
  • StringStartsWithCollate
  • StringSubstring
  • StringSubstringLen
  • StringToCharacters
  • StringToJsonArrayValues
  • StringToJsonObjectValues
  • StringToLowerCase
  • StringToLowerCaseCollate
  • StringToRegexpMatches
  • StringToTitleCase
  • StringToTitleCaseCollate
  • StringToTokens
  • StringToUpperCase
  • StringToUpperCaseCollate
  • StringTranslate
  • StringTrim
  • StringTrimEnd
  • StringTrimStart
  • StringUnescape
  • StringUnescapeDecode
  • StringUnescapeJson
  • StringWktGeom
  • SystemCpuCount
  • SystemGpgpuCount
  • SystemGpgpus
  • Tan
  • Tanh
  • Tgamma
  • TileAbs
  • TileAcos
  • TileAcosh
  • TileAsin
  • TileAspect
  • TileAtan
  • TileAtan2
  • TileAtanh
  • TileBgrHcy
  • TileBgrHsi
  • TileBgrHsl
  • TileBgrHsv
  • TileBlur
  • TileBlurDirection
  • TileBlurGaussian
  • TileCbrt
  • TileCeil
  • TileChannel
  • TileChannelCount
  • TileChannels
  • TileChannelsConcat
  • TileCombine
  • TileCompare
  • TileContrast
  • TileCos
  • TileCosh
  • TileCut
  • TileCutBorder
  • TileCutRect
  • TileEdges
  • TileEdgesDirection
  • TileErf
  • TileErfc
  • TileExp
  • TileExp10
  • TileExp2
  • TileExpm1
  • TileFill
  • TileFloor
  • TileFloorDecs
  • TileFract
  • TileFractDecs
  • TileHcyBgr
  • TileHsiBgr
  • TileHslBgr
  • TileHsvBgr
  • TileHypot
  • TileJ0
  • TileJ1
  • TileJn
  • TileLgamma
  • TileLog
  • TileLog10
  • TileLog1p
  • TileLog2
  • TileMakeNew
  • TileMaskExtract
  • TileMaskReplace
  • TileMax
  • TileMin
  • TileNoise
  • TileRcbrt
  • TileRound
  • TileRoundDecs
  • TileRsqrt
  • TileSharpen
  • TileSign
  • TileSin
  • TileSinh
  • TileSlope
  • TileSqrt
  • TileTan
  • TileTanh
  • TileTgamma
  • TileToValues
  • TileToValuesX2
  • TileToValuesX3
  • TileToValuesX4
  • TileTrunc
  • TileTruncDecs
  • TileUpdatePyramids
  • TileY0
  • TileY1
  • TileYn
  • Trunc
  • TruncDecs
  • UuidMakeNew
  • ValueCount
  • ValueMax
  • ValueMin
  • ValueSequence
  • VectorBgrHcy
  • VectorBgrHsi
  • VectorBgrHsl
  • VectorBgrHsv
  • VectorHcyBgr
  • VectorHsiBgr
  • VectorHslBgr
  • VectorHsvBgr
  • VectorMakeX2
  • VectorMakeX3
  • VectorMakeX4
  • VectorValue
  • VectorValues
  • Y0
  • Y1
  • Yn

Radian speaks your language

Radian speaks your language: Easy, user-editable localization files allow users to configure the Radian GUI to whatever langauge they want. Download starter files in English, German, French Spanish and Portuguese today.

About Manifold

Manifold products deliver quality, performance and value in the world's most sophisticated, most modern and most powerful spatial engineering products. Total integration ensures unbeatably low cost of ownership.