[postgis-users] reverse geocoding

Sat Apr 3 10:05:55 PDT 2010

-- Here's my go at it.  Paste into favorite sql editor for easier reading.  Cheers.   -Eric

/* 

Query to create actual address ranges by side of street from points and lines (address points and street centerlines).

Example tables used are:

adds22 - address points for Franklin Twp, Erie County, Pa
roads22 - road centerlines for Franklin Twp, Erie County, Pa

Subsets of these by the same name are appended to run query. Apologies for the size of the post. 

Please post refinements, other and better ideas.  Thanks.

--========================================================================

*/

select roads_gid, street, side, min(hsnum::integer) as low_add, max(hsnum::integer) as high_add
from adds22,

(

/* Use close points (cpoint) and short lines (sline) to determine left/right sidedness

Uses:

If  line goes from A to B and point is P, 

 v = (Ay-By)*Px+(Bx-Ax)*Py+(Ax*By-Bx*Ay)

 v>0: "Left"
 v<0: "Right"
 v=0: "On the line" 
(or in front of B / behind A)

(from somewhere on comp.graphics.algorithms I think)

*/

select adds_gid, roads_gid, case when

(  st_y(st_startpoint(sline)) - st_y(st_endpoint(sline)) ) * st_x(cpoint) 
+  (   st_x(st_endpoint(sline)) -  st_x(st_startpoint(sline))   ) * st_y(cpoint)
+  (  st_x(st_startpoint(sline)) * st_y(st_endpoint(sline)) - st_x(st_endpoint(sline)) 
* st_y(st_startpoint(sline))  ) > 0

then 'L' 

when

(  st_y(st_startpoint(sline)) - st_y(st_endpoint(sline)) ) * st_x(cpoint) 
+  (   st_x(st_endpoint(sline)) -  st_x(st_startpoint(sline))   ) * st_y(cpoint)
+  (  st_x(st_startpoint(sline)) * st_y(st_endpoint(sline)) - st_x(st_endpoint(sline)) 
* st_y(st_startpoint(sline))  ) < 0

then 'R'

when 

(  st_y(st_startpoint(sline)) - st_y(st_endpoint(sline)) ) * st_x(cpoint) 
+  (   st_x(st_endpoint(sline)) -  st_x(st_startpoint(sline))   ) * st_y(cpoint)
+  (  st_x(st_startpoint(sline)) * st_y(st_endpoint(sline)) - st_x(st_endpoint(sline)) 
* st_y(st_startpoint(sline))  ) = 0

then null

end

as side 

from

(

/*  creates locus for doing left/right calculations; making short lines (sline) and close points (cpoint) 
    by intersecting a 2 foot buffer of projected points with street centerline and perpendicular line 
    made from address points and corresponding projected points. This is to ensure that left/right
    will be correctly calculated (deals with cases where address points lay on the inside of curves 
    and meanders in centerlines). 
*/

select adds_gid,roads_gid, 

st_intersection(st_exteriorring(st_buffer(ppoints22.geom,2)),st_makeline(adds22.geom,ppoints22.geom)) as cpoint,
st_intersection(st_buffer(ppoints22.geom,2),roads22.geom) as sline

from adds22, roads22,

(

/* project address points onto nearest street centerline of the same name and juristiction */

select t2.gid as adds_gid, t1.gid as roads_gid, 
st_line_interpolate_point(st_geometryn(t1.geom,1),st_line_locate_point(st_geometryn(t1.geom,1),t2.geom)) as geom
from roads22 t1, adds22 t2, 

(
/* 
Associate address points with nearest road of the same name and juristiction within 3000 feet */

select gid as address_gid, 
(select gid  
from roads22
where roads22.street = adds22.street
and roads22.mcode = adds22.mcode
and st_dwithin(roads22.geom, adds22.geom,3000)
order by st_distance(roads22.geom, adds22.geom)
limit 1 ) as road_gid
from adds22

) as t3

where t1.gid = t3.road_gid
and t2.gid = t3.address_gid

-- exclude interstate  (mile markers are addressed)

and t1.street not like 'I 79%'
and t2.street not like 'I 79%'

)  as ppoints22

where adds22.gid = ppoints22.adds_gid
and  roads22.gid = ppoints22.roads_gid

) as locus22

) as sides22

where adds_gid = gid
group by roads_gid, street, side
order by roads_gid

--====================================================================================

/*  roads22.sql

SET STANDARD_CONFORMING_STRINGS TO ON;
SELECT DropGeometryColumn('','roads22','geom');
DROP TABLE "roads22";
BEGIN;
CREATE TABLE "roads22" (gid serial PRIMARY KEY,
"erieco_gid" int4,
"mcode" int4,
"street" varchar(35));
SELECT AddGeometryColumn('','roads22','geom','2271','MULTILINESTRING',2);
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3753','117','NEW RD','0105000020DF080000010000000102000020DF0800000B0000000000480052C233410000D8BF1ACA23410000E0FFE3C133410000E85F23CA23410000200096B933410000F0BFCACA23410000200079B8334100002840E1CA23410000C4FFFAB633410000A060FFCA23410000B8FF3DB633410000883F0ECB23410000B8FFD8B533410000F03F16CB23410000D4FF00B533410000883F27CB23410000200034B433410000186037CB234100003C0010AF3341000070BF99CB23410000480055AD334100008060BECB2341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3776','117','CRANE RD','0105000020DF080000010000000102000020DF0800000F0000000000E0FF6BC13341000080A07B9A23410000480055BF33410000A840AA9A234100003C00B1BC334100007800E59A23410000200070BB334100002800019B23410000540097BA3341000040C0139B23410000D4FF62B833410000C0FF449B234100002C0040B633410000B09F749B23410000F8FFEFB53341000038A07B9B23410000F8FFCFB333410000A8FFAA9B23410000D4FF88B23341000038A0C79B2341000020005AB233410000C89FCB9B23410000E0FFDDB133410000A060D69B234100003C0010AF3341000028401E9C23410000080012AD3341000078C04D9C23410000200060AC3341000050A05E9C2341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3821','117','OLD STATE RD','0105000020DF080000010000000102000020DF0800000E0000000000540035C333410000809FBBF5234100000800ECC233410000D8BFC1F523410000D4FFA1C2334100007840C8F523410000ECFF0FC23341000078C0D4F523410000E0FFA4B93341000088BF8EF62341000054000CB8334100007800B2F623410000200024B7334100005840C6F6234100002000D8B63341000000A0CCF623410000ECFF71B533410000809FEBF6234100002C0053B23341000018A030F723410000E0FFCAB133410000985F3CF723410000C4FF0DB133410000E89F4CF7234100003C0010AF3341000080A06CF723410000540045AE33410000703F80F72341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3778','117','EUREKA RD','0105000020DF080000010000000102000020DF0800000900000000002000EED733410000883F33D723410000D4FFDDD733410000F0FF1FD623410000D4FFC4D73341000018A0DBD1234100003C00C1D73341000058001FD123410000E0FFBDD733410000A83F94D0234100000800B0D73341000088BF36CE23410000B8FF9FD733410000404078CB23410000E0FF91D733410000A83F06C92341000048008ED733410000280070C82341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3749','117','RTE 98','0105000020DF080000010000000102000020DF0800000C0000000000E0FF6BC13341000080A07B9A234100002C0043C13341000058C0FB912341000020002AC1334100004000AE8C23410000B8FF14C133410000F0FFFF8723410000080012C13341000050A06E8723410000480009C133410000E85F7F85234100001400F2C033410000883FA28023410000D4FFEDC033410000A8FFD07F23410000ECFFD3C033410000B09F517A234100004800CAC033410000A83F3C78234100000800C0C033410000D8FF207623410000ECFFBBC033410000884C44752341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3774','117','CRANE RD','0105000020DF080000010000000102000020DF080000150000000000B8FF76D633410000A0A0A798234100002C0020D63341000088BFAE9823410000B8FF63D433410000E89FD49823410000200027D433410000A0A0D998234100004800D0D23341000038A0F79823410000F8FF21D233410000A8BF069923410000D4FF72D133410000F0FF15992341000008005ECF33410000805F449923410000D4FF13CF3341000058C04A9923410000F8FFE5CE33410000F0BF4E9923410000B8FF17CE3341000070BF6099234100000800E9CD3341000058C06499234100003C0026CC3341000028408C9923410000D4FF72CB33410000F0BF9B9923410000140044CB3341000088BF9F99234100003C0075C9334100007840C89923410000ECFF38C933410000B05FCD99234100001400CFC733410000F0FFEC99234100003C0085C63341000040C0099A23410000200021C633410000B09F129A23410000E0FF6BC13341000080A07B9A2341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3775','117','EUREKA RD','0105000020DF080000010000000102000020DF08000016000000000048008ED733410000280070C823410000B8FF79D733410000104002C5234100003C0075D733410000686024C423410000ECFF64D73341000090406FC123410000ECFF51D733410000883F11BE23410000B8FF4DD733410000A8C054BD23410000F8FF44D733410000A8BFEFBB23410000540022D7334100004040E4B52341000048001CD733410000C89FEEB423410000480009D733410000F0BFA7B123410000480003D73341000010C083B023410000C4FFF4D633410000C85F31AE23410000F8FFF2D633410000609FC9AD234100003C00D7D633410000B09F22A9234100002000C5D63341000018A0E8A5234100005400BDD6334100008060A2A4234100001400B9D633410000C0BFEFA3234100000800B3D633410000D83FF1A223410000D4FFA1D633410000A83FF09F234100002C0092D63341000000A0459D23410000B8FF89D633410000C0BFD59B23410000B8FF76D633410000A0A0A7982341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3781','117','OLD STATE RD','0105000020DF080000010000000102000020DF080000210000000000F0C427D23341000098578DF123410000D4FF5FD13341000080609EF123410000F8FF47D033410000C03FB6F12341000054009ACF334100002800C5F123410000D4FF78CF33410000E89FC4F123410000140057CF33410000F0BFC0F123410000C4FF33CF3341000038A0C1F123410000200017CF33410000C89FC5F123410000E0FFF9CE3341000050A0CCF1234100002000D8CE3341000010C0D8F123410000C4FFB5CE33410000A8BFE9F1234100003C0098CE334100000060FCF123410000140018CD33410000D83FF1F2234100003C0078CA33410000F0BF9DF423410000C4FF56CA3341000068A0B5F423410000ECFF35CA334100001860CBF423410000080015CA33410000605FDFF4234100004800F3C933410000809FF1F423410000C4FFD1C93341000010C001F5234100000800B0C933410000F03F10F523410000B8FF8CC933410000F0BF1CF523410000F8FF6AC933410000284027F523410000540048C933410000C0FF30F523410000ECFF25C93341000038A036F523410000480003C93341000050603BF523410000C4FFE7C83341000058C03DF523410000C4FF30C83341000068A04DF523410000D4FF03C633410000A0A07DF523410000F8FF18C53341000088BF91F523410000F8FF41C433410000E85FA4F5234100005400E6C3334100006860ACF5234100001400C9C33341000078C0AEF523410000540035C333410000809FBBF52341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3782','117','RTE 98','0105000020DF080000010000000102000020DF080000140000000000480052C233410000D8BF1ACA23410000B8FF4AC2334100009040D7C823410000F8FF41C23341000058C0EBC623410000D4FF29C2334100001040D9C123410000080022C233410000386033C0234100003C0000C233410000C85F41B9234100002000FBC13341000040C01CB823410000E0FFF0C13341000038A000B6234100003C00E7C133410000D83FFBB3234100002000DBC133410000B09F61B123410000C4FFD1C13341000080A09EAF23410000F8FFCFC133410000006045AF234100001400CFC13341000088FF06AF23410000E0FFCAC13341000040C015AE23410000F8FFA9C13341000010403BA723410000F8FFA3C133410000F03FF3A523410000C4FF98C133410000E89FBEA3234100002C008FC133410000580091A123410000080077C133410000E89FC79C23410000E0FF6BC13341000080A07B9A2341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3786','117','EUREKA RD','0105000020DF080000010000000102000020DF0800001400000000002C00FAD93341000018A02D38244100002C00E1D933410000A0A02B3324410000B8FFD8D93341000038A08E31244100002000C8D93341000028C0232E244100000800C3D93341000010C0402D244100004800BAD933410000F0FF802B24410000C4FFB8D93341000010004E2B244100002000B5D933410000809F792A24410000B8FF9FD93341000028C0492624410000140096D933410000D8FF3F2424410000540087D93341000038A03F2224410000480068D933410000A8408A1C2441000008003ED93341000090C0E31424410000200037D93341000040C08413244100003C0016D933410000883F850D24410000C4FF0DD933410000985F060C244100001400F2D8334100009040EA0624410000F8FFCCD833410000A0A02800244100000800C6D833410000883FE7FE23410000D4FF88D83341000010C093F32341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3789','117','RTE 98','0105000020DF080000010000000102000020DF080000190000000000540035C333410000809FBBF5234100002C0030C3334100001040CFF423410000C4FF2DC333410000A83F55F42341000014002BC3334100009000BBF323410000080025C33341000028C088F22341000048001CC33341000038A0C4F023410000B8FF14C33341000018A07CEF23410000080012C33341000090C0DDEE234100000800FFC233410000703F1BEB23410000C4FFFAC23341000070BF50EA234100002000E5C233410000E89FEAE5234100004800DDC233410000A8BF61E423410000B8FFD5C233410000F03FE3E223410000D4FFD4C233410000985FB1E2234100001400CCC23341000040400CE1234100003C00C4C233410000809F76DF234100003C00B1C23341000080A091DB234100005400AAC233410000904052DA23410000F8FFA6C233410000989FA1D92341000020009FC233410000E85F10D823410000E0FF94C233410000F0FF1FD62341000048007EC23341000010406DD323410000E0FF7BC23341000078C0EAD223410000480058C233410000B09F81CB23410000480052C233410000D8BF1ACA2341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3790','117','OLD STATE RD','0105000020DF080000010000000102000020DF0800000F0000000000D4FF88D83341000010C093F3234100003C0065D833410000A8BF8AF3234100003C009BD73341000000602BF323410000F8FF2BD733410000F0FFF6F2234100002C0020D633410000386078F223410000F8FFD2D43341000078C0D4F1234100000800A0D43341000078C0BBF1234100002C007FD433410000C0BFA9F123410000C4FF5CD43341000010C099F12341000008003BD433410000C85F8CF123410000B8FF17D433410000F03F81F123410000F8FFF5D333410000806078F1234100005400D3D33341000040C071F123410000C4FFA5D33341000088BF6CF123410000F0C427D23341000098578DF12341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3791','117','SILVERTHORN RD','0105000020DF080000010000000102000020DF0800001E0000000000140034EE33410000F0FFD3F12341000014002EEE33410000809FCBF02341000020002DEE33410000609F99F0234100002C0007EE33410000B09FE2E8234100002C00FAED33410000400043E623410000C4FFF7ED33410000E85FF0E523410000B8FFF1ED3341000038A0B7E423410000F8FFE8ED3341000078C004E323410000D4FFDDED33410000809FBEE023410000C4FFCBED33410000386016DD234100003C00C7ED3341000090C03FDC23410000F8FFA9ED33410000F0FF1FD6234100003C00A1ED33410000F03F45D42341000054009AED3341000018A0E5D223410000140070ED3341000040403CCA234100003C0062ED33410000D8BF6FC723410000ECFF5EED33410000B09FD0C62341000048005BED33410000186021C623410000200050ED33410000B09FD9C3234100002C0043ED33410000989F23C1234100002C001DED33410000806079B9234100003C0016ED33410000A8400CB823410000F8FF05ED334100009000C4B4234100005400E9EC334100000060E0AE234100000800D9EC3341000070FF9FAB23410000D4FFB4EC33410000104038A423410000F8FFACEC3341000038A0B1A223410000C4FFA8EC33410000F0FFC6A1234100002C0092EC33410000A8402F9D23410000200073EC33410000A060CD962341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3792','117','CRANE RD','0105000020DF080000010000000102000020DF0800000A0000000000200073EC33410000A060CD9623410000ECFF4EEC334100005060D0962341000054009AEB33410000609FDF9623410000B8FF3AE733410000D8BF3D9723410000F8FFACE2334100001040A09723410000080051DD33410000F0BF139823410000B8FF66DB3341000028003D9823410000D4FF88D833410000C0BF7A982341000020004DD833410000D8FF7F9823410000B8FF76D633410000A0A0A7982341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3795','117','RTE 98','0105000020DF080000010000000102000020DF0800000E00000000002000FBC33341000050A0021D24410000ECFFE9C33341000050A0A619244100005400E6C333410000A060EC18244100004800CDC3334100005800FC13244100000800C3C33341000028C00A1224410000C4FFBEC33341000058403E1124410000E0FFA4C333410000C0FF1A0C2441000008009DC33341000068A0700A24410000140090C333410000C0BFD50724410000B8FF8CC333410000D8FF29072441000008008AC33341000028409506244100002C0082C333410000E85FF30424410000480042C33341000058404EF823410000540035C333410000809FBBF52341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3798','117','CRANE RD','0105000020DF080000010000000102000020DF080000060000000000ECFF28F63341000058C0FB9523410000D4FFDAF43341000070FF179623410000C4FFEAF333410000A8402C96234100002C00B8F033410000104071962341000054000FEF334100004040959623410000200073EC33410000A060CD962341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3804','117','SILVERTHORN RD','0105000020DF080000010000000102000020DF080000070000000000200073EC33410000A060CD9623410000D4FF29EC33410000F0FFFF87234100002C00E7EB33410000C0BF0B7B234100002000D5EB3341000040007F77234100004800CDEB334100001040E67523410000E0FFBDEB3341000010C0FB7223410000D4FFB7EB33410000809FAF712341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3813','117','EUREKA RD','0105000020DF080000010000000102000020DF080000170000000000B8FF76D633410000A0A0A79823410000200066D633410000A8FFC99523410000200060D63341000040C0B49423410000B8FF50D6334100009040139223410000480045D63341000028401E9023410000140041D63341000070BF738F2341000008003BD63341000080A0628E23410000B8FF2AD633410000A8FF028C234100002C0020D633410000605FA38B23410000F8FF08D63341000080A0598923410000B8FFFED53341000028004A882341000054000CD633410000F0FFFF8723410000D4FF03D63341000010C0968623410000C4FFF7D533410000989F658423410000C4FFF1D53341000080604D83234100001400E2D533410000A800528023410000D4FFDDD5334100004040B77F23410000D4FFD7D5334100005800817E234100005400D3D53341000058C0B07D234100004800CDD53341000058C0997C23410000F8FFBCD5334100001000AD7923410000ECFFB0D533410000806059772341572EEE0E9CD533414C0A6D6D92732341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3814','117','NEW RD','0105000020DF080000010000000102000020DF08000012000000000048008ED733410000280070C8234100002C0020D63341000090408BC823410000C4FFA2D4334100001040A9C8234100002C00A5D23341000038A0D1C823410000C4FF46D133410000A83FEDC823410000F8FF31CF33410000784017C9234100002000B2CC33410000989F49C9234100002000AFCB3341000058005EC923410000140018CB33410000D8BF69C9234100001400E2C933410000F03F82C923410000540081C93341000058C089C923410000B8FF89C833410000A0609DC923410000B8FF99C7334100005840B0C923410000C4FF92C5334100001040D9C92341000014006DC4334100004040F0C9234100003C00AEC333410000B05FFFC923410000F8FFB3C233410000F0FF12CA23410000480052C233410000D8BF1ACA2341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3816','117','OLD STATE RD','0105000020DF080000010000000102000020DF080000130000000000140034EE33410000F0FFD3F1234100002000EEE933410000F03F3FF2234100001400CFE733410000C03F74F223410000C4FF5CE63341000038A098F223410000C4FF33E533410000C89FB5F2234100004800F6E23341000028C0EDF2234100005400D6E233410000F0BFF0F2234100002000F1DE3341000080A052F3234100003C00EDDD3341000040C06BF3234100003C004FDD33410000985F7BF323410000C4FFDEDB3341000040409EF323410000200024DB33410000C0BFAFF32341000048007EDA3341000078C0B5F323410000ECFF15DA33410000A8BFBDF3234100002C0095D933410000D83FC8F323410000C4FF6CD9334100007840C2F32341000008002BD93341000018A0BCF3234100000800D9D833410000F0FFA7F323410000D4FF88D83341000010C093F32341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3829','117','EUREKA RD','0105000020DF080000010000000102000020DF080000060000000000D4FF88D83341000010C093F3234100003C0085D833410000A83FCDF223410000080028D833410000C85FBFE12341000054000CD833410000D83F9FDC23410000E0FFF6D733410000A840D6D8234100002000EED733410000883F33D72341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3779','117','SILVERTHORN RD','0105000020DF080000010000000102000020DF0800001F0000000000F8FF83EF33410000A840DC3624410000B8FF79EF33410000E89F1335244100003C0062EF33410000F0BF6B3024410000140057EF33410000B09F512E2441000020004AEF33410000E85FB72B2441000020003DEF33410000D8FF552924410000ECFF38EF3341000018A0532824410000540035EF3341000068A09227244100003C0029EF33410000B05F672524410000D4FF26EF3341000010C00E25244100003C0023EF33410000D8FF3F2424410000D4FF2CEF3341000090409B232441000008002BEF334100004040522324410000E0FF1FEF33410000703F212124410000B8FF14EF334100009040D01E2441000054000FEF334100001040BF1D244100002C000AEF33410000F0FFBC1C24410000200004EF33410000F0BF611B24410000D4FF00EF3341000058C0EB1A244100002C00F7EE3341000058C0F11824410000B8FFEEEE33410000E89F3217244100004800E3EE33410000B09FD61424410000C4FFCEEE3341000078C0D710244100004800BDEE33410000C03F440D244100004800A4EE33410000F03F3908244100000800A0EE3341000018A0890724410000E0FF6EEE3341000088FFA4FD23410000ECFF61EE33410000806019FB2341000054005EEE33410000809F53FA23410000D4FF4FEE3341000028406CF723410000140034EE33410000F0FFD3F12341');
INSERT INTO "roads22" ("erieco_gid","mcode","street",geom) VALUES ('3794','117','OLD STATE RD','0105000020DF080000010000000102000020DF0800000C00000000004800B7F833410000609FE5F023410000F8FFE8F733410000A840E3F023410000C4FF6CF733410000703FEFF0234100005400E9F63341000070BFFBF023410000D4FFC7F633410000C0FFFEF023410000F8FF5AF633410000989F09F1234100002000E8F53341000070BF14F123410000C4FF72F533410000883F20F123410000F8FF5DF33341000070BF53F123410000200079F23341000058006AF123410000B8FF76EE3341000038A0CDF123410000140034EE33410000F0FFD3F12341');
CREATE INDEX "roads22_geom_gist" ON "roads22" using gist ("geom" gist_geometry_ops);
END;

*/

/* adds22.sql

SET STANDARD_CONFORMING_STRINGS TO ON;
SELECT DropGeometryColumn('','adds22','geom');
DROP TABLE "adds22";
BEGIN;
CREATE TABLE "adds22" (gid serial PRIMARY KEY,
"erieco_gid" int4,
"address" varchar(40),
"hsnum" varchar(10),
"mcode" int4,
"street" varchar(50));
SELECT AddGeometryColumn('','adds22','geom','2271','POINT',2);
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98671','10095 RTE 98','10095','117','RTE 98','0101000020DF08000033FEE1FFAAC33341DB48B25FC9EA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98672','10115 RTE 98','10115','117','RTE 98','0101000020DF0800003675F2FFB6C33341EBB2A03F6BE92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98674','10135 RTE 98','10135','117','RTE 98','0101000020DF080000BC39EAFFB0C333419D79629FE2E52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98675','10150 RTE 98','10150','117','RTE 98','0101000020DF080000D99F04004EC23341E07688C058E42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98677','10167 RTE 98','10167','117','RTE 98','0101000020DF0800002C75F2FFB6C333412E86B6FFEBE22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98679','10176 RTE 98','10176','117','RTE 98','0101000020DF0800005ADB0C0054C23341AC148DA094E22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98680','10185 RTE 98','10185','117','RTE 98','0101000020DF080000D6F0210001C43341EC49C6BFDEE02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98684','10213 RTE 98','10213','117','RTE 98','0101000020DF0800006ED2F7FFF5C33341962E80BF5CDE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98688','10243 RTE 98','10243','117','RTE 98','0101000020DF0800002E5AD5FF52C333410E083BA009DB2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98689','10280 RTE 98','10280','117','RTE 98','0101000020DF080000931DF5FF2EC233414A247BBF1DDA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98690','10253 RTE 98','10253','117','RTE 98','0101000020DF080000BC43D7FF2CC333414864DCBFDAD92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98692','10267 RTE 98','10267','117','RTE 98','0101000020DF080000F429CCFF5FC33341D8529B9F32D82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98695','10315 RTE 98','10315','117','RTE 98','0101000020DF080000539A360010C33341C0EAC9BF56D32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98697','10330 RTE 98','10330','117','RTE 98','0101000020DF080000143EE0FFD0C133413331FA9F28D22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98709','10376 RTE 98','10376','117','RTE 98','0101000020DF080000153EE0FFD0C13341C09DDC9FD7CB2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98713','7474 NEW RD','7474','117','NEW RD','0101000020DF080000CCCC00009AC2334160FC5760B6CA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98717','7411 NEW RD','7411','117','NEW RD','0101000020DF0800008BE4390075C5334172B45FBF08C92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98718','7341 NEW RD','7341','117','NEW RD','0101000020DF08000091233E00C7C7334117B6EE3FDDC82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98719','10414 RTE 98','10414','117','RTE 98','0101000020DF0800006341B3FFFEC133413FBA04C0CFC82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98720','7323 NEW RD','7323','117','NEW RD','0101000020DF0800001A4D2D006CC8334164636BA0B5C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98721','7215 NEW RD','7215','117','NEW RD','0101000020DF080000DDD14F005ECC334146C47DA09BC82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98722','7455 NEW RD','7455','117','NEW RD','0101000020DF080000F484100008C43341DAF1ACFF80C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98723','7281 NEW RD','7281','117','NEW RD','0101000020DF0800005A053D00DAC9334186DD779F66C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98724','10411 RTE 98','10411','117','RTE 98','0101000020DF0800002691BEFF1AC33341B078994032C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98725','7303 NEW RD','7303','117','NEW RD','0101000020DF080000C4DB4D0035C9334166EB060025C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98729','7239 NEW RD','7239','117','NEW RD','0101000020DF0800000B550E007DCB3341C8DC24C0FAC62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98733','10476 RTE 98','10476','117','RTE 98','0101000020DF08000052B7B1FF73C13341C3096CC01AC42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98734','10480 RTE 98','10480','117','RTE 98','0101000020DF0800008ADDCDFFEAC133416E696CC069C32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98735','10482 RTE 98','10482','117','RTE 98','0101000020DF080000F7FB31006FC13341EB0C1E609FC22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98738','10491 RTE 98','10491','117','RTE 98','0101000020DF080000AB55F0FF8DC23341261777C098C02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98739','7259 NEW RD','7259','117','NEW RD','0101000020DF0800003DE0F8FF80CA33411CD269FF76C02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98741','10495 RTE 98','10495','117','RTE 98','0101000020DF0800002B47E4FFD3C23341E974D8FF29BF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98742','10499 RTE 98','10499','117','RTE 98','0101000020DF08000075091B0037C33341684C7F40F7BE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98749','10528 RTE 98','10528','117','RTE 98','0101000020DF0800001EECD9FFA4C1334192EB8E40C7B92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98750','10539 RTE 98','10539','117','RTE 98','0101000020DF0800000A6AF3FFA3C3334157E7EBFFADB92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98751','10566 RTE 98','10566','117','RTE 98','0101000020DF0800000E984C005BC13341FEF39AC0D9B72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98754','10676 RTE 98','10676','117','RTE 98','0101000020DF080000E6CE46007EBE334138183940D7B52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98756','10610 RTE 98','10610','117','RTE 98','0101000020DF080000BF3BBCFFA2C03341E7A7639F1BB42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98759','10616 RTE 98','10616','117','RTE 98','0101000020DF08000090DD070064C13341203ADC9F5FB12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98762','10621 RTE 98','10621','117','RTE 98','0101000020DF0800005AE5BFFF56C2334154BF959F8EAF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98763','10626 RTE 98','10626','117','RTE 98','0101000020DF0800001123C3FF6CC1334184FB22C046AF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98764','10631 RTE 98','10631','117','RTE 98','0101000020DF080000CFB1E3FF35C2334178183BC0BAAE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98765','10650 RTE 98','10650','117','RTE 98','0101000020DF0800001423C3FF6CC13341946511A0E8AD2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98771','7190 CRANE RD','7190','117','CRANE RD','0101000020DF08000074E92500A2CD334131428F3F33A72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98773','10671 RTE 98','10671','117','RTE 98','0101000020DF080000AFB90F001BC23341C20EAB9F9DA62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98775','10705 RTE 98','10705','117','RTE 98','0101000020DF080000E1A9B7FF50C23341AC8D9D406EA52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98776','10730 RTE 98','10730','117','RTE 98','0101000020DF08000051D2080051C133412C7F89A03FA52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98781','10747 RTE 98','10747','117','RTE 98','0101000020DF0800005249DFFFE3C133410BA5BE3FDFA02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98782','7300 CRANE RD','7300','117','CRANE RD','0101000020DF08000066FEF9FF6DC833411C9B77BF17A02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98786','7220 CRANE RD','7220','117','CRANE RD','0101000020DF080000F55D2300DBC9334196A07FBFCE9E2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98795','10788 RTE 98','10788','117','RTE 98','0101000020DF080000FF61D8FF19C133417C96A3BFAD9C2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98808','7544 CRANE RD','7544','117','CRANE RD','0101000020DF0800006579BFFFB8BF33419F06F5FF289B2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98811','7250 CRANE RD','7250','117','CRANE RD','0101000020DF08000089D01400A9C93341494C66BFCF9A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98816','7643 CRANE RD','7643','117','CRANE RD','0101000020DF080000BD46DDFF6BBB3341359640A0589A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98817','7216 CRANE RD','7216','117','CRANE RD','0101000020DF08000006E8B0FF73CB33417EE08EBF4F9A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98819','7140 CRANE RD','7140','117','CRANE RD','0101000020DF080000CF630900DCCD334196555A602B9A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98820','7591 CRANE RD','7591','117','CRANE RD','0101000020DF0800000B80EAFF61BC33415AFC625F289A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98824','7389 CRANE RD','7389','117','CRANE RD','0101000020DF0800007C6DEFFFEFC53341D080E9FFBD982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98825','7233 CRANE RD','7233','117','CRANE RD','0101000020DF080000F766EDFF64CB3341ACA6709F99982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98826','7141 CRANE RD','7141','117','CRANE RD','0101000020DF080000E4C83A0000CE3341C6A6709F99982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98827','7115 CRANE RD','7115','117','CRANE RD','0101000020DF080000D11A0700B3CE3341C6A6709F99982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98836','10916 RTE 98','10916','117','RTE 98','0101000020DF08000056D3B7FF50C033414424623F87912341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98872','7120 CRANE RD','7120','117','CRANE RD','0101000020DF080000F763F6BFCCCE3341C067F31F889E2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98873','7241 CRANE RD','7241','117','CRANE RD','0101000020DF080000E406044025CA3341DABAF37F51972341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98874','7251 CRANE RD','7251','117','CRANE RD','0101000020DF080000426C096060C933410D0DEA5F16982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98875','7291 CRANE RD','7291','117','CRANE RD','0101000020DF080000F360F75F80C8334168D9FCFF60982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98885','10740 RTE 98','10740','117','RTE 98','0101000020DF080000C679F83FE9BF3341DA0604A090A12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98886','10645 RTE 98','10645','117','RTE 98','0101000020DF0800005D8EFE9F8EC333418A56170087A92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98887','7629 NEW RD','7629','117','NEW RD','0101000020DF08000020ADF4BF09BD3341E09C0AC02EC82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98888','7653 NEW RD','7653','117','NEW RD','0101000020DF080000E8FD0BA0C7BB33415833EF1F72C92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98890','7181 NEW RD','7181','117','NEW RD','0101000020DF080000BB97F4DF99CD3341E4BC216010C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98907','10092 RTE 98','10092','117','RTE 98','0101000020DF08000033BDF13FAFC033414A5405A0D5EB2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98908','10130 RTE 98','10130','117','RTE 98','0101000020DF0800009A66F1DFC0C033418016EBFF92E62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98909','10917 RTE 98','10917','117','RTE 98','0101000020DF080000A2A8795D7DC23341EF0A848C37922341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98910','11300 RTE 98','11300','117','RTE 98','0101000020DF080000EE559928FFBF3341E436AE2A50D72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98913','10613 RTE 98','10613','117','RTE 98','0101000020DF0800000E44D14277C233418D79082E27B32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87548','9970 RTE 98','9970','117','RTE 98','0101000020DF0800008CDC1E00EBC23341409B635F2EF82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87549','7504 OLD STATE RD','7504','117','OLD STATE RD','0101000020DF0800006FC9F3FFF2C23341C01579A0AEF62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87551','7514 OLD STATE RD','7514','117','OLD STATE RD','0101000020DF080000212CC7FF6FC23341C4DE870072F62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87552','7528 OLD STATE RD','7528','117','OLD STATE RD','0101000020DF08000065B63C00EDC13341A218759F53F62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87553','7460 OLD STATE RD','7460','117','OLD STATE RD','0101000020DF08000075D14800F6C4334106DC623F2BF62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87555','7356 OLD STATE RD','7356','117','OLD STATE RD','0101000020DF080000DE4BE1FF5BC833412A00F09F0FF62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87557','7471 OLD STATE RD','7471','117','OLD STATE RD','0101000020DF080000D183C4FFF7C33341C5837D0043F52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87558','7405 OLD STATE RD','7405','117','OLD STATE RD','0101000020DF08000007F4BAFFB5C4334112874860FCF42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87560','7341 OLD STATE RD','7341','117','OLD STATE RD','0101000020DF0800006287AFFFE8C8334104287AC0B1F42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87562','7231 OLD STATE RD','7231','117','OLD STATE RD','0101000020DF0800003485EEFF51C93341F2C485608BF32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87563','7281 OLD STATE RD','7281','117','OLD STATE RD','0101000020DF0800001F1F0E002ECA33410CC585608BF32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87568','7391 OLD STATE RD','7391','117','OLD STATE RD','0101000020DF080000CF534700BAC73341E4E4705F86F02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87570','7231 OLD STATE RD','7231','117','OLD STATE RD','0101000020DF0800002431DCFFBACC3341EFACAF5FA0EF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87571','7391 OLD STATE RD','7391','117','OLD STATE RD','0101000020DF0800000586EFBF96C6334142E200E0A0F02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87572','0 RTE 98','0','117','RTE 98','0101000020DF0800003141F7DFC1C233419ABD18E01CF92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87576','10004 OLD STATE RD','10004','117','OLD STATE RD','0101000020DF0800001170FEFF2EC1334162991DC034F52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87578','7476 OLD STATE RD','7476','117','OLD STATE RD','0101000020DF0800009A58956840C433417815A73A22F72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87579','7280 OLD STATE RD','7280','117','OLD STATE RD','0101000020DF0800005DC2EF1651CB33416AE42A7161F52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98663','10007 RTE 98','10007','117','RTE 98','0101000020DF080000B270D3FF78C333412FD98860A1F42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98664','10010 RTE 98','10010','117','RTE 98','0101000020DF08000082130800B3C23341B1DC53C05AF42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98665','10015 RTE 98','10015','117','RTE 98','0101000020DF080000F2E82F0095C333410AAF4E40C3F32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98666','10023 RTE 98','10023','117','RTE 98','0101000020DF0800009C14E0FFD0C33341708E00408AF22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98667','10036 RTE 98','10036','117','RTE 98','0101000020DF080000B89D4300B7C2334174FC04A01EF12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98668','10038 RTE 98','10038','117','RTE 98','0101000020DF0800005164C2FFCEC23341152D82A003F02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98670','10055 RTE 98','10055','117','RTE 98','0101000020DF080000C8023B0062C333412C0C34A0CAEE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98906','10076 RTE 98','10076','117','RTE 98','0101000020DF080000ABCFF35F31C23341C223F37FD6ED2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25702','6840 OLD STATE RD','6840','117','OLD STATE RD','0101000020DF0800008E6FEDFFA0DA334103F9EE3F91F42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25704','6924 OLD STATE RD','6924','117','OLD STATE RD','0101000020DF0800008E4CB5FFB2D733416E57693F57F42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25707','6721 OLD STATE RD','6721','117','OLD STATE RD','0101000020DF0800009E2ECCFF88DE3341334CD69FC1F22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25708','6945 OLD STATE RD','6945','117','OLD STATE RD','0101000020DF080000002217000ED83341E0A235A0A4F22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25710','6881 OLD STATE RD','6881','117','OLD STATE RD','0101000020DF0800006B53F8FF1ED9334157F994A087F22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25711','6751 OLD STATE RD','6751','117','OLD STATE RD','0101000020DF0800009BB7F5FFF5DD33411601B09F6AF22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25712','6625 OLD STATE RD','6625','117','OLD STATE RD','0101000020DF080000FEF9F5FF93E23341807053C0BCF12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25713','6475 OLD STATE RD','6475','117','OLD STATE RD','0101000020DF080000091D2E0082E53341CE7053C0BCF12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25718','6823 OLD STATE RD','6823','117','OLD STATE RD','0101000020DF080000FAF20E0057DB3341C1F51C00D5F02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25730','6993 OLD STATE RD','6993','117','OLD STATE RD','0101000020DF080000885504008AD533414DCAC75F14EF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25779','6839 CRANE RD','6839','117','CRANE RD','0101000020DF08000011A3DAFF1CD8334174225640C3972341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25781','6601 CRANE RD','6601','117','CRANE RD','0101000020DF08000098401F0063DD33411BDD92A045972341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25782','6741 CRANE RD','6741','117','CRANE RD','0101000020DF080000C7664C0035DB334164A207403B972341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25784','6515 CRANE RD','6515','117','CRANE RD','0101000020DF080000A408C8FFD4E23341814A963FC1962341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25812','6640 CRANE RD','6640','117','CRANE RD','0101000020DF080000B713F7FFADDF3341FF9904E0C8992341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25813','6684 CRANE RD','6684','117','CRANE RD','0101000020DF0800000B8500E06EDE3341B25FF69F4E992341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25814','6692 CRANE RD','6692','117','CRANE RD','0101000020DF0800001EBAF01FD6DD3341E9D9FAFFC1992341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25815','6620 OLD STATE RD','6620','117','OLD STATE RD','0101000020DF080000A86E04C0D4E233416F4602C014F62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25816','6520 OLD STATE RD','6520','117','OLD STATE RD','0101000020DF080000F2450E80CAE533413C23F07F76F32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25820','6734 OLD STATE RD','6734','117','OLD STATE RD','0101000020DF0800009BC35D1D8DDE334160C53F2CFDF42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87564','7200 OLD STATE RD','7200','117','OLD STATE RD','0101000020DF08000061F2EFFF2BCF3341CA6F6AC043F32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87565','7190 OLD STATE RD','7190','117','OLD STATE RD','0101000020DF08000021D350009ACF3341F6E875C05FF22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87567','7151 OLD STATE RD','7151','117','OLD STATE RD','0101000020DF080000AFBD2A0092D03341106F725F11F12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('87569','7101 OLD STATE RD','7101','117','OLD STATE RD','0101000020DF0800004A43D3FF65D1334193AE90C04BF02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98678','10565 EUREKA RD','10565','117','EUREKA RD','0101000020DF080000AE794E000FD9334154518EFFBAE22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98686','10617 EUREKA RD','10617','117','EUREKA RD','0101000020DF08000015BEF7FF80D8334154A567BF4ADC2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98691','10631 EUREKA RD','10631','117','EUREKA RD','0101000020DF08000026D94E005ED833411977F69F12D92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98693','10645 EUREKA RD','10645','117','EUREKA RD','0101000020DF0800009030E9FF4ED833412FB768BFE8D62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98699','10709 EUREKA RD','10709','117','EUREKA RD','0101000020DF0800003D37C9FF23D83341AD6C7E4095D12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98701','10738 EUREKA RD','10738','117','EUREKA RD','0101000020DF08000088F0FBFF83D7334103094F001FD12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98702','10721 EUREKA RD','10721','117','EUREKA RD','0101000020DF080000984B40002CD83341DA6372A01DD02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98703','10761 EUREKA RD','10761','117','EUREKA RD','0101000020DF080000D08D280007D83341CEBE436045CE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98710','7070 NEW RD','7070','117','NEW RD','0101000020DF080000DF11B8FFDBD0334173C4E0BFF0CA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98714','7036 NEW RD','7036','117','NEW RD','0101000020DF080000FA9AD0FFEDD23341CA82754053CA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98716','10787 EUREKA RD','10787','117','EUREKA RD','0101000020DF080000BA84B0FF11D83341EC2560002BC92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98726','7101 NEW RD','7101','117','NEW RD','0101000020DF080000DA08EEFF51CF33414A09A43F09C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98728','6981 NEW RD','6981','117','NEW RD','0101000020DF08000005D2E2FFD3D43341F7FF653F8DC72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98731','10856 EUREKA RD','10856','117','EUREKA RD','0101000020DF08000092CB2B001DD73341DA9F6DA08FC42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98732','10827 EUREKA RD','10827','117','EUREKA RD','0101000020DF080000F2D73C00C7D73341C09F6DA08FC42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98737','10873 EUREKA RD','10873','117','EUREKA RD','0101000020DF0800008815CCFFEAD733415430054028C12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98743','10905 EUREKA RD','10905','117','EUREKA RD','0101000020DF08000084CBF1FFA3D73341083C6060CFBE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98744','10908 EUREKA RD','10908','117','EUREKA RD','0101000020DF08000003D1BFFFE1D6334142DE0F4057BE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98746','10930 EUREKA RD','10930','117','EUREKA RD','0101000020DF08000069EF230066D633419BE37A3FFEBB2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98753','10979 EUREKA RD','10979','117','EUREKA RD','0101000020DF080000675C0D007DD73341EC827AFFE4B52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98755','11030 EUREKA RD','11030','117','EUREKA RD','0101000020DF080000AFB20900C9D53341E02D57A06AB42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98758','11050 EUREKA RD','11050','117','EUREKA RD','0101000020DF0800008E702100EED53341ED83BE3F1BB22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98761','11066 EUREKA RD','11066','117','EUREKA RD','0101000020DF080000B1B20900C9D533419BE7729F9CAF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98766','11080 EUREKA RD','11080','117','EUREKA RD','0101000020DF0800004D652200DBD53341FBA7F99FC3AD2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98767','11057 EUREKA RD','11057','117','EUREKA RD','0101000020DF0800000E593A004FD73341260685A08BAD2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98769','11104 EUREKA RD','11104','117','EUREKA RD','0101000020DF0800003437DAFF7ED53341CF440EA083A92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98774','11167 EUREKA RD','11167','117','EUREKA RD','0101000020DF0800004252200001D83341F5B265BF1EA62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98777','11134 EUREKA RD','11134','117','EUREKA RD','0101000020DF080000385C1E00D8D433417370A69FFCA42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98778','11151 EUREKA RD','11151','117','EUREKA RD','0101000020DF0800007839C4FF33D7334124D992BFF0A32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98779','11154 EUREKA RD','11154','117','EUREKA RD','0101000020DF080000B03BBFFF43D63341E2197140EBA22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98783','11220 EUREKA RD','11220','117','EUREKA RD','0101000020DF08000008624F00ADD533418AE81C005A9F2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98787','11234 EUREKA RD','11234','117','EUREKA RD','0101000020DF08000059F74F004BD63341430E5A40159E2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98798','6994 CRANE RD','6994','117','CRANE RD','0101000020DF080000DD190D00DFD23341E96560A0839C2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98802','11266 EUREKA RD','11266','117','EUREKA RD','0101000020DF080000F22BDBFF6BD53341C9AA8EC0A79B2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98813','7030 CRANE RD','7030','117','CRANE RD','0101000020DF0800008A4ED2FF78D1334152C17300999A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98821','7094 CRANE RD','7094','117','CRANE RD','0101000020DF080000C5872A0043CF334172321160E2992341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98823','6962 CRANE RD','6962','117','CRANE RD','0101000020DF0800004F660B0054D433416735919F62992341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98828','7099 CRANE RD','7099','117','CRANE RD','0101000020DF0800007073B3FF3ACF3341FB5DA0FF74982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98829','7039 CRANE RD','7039','117','CRANE RD','0101000020DF080000A93240008ED13341D15DE29F62982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98830','6967 CRANE RD','6967','117','CRANE RD','0101000020DF0800002601DAFF2FD43341C783693F3E982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98832','11336 EUREKA RD','11336','117','EUREKA RD','0101000020DF0800003EB7280007D63341C80DB63F9D952341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98833','11347 EUREKA RD','11347','117','EUREKA RD','0101000020DF08000002464900D0D6334196A1D5BFD1942341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98835','11379 EUREKA RD','11379','117','EUREKA RD','0101000020DF080000FC6A190037D733412BD89D5FF0922341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98837','11390 EUREKA RD','11390','117','EUREKA RD','0101000020DF080000A7A9CBFF4CD53341E8021CC004902341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98838','11405 EUREKA RD','11405','117','EUREKA RD','0101000020DF080000F8FDF5FFA6D633417953CD3FD58F2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98891','7067 NEW RD','7067','117','NEW RD','0101000020DF080000A716FC3F4FD133413892FD1FBDC72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98892','7031 NEW RD','7031','117','NEW RD','0101000020DF08000075A2F0FF16D333416A3B1B0022C72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98893','10902 EUREKA RD','10902','117','EUREKA RD','0101000020DF08000028100820EDD63341E2C3FF3F3BBF2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98894','10952 EUREKA RD','10952','117','EUREKA RD','0101000020DF080000E4AFFDDFCAD63341205AF55F6BBA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98895','11167 EUREKA RD','11167','117','EUREKA RD','0101000020DF08000037A30660ADD83341F34B08203BA42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98896','11215 EUREKA RD','11215','117','EUREKA RD','0101000020DF080000B1F4F9FF91D83341CE2FE91F199F2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98897','11281 EUREKA RD','11281','117','EUREKA RD','0101000020DF080000A399030076D73341B9A5E4FF7F9A2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98898','11383 EUREKA RD','11383','117','EUREKA RD','0101000020DF0800001EF1FDDF0BD733412A2DED9F7D912341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98903','10771 EUREKA RD','10771','117','EUREKA RD','0101000020DF080000129DFB5F58D83341697609C048CA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98904','10525 EUREKA RD','10525','117','EUREKA RD','0101000020DF080000A090F87FD0D83341F086FE1FF6E52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98905','10481 EUREKA RD','10481','117','EUREKA RD','0101000020DF080000F86CFF7F23D933417664F83F40EC2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('98912','10827 EUREKA RD','10827','117','EUREKA RD','0101000020DF08000073519CC2B3DF3341BB845F60B0C32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25703','6470 OLD STATE RD','6470','117','OLD STATE RD','0101000020DF0800009A2ADDFFD0E733419A75933F62F42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25705','6530 OLD STATE RD','6530','117','OLD STATE RD','0101000020DF080000C32C12005AE633414670AD5FC6F32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25706','6140 OLD STATE RD','6140','117','OLD STATE RD','0101000020DF080000A126DDFFBDF333415C1A91C0E9F22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25709','6170 OLD STATE RD','6170','117','OLD STATE RD','0101000020DF0800009F38300098F23341C63FCD3F8CF22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25715','6361 OLD STATE RD','6361','117','OLD STATE RD','0101000020DF0800003D934400BAE933418FFC04A01EF12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25723','6091 OLD STATE RD','6091','117','OLD STATE RD','0101000020DF080000E655FDFF37F53341B585260017F02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25736','10765 SILVERTHORN RD','10765','117','SILVERTHORN RD','0101000020DF080000F50F01004EEE3341602142A00FE92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25739','10801 SILVERTHORN RD','10801','117','SILVERTHORN RD','0101000020DF08000067CA0B00CCEE334102CE84FFC7E62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25741','10815 SILVERTHORN RD','10815','117','SILVERTHORN RD','0101000020DF0800002392D6FFF3EE3341C8148440AEE52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25742','10833 SILVERTHORN RD','10833','117','SILVERTHORN RD','0101000020DF0800002648FCFFACEE3341AB3FC8BF07E42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25743','10845 SILVERTHORN RD','10845','117','SILVERTHORN RD','0101000020DF080000952711000BEF3341DFF5933F75E22341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25745','10885 SILVERTHORN RD','10885','117','SILVERTHORN RD','0101000020DF080000912711000BEF3341D5A1619FA6E02341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25747','10909 SILVERTHORN RD','10909','117','SILVERTHORN RD','0101000020DF0800004C80310085EE33412A11815FB8DC2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25749','10910 SILVERTHORN RD','10910','117','SILVERTHORN RD','0101000020DF0800004E2FDAFF58ED33413C934EA02BDC2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25752','11056 SILVERTHORN RD','11056','117','SILVERTHORN RD','0101000020DF080000F2FC490048ED334171D774FFCED42341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25753','11057 SILVERTHORN RD','11057','117','SILVERTHORN RD','0101000020DF080000F9B347001FEE33410131C83F24D32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25756','11098 SILVERTHORN RD','11098','117','SILVERTHORN RD','0101000020DF080000BE20080018ED3341B8AE5F4008CA2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25757','11117 SILVERTHORN RD','11117','117','SILVERTHORN RD','0101000020DF0800008A27D7FF91EF3341E44B95BF2FC82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25758','11115 SILVERTHORN RD','11115','117','SILVERTHORN RD','0101000020DF08000016B6CEFF3CEE3341751D1B4011C82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25759','11135 SILVERTHORN RD','11135','117','SILVERTHORN RD','0101000020DF080000222D1900C2ED33415A46D8BF4CC62341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25760','11144 SILVERTHORN RD','11144','117','SILVERTHORN RD','0101000020DF0800000F5BC4FF0DED334138079AA0C3C32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25761','11155 SILVERTHORN RD','11155','117','SILVERTHORN RD','0101000020DF0800003ED2FDFF37EF3341432265C050C32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25764','11181 SILVERTHORN RD','11181','117','SILVERTHORN RD','0101000020DF080000DBD70500EFED3341DAD1793F60C12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25765','11211 SILVERTHORN RD','11211','117','SILVERTHORN RD','0101000020DF08000087822C0095ED33410A82FC9F77B92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25766','11255 SILVERTHORN RD','11255','117','SILVERTHORN RD','0101000020DF080000E358030077ED3341580B0EC086B72341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25767','11330 SILVERTHORN RD','11330','117','SILVERTHORN RD','0101000020DF0800000EDA3A0078EC334195B077C049B52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25768','11391 SILVERTHORN RD','11391','117','SILVERTHORN RD','0101000020DF0800004E2FDAFF58ED3341AA5070C092AE2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25769','11401 SILVERTHORN RD','11401','117','SILVERTHORN RD','0101000020DF080000CED73F0068ED334196F910A04AAB2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25772','11475 SILVERTHORN RD','11475','117','SILVERTHORN RD','0101000020DF0800009B032A001DED33417945E73FAEA32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25773','11490 SILVERTHORN RD','11490','117','SILVERTHORN RD','0101000020DF080000C798C7FF23EC334100561FC0A5A12341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25774','11520 SILVERTHORN RD','11520','117','SILVERTHORN RD','0101000020DF08000050412D0033EC3341903B4600789D2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25776','6200 CRANE RD','6200','117','CRANE RD','0101000020DF0800005EE5EEFFB6EF3341C4A150C02B9B2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25777','6020 CRANE RD','6020','117','CRANE RD','0101000020DF080000B1404B0022F533413C2978FF43982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25778','6430 CRANE RD','6430','117','CRANE RD','0101000020DF080000F5081A0011E73341BDCBB49FF2972341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25780','6330 CRANE RD','6330','117','CRANE RD','0101000020DF08000014EEDAFFF6EB3341D3D081BF59972341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25783','6050 CRANE RD','6050','117','CRANE RD','0101000020DF080000257D020028F43341F2687E9FDE962341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25785','6325 CRANE RD','6325','117','CRANE RD','0101000020DF0800006B5E0B002EEC3341C065615F4E962341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25787','6049 CRANE RD','6049','117','CRANE RD','0101000020DF0800005BDA4100E0F3334168506DA08C952341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25788','6159 CRANE RD','6159','117','CRANE RD','0101000020DF0800000A47D9FFBAF033413AC7AE3F84952341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25807','6116 CRANE RD','6116','117','CRANE RD','0101000020DF080000552302E0B1F133415817E2BF88982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25808','11640 SILVERTHORN RD','11640','117','SILVERTHORN RD','0101000020DF080000D9E80E806CEB3341F60D1520C8902341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25811','11513 SILVERTHORN RD','11513','117','SILVERTHORN RD','0101000020DF080000F5FCF0BF0CED3341C4410CE06E9E2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25817','6250 OLD STATE RD','6250','117','OLD STATE RD','0101000020DF080000B32AF7DFE8EF334182B01F00A8F52341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25818','6200 OLD STATE RD','6200','117','OLD STATE RD','0101000020DF0800008C83076068F1334135C609606AF32341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25819','10960 SILVERTHORN RD','10960','117','SILVERTHORN RD','0101000020DF080000DA110BE06BEB33416D6DEF3F49D82341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25821','11061 SILVERTHORN RD','11061','117','SILVERTHORN RD','0101000020DF080000CE76A87EF9EE33415006C24170CC2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('25822','11573 SILVERTHORN RD','11573','117','SILVERTHORN RD','0101000020DF0800007420C152FCEC3341D15BFCE896982341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('32801','10607 SILVERTHORN RD','10607','117','SILVERTHORN RD','0101000020DF080000F8A12E00BEEE334192836B4076FB2341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('32802','10605 SILVERTHORN RD','10605','117','SILVERTHORN RD','0101000020DF08000038361D00C5EE3341F645F5FFDFF92341');
INSERT INTO "adds22" ("erieco_gid","address","hsnum","mcode","street",geom) VALUES ('32803','10644 SILVERTHORN RD','10644','117','SILVERTHORN RD','0101000020DF080000E4F4E3FFE9ED3341E2D27F9FD1F62341');
CREATE INDEX "adds22_geom_gist" ON "adds22" using gist ("geom" gist_geometry_ops);
END;

*/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
Richard Greenwood
Sent: Monday, March 29, 2010 10:43 PM
To: PostGIS Users Discussion
Subject: [postgis-users] reverse geocoding

I'm not even sure if "reverse geocoding" is the correct term, but what
I am trying to do is improve TIGER road centerline data from known
points. I have a set a accurate address points, and I would like to
assign fromleft, toleft, fromright, toright ranges to the TIGER
centerlines from these points. I am just doing this for one small
community, so I don't intend to turn it into a big programming
project. i.e. I don't want to spend more time doing it programatically
than it would take to do it "by hand". But if there is a tool or some
code out there that would help, I sure would appreciate any pointers.

Thanks,
Rich

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users