sql

My sql scripts for postgis

These functions are designed to expand abbreviated road types typically found in shapefile provided by government organizations.

run the sql script with psgl

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
Get_CityName.sql		Get_CityName.sql
LICENSE		LICENSE
README.md		README.md
TileBBox.sql		TileBBox.sql
count_id_tutorial.sql		count_id_tutorial.sql
editors.sql		editors.sql
expand_direction.sql		expand_direction.sql
expand_roads.sql		expand_roads.sql
format_road.sql		format_road.sql
fullname.sql		fullname.sql
hot_project.sql		hot_project.sql
iD_tutorial.sql		iD_tutorial.sql
king_county_feature_class.sql		king_county_feature_class.sql
king_county_rd_class.sql		king_county_rd_class.sql
missing_starbucks.sql		missing_starbucks.sql
mktbl_geolocation.sql		mktbl_geolocation.sql
new_user_count.txt		new_user_count.txt
new_user_summary.txt		new_user_summary.txt
new_users.txt		new_users.txt
okanogan_road_view.sql		okanogan_road_view.sql
patindex.sql		patindex.sql
prop_name.sql		prop_name.sql
prop_name2.sql		prop_name2.sql
prop_name3.sql		prop_name3.sql
proper_case.sql		proper_case.sql
psql.sh		psql.sh
pyparse2full_street.sql		pyparse2full_street.sql
pyparse_full_addr.sql		pyparse_full_addr.sql
seo_spam_finder.sql		seo_spam_finder.sql
split_polygon.sql		split_polygon.sql
usfs2osm.sql		usfs2osm.sql
wash_road.sql		wash_road.sql