Youre currently subscribed to some eWEEK features and just need to create a username and password. ADSelfService Plus Release Notes Release Notes for build 5506 October 16, 2017 Highlight. SSO for 90 cloud apps Now provide users with oneclick access to 16 more. Fork Me on GitHub The Hadoop Ecosystem Table This page is a summary to keep the track of Hadoop related projects, focused on FLOSS environment. An almost Idiots Guide Post. GIS 2. 2Part 1 Getting Started With Post. GIS An almost Idiots Guide Post. GIS 2. 2Printer Friendly. What Is Post. GIS Post. GIS is an open source, freely available, and. OGC compliant spatial database extender for the Postgre. SQL. Database Management System. In a nutshell it adds spatial functions. Today AWS Direct Connect has landed sites in five cities Denver, Phoenix, Madrid, Helsinki and Chennai. In the US, CoreSite DE1, Denver and phoenixNAP, Phoenix. Current version 2. 5 Licence LGPL. Download GeoKettle. Information and documentation on GeoKettle in the Documentation Center. Get support and interact with. Brent Ozar Unlimiteds specialized experts focus on your goals, diagnose your tough database pains, and make Microsoft SQL Server faster and more reliable. Post. GIS is very similar in functionality to SQL Server Spatial support, ESRI Arc. SDE. Oracle Spatial, and DB2 spatial extender except it has more functionality and generally better performance than all of those and it wont bankrupt you. The latest release version. Postgre. SQL DBMS installs as an optional. As of this writing Post. GIS 2. 2. 0 is the latest stable release. Noteable features in this release now packages along new 3. D measurement functions, 3. D spatial index support and 3. D surface area typesseamless rastervector analysis support including an easy to use command line raster database loader that supports various types and can load whole folders of raster files with one commandline statement, and really jazzy image export functions to output both raster and geometries as PNGTIFF and other raster formats. SQLMM topology support now improved using native C functions. Windows Application Stack builder and some other desktop distros, now includes batch file uploading as well as exporting. This feature can be enabled as a plugin in pg. Admin IIIAbility to install using CREATE EXTENSION postgis, ALTER EXTENSION postgis. KNN distance functionality now works with geography and 3. D geometries. You get KNN true distances not just bounding box distances, if you are using Postgre. SQL 9. 5It also includes as an extra Tiger geocoder upgraded to work with Tiger 2. The very first version of Post. GIS windows to include SFCGAL Enhanced 3. D geometry and other geometry processing functions. SFCGAL now supports extension model so can be installed with CREATE EXTENSION postgissfcgal after you have installed postgis. The very first version of Post. GIS to include addressstandardizer extension for parsing addresses into parts, useful for geocoding addresses. The Post. GIS windows 2. Post. GIS related extensions that augment your spatial enjoyment. In the bundle you will also find pg. Routing 2. 1. 0 and osm. This includes curl support so you can query web services such as WFS services as well. LIDAR data in compress POINTPATCH and also performing various operations on it. We will assume a windows environment for this. Linux, Unix, BSD, Mac etc. We will also be using. MassachusettsBoston data for these examples. For desktop users, the Enterprise. DB one click installer exists as well for MacOSX and Linux desktops, so you should be able to follow along without too much fuss. Installing Postgre. SQL with Post. GIS Functionality. We will not go into too much detail here since the. Below are the. basic steps. Download the install for your specific platform. Postgre. SQL Binary Download http www. As of. this writing the latest version is Postgre. SQL 9. 5. 0beta. 1 and we will be assuming Post. GIS 2. 2. The minimum support Postgre. SQL for Post. GIS 2. Postgre. SQL 9. 1 for windows we only build installers for 9. KNN true distance indexable operators prior versions are bounding box distance only you need Postgre. SQL 9. 5. So use 9. The below options follow the. Launch exe to install Postgre. SQLOnce Postgre. SQL is installed, launch Application Stack Builder from Start Programs Postgre. SQL 9. 5 Applciation Stackbuilder and pick the version of Postgre. SQL you want to install Post. GIS on and the version of Post. GIS to install. NOTE Post. GIS 2. 1, 2. 2, 1. You can upgrade from 2. ALTER EXTENSION postgis UPDATE will do the trick after youve installed the latest Post. GIS. In prior versions of the installer, we had a template database. We took that out since creating a database from template doesnt maintain search paths set by postgistigergeocoder and postgistopology extensions. There is still a postgis sampler option which creates a regular spatial db. The dumper,loader commandline and GUI tools in Postgre. SQL bin folder will get overwritten by the last Post. GIS you installed so be careful. Generally speaking Post. GIS 2. 2. 0 should work just fine everywhere you were using Post. GIS 2. 0 2. 1 before, but you may need install the legacyminimal. Post. GIS 2. 0 and 2. Navigate to spatial extensions and pick Post. GIS 2. 2. Download, install. Please note the Post. GIS windows installer, no longer creates a template database. Using CREATE EXTENSION postgis for enabling Post. GIS in a database is the recommended way. The create spatial database checkbox is optional, and we generally uncheck it. It creates a spatial database for you to experiment with and has all the extensions packaged with Post. GIS Bundle pre installed. Do you want to register the GDALDATA prompt is new for Post. GIS 2. 0. This is because in order to do operations that require raster transformations or other rater warping clipping etc, Post. GIS uses GDAL epsg files. The windows build, makes a local copy of these in the Postgre. SQL installgdal data folder and saying yes will. GDALDATA environment variable putting this path in for you. If you use GDAL already or you are running both Post. GIS 3. 2 bit and 6. Post. GIS will work happily with an existing one, but just remember if you uninstall a Post. GIS 2. 0 or your GDAL, these functions may stop working and youll need to repoint the environment variable. Enable Raster drivers. In 2. 0. 6, 2. 1. Saying yes to this prompt allows the most common drivers that are considered safe. E. g. they dont call out to web services etc. If you are not content with the list shown there, you may want to explicitly enable additional drivers using the new Post. GIS 2. 2. GUC raster features Post. GIS GDAL Enabled Raster Drivers GUC, that can either be set using ALTER SYSTEM for 9. ALTER DATABASE for specific databases. Enable Out of database rasters. In 2. 0. 6, 2. 1. If you need them, say yes to this prompt. Again if you want each database to have different settings, you can opt for the new Post. GIS 2. 2 GUC route. Enable Out of Database rasters GUCFor those of you who want to try experimental builds e. We have experimental Windows builds made weekly or as frequently as anything interesting happens in the Post. GIS code base. These can be downloaded from http postgis. Creating a spatial database using SQLYou can use something like psql or the pg. Admin query window to create a database and spatially enable your database. This is the way to go if you have only a terminal interface to your db or you have a butt load of extensions you want to enable. Your psql steps would look something like this To install a bunch of extensions, just open up the pg. Admin SQL Query window which well cover shortly or psql and run this including only the extensions you want. CREATE DATABASE gisdb. Enable Post. GIS includes raster. CREATE EXTENSION postgis. Enable Topology. CREATE EXTENSION postgistopology. Enable Post. GIS Advanced 3. D. and other geoprocessing algorithms. CREATE EXTENSION postgissfcgal. Tiger. CREATE EXTENSION fuzzystrmatch. CREATE EXTENSION addressstandardizer. CREATE EXTENSION addressstandardizerdataus. Enable US Tiger Geocoder. CREATE EXTENSION postgistigergeocoder. CREATE EXTENSION pgrouting. CREATE EXTENSION ogrfdw. LIDAR support. CREATE EXTENSION pointcloud. LIDAR Point cloud patches to geometry type cases. CREATE EXTENSION pointcloudpostgis. Easily Transform JSON Data When Importing to Azure Document. DB Blog. The Azure Document. DB Data Migration Tool is an open source solution that imports data to Document. DB, Azures No. SQL document database service.   Hopefully you already know the tool available on Git. Hub or the Microsoft Download Center supports importing data to Document. DB from a variety of sources, including JSON files, CSV files, SQL Server, Mongo. DB, Azure Table storage, Amazon Dynamo. DB, HBase and Document. DB collections, but did you know the tool also supports custom transformation of data during import  Lets see how easy it is to apply custom transformations to data during the import process. When importing data to Document. DB using the migration tool, the default option is bulk import. This leverages a Document. DB Java. Script stored procedure to import data as efficiently and quickly as possible. Two stored procedures are available in the migration tool directory, Bulk. Insert. js and Bulk. Transformation. Insert. Bulk. Insert. js is the default import stored procedure the tool uses, but you can specify a custom stored procedure you wish to use in the Advanced Options section. The difference between Bulk. Insert. js and Bulk. Transformation. Insert. Document function stub you can use to apply custom transformation logic to every document being imported. Documentdoc. Add custom tranformation code here. You can either modify an existing document and. Example 1, rename External. Id field to id. External. Id. delete doc. External. Id. Example 2, convert string field to an array. Cities. docCities docCities. You can use Bulk. Transformation. Insert. Lets walk through an example. The city of Chicago has a food inspection data set available in CSV format.   If you perform a default import of this data set with the migration tool, a typical document looks like this. DBA Name CONTOSO CO. AKA Name CONTOSO CO. License 2. 42. Facility Type Restaurant. Risk Risk 1 High. Address 3. 14. N FABRIKAM ST. City CHICAGO. State IL. Zip 6. Inspection Date 2. T0. 0 0. 0 0. 0. Z. Inspection Type License. Results Pass. Violations 3. 0. FOOD IN ORIGINAL CONTAINER, PROPERLY LABELED CUSTOMER ADVISORY POSTED AS NEEDED Comments OBSERVED WRAPPED TO GO DESSERTS AT THE FRONT COUNTER UNLABELED. INSTRUCTED FACILITY TO LABEL AND MAINTAIN WITH PRODUCTION FACILITY NAME AND CONTACT INFORMATION. FLOORS CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST LESS CLEANING METHODS USED Comments INSTRUCTED FACILITY TO INSTALL AND MAINTAIN COVING ALONG THE WALLS IN THE PREP AREA. LIGHTING REQUIRED MINIMUM FOOT CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED Comments INSTRUCTED FACILITY TO INSTALL LIGHT SHIELDS OR TO OBTAIN SHATTER PROOF LIGHT BULBS AND TO MAINTAIN. Note the Violations property.   It has a number of violations, with each violation separated by a character.   We can use a custom transformation to store the list of violations as a proper JSON array within each document.   Well modify the transform. Document function of the Bulk. Transformation. Insert. Transform. Chicago. Dataset. js. function transform. Documentdoc. if docViolations. Violations docViolations. And well specify the modified stored procedure during import. After performing the import with the modified stored procedure, a typical document now looks like this. DBA Name CONTOSO CO. AKA Name CONTOSO CO. License 2. 42. Facility Type Restaurant. Risk Risk 1 High. Address 3. 14. N FABRIKAM ST. City CHICAGO. State IL. Zip 6. Inspection Date 2. T0. 0 0. 0 0. 0. Z. Inspection Type License. Results Pass. Violations. 3. FOOD IN ORIGINAL CONTAINER, PROPERLY LABELED CUSTOMER ADVISORY POSTED AS NEEDED Comments OBSERVED WRAPPED TO GO DESSERTS AT THE FRONT COUNTER UNLABELED. INSTRUCTED FACILITY TO LABEL AND MAINTAIN WITH PRODUCTION FACILITY NAME AND CONTACT INFORMATION. FLOORS CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST LESS CLEANING METHODS USED Comments INSTRUCTED FACILITY TO INSTALL AND MAINTAIN COVING ALONG THE WALLS IN THE PREP AREA. LIGHTING REQUIRED MINIMUM FOOT CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED Comments INSTRUCTED FACILITY TO INSTALL LIGHT SHIELDS OR TO OBTAIN SHATTER PROOF LIGHT BULBS AND TO MAINTAIN. Note the Violations property now contains a proper JSON array of violations, with each array member representing an individual violation. We hope you can find lots of creative uses for this functionality.   Please leave a comment below with your biggest takeaway from the content above. We want to hear your perspective and feedback because it helps us continue to provide relevant information and features. If you need any help or have questions or feedback, please reach out to us on the developer forums on stack overflow or schedule a 1 1 chat with the Document. DB engineering team.   Make sure to stay up to date on the latest Document. DB news and features by following us on Twitter Document. DB. he City of Chicago makes no claims as to the content, accuracy, timeliness, or completeness of any of the data provided at this site.   The data provided at this site is subject to change at any time.   It is understood that the data provided at this site is being used at ones own risk.