资源描述:
《Introduction to PostGIS》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、IntroductiontoPostGISPreparedBy:PaulRamseyRefractionsResearchInc.300-1207DouglasStreetVictoria,BC,V8W-2E7pramsey@refractions.netPhone:(250)383-3022Fax:(250)383-2140August29,2006-36-TableofContents1SUMMARY31.1Requirements31.2Conventions31.3Downloads32
2、INSTALLATION43SETUP104USINGPOSTGIS134.1SimpleSpatialSQL134.2LoadingShapeFiles144.3CreatingSpatialIndexes164.4UsingSpatialIndexes174.5IndexesandQueryPlans184.6PostgreSQLOptimization204.7SpatialAnalysisinSQL214.8DataIntegrity224.9DistanceQueries224.10S
3、patialJoins234.11Overlays244.12CoordinateProjection255EXERCISES265.1BasicExercises265.2AdvancedExercises276MAPSERVER&POSTGIS296.1BasicMapserverConfiguration296.2MapserverFiltersandExpressions306.3MapserverwithSQL32-36-SummaryPostGISisaspatialdatabase
4、add-onforthePostgreSQLrelationaldatabaseserver.ItincludessupportforallofthefunctionsandobjectsdefinedintheOpenGIS“SimpleFeaturesforSQL”specification.UsingthemanyspatialfunctionsinPostGIS,itispossibletodoadvancedspatialprocessingandqueryingentirelyatt
5、heSQLcommand-line.Thisworkshopwillcover·installationandsetupofPostgreSQL,·installationofthePostGISextension,·loadingofsampledata,·indexing,·performancetuning,·spatialSQLbasics,·mapserverconfiguration,·advancedmapserverconfiguration,and·spatialSQLbest
6、practices.1.1RequirementsThisworkshopwillusethenewWindowsnativePostgreSQL,andadatapackageofshapefiles,whicharebothincludedintheworkshopCDROM.1.2ConventionsInteractivesessionswillbepresentedinthisdocumentingreyboxes,withthetexttobeenteredinboldface,an
7、dtheresultsinnormaltext.Ingeneral,directionstobeperformedwillbepresentedinboldface.1.3DownloadsThePostgreSQLsourcecodeisavailablefromhttp://www.postgresql.org/.ThePostGISsourcecodeisavailablefromhttp://postgis.refractions.net/.TheGEOSsourcecodeisavai
8、lablefromhttp://geos.refractions.net/.TheProj4sourcecodeisavailablefromhttp://proj.maptools.org/.ThePgAdminadministrationtoolisavailablefromhttp://www.pgadmin.org.2-36-InstallationThePostgreSQL/PostGISinstallationpackageisintheCDROMatPostGISWorkshop