Reload KCMO Neighborhoods from new file containing North of the River

[zmon]

This is based off of Load KC Neighborhood shape file #33 which was the first load that did not include North of the river.

• [x] Unzip KCMO_Address_Nbhd.zip
• [x] Load

shp2pgsql -g geom -I  NeighborhoodCensus.shp address_spatial.kcmo_address_nbhd_tmp | psql -d code4kc

results in

\d address_spatial.kcmo_address_nbhd_tmp
                                       Table "address_spatial.kcmo_address_nbhd_tmp"
   Column   |          Type          |                                      Modifiers                                      
------------+------------------------+-------------------------------------------------------------------------------------
 gid        | integer                | not null default nextval('address_spatial.kcmo_address_nbhd_tmp_gid_seq'::regclass)
 objectid   | numeric(10,0)          | 
 nbhid      | numeric                | 
 nbhname    | character varying(50)  | 
 shape_area | numeric                | 
 shape_len  | numeric                | 
 geom       | geometry(MultiPolygon) | 
Indexes:
    "kcmo_address_nbhd_tmp_pkey" PRIMARY KEY, btree (gid)
    "kcmo_address_nbhd_tmp_geom_gist" gist (geom)

• [X] Create permanent table address_spatial.mo_kc_city_neighborhoods

  CREATE TABLE address_spatial.mo_kc_city_neighborhoods (
    gid integer NOT NULL,
    name character varying(62),
    geom geometry(MultiPolygon),
    CONSTRAINT pk_kcmo_nhood_gid PRIMARY KEY (gid)
  );
  
  CREATE INDEX idx_mo_kc_city_neighborhoods ON
  address_spatial.mo_kc_city_neighborhoods
  USING gist(geom);

• [X] Delete existing rows

DELETE FROM address_spatial.mo_kc_city_neighborhoods;

• [X] Copy tmp table into permanent table

  INSERT INTO address_spatial.mo_kc_city_neighborhoods 
   (gid, name, geom) 
        SELECT gid, nbhname, geom
            FROM address_spatial.kcmo_address_nbhd_tmp;

• [x] Test

  SELECT name FROM address_spatial.mo_kc_city_neighborhoods
  WHERE ST_Intersects( ST_MakePoint( -94.5867908690, 39.0903343205), geom);

• [ ] Now update the address in the directory data/KCNeighborhoods

php load.php

Results in

Totals
--------------------------------------------------------------------------
table                              insert     update        N/A      ERROR
input                                   0          0          0          0
city_address_attributes                 0      97770     101718          0
--------------------------------------------------------------------------

Number of lines processed 199488

This process used 15741 ms for its computations
It spent 3166 ms in system calls
Run time:  2m 33s