geo zip code database

PrefaceJust now on the internet to inquire about the national provinces and Cities database, compared to the pit is a relatively comprehensive data, a comprehensive fee, the heart is very uncomfortable.But in the end, I got it. A slightly better national provincial and municipal database, and with left, simple spell, abbreviation, pinyin, Administrative Code,

Tags: var blog city style float null creat int arcNational provinces and Cities database, and with the left, simple spell, abbreviation, pinyin, Administrative Code, postcode, city three loadline data CREATE TABLE [dbo]. [Region] ([Id] [int] NULL, [Name] [nvarchar] ( +) NULL, [ParentID] [int] NULL, [shortname] [nvarchar] ( +) NULL, [LevelType] [int] NULL, [citycode] [varchar] ( -) NULL, [ZipCode] [varchar]

For work reasons, a complete zip code database is required. The data on the Internet is relatively old and there is very little data. I really hope the post office can download the zip code for free, or you can have an interface. At last, I did not pay for it, and my eyes we

The earthdistance () function in postgreSQL is used in the project to calculate the distance between two points on the earth. There is too little Chinese information. I found a good English article, hope to help those who will use earthdistance in the future. It is never easy to make a GEO application. However, with some open-source projects around you, you can easily solve this problem within a few minutes. PostgreSQL has many features. Is my first c

Recently developed projects require the use of provincial, municipal, and district data, because the projects to be developed are also e-commerce websites. when referring to the user experience of Vanke, it was found that it even had the latest released Guangming New Area in Shenzhen, and no data was updated on the Pat network. It seems that fanke is still responsible for data updates, so he learned about its data format, then I spent some time writing a small program to extract the latest provi

Because some situations need to use the National Administrative Division database, itself does not have the library on the Internet to find, but found is basically not what I want, because it contains only the basic information,Finally himself under a primitive library to prepare their own assembly data, online XX data network Ah, Web services are limited, or to find their own way to get the hands of the most assured.The original data is April 2015, t

Use php to ZIP and export the backup database. In some open-source PHP systems, we often see Methods for backing up and exporting databases. In fact, the code is not complicated. The following describes the two methods, taking WINDOWS as an example, one is that directories are often found in some PHP open-source systems and there are methods for backing up databa

Often in some of the PHP open source system, see the backup database and export methods, in fact, the code is not complex, the following About the following, take windows as an example, two kinds of methods, one is the directory folder to execute script permissions, There are no permissions, the code is as follows: A Java code1. 2.3. $username = "root";4. $pass

This article describes how to obtain all the information (such as the address, zip code, country, and latitude and longitude) of a specified IP address in php, it is very simple and practical to call an API to query visitor information, This article describes how to obtain all the information (such as the address, zip code