{"title":"基于PostGIS的空间数据管理方法","authors":"Lijing Zhang, Jing Yi","doi":"10.1109/PACCS.2010.5626962","DOIUrl":null,"url":null,"abstract":"GIS is primarily associated with spatial data. In the most GIS, the spatial data as a file, together with the attribute data, is stored in relational database. So it is difficult to keep data security data management and data consistency. PostgreSQL and PostGIS can store spatial data and attribute data in one database; this makes it easy to manage and use data. In this paper, the features of spatial data, the shortcomings of relational database and how to create spatial database by PostGIS are analyzed, and the management methods of spatial data in PostGIS are introduced.","PeriodicalId":431294,"journal":{"name":"2010 Second Pacific-Asia Conference on Circuits, Communications and System","volume":"05 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2010-11-11","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"18","resultStr":"{\"title\":\"Management methods of spatial data based on PostGIS\",\"authors\":\"Lijing Zhang, Jing Yi\",\"doi\":\"10.1109/PACCS.2010.5626962\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"GIS is primarily associated with spatial data. In the most GIS, the spatial data as a file, together with the attribute data, is stored in relational database. So it is difficult to keep data security data management and data consistency. PostgreSQL and PostGIS can store spatial data and attribute data in one database; this makes it easy to manage and use data. In this paper, the features of spatial data, the shortcomings of relational database and how to create spatial database by PostGIS are analyzed, and the management methods of spatial data in PostGIS are introduced.\",\"PeriodicalId\":431294,\"journal\":{\"name\":\"2010 Second Pacific-Asia Conference on Circuits, Communications and System\",\"volume\":\"05 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2010-11-11\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"18\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2010 Second Pacific-Asia Conference on Circuits, Communications and System\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/PACCS.2010.5626962\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2010 Second Pacific-Asia Conference on Circuits, Communications and System","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/PACCS.2010.5626962","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Management methods of spatial data based on PostGIS
GIS is primarily associated with spatial data. In the most GIS, the spatial data as a file, together with the attribute data, is stored in relational database. So it is difficult to keep data security data management and data consistency. PostgreSQL and PostGIS can store spatial data and attribute data in one database; this makes it easy to manage and use data. In this paper, the features of spatial data, the shortcomings of relational database and how to create spatial database by PostGIS are analyzed, and the management methods of spatial data in PostGIS are introduced.