GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → dracodoc → Geocode

dracodoc / Geocode

Batch geocoding addressess, map to census block with PostGIS Tiger Geocoder

Labels

plpgsql

Projects that are alternatives of or similar to Geocode

Hioshop Server
海风小店，开源商城，微信小程序商城服务器端
Stars: ✭ 331 (+1339.13%)
Mutual labels:  plpgsql
Node Sqlite3
Asynchronous, non-blocking SQLite3 bindings for Node.js
Stars: ✭ 5,083 (+22000%)
Mutual labels:  plpgsql
Mysql Deadlocks
收集一些常见的 MySQL 死锁案例
Stars: ✭ 777 (+3278.26%)
Mutual labels:  plpgsql
103976
103976个英语单词库（sql版，csv版，Excel版）包含英文单词，中文翻译，单词的词性及多种词义,执行SQL语句就可以生成表，支持SQL Server，MySQL等多种数据库
Stars: ✭ 361 (+1469.57%)
Mutual labels:  plpgsql
Mixerp
Open Source ERP, HRM, MRP, MPS
Stars: ✭ 472 (+1952.17%)
Mutual labels:  plpgsql
Postgrest Starter Kit
Starter Kit and tooling for authoring REST API backends with PostgREST
Stars: ✭ 657 (+2756.52%)
Mutual labels:  plpgsql
Cgasm
We're insanely passionate about command line asm documentation in the cloud, and we're crushing it!
Stars: ✭ 321 (+1295.65%)
Mutual labels:  plpgsql
Pg Mask
Simple data masking for PostgreSQL
Stars: ✭ 16 (-30.43%)
Mutual labels:  plpgsql
Audit Trigger
Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
Stars: ✭ 493 (+2043.48%)
Mutual labels:  plpgsql
Mysql Sys
The MySQL sys schema
Stars: ✭ 758 (+3195.65%)
Mutual labels:  plpgsql
Practical Sql
Code and Data for the book "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).
Stars: ✭ 392 (+1604.35%)
Mutual labels:  plpgsql
Vector Datasource
Tilezen vector tile service - OpenStreetMap data in several formats
Stars: ✭ 427 (+1756.52%)
Mutual labels:  plpgsql
Blog
Everything about database,business.(Most for PostgreSQL).
Stars: ✭ 6,330 (+27421.74%)
Mutual labels:  plpgsql
100daysofiac
100 Days of IaC in Azure
Stars: ✭ 347 (+1408.7%)
Mutual labels:  plpgsql
Chinook Database
Sample database for SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DB2
Stars: ✭ 786 (+3317.39%)
Mutual labels:  plpgsql
Plpgsql check
plpgsql_check is linter tool for language PL/pgSQL (native language for PostgreSQL store procedures).
Stars: ✭ 322 (+1300%)
Mutual labels:  plpgsql
Pgtap
PostgreSQL Unit Testing Suite
Stars: ✭ 631 (+2643.48%)
Mutual labels:  plpgsql
Pg query internals
Query PostgreSQL internals using SQL
Stars: ✭ 17 (-26.09%)
Mutual labels:  plpgsql
Odata V4 Typeorm
OData to TYPEORM query compiler
Stars: ✭ 16 (-30.43%)
Mutual labels:  plpgsql
Demo
“Happy Lager” Craft CMS demo site.
Stars: ✭ 730 (+3073.91%)
Mutual labels:  plpgsql
View All Similar Projects ➔

This is my setup to batch geocode NFIRS data addresses into valid addresses and map to census block.

To use this work flow:

  1. Setup server. Assuming the project folder located in /home/ubuntu/geocode.
  2. Make address input file, upload to address_input folder. Don't use spaces in file name, it will cause error in shell script.
  3. Run python gaddress.py, then sh ./batch.sh.
  4. Output file will be put in address_output folder. The log folder hold the log file of console messages.
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].