Spatial Manager Desktop

Esri #Geodatabase File to DWG/DXF - #SpatialManager #Desktop An ESRI Geodatabase File (FileGDB), is a powerful database system designed to store, query, and manage spatial data as a collection of files stored directly on disk without the requirement of having a database server deployed. It serves as a centralized repository for geographic information, enabling seamless data integration, analysis, and sharing across various platforms and applications. Blog entry and video: https://bit.ly/4fGj7Kj Spatial Manager product family includes an data provider for FileGDB. It allows importing to CAD/DWG/DXF, export and convert between multiple geospatial formats (Shapefile, KML, GML, SQLite, …) * Import - Configure the GDB access as User Data Source (UDS), or open directly if the main folder name ends with .GBD - Import only one Table or all the Tables in a directory or sub-directory by using the “Import all” application funcionality * Export and Convert - From Spatial Manager data sources panel FileGDB can be converted and exported directly to other formats and also transforming the Coordinate Reference System Note: Some functionalities can be found in the Standard or Professional editions only

U.S. Department of Agriculture background maps #SpatialManager #Desktop The Farm Service Agency of the U.S. Department of Agriculture (USDA) provides some web services for accessing the National Agriculture Imagery Program (NAIP). Spatial Manager products provide an easy way to integrate its ortoimagery on your own projects and drawings (DWG/DXF) Blog entry and videos: https://bit.ly/4hcXjXI 1. Configure USDA Background Map - Execute SPMBGMAPSHOW command - Configure custom map, click the Configure Backgound Maps button - Set URL: https://lnkd.in/dhG2Jtga - Click Get List of Layers - Select the visualization, for example USGSNAIPImagery for photographic natural color - Set your desired Name (USGSNAIPImagery) and Group (USDA) - Save 2. Configure alternative visualizations - If you also want to create maps for alternative visualizations like color-infrared (false color) or vegetation (NDVI), repeat steps from section 1 selecting other layer, change Name and click Save as a copy 3. Activate Background Map and alternate between styles - You can activate a Background Map with the SPMBGMAPSHOW command - And easily alternate between styles from SPM palette USGS NAIP Imagery - The USGS NAIP Imagery service from The National Map (TNM) consists of high resolution aerial images that combine the visual attributes of an aerial photograph with the spatial accuracy and reliability of a map. Presented in natural color, this service also supports the use of templates that can be used to dynamically generate ‘false color’, also known as color-infrared (CIR), and Normalized Difference Vegetation Index (NDVI) views of the data. - Service Url: https://lnkd.in/dhG2Jtga USGS NAIP Plus - The USGS NAIP Plus service from The National Map consists of National Agriculture Imagery Program (NAIP) and high resolution orthoimagery (HRO) that combine the visual attributes of an aerial photograph with the spatial accuracy and reliability of a map. Many states contribute orthoimagery to the National Map, and the USGS also relies on a partnership with the U.S. Department of Agriculture’s Farm Service Agency. - Service Url:  https://lnkd.in/d3N6gEyT Note: Some functionalities can be found in the Standard or Professional editions only

Get postal addresses from points (Reverse geo-coding) (#SpatialManager #Desktop) Reverse geocoding is the process of converting geographic coordinates (latitude and longitude) into a human-readable address or place name. This is typically done using a reverse geocoding service or API, which can interpret the provided coordinates and return the corresponding address details Blog and video: https://bit.ly/3B7ycVK Steps for getting address data based on a set of points: 1. Input data - Execute SPMGEOCODING_REVERSE command - Select the points 2. Geocoding provider - Select the provider between Bing, Google and OpenStreetMap (some of them require an API key) - You can select specific result types according the type of elements you want to search data for 3. Data retrieval - Get the data related to each coordinate - You can append to the existing objects data table - Or export to CSV Note: Some functionalities can be found in the Standard or Professional editions only

Object type as field importing GML files #SpatialManager #Desktop GML (Geography Markup Language) is an XML-based language created by the Open Geospatial Consortium (OGC) for modeling, transporting, and storing geographic information. GML files classify elements by type, Spatial Manager aids in sorting and separating them into layers Blog entry and video: https://bit.ly/47i0vg6 In the internal codification of a GML file, generally is stored the type of element. This classification is often not taken into consideration, but it can be very helpful for sorting elements or separate them into layers Also it can be used to split GML files into multiple ones: - Execute SPMIMPORT selecting “Use Field values for layer=ItemType” - Execute SPMEXPORT, select a specific layer and select the output GML location (or any other format) - Repeat for getting each file for the desired types Note: Some functionalities can be found in the Standard or Professional editions only

Fields data calculator (#SpatialManager #Desktop) Perform calculations on new or existing field values by applying a wide range of operators and functions, such as arithmetic operations (addition, subtraction, multiplication, division), mathematical functions (square root, logarithms, trigonometric functions), and date manipulations. These expressions can incorporate constant values as well as values retrieved from other fields within the table. This allows for dynamic and complex data transformations and analyses within the table’s dataset. Blog entry and videos: https://bit.ly/3WJ2fvm Available Expressions: - Field: To select any Field name defined in the Source Table - Values: To select any value from a selected Field in the Source Table (you will see all values list for the selected field), or some “special” fixed values, such as “NULL” - Operator: Arithmetic, logical, comparator or conditional Operators. Many of them can be applied to numeric values but also to text, dates, etc. For example, the “+” operator will return the sum of two numeric values, but it will also return the concatenation of two texts - Math: Mathematical functions such as logarithmic or trigonometric expressions, rounding, square roots, etc. - Text: Text functions, such as full or partial text replacement, convert numerical values to text, split texts, etc. - Date: Date functions, such as hourly, daily or monthly calculations, etc. - Geometry: Functions applicable to object geometries, such as area calculations, elevations, etc. They will be applied to objects attached to the Source Table - Advanced: Set of advanced functions not included in the previous sections, such as creating lists, returning values from one list based on the values of another list, etc. Samples: 1. Simple Text replacement in a Field: Replace abbreviations on addresses with the complete text, or viceversa: ‘ST’ <–> ‘Street’ , ‘DR’ <–> ‘Drive’ (https://lnkd.in/dC42YeyE) 2. Creation of new Fields as result of operations between fields, fixed values, geometry, etc.: Calculate new field with the area or perimeter of a polygon or closed polyline, get the lenght of a line, etc. (https://lnkd.in/dD6X2aHv) 3. Complex and chained operations using all types of operators, functions and parameters: Fully customizable formated results, and easy programming control structures like conditions (https://lnkd.in/dQ5Cr6st) Note: Some functionalities can be found in the Standard or Professional editions only

Locate addresses in a map (Direct geo-coding) - #SpatialManager #Desktop) Direct geocoding is the process of converting an address or a place name into geographic coordinates (latitude and longitude). This is typically done using a geocoding service or API, which can interpret the provided address and return the corresponding coordinates Steps of getting the location for a list of addresses: 1. Input data - Execute SPMGEOCODING_DIRECT command (in Spatial Manager Desktop go to Start/Search Location/Reverse Geo-coding) - Select a text file (CSV) and the field separator (comma, semicolon, space, …) 2. Select fields - Add the fields for compound the text for geo-coding process and sort them 3. Geocoding service - Select the provider between Bing, Google and OpenStreetMap (some of them may require an API key) 4. Coordinate retrieval - Review the resulting coordinates, export to CSV or insert to the current document - Select the source fields and add additional data obtained during the geocoding query - Export to CSV, selecting header, separators, … Note: Some functionalities can be found in the Standard or Professional editions only Blog entry and video: https://bit.ly/46ngWaJ

Import, export and convert #GeoJSON in #Desktop GeoJSON is an open standard geospatial data format based on JSON (JavaScript Object Notation). The content is stored as plain text, structured for allowing complex or compound geometries and with attached data. Most common file extensions are .geojson, .geo.json and even a generic .json #SpatialManager products includes an own data provider for GeoJSON files. It allows import to DWG and export and convert between multiple geospatial formats (Shapefile, KML, GML, SQLite, …) Blog entry: https://bit.ly/4czrJjW Import - Spatial Manager for CAD (AutoCAD/BricsCAD/ZWCAD/GstarCAD) can import GeoJSON to DWG using SPMIMPORT command or directly from the Data Sources palette - Spatial Manager Desktop opens GeoJSON and allow to visualize and integrate with other data sources Export - Spatial Manager for CAD (AutoCAD/BricsCAD/ZWCAD/GstarCAD) can export from DWG to GeoJSON using SPMEXPORT command or directly to Google Earth with SPMCREATEKML command - Spatial Manager Desktop opens GeoJSON and allow to visualize and integrate with other data sources Convert - From Spatial Manager data sources panel GeoJSON can be converted directly to other formats and also transforming the Coordinate Reference System Encoding - Like all text files, GeoJSON allows to use diferent encodings for representing different character sets for diverse languajes (UTF-8, ISO-8859-1, Windows-1252, …) For allowing the interoperability between different systems, while importing and exporting the character encoding can be selected Coordinate Reference System - GeoJSON latest specification uses WGS84 as coordinate reference system and decimal degrees as units for latitude and longitude. Although some legacy files using other coordinate reference systems, even projected, can still be found. Any of them is recognized by Spatial Manager Note: Some functionalities can be found in the Standard or Professional editions only

Union of polygons with common data in #Desktop It is often useful to create enveloping polygons from the union of other adjacent polygons that share some data in common. Among the many examples that could be detailed, for example, obtaining county or provincial boundaries from the boundaries of municipalities, or urban blocks from parcels, etc. #SpatialManager includes the “Dissolve” function to carry out this type of procedures In the example that you can review in the related videos, the aim is to calculate the “Groups” of adjacent parcels that share the value of the “Group” field in the “Parcels” data table   First of all, we need to select the common Table/Field data for dissolving the polygons (Group in this case). In order to reduce possible precision errors in the geometry, you can check the option to generate a temporary small buffer around the polygon boundaries in order to avoid as much as possible the generation of inner holes during the operation   Learn more: https://bit.ly/3DWDuzF Create buffers around existing geometries The Buffer function allows you to generate Buffered polygons around point, linear (lines, polylines, etc.) or polygonal (boundaries) objects. Show me how: https://bit.ly/3n5Wm9P Centroids and Polygons It is very common that when handling polygonal spatial information (Parcels, Buildings, Zones, etc.), the polygon data is attached to its Centroid, a point element, usually inside the polygon, which concentrates its alphanumeric information Read about: https://bit.ly/3zdVGmf

Create buffers around existing geometries in #Desktop Among the spatial analysis tools included in #SpatialManager, the Buffer function allows you to generate Buffered polygons around point, linear (lines, polylines, etc.) or polygonal (boundaries) objects. Buffers have multiple applications to analyze objects and their relationship with their own or other objects’ environment   As you can review in the videos, through this example we will build a table including the data of the Hydrants that are close to the Roads of a municipality   First, we import the Hydrants (which are in a KMZ file from Google Earth) and the Roads (which are in a Shapefile) into a map of the city. Note the ability of the application (CAD versions) to import at once all the data sources recognized within a folder or schema of a User Data Source, carrying out also the necessary coordinate transformations for each of these sources   Then, using the Buffer function, we generate Buffers around the vial axes. Although the distance defined to generate the Buffer for each element can be variable taken from the data of a table, in this example we define a fixed distance of 25 feet from the axis. In the videos you can also review other options of interest in the Buffer function that are applied in this example   Finally, we make use of the Spatial Query selection function to select all the Hydrants that are “Within” the generated Buffer polygons, and, in the application Data Grid, we export the selected Hydrants data to a CSV file, which we can open and handled in MS Excel and many other applications   Learn more: https://bit.ly/3n5Wm9P Union of polygons with common data - Dissolve Polygons: It is often useful to create enveloping polygons from the union of other adjacent polygons that share some data in common Show me how: https://bit.ly/3DWDuzF Centroids and Polygons: It is very common that when handling polygonal spatial information (Parcels, Buildings, Zones, etc.), the polygon data is attached to its Centroid, a point element, usually inside the polygon, which concentrates its alphanumeric information Read about: https://bit.ly/3zdVGmf

Find objects that lie within a polygon in #SpatialManager #Desktop In this example on spatial analysis using Overlays in ‘Spatial Manager’ we will apply the “Intersect” operator. This operator determines the geometries that overlap in the Source and Overlay object groups. Anything that does not overlap is discarded from the output, so the resulting objects represent what the Source and Overlay have in common. The resulting data table will include the data of both the Source and Overlay objects Use “Intersect” in order to find points or lines that lie within a polygon, to determine the places where two linear objects overlap, or to find the common areas between two polygon sets. For example, find tree point objects that are within park polygons, or, as you can see in the above videos, the parcels located total or partially inside a set of urban zones   First, by means the ‘Spatial Manager’ advanced selection tools, in this case “Selection by Query”, we find the urban areas with a certain Zone qualification (“R1” in this sample). If we now apply an Intersection Overlay operation between the selected Zones and the objects included in the “Parcels” layer, we will obtain a new layer that will include the polygons of the Parcels that are located (totally or partially) inside the “R1” Zones   Learn more: https://bit.ly/3EEHepa Create buffers around existing geometries: The Buffer function allows you to generate Buffered polygons around point, linear (lines, polylines, etc.) or polygonal (boundaries) objects How it works: https://bit.ly/3n5Wm9P Union of polygons with common data - Dissolve Polygons: It is often useful to create enveloping polygons from the union of other adjacent polygons that share some data in common Show me how: https://bit.ly/3DWDuzF Centroids and Polygons: It is very common that when handling polygonal spatial information (Parcels, Buildings, Zones, etc.), the polygon data is attached to its Centroid, a point element, usually inside the polygon, which concentrates its alphanumeric information Read about: https://bit.ly/3zdVGmf