Skip to content
This repository has been archived by the owner on Jun 25, 2024. It is now read-only.

miguelomp/tiger-geocoder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Jul 29, 2022
33ee6f9 · Jul 29, 2022

History

6 Commits
Jul 29, 2022
Jul 29, 2022
Jul 29, 2022
Jul 29, 2022
Jul 29, 2022
Jul 29, 2022
Jul 29, 2022
Jul 29, 2022

Repository files navigation

license

Container locations

  • /var/lib/postgresql/gisdata/: temp folder and staging for this container

Post container creation set-up

run post-install script. It installs DC data only.

  • windows: cmd /c post-intall.bat
  • linux: ./post-intall.sh

Test use-cases

  • template
    docker exec some-postgis-geocoder psql -U postgres -d geocoder -c "<YOUR SQL GOES HERE (paste it in 1 line)>"
    
  • query #1 geocoder usage
    SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat, (addy).address As stno, (addy).streetname As street, (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip FROM geocode('1600 Pennsylvania Ave NW, Washington, DC 20500') As g;
    
    pprinted
      SELECT 
          g.rating, 
          ST_X(g.geomout) As lon, 
          ST_Y(g.geomout) As lat, 
          (addy).address As stno, 
          (addy).streetname As street, 
          (addy).streettypeabbrev As styp, 
          (addy).location As city, 
          (addy).stateabbrev As st,
          (addy).zip 
      FROM geocode('1600 Pennsylvania Ave NW, Washington, DC 20500') As g;
    
  • query #2 reverse geocoder usage
    SELECT pprint_addy(r.addy[1]) As st1, pprint_addy(r.addy[2]) As st2, pprint_addy(r.addy[3]) As st3, array_to_string(r.street, ',') As cross_streets  FROM reverse_geocode(ST_GeomFromText('POINT(-77.00046877117504 38.8875068167358)',4269),true) As r;
    
    pprinted
      SELECT 
          pprint_addy(r.addy[1]) As st1, 
          pprint_addy(r.addy[2]) As st2, 
          pprint_addy(r.addy[3]) As st3, 
          array_to_string(r.street, ',') As cross_streets 
      FROM reverse_geocode(ST_GeomFromText('POINT(-77.00046877117504 38.8875068167358)',4269),true) As r;
    

About

Dockerized tiger geocoder

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published