text: CREATE OR REPLACE PROCEDURE load_np21_waterbody_55059
  AUTHID CURRENT_USER
  AS
     str_sql CLOB;
     
  BEGIN
  
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (1,'19284997',19284997,'15-OCT-99',3,NULL,NULL,.34611047906,0,NULL,466,46600,'071200061003',.8943,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2811421067222,42.5946544004811,-88.2811415068744,42.5951118676195,-88.2809233736141,42.5961180003463,-88.2807369738317,42.5965754009349,-88.280519506969,42.5970554005872,-88.2803023737549,42.5973754675047,-88.2799615064177,42.5976268675868,-88.2786913066578,42.5982204669019,-88.2779477732705,42.5985856671957,-88.2775137730416,42.5989742003999,-88.2772965732776,42.5992942673175,-88.2773887735724,42.5997518001064,-88.2775433067775,42.5999576675133,-88.2776049732902,42.6001408009581,-88.2780377738235,42.6004612671746,-88.2788731738572,42.6008280008125,-88.279770506603,42.6011032005532,-88.280451573081,42.6011494005253,-88.2816899737127,42.6010818002858,-88.2831147066777,42.6007398007022,-88.2845705067228,42.600123467425,-88.2856551070969,42.599438067114,-88.2858721737612,42.5990494673599,-88.2858733069069,42.598294667266,-88.2857809069627,42.5979058004133,-88.2856575064881,42.5977226669684,-88.2856267730565,42.5975396675225,-88.284761373438,42.5964870668256,-88.2845761068012,42.5961666671589,-88.284607172982,42.5960294674869,-88.2845145068384,42.5959836002638,-88.2844539734714,42.5949544008258,-88.2843615735272,42.5946798674828,-88.2841145063787,42.5942222006949,-88.2837743737877,42.5939016670292,-88.2833413736049,42.593649800199,-88.2829701064846,42.5935810002638,-88.2824437737605,42.5936034005774,-88.2817315071027,42.5938772675228,-88.2815455066192,42.594014400645,-88.2813283734051,42.5943344001134,-88.2811421067222,42.5946544004811));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (2,'14768008',14768008,'15-OCT-99',3,'1564227','Dyer Lake',.23475818403,0,'07120006001630',390,39004,'071200061002',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.296872106362,42.6037434670882,-88.296392506908,42.6036312002206,-88.294751506776,42.6036528675867,-88.2926767069638,42.6040174671333,-88.2918715736136,42.6040856006708,-88.2916855731301,42.6042454668557,-88.2913133734128,42.6047942007926,-88.2911579732612,42.6052742669947,-88.2910949065041,42.6061206000865,-88.2911877731966,42.6061892003722,-88.2912179733302,42.606715400896,-88.2919303065378,42.6065784674232,-88.2921163735712,42.6063728005652,-88.2925499736018,42.6061902004183,-88.2927977071478,42.6062132005796,-88.2933237071227,42.606442266898,-88.2934783068777,42.606579600569,-88.293663773164,42.6068542670117,-88.2940969064464,42.6071976002899,-88.2942821730832,42.607517866857,-88.2944059063069,42.607609467304,-88.2956753065695,42.6077932671465,-88.2966967736365,42.6079770004391,-88.2972231063606,42.6079544670259,-88.297904707036,42.6077032674927,-88.2985553062817,42.6073378001003,-88.2988341734577,42.6070634673061,-88.2990823737519,42.6066062672663,-88.2990517068702,42.6064232669211,-88.2989589732774,42.6063316673735,-88.2989295735404,42.6050508673046,-88.298651506761,42.6045246667808,-88.2982493731095,42.604227067626,-88.2969805070441,42.6037688675401,-88.296872106362,42.6037434670882));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (3,'14768012',14768012,'15-OCT-99',3,NULL,NULL,.04601128032,0,'07120006001629',390,39004,'071200061003',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1361359739954,42.5983490007067,-88.135857373918,42.598372000868,-88.1354859736981,42.5986464676612,-88.1350835072974,42.5988752003311,-88.1349907071548,42.5991496671243,-88.1351765736393,42.5995386005269,-88.1366009738552,42.6004532668057,-88.1374989073481,42.6008420005588,-88.1378085736062,42.601024866905,-88.1381181067646,42.6010248003552,-88.138582373677,42.6005216008921,-88.138551374046,42.6002928673229,-88.1376533065542,42.5994466673308,-88.1374985071498,42.5992180003114,-88.1374985071498,42.5990578670279,-88.1367243734305,42.5985776002769,-88.1361359739954,42.5983490007067));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (4,'14768002',14768002,'15-OCT-99',3,'1565054','Flanagan Lake',.04367565203,0,'07120006001628',390,39004,'071200061003',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1801079072535,42.6102746000936,-88.1793029070029,42.6103664001901,-88.1781883070441,42.6103898670996,-88.177971573129,42.6104814000975,-88.1778479739042,42.6107788005021,-88.1780653733177,42.6114876668233,-88.1784995731961,42.6123108675534,-88.1788405070831,42.6125852003476,-88.1792739065649,42.6125850006981,-88.1794905739302,42.6125162673128,-88.1799237737625,42.6121272673604,-88.1802331072714,42.6116696671223,-88.180356907045,42.6116008671872,-88.1807897732288,42.6109374669914,-88.1807273737687,42.6105486675879,-88.180262706658,42.6102744004442,-88.1801079072535,42.6102746000936));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (5,'14767994',14767994,'15-OCT-99',3,NULL,NULL,.04856608317,0,'07120004009694',390,39004,'071200040101',1,'01-JUN-12',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.126601906652,42.6165102671361,-88.1262923734936,42.6166246671955,-88.1250845740932,42.6175854668967,-88.1248059740158,42.6177454670806,-88.1244033736161,42.6181344004831,-88.124093707358,42.6182716001551,-88.1237529740199,42.6182488005426,-88.1234123072315,42.6179514675871,-88.1233505067199,42.6178142004659,-88.1232885065587,42.6177456001802,-88.1232575734776,42.6175626007343,-88.122823973447,42.6173338671651,-88.1222665736428,42.6174026005505,-88.1221427073194,42.6175854668967,-88.1222355740119,42.6182716001551,-88.1226691740425,42.6185918676215,-88.1235671740852,42.618889200577,-88.1234123737814,42.6193008670423,-88.1235671740852,42.6193694673279,-88.1242175736814,42.6191408003086,-88.1250847071929,42.6186604670078,-88.1266639733631,42.6175854003469,-88.1272213740665,42.6171736007819,-88.1272213740665,42.6167618668676,-88.1268807072782,42.6165788674217,-88.126601906652,42.6165102671361));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (6,'14767996',14767996,'15-OCT-99',3,NULL,NULL,.01405020388,0,'07120004009693',390,39004,'071200040101',1,'01-JUN-12',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1196033069464,42.6175168675103,-88.1190457740426,42.6178370675275,-88.1190459071423,42.6182258003813,-88.1192315739773,42.6185002671745,-88.1195413067853,42.6187748005175,-88.1198819735736,42.6188662669655,-88.1201297071196,42.6187748670674,-88.1204085068465,42.6185460669483,-88.1205633071503,42.6180886672591,-88.1204393733777,42.6177226674681,-88.1200987740385,42.6175168675103,-88.1196033069464,42.6175168675103));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (7,'14783859',14783859,'15-OCT-99',3,NULL,NULL,.43719330319,0,'07120004001466',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1282755737581,42.6288612674344,-88.1292975732238,42.6285868006412,-88.129607306931,42.6285866675416,-88.1301029736726,42.6287238672136,-88.1306913740071,42.6287238672136,-88.1309391732036,42.6285408668684,-88.131001106815,42.6282434673631,-88.1310319067964,42.6268254667228,-88.1308769068431,42.6264824670931,-88.1307221065393,42.6263910006451,-88.1299787737008,42.6263680670336,-88.1294211733479,42.6265968671526,-88.1277489073855,42.6279922003807,-88.1271913070325,42.6280608006663,-88.125085173941,42.6276948674251,-88.1242179738798,42.6276720669132,-88.1239701737838,42.6276034675269,-88.1235365072034,42.6271688674502,-88.122948106869,42.6268030007588,-88.1223593737855,42.6266200004136,-88.1221425733204,42.6264370000684,-88.121987773916,42.6261626007243,-88.1221117067892,42.6256136005881,-88.1221117067892,42.6250188672278,-88.1219569073847,42.6243784671934,-88.1217399738201,42.6240354001145,-88.121244506728,42.623646600711,-88.1205631066014,42.6233950000801,-88.1187979073969,42.6230976671246,-88.1186119734631,42.6229376003909,-88.1185191067707,42.6226402008855,-88.1187049067054,42.6223198668692,-88.1188289070278,42.6213136001434,-88.1184573071583,42.6213136001434,-88.1160725739895,42.6221596670359,-88.115979573298,42.622388467155,-88.1161343736018,42.6230746004134,-88.1165059734712,42.6235550002639,-88.1164129736791,42.6240580675267,-88.1158863738564,42.6245386004769,-88.1154527738258,42.624744267335,-88.1148643069416,42.625018800678,-88.1144617074412,42.6251788674117,-88.1145235736034,42.6253618668576,-88.1146165068457,42.6257964003845,-88.1149571070842,42.6262310004612,-88.1161031068722,42.6265970002523,-88.1182401073944,42.6271688674502,-88.119231173779,42.6273290672835,-88.1197577736017,42.6276264002391,-88.1210585736936,42.6281296006015,-88.1212753732592,42.6282668002735,-88.1213683074008,42.628381200333,-88.121244506728,42.6293418669345,-88.1213993735816,42.6295248672797,-88.1222977072727,42.6296162671779,-88.1224835072074,42.6297078001758,-88.1225763738999,42.6298908005209,-88.122669373692,42.6299822004191,-88.1230719066426,42.6300966004786,-88.1241251071873,42.6300508007048,-88.1246207073791,42.6299136001334,-88.1249923737984,42.6294790000567,-88.1250853070406,42.6291358673273,-88.125487906541,42.6288384669226,-88.1264481072937,42.6287470670244,-88.1275011738394,42.6289070672083,-88.1282755737581,42.6288612674344));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (8,'14767988',14767988,'15-OCT-99',3,NULL,NULL,.0209811614,0,'07120004009692',390,39004,'071200040101',1,'01-JUN-12',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1305357733066,42.6231202670876,-88.1300093740327,42.6231660003116,-88.1289563740368,42.6233720008181,-88.128739507022,42.6234862668786,-88.1287705066529,42.6237836672833,-88.1289253735065,42.6240810002389,-88.1292351737636,42.6243326008698,-88.129637907263,42.6244012002561,-88.1305979065675,42.6242410004227,-88.1311863069019,42.6238292674077,-88.1311243067407,42.6234632676166,-88.1305357733066,42.6231202670876));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (9,'14767986',14767986,'15-OCT-99',3,NULL,NULL,.02116847527,0,'07120004009691',390,39004,'071200040101',1,'01-JUN-12',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1263239073218,42.6241268674619,-88.1258283736798,42.6243098003579,-88.1253947070994,42.6246072007626,-88.1253637740183,42.6250188672278,-88.1256115732149,42.6252934005709,-88.1272531066449,42.6251104002257,-88.1274697740103,42.625018800678,-88.127779573368,42.6248586673945,-88.127996373833,42.6246756670493,-88.127996373833,42.6244698670916,-88.1279343736718,42.6243326674196,-88.1275007070913,42.6241496670744,-88.1263239073218,42.6241268674619));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (10,'14767972',14767972,'15-OCT-99',3,NULL,NULL,.11369191847,0,'07120006001617',390,39004,'071200061003',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1615429738285,42.6318736671369,-88.1611093737979,42.6318966672983,-88.1607997066405,42.63203400007,-88.1604903065817,42.6326060003675,-88.1602427070347,42.6328348004865,-88.1600879067309,42.6329034007722,-88.1595921734394,42.6328578671977,-88.1590345065366,42.6326522003397,-88.158260106618,42.6327210002748,-88.1581051732146,42.6328354003344,-88.1581365064939,42.6332928674728,-88.158508373462,42.633521467043,-88.1589731736724,42.6336814672268,-88.1590971739947,42.6338186003491,-88.1590973736442,42.6341846001401,-88.1587569065054,42.63466500089,-88.1585091738586,42.6349166671714,-88.1580757069277,42.635237066838,-88.1575183071236,42.6354430673446,-88.1574253738813,42.6355574674041,-88.1572705735775,42.6359004670338,-88.1574257731803,42.6363122000489,-88.1575187738717,42.6365180009059,-88.1575189069713,42.6366552671278,-88.1575809071325,42.6366780667403,-88.159253773842,42.6367232675656,-88.1601827735155,42.6361970004921,-88.160430373962,42.6358994669877,-88.1603991737822,42.6355336002963,-88.16027510691,42.6352820671146,-88.1602749072605,42.634801667264,-88.1605843738691,42.634435667473,-88.1609249732083,42.6342298000661,-88.1612655734468,42.634115266907,-88.1614203072008,42.6336578006679,-88.1617917739705,42.633474667223,-88.1623183737933,42.6334744675735,-88.1627829734548,42.6333828671265,-88.1628447739665,42.6332454669057,-88.1626899071129,42.6330854667218,-88.1626897740132,42.6328110673778,-88.1629373735603,42.6326050668712,-88.1629371739108,42.6323762667522,-88.1623175068468,42.6320564003835,-88.1615429738285,42.6318736671369));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (11,'14767976',14767976,'15-OCT-99',3,NULL,NULL,.13233030775,0,'07120006001615',390,39004,'071200061003',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1701241069413,42.6333570008258,-88.1687305732567,42.6337692671389,-88.1683589733873,42.6338380670741,-88.1668411066311,42.63393006682,-88.1662837733768,42.6340676001406,-88.1650449734461,42.6345712672511,-88.1642089735647,42.6350520007501,-88.1634039733141,42.6354410672524,-88.162257973526,42.6358302668542,-88.1621033072212,42.6359904675869,-88.1621035068707,42.6362878005424,-88.1622273731941,42.6363792004407,-88.1625371734511,42.6364478007263,-88.1630329067426,42.6364476001775,-88.163621307077,42.6362186669588,-88.1639619073155,42.6359668675778,-88.1644883065894,42.6356922667856,-88.1656339736284,42.6352344003482,-88.1673065066893,42.634799067324,-88.1686385069609,42.6347756669643,-88.169474773941,42.6348210674392,-88.1702181733294,42.6347064002811,-88.1708995734559,42.6346604008577,-88.17111670667,42.6349118674896,-88.1710857735889,42.635117800547,-88.1708383736914,42.6356896002957,-88.1708695738711,42.6359870007004,-88.1735337731645,42.6361458668392,-88.173967507194,42.6361456671897,-88.1739671735456,42.635848400784,-88.1735641072971,42.6353454000711,-88.1733159070029,42.6347966004836,-88.1734701740087,42.6341560673495,-88.1732841735251,42.6340418003897,-88.1704339071984,42.6333568668268,-88.1701241069413,42.6333570008258));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (12,'19285167',19285167,'15-OCT-99',3,NULL,NULL,.12285707694,0,NULL,466,46600,'071200040101',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0918471736076,42.6353990671142,-88.0918471736076,42.6353306008275,-88.0912899069031,42.6348042672041,-88.0905467071642,42.6343238008037,-88.089989173361,42.6342092001954,-88.0854047074607,42.6342308001122,-88.084846974008,42.6343906671964,-88.0844751070399,42.6346192667667,-88.0844749739402,42.6348938001097,-88.084660773875,42.6349396007828,-88.0848775068908,42.6351226667786,-88.0850943073557,42.6352142006757,-88.0851561735179,42.6352828000621,-88.0872619738604,42.6363814001824,-88.0919705740821,42.6364054669397,-88.0924043072123,42.6364056000393,-88.0923425741498,42.6357880670665,-88.092218773477,42.6355594000472,-88.0920949071536,42.6354678004995,-88.0918471736076,42.6353990671142));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (13,'19284985',19284985,'15-OCT-99',3,NULL,NULL,.56372649813,0,NULL,466,46600,'071200040101',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0856173071923,42.6414128003614,-88.0855863741112,42.6413670005875,-88.0858343738566,42.6411154674058,-88.0857417068137,42.6406580002674,-88.0856797741017,42.6405664672695,-88.0853081733329,42.6402460667035,-88.0848745733023,42.6400860008691,-88.0841311739139,42.6399484675487,-88.0832947738341,42.6399252668385,-88.0827989739928,42.6400166667367,-88.0820553740556,42.6402908673306,-88.0816523734576,42.6405194669008,-88.081497506604,42.6406794670846,-88.0814663073236,42.6408168007557,-88.0813423070013,42.6410912000997,-88.0813419733527,42.6416172000746,-88.081527573638,42.6420976008245,-88.0815273739885,42.6422806002704,-88.0817131073734,42.6424178673916,-88.0817131739232,42.6425322009013,-88.0818989073081,42.6428296669565,-88.0818987733091,42.6428982672422,-88.0819917074507,42.6430126673017,-88.0820225074322,42.6431498669737,-88.0821463737555,42.6433100002572,-88.0822391738981,42.6434472673784,-88.0826417733985,42.6437904675569,-88.0833541066061,42.6441110003233,-88.084500306943,42.6444544001513,-88.0864829073597,42.6447296007914,-88.087629173347,42.6447526675025,-88.0906347732756,42.6442962004102,-88.0920911066186,42.6438390003705,-88.0923389732644,42.6437476004723,-88.0933615069274,42.6434048004921,-88.0948177071708,42.6430392008993,-88.0958093068534,42.6427192005316,-88.0964599735483,42.6423992001639,-88.0968319070662,42.6420332669226,-88.0970799068116,42.6416444675191,-88.0970801739103,42.6410498672585,-88.0969253070566,42.6408896674251,-88.0969253736064,42.6407296006914,-88.0966775735106,42.6404092675746,-88.0960273735638,42.6399288002748,-88.0950981733414,42.6393568008766,-88.0949123734067,42.6392880674912,-88.0943239074218,42.6388764001267,-88.0941381065877,42.638739067355,-88.093611506765,42.6383500674026,-88.0934567739104,42.6381212672836,-88.0934257733801,42.6379612005499,-88.0932711070753,42.6376180669212,-88.0928685741247,42.6371834002946,-88.092156173468,42.6369088004017,-88.0916605732762,42.6368858002404,-88.0885009068907,42.6369078003556,-88.0882219740642,42.6370906676011,-88.0881597733542,42.6373880005567,-88.0882835740271,42.6377768674094,-88.0884383068817,42.6380742003649,-88.0886241068164,42.6381886004245,-88.0885929740858,42.6383716007697,-88.0888715732639,42.6386462006625,-88.0889335068752,42.6388520006203,-88.0889955070364,42.6389206674557,-88.0890263735677,42.6390350000661,-88.089088307179,42.6391494001256,-88.0892119738529,
  42.6394696001428,-88.0892739740141,42.6395382669783,-88.0892739074642,42.6396298008755,-88.0893667741566,42.6397898667099,-88.0896759736666,42.6407734669229,-88.0897999074392,42.64086500082,-88.0898617736013,42.6410480002659,-88.0898925735827,42.6411394667139,-88.0898925070329,42.6414596667311,-88.0898301741226,42.6420086003176,-88.0897061738003,42.6423288003348,-88.0895511738469,42.6426032005782,-88.0893031741016,42.6427860669244,-88.0885283739846,42.6431748672272,-88.0877847740475,42.6434718674336,-88.0876609068247,42.6433804000863,-88.0870411066611,42.6436088674562,-88.0862357071115,42.6436316005189,-88.0858329736122,42.6434714006855,-88.0854923068239,42.6431968007926,-88.0852757069077,42.6428764667764,-88.0852137067465,42.6427620667169,-88.0850899735228,42.6425562002094,-88.0850593740902,42.6418700004011,-88.0851523738823,42.6417100002172,-88.0856173071923,42.6414128003614));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (14,'14783851',14783851,'15-OCT-99',3,NULL,NULL,.05318672658,0,'07120004001464',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1200359734808,42.6484172006942,-88.1197261066739,42.6485314667547,-88.1194163073161,42.6488516667719,-88.1193853067858,42.6494236005196,-88.1194781734783,42.6495380005792,-88.1194781734783,42.6498352004351,-88.119323173525,42.6500868001666,-88.1187655740713,42.6506358003028,-88.1187035073604,42.6508644673222,-88.118982373637,42.6511160670537,-88.1191993072017,42.6511618668276,-88.1199429071388,42.6511618668276,-88.1209345068214,42.6510932008914,-88.1211513072864,42.6510018000939,-88.1212133065482,42.6501326673896,-88.1213991739321,42.6498580674967,-88.1219569073847,42.6493778007458,-88.1219879070156,42.6490348002168,-88.1217711065507,42.6488976005447,-88.1206245734647,42.6484172006942,-88.1200359734808,42.6484172006942));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (15,'19284983',19284983,'15-OCT-99',3,NULL,NULL,.28995709759,0,NULL,466,46600,'071200040101',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0956209069786,42.6485058675527,-88.0952181734793,42.6484828673914,-88.0946915071067,42.6482998004963,-88.0936071738313,42.6481394001141,-88.0909117069091,42.648070066881,-88.0882473070669,42.6478178007518,-88.0864501738358,42.6478630006778,-88.0855205068652,42.6481142667609,-88.0851175071666,42.648503000514,-88.0849623741136,42.6489832007151,-88.0849931066459,42.6494864001781,-88.0851477738501,42.6498524674183,-88.0853955073961,42.6500812675374,-88.0874401070747,42.6506766007454,-88.0901973736093,42.6513406673388,-88.0910339067887,42.6514324008855,-88.0944733072967,42.6514332669327,-88.0951859732534,42.6513418670344,-88.0952789739449,42.6514106004198,-88.0955577736717,42.6513648671958,-88.095681773994,42.6511818668506,-88.0956209069786,42.6485058675527));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (16,'14783847',14783847,'15-OCT-99',3,NULL,NULL,.02101949277,0,'07120004001463',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1110807736582,42.6545008004725,-88.1110497065781,42.6547066004302,-88.1111735738007,42.6547752672657,-88.111700507272,42.6546380666943,-88.1121033073211,42.6544322667366,-88.1124753073889,42.6539520008851,-88.1125681740813,42.6538834005993,-88.1127541736656,42.653609000356,-88.112909107069,42.6534716001352,-88.1129401066999,42.6530828007316,-88.1125993068119,42.6529684672219,-88.1117937067136,42.6530370675076,-88.111142906919,42.6533342673634,-88.1110189065966,42.6539518003362,-88.1110807736582,42.6545008004725));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (17,'14767952',14767952,'15-OCT-99',3,NULL,NULL,.02802092915,0,'07120006001608',390,39004,'071200061001',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1334533071238,42.656421800027,-88.132771506799,42.6564218674761,-88.1323377071188,42.6565590671481,-88.1320899070229,42.6565362675356,-88.1317489065862,42.6562846669048,-88.1315011073896,42.656376200802,-88.131377173617,42.656879400265,-88.1310983738902,42.6570852667725,-88.1308505072445,42.6571996668321,-88.1309125739555,42.657954466926,-88.1312225073122,42.6582060001077,-88.1314703739579,42.6582288671694,-88.1317803073147,42.6581602003339,-88.132616907044,42.6575198002994,-88.1331435068667,42.6571994671826,-88.1333295073503,42.6569250003894,-88.1336081739774,42.6566962002703,-88.1335771734472,42.6565818667606,-88.1334533071238,42.656421800027));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (18,'14783843',14783843,'15-OCT-99',3,NULL,NULL,.06310117502,0,'07120004001461',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1241571734142,42.6587326008298,-88.123630373942,42.658824000728,-88.1234753739887,42.6589384007875,-88.1234755736382,42.6592814669671,-88.1236305070416,42.6594644673122,-88.1235995074107,42.6597388675556,-88.1231655737316,42.6599448006129,-88.1226077737292,42.6606994667079,-88.1224527737759,42.6606994667079,-88.1222049071301,42.6606310004212,-88.1220189066466,42.6604250673639,-88.1219569739346,42.6601506005707,-88.1216781067586,42.660036267061,-88.1212751736097,42.6601506671205,-88.1209033066417,42.6604708005879,-88.1207483066884,42.6607224003194,-88.1206243738151,42.6610654673983,-88.1206863739764,42.6612256006819,-88.121027306964,42.6615458672489,-88.121802107081,42.6618432002044,-88.1223289740023,42.6619804007758,-88.122638907359,42.6619116673904,-88.1229177070859,42.6616830669209,-88.1231037066701,42.6613628669037,-88.1231657068313,42.6613398667424,-88.1234445740072,42.6610654673983,-88.1245911070933,42.6607452673811,-88.1250869069345,42.6602878002427,-88.1252419068879,42.6600362005112,-88.1252419068879,42.6593958004767,-88.1250869734844,42.6592128001315,-88.1246221067242,42.658915467176,-88.1241571734142,42.6587326008298));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (19,'14768112',14768112,'15-OCT-99',3,NULL,NULL,.03311504795,0,'07120006001658',390,39004,'071200061005',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0893703066936,42.5180162675376,-88.0885045068769,42.5181074677863,-88.0880097070817,42.5183360673565,-88.0878239736968,42.5185418007644,-88.0873909069641,42.5188848003941,-88.0874527074758,42.5190220009655,-88.0877309739047,42.5190908009006,-88.0885657740906,42.5190224677136,-88.0894007073761,42.5190226673631,-88.0920599738881,42.5187032677425,-88.092369173398,42.5185432675586,-88.0923383734166,42.5183602006637,-88.0921839067612,42.518245867154,-88.090235906861,42.518062266961,-88.0893703066936,42.5180162675376));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (20,'14783855',14783855,'15-OCT-99',3,'1565332','Friendship Lake',.04386432997,0,'07120004001465',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0856173071923,42.6414128003614,-88.0851523738823,42.6417100002172,-88.0850593740902,42.6418700004011,-88.0850899735228,42.6425562002094,-88.0852137067465,42.6427620667169,-88.0852757069077,42.6428764667764,-88.0854923068239,42.6431968007926,-88.0858329736122,42.6434714006855,-88.0862357071115,42.6436316005189,-88.0870411066611,42.6436088674562,-88.0876609068247,42.6433804000863,-88.087753974066,42.6431974671902,-88.0877233737341,42.6424198674838,-88.0876613735729,42.6423512006483,-88.0875377734488,42.6420310006311,-88.0867635066299,42.6414818008453,-88.0862369068072,42.6413672667869,-88.0856173071923,42.6414128003614));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (21,'14783891',14783891,'15-OCT-99',3,NULL,NULL,.02867713019,0,'07120004001482',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0898719071621,42.5624582008862,-88.0895313734734,42.5624810004987,-88.0872413739896,42.5633494002555,-88.0870557071545,42.5634866008269,-88.0870243738751,42.5639440005161,-88.0870861734875,42.5641726675355,-88.0872409072414,42.5642414009208,-88.0876739739741,42.564172867185,-88.0896547073982,42.5636246008955,-88.0901497733927,42.5633960669758,-88.0901499739415,42.5630530007962,-88.0900263072676,42.5628928009629,-88.0899645733058,42.5626182676199,-88.0898719071621,42.5624582008862));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (22,'14783899',14783899,'15-OCT-99',3,'1569679','Montgomery Lake',.23294495632,0,'07120004001487',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0860431074029,42.549145067192,-88.0854551738166,42.5492820672146,-88.0846197737829,42.5496478673561,-88.0841555068705,42.5501280010074,-88.0836911068585,42.5507452668814,-88.0836291066973,42.5509512008381,-88.083535774156,42.5517516676063,-88.0837521069735,42.5520490671117,-88.0841849066075,42.5525524671236,-88.0844939739171,42.5529184669146,-88.0852979741215,42.5535592671474,-88.0852355737621,42.5544282676514,-88.0853901735171,42.5546342672585,-88.085699507026,42.5547488004177,-88.0861325072088,42.5549090002511,-88.0864417732686,42.5549320004124,-88.0866585071837,42.5548406005142,-88.0869371072611,42.5545890673325,-88.0872775069507,42.5544976674343,-88.0881127073349,42.554726600653,-88.0887005069222,42.5547038675903,-88.089009906981,42.5545438674064,-88.0895051069745,42.5540866673667,-88.0899385739054,42.5534692009438,-88.0899695069865,42.5534234677198,-88.0901863074515,42.5531262004147,-88.090186507101,42.5525544006659,-88.0891661066299,42.5517306675372,-88.0891353066484,42.5515934669658,-88.0888569736697,42.551318867073,-88.0887953071571,42.5510672673414,-88.0887333735457,42.5509986005059,-88.0886409736014,42.5504038671456,-88.0884245067849,42.5502208002507,-88.087805973766,42.5501062670915,-88.0875275733382,42.5499004005839,-88.0874659068255,42.5497172671391,-88.087373174132,42.549625800691,-88.0873113070705,42.5495114671814,-88.0870639071729,42.5493284002864,-88.086599973909,42.549168200453,-88.0860431074029,42.549145067192));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (23,'14783845',14783845,'15-OCT-99',3,NULL,NULL,.01864678104,0,'07120004001460',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0834381068825,42.6589094003494,-88.0831281735257,42.6590008002477,-88.0830351071838,42.6591150672075,-88.0829421073917,42.6592522668795,-88.0829415740938,42.6599612671996,-88.083034373337,42.660258666705,-88.0830963069484,42.6603272669907,-88.0831583071096,42.6604646006617,-88.0832201067219,42.6605560671097,-88.0843357732767,42.6605336002464,-88.0844909737788,42.6601676670051,-88.084460306897,42.6596416004804,-88.0841195735588,42.6593212673635,-88.0839647741544,42.6591382670183,-88.0834381068825,42.6589094003494));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (24,'14768118',14768118,'15-OCT-99',3,'1576125','Voltz Lake',.25037615391,0,'07120006001665',390,39004,'071200061005',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.085483373858,42.5034908009606,-88.0847105072834,42.5037192008813,-88.0839065736288,42.5041306002479,-88.0832879740601,42.5045650006751,-88.0827311066546,42.5053424672819,-88.0825763072501,42.5056854669117,-88.0824521738281,42.5063716676192,-88.082297506624,42.5065546670651,-88.081307773934,42.5072862007984,-88.0805965738721,42.5074918011067,-88.080379973956,42.5076746674529,-88.080379973956,42.5078348007364,-88.0805033735312,42.5081094006292,-88.0805341069628,42.508406667035,-88.0805959074745,42.5085438676063,-88.0806573068886,42.5090928677425,-88.0808115738944,42.5094818002458,-88.0810897072236,42.5097106003648,-88.0814605066964,42.5098708010975,-88.0822333067211,42.5100312671302,-88.0829751736647,42.5101230006769,-88.0843665741575,42.5100092004652,-88.0856031734471,42.5098724009914,-88.0866855066302,42.5095982669474,-88.0875511733473,42.5092784005786,-88.0877367736326,42.5090954011328,-88.0877679072624,42.5088666675636,-88.0874281074206,42.508523467385,-88.0870883066794,42.5080200673731,-88.0865937739828,42.5077226004186,-88.0863465737348,42.5076310008709,-88.0852955072812,42.5076306672224,-88.0849245738094,42.5075390676747,-88.0847703068036,42.5070358007625,-88.0849561067383,42.5066240677475,-88.0849871738184,42.5063726011156,-88.0850181734493,42.5063268004424,-88.085141906673,42.5060294674868,-88.0855131072435,42.5056636673453,-88.0860079070387,42.5054808675489,-88.0864407741218,42.5053438009766,-88.0865335733651,42.5051608671812,-88.0865345068614,42.5036740675051,-88.0862253073514,42.5035138011219,-88.085483373858,42.5034908009606));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (25,'19285179',19285179,'15-OCT-99',3,NULL,NULL,.71481859287,0,NULL,466,46600,'071200040101',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0722109740566,42.5926206673109,-88.0742553740856,42.5909062006615,-88.075339707361,42.589763000463,-88.0764239740865,42.588459666981,-88.0768579068663,42.5878424002075,-88.0778801068808,42.5866532671355,-88.0788715069139,42.5854414010008,-88.0793361740245,42.5847782670043,-88.0796151068511,42.5845040007599,-88.0796461739312,42.5841836676431,-88.0790583734445,42.5838404674645,-88.0780989739878,42.5835428008605,-88.0774799733215,42.5834966674382,-88.0748801070307,42.5834728003304,-88.0740135733671,42.5833580675217,-88.0706403072038,42.5830364007102,-88.0693711740398,42.5829900676384,-88.0689687741889,42.5831500003731,-88.0686901066625,42.5833556672312,-88.0685969737707,42.5835386675764,-88.0684731074473,42.5836758672484,-88.0681317068122,42.5847278006484,-88.0680387735699,42.5847964009341,-88.0680695735513,42.5849108009936,-88.0677599738431,42.5850708002781,-88.0677597732943,42.5852308670118,-88.0678833734183,42.5853910002953,-88.0680069735424,42.5857112668624,-88.0680379075228,42.5858484674337,-88.0682543068901,42.5861002668148,-88.068501573688,42.5863518674456,-88.0685633733004,42.5865806675646,-88.0689035067908,42.5870382669034,-88.0689961738337,42.5871526669629,-88.0696453071845,42.5881594004369,-88.0697381073272,42.5883882005559,-88.0695831739237,42.5885024009659,-88.0696449735361,42.5886854669616,-88.0696441740388,42.5896232674008,-88.0694271073745,42.590126400314,-88.0692721074212,42.5902864004979,-88.0688077074091,42.5904462675821,-88.0677857070441,42.591017467483,-88.067351773365,42.5916578009677,-88.0673825733464,42.5917722001278,-88.0674443738581,42.5917950671895,-88.0675061069206,42.592046666921,-88.0677225737372,42.5922754670401,-88.0677841737,42.5926872675043,-88.0679079069237,42.5927558668906,-88.0679077072742,42.5930076006212,-88.0682787738457,42.5935110006331,-88.0688045741711,42.5939000671353,-88.069268906734,42.5940374673561,-88.0699809737423,42.5939006004332,-88.0710339071885,42.5934664671047,-88.0715293733812,42.5931692672488,-88.0722109740566,42.5926206673109));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (26,'19285019',19285019,'15-OCT-99',3,NULL,NULL,.72556993824,0,NULL,466,46600,'071200040201',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0435449741206,42.5203262004947,-88.0438851067117,42.5202578673076,-88.0446583069347,42.5201212009336,-88.0475967733718,42.5192768670347,-88.0489889733618,42.5186602010084,-88.0491129071343,42.5183858673148,-88.0496389736591,42.5179972675608,-88.0522063735247,42.5169926007288,-88.0533507734188,42.5166272673354,-88.0559175068868,42.5162856670508,-88.0588863740063,42.5156928006831,-88.0601231072949,42.5156020006327,-88.0607107737825,42.5154878676719,-88.0612055735777,42.5153052009751,-88.0629069074272,42.5145284673158,-88.0643603071818,42.5142090676952,-88.066123173545,42.5135924673194,-88.067174573647,42.5132498669887,-88.0677931741151,42.5129986009056,-88.067669573991,42.5127926669489,-88.0674225733924,42.5126094669542,-88.0667427075093,42.5123118003502,-88.0653825737461,42.5120594676712,-88.0647643069266,42.51203640096,-88.0623835073923,42.5123096006085,-88.0606829073896,42.5124230006219,-88.0582097070117,42.5122614005441,-88.0560763739249,42.5122374003367,-88.0548087066558,42.5124424007971,-88.0532315071277,42.5128760008277,-88.05196330746,42.5133556002816,-88.0516541070508,42.5133554006321,-88.0511591067068,42.5136296003267,-88.0502311070793,42.5140406003943,-88.0499837071817,42.5142006005781,-88.0491177733659,42.5143830010755,-88.0485921735893,42.5143826008772,-88.0482211735676,42.5143138009421,-88.0472629072567,42.5142674004211,-88.0469537733973,42.5140612677142,-88.0465827068258,42.514175467225,-88.0463347736302,42.5146328003643,-88.046271907422,42.515456200744,-88.0460237736776,42.5160278673931,-88.0457761741305,42.5163250672489,-88.0451259741837,42.5169192673113,-88.0439809069926,42.5178790669663,-88.0431139740301,42.5187706008834,-88.0430507741733,42.5197998003214,-88.0430815067055,42.5200056677283,-88.0435449741206,42.5203262004947));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (27,'14783871',14783871,'15-OCT-99',3,NULL,NULL,.01862340955,0,'07120004001471',390,39004,'071200040103',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0597615069873,42.5977380004093,-88.0595137068914,42.5978750669817,-88.0588629070969,42.5985610005906,-88.0588315738174,42.5988810675082,-88.0589241734112,42.5991098676272,-88.0593265741614,42.5992244673362,-88.0599457070281,42.5992248009847,-88.0604411741202,42.5991106671245,-88.0605961740735,42.5989964676138,-88.0607201734966,42.5987220673704,-88.0607513736763,42.5985390670252,-88.0603493074739,42.5981272009105,-88.0602257073499,42.5978526675675,-88.0600091074337,42.5977610005706,-88.0597615069873,42.5977380004093));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (28,'19285021',19285021,'15-OCT-99',3,NULL,NULL,.45462779587,0,NULL,466,46600,'071200040201',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.059921573721,42.5011690005499,-88.0594577735567,42.5012832009598,-88.0588393070877,42.5015800671673,-88.0576019074015,42.5024942675973,-88.0566739734245,42.5029284009259,-88.0550037741043,42.5038422677074,-88.0545089734098,42.5039562675686,-88.053458107505,42.5038870008853,-88.0511709741605,42.5034966672383,-88.0505529069904,42.5034278007533,-88.0497797067674,42.5037018007984,-88.0498721067117,42.5040220008156,-88.0500265068172,42.5041136003633,-88.0506437070408,42.5049374674911,-88.0508909072889,42.5051434670982,-88.0510141072147,42.5054180669911,-88.0511687069696,42.5055096008883,-88.0512303069325,42.5056926677833,-88.0514153739197,42.5058986673905,-88.0515079735135,42.5061046004479,-88.0515387734949,42.5061732007335,-88.0515695734764,42.5062648002812,-88.0516621739695,42.5064020674024,-88.0517545739138,42.5066308009716,-88.0518473740564,42.5066766672953,-88.0519087734705,42.5070654675982,-88.0520629739265,42.5074086677767,-88.0520625737282,42.5077518005061,-88.0521551067721,42.5080034676868,-88.0526183736384,42.5082552670679,-88.0531129737841,42.5083700007758,-88.054133306806,42.5082790676258,-88.0549681735417,42.508073800966,-88.0558959735197,42.5076854674113,-88.0568859067586,42.5071828003469,-88.0586181736891,42.5060172672839,-88.0591131740331,42.5057202670775,-88.0597935066643,42.5054004672587,-88.0618339074082,42.5053558006306,-88.0624521733285,42.5052190002576,-88.0625759740013,42.5050360008117,-88.0627619070357,42.5046930677318,-88.0627931737653,42.5043270670414,-88.0629167738894,42.5042814003672,-88.0629175068368,42.5036410003328,-88.0630723071406,42.5033436673772,-88.06313477405,42.5026804002812,-88.0630115066751,42.5023372675518,-88.0628879074503,42.5022686007163,-88.0628879740001,42.5022000004306,-88.0625175072765,42.501788067766,-88.061961307168,42.5014674675505,-88.0610033736062,42.5011924674593,-88.059921573721,42.5011690005499));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (29,'14783903',14783903,'15-OCT-99',3,NULL,NULL,.04038219787,0,'07120004001486',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0573049737449,42.5489948003706,-88.0564385075305,42.5493144670899,-88.056469106963,42.5495432672089,-88.0566855072298,42.5497264006538,-88.0574897070837,42.5499098002979,-88.0576133072077,42.5500014672948,-88.0575819739283,42.5504130672102,-88.0573961074438,42.5505958670066,-88.0573031067523,42.5507560002901,-88.0575505740991,42.5508476672869,-88.0582929068915,42.5509166668716,-88.0589735075207,42.5509170670699,-88.0591591734565,42.550757066886,-88.0597169734589,42.5498882669309,-88.0597173736572,42.549476467366,-88.0595937735332,42.549385000918,-88.0584187067573,42.5489040003202,-88.0579547734933,42.5488580008969,-88.057351707015,42.5489850004583,-88.0573049737449,42.5489948003706));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (30,'14783919',14783919,'15-OCT-99',3,'1570981','Paasch Lake',.08636415977,0,'07120004001494',390,39004,'071200040201',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0469537733973,42.5140612677142,-88.0472629072567,42.5142674004211,-88.0482211735676,42.5143138009421,-88.0485921735893,42.5143826008772,-88.0491177733659,42.5143830010755,-88.0499837071817,42.5142006005781,-88.0502311070793,42.5140406003943,-88.0511591067068,42.5136296003267,-88.0516541070508,42.5133554006321,-88.0520873734329,42.5129668008781,-88.0522423733862,42.5126696010222,-88.0522739737642,42.5120748676619,-88.051810706898,42.5117086007722,-88.0511925740774,42.5114566008423,-88.0503579069912,42.5114790002565,-88.0498011735846,42.5116616004034,-88.0486253738613,42.5124614007739,-88.0484705070077,42.512712800856,-88.0471089073496,42.5137182671852,-88.0469537733973,42.5140612677142));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (31,'14783889',14783889,'15-OCT-99',3,NULL,NULL,.07108878375,0,'07120004001480',390,39004,'071200040103',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0442921074941,42.5651348009312,-88.0438897741931,42.5651802670566,-88.0432087068157,42.5654314009393,-88.0418781733384,42.565430467443,-88.0398043735723,42.5659778676854,-88.0392469072183,42.5662748669924,-88.0392149740911,42.5669382006383,-88.0394003738276,42.5671900009187,-88.0394003738276,42.5672356675929,-88.039554773933,42.5674416672001,-88.0397405073179,42.5674190006873,-88.0406071740812,42.5672136674777,-88.0411025737242,42.5669624004953,-88.0412885742077,42.5667796006989,-88.0412885742077,42.5666652006394,-88.04138150745,42.5666194674154,-88.0415679072325,42.5661392672143,-88.0417225735373,42.5660250677036,-88.0421249733882,42.5660482675144,-88.0423721736362,42.5662542005718,-88.0424335073998,42.5666888671984,-88.0427117738287,42.5668720671931,-88.0441965734125,42.5672618675421,-88.0448773736912,42.5671480007805,-88.0453111068215,42.5668510005741,-88.045372973883,42.5667596006759,-88.0453425075501,42.5664850673329,-88.0451877737961,42.5663934668859,-88.0445383067968,42.5661870670804,-88.0444455075535,42.5660956006324,-88.0445085068615,42.5653180009259,-88.0442921074941,42.5651348009312));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (32,'14783877',14783877,'15-OCT-99',3,NULL,NULL,.02094731243,0,'07120004001473',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0402141739443,42.5836588673637,-88.0396259067096,42.5837958008365,-88.0391923741281,42.5839556004715,-88.0390681067071,42.5842986010006,-88.0391607072002,42.5844816004464,-88.0401197739078,42.5847338674749,-88.0407697742051,42.5847800674471,-88.0410793739134,42.5847116668109,-88.0414511734323,42.5843916673425,-88.0416063739344,42.5840944674866,-88.0417305073564,42.583911600241,-88.0417925075176,42.583728667345,-88.0414213069471,42.5836598674098,-88.0402141739443,42.5836588673637));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (33,'14783909',14783909,'15-OCT-99',3,'1565464','George Lake',.2719197037,0,'07120004001490',390,39004,'071200040201',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0356171741926,42.5287834007343,-88.0362663740933,42.5289668669283,-88.0365447070719,42.5289900010886,-88.0369779734541,42.5287386675564,-88.0372875075118,42.5285788004722,-88.0386793073035,42.5284884006201,-88.0410605070361,42.528535867737,-88.0418953737719,42.5285364675848,-88.0423903066667,42.5283766670505,-88.0427311740038,42.5278966673982,-88.0427321075001,42.5271188671429,-88.0425779070441,42.5268214676375,-88.0423307733459,42.5265926009687,-88.0413111741707,42.5259742675993,-88.041126306833,42.5254938677487,-88.0407559075584,42.5249904002877,-88.0399521070035,42.524806800994,-88.0394577074067,42.5245090669408,-88.038344973541,42.5241194005908,-88.0379431069882,42.5240504675559,-88.0369535073978,42.5240954669331,-88.0356849740817,42.5245748676369,-88.0350969739455,42.5249402675802,-88.0349421070919,42.5251002677641,-88.0344771737819,42.5259004674335,-88.0344457739527,42.5261978003891,-88.0344753067893,42.5272500674376,-88.0345369742013,42.5272958006616,-88.034752707171,42.5278448673477,-88.0353085736311,42.5284172003944,-88.0353393070627,42.5284858672299,-88.0355865073108,42.5286690006748,-88.0356171741926,42.5287834007343));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (34,'19285023',19285023,'15-OCT-99',3,NULL,NULL,.34482299942,0,NULL,466,46600,'071200040201',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0350069068426,42.5014266671079,-88.0350073735908,42.5010150671925,-88.0352241740558,42.500695000275,-88.0356265739066,42.5003522677439,-88.0362141738444,42.5001010673113,-88.0370487069316,42.5001246007706,-88.0376669072014,42.5001706676431,-88.0382535736429,42.500583000506,-88.038562307304,42.5009262672344,-88.0385929741857,42.5010634678057,-88.0386547737982,42.5011550673534,-88.038653773752,42.5017954673878,-88.0380655074166,42.5025042006093,-88.0372609073643,42.5031438676962,-88.0367971072001,42.5032808677188,-88.036982307287,42.5034182670403,-88.036982307287,42.5035098009375,-88.0368585075134,42.5035782006743,-88.0367963733533,42.503738267408,-88.0365177741753,42.5040584008754,-88.0365177067262,42.5041498007736,-88.0362079739182,42.5045384670775,-88.0362077068196,42.504675601099,-88.0359911069034,42.5049270677309,-88.0359909072539,42.5050186007288,-88.0359599067237,42.5050872010144,-88.0359287739931,42.505201601074,-88.0357429740584,42.5053842677706,-88.035556907025,42.5058874672337,-88.0355253740961,42.5062762009868,-88.0354325739535,42.5063676674348,-88.0354323068548,42.5065276676187,-88.0356485740218,42.5065966006535,-88.0357103070843,42.5067338677747,-88.0358647071898,42.5068482669349,-88.0362971740747,42.5070774007024,-88.0373481074286,42.5071010672614,-88.0375645733457,42.5070554005871,-88.038368774099,42.5066900671937,-88.0392043072324,42.5061188672928,-88.0399165073403,42.505273067499,-88.0405667072871,42.5044960010905,-88.0407525072218,42.504267400621,-88.0408145073829,42.5041072673374,-88.0409385733558,42.503741400646,-88.0397969074007,42.5022538671232,-88.0397979074468,42.5015448002532,-88.0400461733915,42.5008358008325,-88.0404797734222,42.5001728673848,-88.0405109070521,42.5000322673761,-88.0263227734766,42.5000292672378,-88.0263841072401,42.5004360674715,-88.026568774029,42.5008938008092,-88.0269699067352,42.5013972673709,-88.0275873740574,42.5018324007456,-88.0280817071044,42.5021072677371,-88.0301217067507,42.5021090007307,-88.0315125739455,42.5022246004858,-88.0317907072747,42.5023162674827,-88.0325635072994,42.5022710675566,-88.033583973421,42.5020660670962,-88.034357173644,42.5017236007645,-88.0348523070876,42.5014494676198,-88.0350069068426,42.5014266671079));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (35,'19285189',19285189,'15-OCT-99',3,NULL,NULL,.39681109376,0,NULL,466,46600,'071200040201',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0332651736482,42.5299938675239,-88.0327705069527,42.5299020008775,-88.0327085067915,42.530016266938,-88.0302345734661,42.5299456674595,-88.0297707742012,42.529899600587,-88.0293379736679,42.5298306010023,-88.02819450727,42.5293722003677,-88.0269585069289,42.5287764004115,-88.0266801739502,42.5286846677641,-88.0264021737207,42.5285472675433,-88.0258147734324,42.5282722674521,-88.0254441736091,42.5280204006219,-88.0246097736215,42.5276536004342,-88.0239297071896,42.5274928673029,-88.023187306948,42.5276980674128,-88.0229703733834,42.527926666983,-88.0226913074573,42.5284526004081,-88.0226289070977,42.5287726673257,-88.0226587735829,42.5293444670744,-88.022812907489,42.5297334670268,-88.0229055070828,42.5298022004121,-88.0229361739646,42.5299852007573,-88.0232137739958,42.5303742672596,-88.0233063070398,42.530580267766,-88.0236457741325,42.5309694008181,-88.0248199074122,42.5317480671205,-88.0256851073812,42.5321834010441,-88.026396173444,42.5323440676255,-88.0274785075264,42.532413667058,-88.0297363742337,42.5322326002552,-88.0317781068735,42.5318912005194,-88.0326747741209,42.5319376675902,-88.0334477737951,42.5320298004359,-88.0340041735531,42.5323046008775,-88.0345293740307,42.5326480672554,-88.0348077070094,42.5326940675781,-88.0360743067832,42.5336558007755,-88.0364453068048,42.5338162002583,-88.0369087067708,42.5341138003125,-88.0372799073412,42.5340912668993,-88.0378057067673,42.5340688009353,-88.0379297736395,42.5337716010794,-88.0380235738282,42.5331082008836,-88.0378077068596,42.5326048008718,-88.0377771074269,42.5324446675883,-88.0376535073029,42.5322844677549,-88.037622906971,42.5320786668979,-88.0373759072717,42.531826800967,-88.0372835073273,42.5315294005623,-88.0371291072219,42.5313462671174,-88.0370675738088,42.5311174669984,-88.0369441067845,42.5309802673264,-88.0367895735793,42.5308886003295,-88.0365427069797,42.530522400889,-88.0360793070138,42.5301104007753,-88.0349355735173,42.5296748672023,-88.0343475733812,42.5299488672474,-88.0339765068097,42.5300172004344,-88.0332651736482,42.5299938675239));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (36,'14783931',14783931,'15-OCT-99',3,'1569904','Mud Lake',.07798926598,0,'07120004001497',390,39004,'071200040201',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0367971072001,42.5032808677188,-88.0372609073643,42.5031438676962,-88.0380655074166,42.5025042006093,-88.038653773752,42.5017954673878,-88.0386547737982,42.5011550673534,-88.0385929741857,42.5010634678057,-88.038562307304,42.5009262672344,-88.0382535736429,42.500583000506,-88.0376669072014,42.5001706676431,-88.0370487069316,42.5001246007706,-88.0362141738444,42.5001010673113,-88.0356265739066,42.5003522677439,-88.0352241740558,42.500695000275,-88.0350073735908,42.5010150671925,-88.0350069068426,42.5014266671079,-88.0351609067498,42.5017928674478,-88.0352841741247,42.502044600279,-88.0353149075563,42.5021360676263,-88.0357777742242,42.5027540007974,-88.0362409070916,42.503074467014,-88.036704506707,42.5031892672718,-88.0367971072001,42.5032808677188));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (37,'14783901',14783901,'15-OCT-99',3,NULL,NULL,.02842741998,0,'07120004001485',390,39004,'071200040103',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0172109072569,42.5505886004844,-88.016839507037,42.5506798007331,-88.016498707149,42.5509996671018,-88.0165291069321,42.5512742004449,-88.0167763071802,42.5514574004396,-88.0170237070778,42.5515262003748,-88.0176423075458,42.5515268676717,-88.0179825741358,42.5516186668689,-88.0184765735344,42.5521222674296,-88.0187859070433,42.5521912004644,-88.0192811070368,42.5520544009907,-88.0196529074551,42.5517116675603,-88.0197463074455,42.5513228672574,-88.0197471069428,42.5508424674069,-88.0195927068373,42.5507052002857,-88.0190665737628,42.5507962008849,-88.018540507238,42.5509558674203,-88.0182619737105,42.5509784673833,-88.0172109072569,42.5505886004844));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (38,'14783703',14783703,'22-OCT-99',3,NULL,NULL,.70228452406,0,NULL,466,46600,'071200040103',.9688,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9578017738322,42.5542192004567,-87.9579253074064,42.5540132673993,-87.9579553069912,42.5533956669773,-87.9581099076455,42.5532810672684,-87.9587595068451,42.5531890675223,-87.9600897075733,42.5531196002902,-87.9604609072445,42.5530506007055,-87.9610173070025,42.5527986007757,-87.9616663738035,42.5523864010125,-87.9631507740883,42.5520192671763,-87.9632125071508,42.551859067343,-87.9642023738398,42.5518126002722,-87.9646665742024,42.5519266010327,-87.965038506821,42.5523150676871,-87.965286907664,42.5530240005581,-87.9654729737981,42.5533440674756,-87.9659065738287,42.5535496003347,-87.9668039074737,42.5536632008969,-87.967886707405,42.5536852675619,-87.9691237743421,42.5534326003352,-87.9702679071376,42.5530656670478,-87.9716281740004,42.5524698670916,-87.971999174022,42.5522408007732,-87.9724937741677,42.5520344675176,-87.9737929734663,42.5519418004746,-87.9746899734629,42.5518266009178,-87.9753703735433,42.5517574007843,-87.9760823074519,42.5519854670566,-87.9770107072777,42.5521220003309,-87.9773511069674,42.552144600294,-87.978062507578,42.552029467287,-87.9783097069268,42.5518692009038,-87.9785873735078,42.5514800669524,-87.9787103737841,42.5510454003258,-87.9791109740916,42.5500842669762,-87.9796977736327,42.5495120004794,-87.9800687071045,42.5493516009965,-87.9813061067908,42.5493046671776,-87.9818937076279,42.5492582675559,-87.9823883068742,42.5490292003382,-87.982697173635,42.54880006747,-87.9835013069391,42.5486392003397,-87.9835319738209,42.5485248677294,-87.9834699071099,42.5483648009957,-87.9830983072404,42.5481364001756,-87.9829743069181,42.5480222006649,-87.982757707002,42.5479308673166,-87.9824169736638,42.5476796003342,-87.9817671073655,42.54754300051,-87.9806533734538,42.5475668676178,-87.9801897072885,42.5476816669762,-87.9797261067738,42.5479336669061,-87.9794791070745,42.5482312669603,-87.979201106845,42.5484602676282,-87.9788923740832,42.5488950673544,-87.9778419074774,42.5496738002066,-87.977532773618,42.5498800003626,-87.9762959737795,42.550292800873,-87.9744097734916,42.5507746675178,-87.9728013737837,42.5509820008196,-87.9691825072663,42.5513054006246,-87.9681613072979,42.5511690004499,-87.9673873741274,42.5509180005662,-87.9667063076494,42.5504840003372,-87.9659321073802,42.5499584671105,-87.9659319068314,42.54984420105,-87.965745973797,42.5496384001929,-87.9655913074922,42.5495928009679,-87.9654055075575,
  42.5494328673338,-87.9648483074028,42.5492274010247,-87.9633319074409,42.5487940006435,-87.9619399736502,42.5489780675846,-87.9608269070355,42.549253400425,-87.9603939743018,42.5494366669695,-87.9588785069369,42.5496436675222,-87.9586309739396,42.5497582006813,-87.9577031074118,42.5498732671385,-87.9574557075143,42.5499192674611,-87.9570225742318,42.5499652668844,-87.9566205736799,42.550102800205,-87.9556307735407,42.5501722008873,-87.9535893736501,42.5504252008632,-87.9531565074662,42.5506086005074,-87.9530947735043,42.5507000669554,-87.9530959740993,42.5516836006186,-87.9532221741634,42.5536278008832,-87.9531299073187,42.5540624009599,-87.953377574315,42.5541536668591,-87.9573067069383,42.5541508672696,-87.9578017738322,42.5542192004567));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (39,'14783613',14783613,'22-OCT-99',3,NULL,NULL,.04366131319,0,'07120004001492',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.960710907082,42.5102544671709,-87.960309107079,42.5103462672673,-87.9601857075037,42.5105750673864,-87.9600631739756,42.5113070669685,-87.9599395738516,42.5114674008008,-87.9599095742668,42.5120392005496,-87.9600951736527,42.512176267122,-87.9617035742599,42.5127240010128,-87.9623219076293,42.5127464669768,-87.9626927071021,42.5125402677201,-87.9627543736148,42.5124030005989,-87.9627539068667,42.5120370673577,-87.9621037734697,42.5114656669079,-87.9621339070536,42.5108252003237,-87.9614533073236,42.5105284006661,-87.960710907082,42.5102544671709));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (40,'14783701',14783701,'22-OCT-99',3,NULL,NULL,.57800545578,0,NULL,466,46600,'071200040102',.8497,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9467385073756,42.5650000672002,-87.9467095069376,42.5664868003265,-87.9472669076411,42.5668752669809,-87.9482573741778,42.5670576674783,-87.948473974094,42.567080400541,-87.9489997069703,42.5667826673871,-87.9491541736256,42.5665766668806,-87.9490293738059,42.5657762010118,-87.9491523740821,42.565067067592,-87.9493995743302,42.5647924676991,-87.950296373778,42.5644260002606,-87.9511935068742,42.5641966002938,-87.9519355069175,42.5637158002449,-87.9520591070415,42.5635098006377,-87.9522131734985,42.5631208672352,-87.9522047738306,42.5564876009229,-87.9520487738312,42.5554126673616,-87.9520785737665,42.5544976674343,-87.9521089735496,42.5540630673576,-87.9514589076019,42.5537432675387,-87.9508707743661,42.5534922002058,-87.95059197374,42.5532178008617,-87.9503441070942,42.5528062674962,-87.949817706921,42.5524406670041,-87.9492915072966,42.5521666004092,-87.947217373882,42.5511614677284,-87.946598374115,42.5510016671941,-87.9464439074597,42.5511162003532,-87.9456709068862,42.5514598007301,-87.9454855736996,42.5517116010105,-87.9455167073295,42.5518486675829,-87.9456407742017,42.5521688010502,-87.9460433737021,42.5526260676398,-87.9460745738818,42.5526946670262,-87.9464771742815,42.5531518670659,-87.9466633735153,42.553494867595,-87.9468181738191,42.5535634004315,-87.946942307241,42.5538606002874,-87.9471899742373,42.5540434675329,-87.9473759738215,42.5544550674483,-87.9473777068151,42.5558732002889,-87.9473473735818,42.5564450674868,-87.947349373674,42.5581834668944,-87.9475043736273,42.5583664006897,-87.9476903741108,42.5586408009331,-87.947721307192,42.5586864676073,-87.9479071736765,42.5589150671775,-87.947876507694,42.5590066001753,-87.9481551743212,42.5592580677066,-87.9481861739521,42.5593494676048,-87.9482791071944,42.5593952008288,-87.9482799741409,42.560172867085,-87.9481881740443,42.5610420672385,-87.9480029074076,42.5613166671314,-87.9478489075004,42.561934400653,-87.9476021740005,42.5626664676843,-87.9473551743012,42.5631468675348,-87.9473247736188,42.5636272673854,-87.9470779070191,42.5641078003356,-87.9468309073198,42.5644738675758,-87.9467385073756,42.5650000672002));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (41,'14783705',14783705,'22-OCT-99',3,NULL,NULL,2.72115298799,0,NULL,466,46600,'071200040104',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9300765070245,42.5487466009758,-87.9306945741946,42.5481058672929,-87.9308179737698,42.5477398675018,-87.9310651740179,42.5474424005473,-87.9311577736117,42.5472822672637,-87.9317141077192,42.5466642675428,-87.9322085073161,42.5461836671435,-87.9328577072168,42.5457030676434,-87.9330741074834,42.545588601034,-87.9335379076477,42.5452452668565,-87.9346509077126,42.5446728007101,-87.9349911743026,42.5445810671634,-87.9353621068751,42.5443750675562,-87.9361661736294,42.5441230676264,-87.9366917743053,42.5440084004682,-87.9371249741376,42.5440768002051,-87.9378367074974,42.5443280006376,-87.9383009735105,42.5446250673938,-87.9383939076521,42.5447622670659,-87.9393223074779,42.5452192009063,-87.9397865069411,42.5453332673173,-87.9407763736301,42.5453328005692,-87.9416733070768,42.5452178672117,-87.9424153071201,42.5448514672223,-87.9429715737785,42.5444622010706,-87.9434969073557,42.5438442670002,-87.9438987073588,42.543546666946,-87.9446407074021,42.5431574007943,-87.9455373737501,42.5428594670917,-87.9470219736845,42.5427900007588,-87.9475477074601,42.542629467277,-87.948320306936,42.5420114010063,-87.9498967069668,42.5410954675827,-87.9506691742424,42.5405230670868,-87.9509163070413,42.5401570007459,-87.9508231075997,42.5398826005025,-87.9505443735234,42.5396082677083,-87.9502039738337,42.5394712002366,-87.9498943075756,42.5391970005421,-87.9497391736233,42.5388312004005,-87.9483459070373,42.5375968674024,-87.9480669742109,42.5371854005867,-87.9475097075064,42.5367282670967,-87.9471691072678,42.5364082010785,-87.9471689741682,42.5362710005072,-87.9470141073145,42.5360650674498,-87.9470139742149,42.5359736675516,-87.9467351070389,42.5355620676362,-87.9466725735797,42.5349674008258,-87.9465487738062,42.5348074006419,-87.9462081735677,42.5344874002742,-87.9462079739182,42.5343958672764,-87.9460843072443,42.5343044673781,-87.9454955076109,42.533298467751,-87.945432907602,42.5326810004287,-87.945586974059,42.5321318671928,-87.9460191738452,42.5314682673476,-87.9469153068953,42.5308730672392,-87.947100573532,42.5305984007965,-87.9470997074849,42.5298436007025,-87.9470377738735,42.5297978674785,-87.9470065736938,42.5296148671333,-87.9468515071907,42.5291804010556,-87.9466349072745,42.5290204674216,-87.9463561075477,42.5286090006058,-87.9457367741322,42.5280146674439,-87.9455817076291,42.5276488007524,-87.9449633077098,42.527740600849,-87.9424901073319,
  42.5284740006755,-87.9401093743475,42.5288870673851,-87.9394291073668,42.5288874675834,-87.9389341070228,42.5287048674366,-87.9387793076183,42.5285906004767,-87.9382843738242,42.5284764675159,-87.9377585069489,42.5282936677195,-87.9367069737472,42.5282256672816,-87.9359649071541,42.5283862007635,-87.9341721743058,42.5295310008559,-87.933430373912,42.5298744672338,-87.9316987742783,42.5301726671358,-87.9291321073602,42.5302882668909,-87.9271839743603,42.5306094004044,-87.9262565736813,42.5310672677411,-87.9257621740844,42.5314564007932,-87.9251441743635,42.5321200006384,-87.9248661075841,42.5323946005313,-87.9246189073361,42.532715000198,-87.9244337072491,42.5331724673364,-87.9243411076554,42.5334470672293,-87.9244343070969,42.5338358675322,-87.9248055742173,42.5342474008978,-87.9251771075369,42.5345216671421,-87.925888573798,42.534795867736,-87.9265385075454,42.5352072671026,-87.9282709075757,42.5356640003942,-87.9296321070354,42.5361436672973,-87.930467573619,42.5365092003402,-87.9305913742919,42.5366236003998,-87.9307771076768,42.5367148671983,-87.9315819073785,42.5374006677076,-87.9319843072294,42.5378350672354,-87.9322013738936,42.5384296674961,-87.9323871072785,42.5385896676799,-87.9323873743772,42.5388412674114,-87.9328825743707,42.5392298671655,-87.9334397070762,42.5395498675333,-87.9337799736662,42.539664067044,-87.9341513073363,42.5398468002905,-87.9347391069236,42.5399838003131,-87.93498670737,42.5401208668854,-87.9350487075312,42.5402580674568,-87.9349873737676,42.5407842005313,-87.9348329071123,42.5409900670389,-87.9347403075186,42.5411960009956,-87.9345859074131,42.5413790669913,-87.9341839068612,42.5416310003713,-87.9332871074134,42.5418602006886,-87.931493773818,42.5426158002799,-87.9309375071596,42.5430278669434,-87.9299171075878,42.5435086669923,-87.9289587738277,42.5441266676125,-87.9286185737875,42.544264066934,-87.9274439072099,42.545111000773,-87.9272585074735,42.5453628010533,-87.9270731742869,42.5456602005587,-87.9269187076316,42.5459118002902,-87.9268263742371,42.5465066002004,-87.9267339742929,42.5469870009503,-87.9267345741407,42.5477190005324,-87.9269203740753,42.5479704006144,-87.9278179073699,42.5484046004928,-87.9279417071434,42.5485418010642,-87.9287463071957,42.5488388003712,-87.9300765070245,42.5487466009758));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (42,'14783605',14783605,'22-OCT-99',3,NULL,NULL,.08904281413,0,'07120004001484',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.946942307241,42.5538606002874,-87.9468181738191,42.5535634004315,-87.9466633735153,42.553494867595,-87.9464771742815,42.5531518670659,-87.9460745738818,42.5526946670262,-87.9460433737021,42.5526260676398,-87.9456407742017,42.5521688010502,-87.9455167073295,42.5518486675829,-87.944774307088,42.5518720670432,-87.9443107074725,42.5523298669307,-87.9432897737034,42.5522846670047,-87.9431041743176,42.5523304676778,-87.9427639068282,42.552330800427,-87.9424851736512,42.5521478675309,-87.9420205739897,42.5516220672055,-87.9417109742814,42.5514164668974,-87.9411851074062,42.5514166674462,-87.941030574201,42.551554067667,-87.9410313071485,42.5522402674753,-87.9410933073096,42.5522860006993,-87.9411865076506,42.5526518673907,-87.9412485069124,42.5527662009004,-87.9412485743616,42.5529264007337,-87.9413415741537,42.5529948670204,-87.9414345739458,42.5532692672638,-87.9416515075104,42.5535894007311,-87.9420849069922,42.5538178672017,-87.9428273737836,42.5537716672296,-87.9435695743757,42.5535654005237,-87.9442195072239,42.5538394671186,-87.9448695740709,42.5541592669375,-87.9454575742071,42.5543190009221,-87.9462621077095,42.5542728674997,-87.9465095076071,42.5541812005029,-87.946942307241,42.5538606002874));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (43,'14783707',14783707,'22-OCT-99',3,NULL,NULL,3.57805181754,0,NULL,466,46600,'071200040104',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.932653507153,42.5258032669082,-87.9326533075035,42.5256888677479,-87.9319107076124,42.5250260008502,-87.9314457743024,42.5240426677358,-87.9313529741598,42.5239512003885,-87.9313219736296,42.5238368668788,-87.9320327069432,42.5232188671579,-87.9327129073741,42.5231270670614,-87.9334859735982,42.5232410669226,-87.9345377073487,42.5235378009297,-87.9359603071218,42.5236744007539,-87.9374445068578,42.5236964674189,-87.9381247072888,42.5235816671611,-87.9390831075987,42.5233296006814,-87.9400721738911,42.5228258004712,-87.9412157742879,42.5224590677327,-87.9416793739034,42.5222302010638,-87.9427301741576,42.5216804670808,-87.9430081734878,42.5214058671879,-87.9432551075365,42.5209710674617,-87.9433471072825,42.5202620005917,-87.9432845072736,42.5195758007835,-87.9431295073203,42.5191640677684,-87.9430673740594,42.5189126002372,-87.9429743742673,42.518821200339,-87.94257110747,42.5177464007767,-87.9424781742277,42.5175634004315,-87.9424471736975,42.5174720005333,-87.9423853075353,42.5174262673093,-87.942354307005,42.5172662005756,-87.9420757069277,42.5169918677814,-87.9415187073218,42.5166262007395,-87.9413639735679,42.5164890676173,-87.941178374182,42.5163290674334,-87.9410545735091,42.5163062669216,-87.9406835069377,42.5162378006349,-87.940652773506,42.5164208009801,-87.9404985073996,42.5166268005873,-87.9403439741944,42.5167412671966,-87.9403443734934,42.5171072004379,-87.9404375072845,42.5174960007407,-87.940654507399,42.518021867616,-87.9407473740914,42.518159067288,-87.9408713069646,42.5184106670196,-87.9408721073612,42.5190968677272,-87.9405011738894,42.5192114674362,-87.9402847070729,42.5191428671505,-87.9400677735083,42.5188228676821,-87.9399745740667,42.518388400705,-87.9396959739894,42.5179996004022,-87.9396649743584,42.5179310675656,-87.939571973667,42.5177710008319,-87.9393245072196,42.5176568004219,-87.9388915070368,42.5174968676872,-87.9386129735093,42.5171768007697,-87.9386435738412,42.5168794669148,-87.9391685072202,42.5161700672957,-87.9391679073724,42.5156440007709,-87.9390751072298,42.5155982675469,-87.9390129074191,42.5152780675297,-87.9389201072765,42.5151408669583,-87.9388887739971,42.5148664676143,-87.9389815075899,42.5147748671673,-87.9389505070596,42.5146834007193,-87.9386099742703,42.5143862674132,-87.938207707519,42.5139062003118,-87.9373411738554,42.5132432677635,-87.9372171735331,42.5129688675201,-87.9372165071355,
  42.5121454671405,-87.9374325737537,42.5118480010853,-87.9378957740701,42.5114132004597,-87.9384211076473,42.5110468670202,-87.9395337740638,42.5106344676075,-87.9399043738871,42.5103598002655,-87.9401515741352,42.5101538006583,-87.9404291741664,42.509673267708,-87.9404289070678,42.5093072670177,-87.940582906975,42.5088496676789,-87.9406127069103,42.5078662005656,-87.9404267738759,42.5073402005907,-87.9403027735535,42.5071116010205,-87.9397457739477,42.5065400009212,-87.9393747073762,42.506334400613,-87.9386011735047,42.5057402005507,-87.9377659740198,42.5053060006723,-87.9371475075508,42.5050318675276,-87.9366527743055,42.5048262672194,-87.9362505075542,42.504552000975,-87.9349827071856,42.5041410009074,-87.9333131742629,42.5039816005713,-87.9327567070558,42.5038904003226,-87.9308403075335,42.5040744007139,-87.9292331740711,42.5046014007349,-87.9276263077073,42.5051968004929,-87.9270699070499,42.505357200875,-87.9269155069445,42.505448667323,-87.925153907726,42.5061128004663,-87.9227427740591,42.5065714007504,-87.9211663074785,42.5065490669867,-87.9197441070043,42.5065038670607,-87.9189093077177,42.5062756002397,-87.9179507743082,42.5059328002594,-87.9175489077552,42.5059330008082,-87.9176423077457,42.5069852004076,-87.9177353740876,42.507579867218,-87.9178603735568,42.5095240674826,-87.9177681741613,42.5103018002887,-87.9178921070344,42.5106676669802,-87.9179857741236,42.5119714006605,-87.9180169077534,42.5122916006777,-87.918140707527,42.5124060007373,-87.9182953072819,42.5124974006354,-87.9194083073469,42.5123826003776,-87.9211089073495,42.5124504677158,-87.9226857075787,42.5125872006397,-87.9230257736199,42.5125412677662,-87.9238605072559,42.5125638002801,-87.9250047075006,42.5128376672255,-87.9271077073542,42.513591600373,-87.9284069075521,42.5142544007209,-87.929427773872,42.5148942674574,-87.9294897074834,42.5150544007409,-87.9300775736205,42.515534466943,-87.9303871076783,42.5159232006961,-87.9306349068748,42.516311867,-87.9307897737284,42.5167234669154,-87.930882573871,42.516792067201,-87.9311309072649,42.5177754677645,-87.9311007736811,42.5186218008564,-87.9308845739633,42.5189192669116,-87.9306373737152,42.5191710671919,-87.9302355071623,42.5193084674128,-87.9297407739169,42.5192858674498,-87.928658374184,42.5190118674047,-87.9281015076778,42.5186004005889,-87.9278849068623,42.518440400405,-87.9277611070888,42.5182346669972,-87.9275753737039,42.5181432005492,-87.9271113073403,42.5177546007951,-87.9269567075854,42.5176860670592,
  -87.9263069743867,42.5171830672456,-87.9255333074155,42.5164972676357,-87.9252547738881,42.516291467678,-87.924636307419,42.5160858673698,-87.9243579069912,42.5159260002856,-87.9235229071558,42.5156976003649,-87.9222549071376,42.5152178003621,-87.9211727070542,42.5151266675626,-87.9200289070078,42.5153330008183,-87.9188851744106,42.5157910003553,-87.9181125740354,42.5163172674289,-87.9179891070111,42.5165690002601,-87.9178659736351,42.5173924006397,-87.9178043071224,42.5175756006344,-87.9177125735758,42.519153801108,-87.9178055077174,42.519245267556,-87.9178063737645,42.5205948010102,-87.9177137076209,42.5208006675177,-87.917777307676,42.5232938670193,-87.9179939075921,42.5234996004271,-87.9182413740396,42.523613867387,-87.9186125071608,42.5237052672852,-87.9188599736083,42.5238654005687,-87.9191073744051,42.5239568004669,-87.9192001736484,42.5240024005912,-87.9202519739488,42.5244822671438,-87.9205613740075,42.5247338003255,-87.9212109741065,42.5250538006932,-87.9219845070787,42.5255566674072,-87.9231289735227,42.5258992677379,-87.9233765074192,42.5261050676957,-87.923685907478,42.5262422008178,-87.9248611073536,42.5263560675793,-87.9261595737047,42.5260810009383,-87.9269945735401,42.5260578002282,-87.9287885069834,42.5263770676485,-87.9300875075318,42.5265136674727,-87.9316953073919,42.5263298676302,-87.9320663074135,42.5261924008595,-87.932653507153,42.5258032669082));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (44,'14783611',14783611,'22-OCT-99',3,NULL,NULL,.04345725499,0,'07120004001491',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9389815075899,42.5147748671673,-87.9388887739971,42.5148664676143,-87.9389201072765,42.5151408669583,-87.9390129074191,42.5152780675297,-87.9390751072298,42.5155982675469,-87.9391679073724,42.5156440007709,-87.9391685072202,42.5161700672957,-87.9386435738412,42.5168794669148,-87.9386129735093,42.5171768007697,-87.9388915070368,42.5174968676872,-87.9393245072196,42.5176568004219,-87.939571973667,42.5177710008319,-87.9396649743584,42.5179310675656,-87.9396959739894,42.5179996004022,-87.9399745740667,42.518388400705,-87.9400677735083,42.5188228676821,-87.9402847070729,42.5191428671505,-87.9405011738894,42.5192114674362,-87.9408721073612,42.5190968677272,-87.9408713069646,42.5184106670196,-87.9407473740914,42.518159067288,-87.940654507399,42.518021867616,-87.9404375072845,42.5174960007407,-87.9403443734934,42.5171072004379,-87.9403439741944,42.5167412671966,-87.9404985073996,42.5166268005873,-87.940652773506,42.5164208009801,-87.9406835069377,42.5162378006349,-87.9402503736552,42.5160322677759,-87.9396313073383,42.5152778004311,-87.9395383740961,42.515094867535,-87.9392907736496,42.5148662670655,-87.9389815075899,42.5147748671673));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (45,'14783609',14783609,'22-OCT-99',3,NULL,NULL,.21603863957,0,'07120004001489',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.921181774019,42.5272038674654,-87.9209035075901,42.5272726674006,-87.9204399736253,42.527707400577,-87.919821573706,42.5279592674072,-87.9195125738456,42.5281652004645,-87.9188329076119,42.5291262672643,-87.9185857739137,42.5295610004407,-87.9184931743199,42.5298584008455,-87.9183391744127,42.5306818003257,-87.9181847068581,42.5309106004448,-87.9170097075313,42.5311626669244,-87.9162675743884,42.5313458669191,-87.9160203075905,42.5315748010372,-87.9160823743015,42.5318034671572,-87.9168867738049,42.5324664671546,-87.9179387737548,42.5331522676639,-87.9184029075675,42.5333350674603,-87.9190833076479,42.5332890671377,-87.9197325740984,42.5330600673691,-87.9211547071234,42.532304800527,-87.9214637069838,42.5320300675345,-87.9218345739058,42.5317554676416,-87.9228543070799,42.530611267397,-87.9230087071854,42.5302910008299,-87.9231319071112,42.5295818674102,-87.9230387742194,42.529307400617,-87.923007306941,42.5285298009105,-87.9228523735376,42.5281638676693,-87.9221099076455,42.5276152677313,-87.921181774019,42.5272038674654));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (46,'14783607',14783607,'22-OCT-99',3,NULL,NULL,.04857669697,0,'07120004001488',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9150311738489,42.5324900671638,-87.9149075737249,42.5325816010609,-87.9148773735913,42.5337480676201,-87.9147847739975,42.5339540006775,-87.914753974016,42.5342056004091,-87.9144141741742,42.5348232673808,-87.9144453743539,42.535143467398,-87.9146309737398,42.535143467398,-87.914785506945,42.535051866951,-87.9151871072986,42.5343428009804,-87.9156817074442,42.5340222673147,-87.9160219074844,42.5339536004792,-87.9165479074593,42.5343194006207,-87.9166719068824,42.5346624002505,-87.9177237737325,42.5351880674762,-87.9185279070367,42.5351420006037,-87.9188987739586,42.5349360675464,-87.9189605070212,42.5345472006937,-87.9187747070864,42.5342270006764,-87.9182797076418,42.5341128677156,-87.9176609740741,42.5339988004052,-87.9173515740153,42.5337244010612,-87.9166091072239,42.5333358004078,-87.9154643071314,42.5325814005121,-87.9150311738489,42.5324900671638));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (47,'12168941',12168941,'22-OCT-99',3,NULL,NULL,.07391511386,0,'04040002000345',390,39004,'040400020402',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9078455736137,42.5700048006819,-87.9073815072501,42.5700964002296,-87.9071341739024,42.5703710010218,-87.9072589071722,42.5721092673297,-87.9071973072093,42.5725896006305,-87.9072595735698,42.5733902004982,-87.9073215071812,42.573596000456,-87.9078477742547,42.5739846676592,-87.9083121742668,42.5742132672294,-87.9088073077104,42.5741674674555,-87.9091785739314,42.5739386007867,-87.9093331071365,42.5736410672823,-87.9094257076297,42.5730692675336,-87.9093625743227,42.5710564669833,-87.9091767069388,42.5705532675202,-87.9088051070694,42.5703248001503,-87.9078455736137,42.5700048006819));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (48,'12168947',12168947,'22-OCT-99',3,NULL,NULL,.02233804752,0,'04040002000346',390,39004,'040400020402',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9081525077314,42.5653844005706,-87.9081213741015,42.5649496673942,-87.9079973737792,42.5647438674364,-87.9079353736179,42.5645610001909,-87.9076567735406,42.564332267521,-87.9070999070344,42.5642866673967,-87.9066977077324,42.5644470003297,-87.906326507162,42.5647214671229,-87.9060791072644,42.5649960670158,-87.9059245740592,42.565316401032,-87.90598670732,42.5658882007808,-87.9061725072548,42.5660254004528,-87.9062963070283,42.5660710671269,-87.9064819073135,42.5660252673531,-87.906852973885,42.5656134003391,-87.907007707639,42.5654990668294,-87.9078121736922,42.5654530674061,-87.9081525077314,42.5653844005706));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (49,'14783603',14783603,'22-OCT-99',3,NULL,NULL,.0244863084,0,'04040002000361',390,39004,'040400020402',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8988713738142,42.5699156670753,-87.8985309741245,42.5699614668491,-87.8985623074039,42.5710366009592,-87.8990265743163,42.5711278668585,-87.9007905072755,42.5710590003735,-87.9011925743771,42.5708528676666,-87.9012543739895,42.5706012670357,-87.901192506928,42.5703954005282,-87.9008829737696,42.5702124676322,-87.8997687740091,42.570006867324,-87.8988713738142,42.5699156670753));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (50,'12168935',12168935,'22-OCT-99',3,NULL,NULL,.03120185075,0,'04040002000341',390,39004,'040400020403',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8725053738233,42.6521022006569,-87.8734659073251,42.6516904667425,-87.8739307075355,42.6513930672372,-87.8742095738122,42.6508440671009,-87.8744575070077,42.6498834670493,-87.8743335075847,42.6495632004822,-87.8740855743891,42.6490830002812,-87.8737137739708,42.6491516005668,-87.8735897736485,42.649334600912,-87.8735899076475,42.6501580003923,-87.8734969744052,42.6503866674117,-87.8732799742908,42.6506382671432,-87.872009573982,42.6512330005035,-87.8717307742552,42.6515532005207,-87.8717617073363,42.6519192003117,-87.8721335077545,42.6520792670455,-87.8725053738233,42.6521022006569));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (51,'12168937',12168937,'22-OCT-99',3,NULL,NULL,.0140286029,0,'04040002000342',390,39004,'040400020403',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8672079074183,42.6357020001481,-87.8669291076915,42.6355190672521,-87.8665573738231,42.6356104671502,-87.8663715073386,42.6358164002076,-87.8660617070815,42.636228000123,-87.8659687072894,42.6366854672614,-87.8659687072894,42.6370514670525,-87.8662473739165,42.6373718001694,-87.8667121075771,42.6373488674571,-87.8668981071613,42.6370056672786,-87.8669289736926,42.6364796673037,-87.867083907096,42.6362510002843,-87.8672079074183,42.6357020001481));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (52,'12168939',12168939,'22-OCT-99',3,NULL,NULL,.02423902965,0,'04040002000343',390,39004,'040400020401',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8597481074885,42.6062406667743,-87.8573019074564,42.6063090674105,-87.85665157441,42.606446067433,-87.8565895742488,42.6069722670574,-87.8567443071034,42.6071780670151,-87.8572087736653,42.6073840009718,-87.8578281070808,42.6074070002338,-87.8581377076884,42.6073156003356,-87.8595311739239,42.6067438671367,-87.8597479078391,42.6065380006291,-87.8597481074885,42.6062406667743));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (53,'12168931',12168931,'22-OCT-99',3,NULL,NULL,.01952715465,0,'04040002000339',390,39004,'040400020403',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8460385076704,42.6623692667292,-87.8459145738978,42.6621176669976,-87.845635774171,42.6618660672661,-87.8447991069926,42.6616142669857,-87.8435597737639,42.6611336000365,-87.842970774481,42.661225000834,-87.8426917742054,42.6614764674659,-87.8426917742054,42.6617052666856,-87.8428775741401,42.6617968005828,-87.843652374257,42.661819867294,-87.8442101077097,42.6620258669012,-87.844674773921,42.6624148003037,-87.8451087076002,42.6625064007507,-87.8458835077171,42.6624836667887,-87.8460385076704,42.6623692667292));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (54,'12168933',12168933,'22-OCT-99',3,NULL,NULL,.02168605594,0,'04040002000340',390,39004,'040400020403',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8422905740501,42.6580226004635,-87.8415467744634,42.6582510669341,-87.8410507740733,42.6584796674036,-87.8408645739403,42.6589142674804,-87.8408949737234,42.6599664005299,-87.8410809742069,42.6601036667518,-87.8418247737936,42.6600580675267,-87.8419181072342,42.6593034005324,-87.8419801073954,42.6591432672489,-87.8426001072086,42.6588002667198,-87.8426931744498,42.6585258673758,-87.842538374146,42.6581828002969,-87.8424145078226,42.6580454675252,-87.8422905740501,42.6580226004635));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (55,'12168951',12168951,'22-OCT-99',3,NULL,NULL,.03922790661,0,'04040002000347',390,39004,'040400020401',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8391593739053,42.5446838668678,-87.8387263071727,42.5448210008894,-87.8386023077497,42.5452326673546,-87.8383547073033,42.5453240672528,-87.8372721070215,42.5452552007678,-87.8367769744772,42.5453694002785,-87.8361271738294,42.5457350673204,-87.8360031744064,42.5461924670096,-87.8361267745304,42.5463298006807,-87.8364051075091,42.5465128675757,-87.8370239741764,42.5465130672252,-87.837704707006,42.5462846007546,-87.8379521078029,42.5461016669593,-87.8379833070833,42.5459416002256,-87.8382617075112,42.5458502003274,-87.8388185074675,42.5458960675504,-87.8395297075293,42.5463080676641,-87.8399319077307,42.5463082007637,-87.840210373809,42.5461710001924,-87.8402723739703,42.5457822007888,-87.8399633741098,42.5451874008788,-87.8398397739857,42.5449586007597,-87.8393759072717,42.5446840008669,-87.8391593739053,42.5446838668678));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (56,'12168959',12168959,'22-OCT-99',3,NULL,NULL,.08704831343,0,'04040002000348',390,39004,'040400020401',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8355891742004,42.5149240008429,-87.8348161745262,42.5150152676414,-87.8348763742446,42.5177602008735,-87.8350001074683,42.5178060006473,-87.8362985072696,42.5178978672936,-87.8365459737171,42.5179666672288,-87.8375041078277,42.5185388006261,-87.8376895075641,42.5186302670741,-87.8382461078709,42.5185388671759,-87.8384317738067,42.5183560008297,-87.838524707049,42.5181730004845,-87.8384941741662,42.5174868006762,-87.8382779744483,42.5170064008257,-87.8382161739366,42.5169148669285,-87.8381543743243,42.5167318674826,-87.8380927078116,42.5166402670356,-87.8379691742373,42.5162972008561,-87.837691107458,42.515931201065,-87.8369183739831,42.5153820003799,-87.8363311742436,42.5151072673874,-87.8355891742004,42.5149240008429));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (57,'12168943',12168943,'22-OCT-99',3,NULL,NULL,.01521073962,0,'04040002000344',390,39004,'040400020401',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8328941074764,42.5704374672163,-87.8326155073991,42.5706432671739,-87.8326153077496,42.5708492002313,-87.8322127073499,42.5712608001467,-87.8319339076231,42.5717180676356,-87.8319025743437,42.5723128009959,-87.8320881071797,42.5725874008887,-87.8323045739962,42.5726102670511,-87.8325523075423,42.5725188671529,-87.8326453073344,42.5723588004192,-87.8327693742066,42.5718328004443,-87.8329863077713,42.5713526002432,-87.8333889738215,42.5708950674543,-87.8334201074513,42.5705748674371,-87.8332963742276,42.5704376003159,-87.8328941074764,42.5704374672163));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (58,'167157004',167157004,'16-MAY-09',3,'1571135','Peat Lake',.17083576311,0,'07120006009324',390,39004,'071200061005',1,'16-MAY-09',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1557653737723,42.5000298005358,-88.1557035732607,42.5001766004706,-88.1556417736483,42.5002224676936,-88.1555185071727,42.500565600423,-88.1556731734775,42.5007256006069,-88.1563843069895,42.5007940677929,-88.1568789071352,42.5009312009151,-88.1579917066513,42.5009078671053,-88.1589187736818,42.5007246671106,-88.1604019068219,42.5001294670022,-88.1605253072964,42.5000308671317,-88.1614757737873,42.4994188676875,-88.1616893070153,42.4990984671215,-88.1617807734633,42.4987554674917,-88.1617495067337,42.4981608006813,-88.1614399735753,42.4975662004207,-88.160481307066,42.4966288676291,-88.160202973188,42.4965374677308,-88.1592185069279,42.4966520674399,-88.1574325738536,42.4970872673644,-88.1563513072664,42.4974536673538,-88.1564131068787,42.497682400923,-88.1567837067021,42.497933801005,-88.156659173981,42.4992604673976,-88.1562893736551,42.4997180010858,-88.1557653737723,42.5000298005358));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (59,'167157006',167157006,'16-MAY-09',3,'1572460','Rock Lake',.19796539343,0,'07120006009326',390,39004,'071200061005',1,'16-MAY-09',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1168803738295,42.5000226671133,-88.1168495072983,42.4998384005227,-88.1152735065664,42.4990834673291,-88.1145935066843,42.4990606002674,-88.1141607070504,42.4991520676147,-88.1132641072521,42.4997924676492,-88.1131403740284,42.5000240673577,-88.1128627074473,42.5011180008959,-88.1128631732961,42.5016670010322,-88.1130799072113,42.501941466926,-88.113049973277,42.5028334675914,-88.1135765074492,42.5034282675015,-88.1140101065805,42.5037942007427,-88.115030773251,42.5040002003499,-88.1160207739389,42.503794466942,-88.1176005734071,42.5031542009066,-88.1190239735769,42.5028340008893,-88.1191477068006,42.5027196673797,-88.1191467067545,42.5019648007359,-88.1191155065747,42.5019190675118,-88.1190209068887,42.5016446007186,-88.1184917071259,42.5011870670304,-88.1171589073571,42.5002720671031,-88.1171279068268,42.5001348674311,-88.1168803738295,42.5000226671133));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (60,'14768128',14768128,'15-OCT-99',3,NULL,NULL,.05017276373,0,'07120006001671',390,39004,'071200061006',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1920655737666,42.501876400976,-88.1918493065996,42.5018994676872,-88.1909221739186,42.5021744003292,-88.18977897372,42.5026554674768,-88.1894703066087,42.5029758671434,-88.189285173971,42.5034104672202,-88.1892241073061,42.5041882674755,-88.1893479736294,42.5043940008833,-88.1897189736511,42.5043938677837,-88.1900589065926,42.5043022007869,-88.1910171738029,42.5043244671014,-88.1916661066049,42.5041410674572,-88.1922221736138,42.5038434008532,-88.1923147732076,42.5036146007341,-88.1919433738869,42.5032488005926,-88.1918193070148,42.5029058009629,-88.1920045736515,42.5026312676198,-88.1923751734748,42.5023108005039,-88.1923439067452,42.5020364002606,-88.1920655737666,42.501876400976));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (61,'19285193',19285193,'15-OCT-99',3,NULL,NULL,2.07899360795,0,NULL,466,46600,'071200061005',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1473457067383,42.5238746671831,-88.1472533733439,42.5250868669663,-88.1473153069552,42.5252012670257,-88.147315373505,42.5255444006545,-88.1475011068899,42.5257730676739,-88.1475011068899,42.525864467572,-88.1476247735638,42.5260474670179,-88.1477175737064,42.5261390009151,-88.1477177068061,42.5262304673631,-88.1481199070075,42.5268478672362,-88.1483673734549,42.5270766008054,-88.1483673069051,42.5271680672534,-88.1485839068212,42.5273738672111,-88.1486459069824,42.5275796671688,-88.1487695736562,42.527671201066,-88.1488313732686,42.5278312669004,-88.1490479731848,42.5281286007552,-88.1491717738576,42.5282428677151,-88.1492647070999,42.5283572668753,-88.149790506526,42.5287916673025,-88.1504399735253,42.5290888671584,-88.1513677069535,42.5290886675089,-88.1524191070555,42.528768200393,-88.1535011065902,42.5282190006073,-88.1543667067575,42.5277156005954,-88.1547377067791,42.527418067091,-88.1548613069032,42.5272350676452,-88.1550767736735,42.5255652676239,-88.155231173779,42.5250164005873,-88.1554475065965,42.5246274671848,-88.1554783740271,42.5244902009629,-88.1556945737449,42.5242386003321,-88.1563437736456,42.5237580673818,-88.1574871734936,42.5225684010118,-88.1577653068228,42.5220880002619,-88.1579813068911,42.5214246009655,-88.1581667066276,42.5211272005608,-88.1587845732488,42.5202808009191,-88.1593409739062,42.5196858670101,-88.1594335735,42.51945720089,-88.1594023067704,42.5190226008133,-88.1592787066464,42.5189998003015,-88.1590309065505,42.5182450676567,-88.1590303732525,42.5174674005011,-88.1591541073755,42.5173530004415,-88.1591539733765,42.517192867158,-88.1593703070934,42.516964067039,-88.1594321067057,42.5168726005909,-88.1599265737518,42.5165294004124,-88.1609775736555,42.5159800009772,-88.1611939739221,42.5158198676937,-88.161255573885,42.5157054676341,-88.1621827740152,42.5150418003397,-88.1632955069814,42.5144238671687,-88.1643461732367,42.5136916004879,-88.1649333073256,42.513279800923,-88.1655513070465,42.5127076675257,-88.1657983067458,42.5122502003874,-88.1659833071832,42.5115638674794,-88.1661063740093,42.5107862003238,-88.1661681736217,42.5106490006518,-88.1660751738296,42.5103058670231,-88.1657969065014,42.5101002010643,-88.1652403070939,42.5099174003686,-88.1640035738052,42.5097348011211,-88.1637253064771,42.5096206007111,-88.1628905071905,42.509460801076,-88.1618703072682,42.509438201113,-88.1611283072249,
  42.509507067598,-88.1606027739982,42.509667400531,-88.1590263739673,42.5099650671351,-88.1563059067915,42.5099430670198,-88.1550693740517,42.510012000954,-88.152750706879,42.5098754011298,-88.1509265067522,42.5094870010252,-88.1501225065478,42.5090296669865,-88.1501223734481,42.5089154009259,-88.1499677071433,42.5087094669692,-88.1499675740437,42.5082750008915,-88.1499983740251,42.5080004675485,-88.1503691069481,42.5074056676384,-88.1507707738515,42.5070168007856,-88.1512345065666,42.5066964011189,-88.1536761740156,42.5056666674836,-88.1545413739846,42.5051174676979,-88.154572173966,42.504865867067,-88.1540775072705,42.5043628007036,-88.1536135740066,42.5040426672362,-88.1512329066726,42.5031512673181,-88.150676373815,42.5028768670747,-88.1506765069146,42.5028540009123,-88.1497489740353,42.5026712676658,-88.1492543738896,42.5026942669278,-88.1489763071102,42.5027400010511,-88.1476783066079,42.5034722002827,-88.146782107008,42.5043872676592,-88.146782107008,42.5044558670455,-88.1464423071661,42.5048218677359,-88.1464423071661,42.5049820675692,-88.1460715733438,42.505691200989,-88.1459171066885,42.5057826674371,-88.145886306707,42.5060800003926,-88.1452065073738,42.5070636671554,-88.1451757739422,42.5075440004562,-88.1453303736972,42.5077498004139,-88.1461343073518,42.5082070670035,-88.1464125737806,42.5086188009178,-88.1463817737992,42.5088932002619,-88.1462891067562,42.5089618670974,-88.1455781072432,42.5091678676039,-88.145609173424,42.509671067067,-88.1454857738487,42.5100142672455,-88.1454549073175,42.5102430008147,-88.145300507212,42.5106318676675,-88.1451153071251,42.5118898006747,-88.1455483073079,42.5120498674083,-88.1461665732281,42.5121412673066,-88.1462901733522,42.5122098675922,-88.1467849065975,42.5120496677588,-88.1478359739504,42.5120036674362,-88.1486707066871,42.5122322670064,-88.1493819067489,42.5125752009856,-88.1499697072356,42.5130782007992,-88.1502171071331,42.5133526675924,-88.1508665066833,42.5138786010176,-88.1511139065809,42.5139242676917,-88.1522887071575,42.5139926008787,-88.1525981072162,42.5141526676124,-88.1527835735025,42.5143814002823,-88.1528457733132,42.5151132676641,-88.1531551068221,42.5153418672343,-88.1533405740076,42.5153876004583,-88.1534027738183,42.5161422674526,-88.1534645734307,42.5161880672264,-88.1535885072032,42.5167370008128,-88.1535887734025,42.5172400671763,-88.1536507735637,42.5176290005788,-88.1535273739885,42.5182236673892,-88.1533111068215,42.5185210668946,-88.1527855735947,42.5189328673588,
  -88.1516729737281,42.5197566004877,-88.1510547069086,42.5200312669303,-88.1501891067413,42.5205574674541,-88.1490453066949,42.5210380669541,-88.1487979733471,42.5212668005233,-88.1486745072221,42.5214498674184,-88.1486127732603,42.5220674003911,-88.1485201071166,42.5222960674105,-88.1480255735208,42.5227766003607,-88.14771670676,42.5235314004547,-88.1473765732696,42.5237602671235,-88.1473457067383,42.5238746671831));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (62,'14768122',14768122,'15-OCT-99',3,NULL,NULL,.04120305718,0,'07120006001666',390,39004,'071200061005',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1455781072432,42.5091678676039,-88.1462891067562,42.5089618670974,-88.1463817737992,42.5088932002619,-88.1464125737806,42.5086188009178,-88.1461343073518,42.5082070670035,-88.1453303736972,42.5077498004139,-88.1451757739422,42.5075440004562,-88.1452065073738,42.5070636671554,-88.145886306707,42.5060800003926,-88.1459171066885,42.5057826674371,-88.1453915734617,42.5058056010486,-88.1451133735827,42.5059886670443,-88.1440625733285,42.506743667687,-88.1436917738557,42.5072468671501,-88.1437227734866,42.5074070004336,-88.1438773732415,42.507635667453,-88.1441557071195,42.5079102007961,-88.1443723070357,42.5084132671595,-88.1453617069765,42.5091680007036,-88.1455781072432,42.5091678676039));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (63,'19285017',19285017,'15-OCT-99',3,NULL,NULL,.51946806796,0,NULL,466,46600,'071200060802',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2707367069328,42.5219134670338,-88.2707983068957,42.5220736003173,-88.2706743065734,42.5222336005012,-88.2706117731142,42.5226680674783,-88.2711059730616,42.5229888007934,-88.2717243064309,42.5230122002537,-88.2727447734519,42.5229444669145,-88.2739509738577,42.5226938672291,-88.2748173735224,42.5223516005468,-88.2759005736519,42.5217808008442,-88.2763651733135,42.5213008002926,-88.277356373697,42.5200666003942,-88.2779137069514,42.5195866672918,-88.2791207068545,42.5188786670178,-88.2797705731528,42.518399001014,-88.2806371068164,42.5178506672754,-88.2815967068219,42.5171654009634,-88.2820305065021,42.5164568008416,-88.2819073065763,42.5161822009487,-88.2817529730207,42.5159762004422,-88.2817531070197,42.5158618003827,-88.2816605065265,42.5157702673848,-88.2816297730949,42.5156786669378,-88.2815679734825,42.5156100675515,-88.2815371735011,42.5155186011035,-88.2812903069015,42.5152210675991,-88.281290506551,42.5151296002518,-88.2808275067834,42.5146488676521,-88.2803333733858,42.5142594675013,-88.279900906501,42.514053400445,-88.2777067063988,42.5135254669277,-88.2765939734325,42.513410200821,-88.2759755069634,42.5135012005209,-88.2761289735726,42.5141646007166,-88.2760355735822,42.5145990676937,-88.2758803730801,42.5149878005475,-88.2755091068591,42.5151704672442,-88.2746115070148,42.5158100677813,-88.2744561068632,42.5163130675949,-88.2743013731093,42.5164044674931,-88.2739303730876,42.5163584006206,-88.2734051069595,42.5161292003033,-88.2731267730815,42.5161518677155,-88.2730649069193,42.5162432676136,-88.2730021738107,42.5167236009144,-88.2726303733924,42.5172036005666,-88.2726607066257,42.5175924008695,-88.2727531731198,42.5177296670914,-88.2726907071098,42.5181414010058,-88.2722875734121,42.5189414675756,-88.2717609070396,42.5196042670242,-88.271450907133,42.5200842675758,-88.2713881065752,42.5206788669371,-88.2712639066034,42.5209074674066,-88.2711707737116,42.5211360669768,-88.2711081737026,42.5216392673392,-88.2707367069328,42.5219134670338));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (64,'14768092',14768092,'15-OCT-99',3,'1562620','Camp Lake',1.75709097561,0,'07120006001661',390,39004,'071200061005',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1396791068047,42.5319728005052,-88.1398337065597,42.5320184671794,-88.1400193068449,42.5322472007486,-88.1404523735775,42.5326360010515,-88.1407615739868,42.5328188673977,-88.1420297736545,42.5334820004948,-88.1428957740201,42.5338020674124,-88.1431123073864,42.5338020008626,-88.1432669071414,42.5336190005174,-88.1436997733252,42.5332302002145,-88.1439779732042,42.5329098670976,-88.1442251734524,42.5323152002871,-88.1443795735578,42.5314002669097,-88.1446885734183,42.5305996004921,-88.1449049071351,42.5302108010885,-88.1464197737529,42.5287238008636,-88.146543373877,42.5283350005607,-88.1465121071474,42.5274428676951,-88.1463879737254,42.5264136673578,-88.1461405072779,42.5261622007259,-88.1457073739955,42.5257276006491,-88.1456763069154,42.5253158676341,-88.1458617066518,42.5249956676168,-88.1470983733906,42.5239662010802,-88.1473457067383,42.5238746671831,-88.1473765732696,42.5237602671235,-88.14771670676,42.5235314004547,-88.1480255735208,42.5227766003607,-88.1485201071166,42.5222960674105,-88.1486127732603,42.5220674003911,-88.1486745072221,42.5214498674184,-88.1487979733471,42.5212668005233,-88.1490453066949,42.5210380669541,-88.1501891067413,42.5205574674541,-88.1510547069086,42.5200312669303,-88.1516729737281,42.5197566004877,-88.1527855735947,42.5189328673588,-88.1533111068215,42.5185210668946,-88.1535273739885,42.5182236673892,-88.1536507735637,42.5176290005788,-88.1535887734025,42.5172400671763,-88.1535885072032,42.5167370008128,-88.1534645734307,42.5161880672264,-88.1534027738183,42.5161422674526,-88.1533405740076,42.5153876004583,-88.1531551068221,42.5153418672343,-88.1528457733132,42.5151132676641,-88.1527835735025,42.5143814002823,-88.1525981072162,42.5141526676124,-88.1522887071575,42.5139926008787,-88.1511139065809,42.5139242676917,-88.1508665066833,42.5138786010176,-88.1502171071331,42.5133526675924,-88.1499697072356,42.5130782007992,-88.1493819067489,42.5125752009856,-88.1486707066871,42.5122322670064,-88.1478359739504,42.5120036674362,-88.1467849065975,42.5120496677588,-88.1462901733522,42.5122098675922,-88.1463213069821,42.5125072005478,-88.1466305073914,42.5130102669112,-88.1467543071649,42.5131018008084,-88.1467235071835,42.5132848002542,-88.1463215731814,42.5135364008851,-88.1457959734048,42.5135136669231,-88.1452703736282,42.5133766003507,-88.1442193071746,42.5134452671862,-88.1423027071036,42.5141546677046,
  -88.1415917066913,42.5146580002674,-88.1414989739978,42.5148638011244,-88.1411589070573,42.5151612671796,-88.1404481071938,42.5156188008679,-88.1380367738774,42.5168314008494,-88.1376657073059,42.5167628005637,-88.1375729071633,42.516694200278,-88.137263706754,42.516694200278,-88.1367381069774,42.5171060007423,-88.1366453068348,42.517403267148,-88.1366763073651,42.5174948010451,-88.136707306996,42.5177234671652,-88.1364599736482,42.5179750668967,-88.1360581070953,42.5185470671943,-88.1360581070953,42.5187300675395,-88.1360581736452,42.5191646010664,-88.1361513065369,42.5202168006657,-88.1362441732294,42.5202624673399,-88.1363679073524,42.5208800003127,-88.1364297735146,42.5209716007597,-88.1365225071074,42.5212460010031,-88.1366463068809,42.5214518009607,-88.1367081739425,42.5217490673665,-88.1368937733283,42.5219550004238,-88.1373267735112,42.5226640007439,-88.1385019733867,42.5238304007533,-88.1386257066104,42.5240132670995,-88.1398009739352,42.5250652670493,-88.1402649737489,42.5256370002483,-88.140914507298,42.5260944008368,-88.1418423738259,42.5265746010379,-88.1421207068045,42.5268032006081,-88.1421825738661,42.5271464007866,-88.1420899068231,42.5273978674185,-88.1418735740056,42.5275580672519,-88.1411931739252,42.5276038670257,-88.140914906597,42.5278098009824,-88.1405749071056,42.5281072670376,-88.1398019739813,42.5289308005169,-88.1397401734696,42.5291824002485,-88.1397713070995,42.5299828670166,-88.1398331732617,42.5302574003596,-88.1398025738291,42.531057800578,-88.1395243074002,42.5314696010421,-88.1396517737098,42.5318840670969,-88.1396791068047,42.5319728005052));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (65,'14768096',14768096,'24-AUG-09',3,'1569034','Lake Mary',1.29906137215,0,'07120006001663',390,39004,'071200060802',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2500787066663,42.5298916676672,-88.2514269064259,42.5299224010988,-88.2517981735462,42.5298542675613,-88.2537473731421,42.529307400617,-88.2552631067064,42.5290344671678,-88.2563149070067,42.5289668669283,-88.2569639738077,42.5290592003228,-88.2577369734819,42.5291056673935,-88.258912507006,42.5288780669701,-88.2593151730562,42.5285582671512,-88.2595939736823,42.5282612669448,-88.2598109737968,42.5279640670889,-88.260339306613,42.5265236670345,-88.2604947067647,42.5260892675066,-88.2607427065101,42.5257236004647,-88.2610523736675,42.5254722003826,-88.2617021734159,42.5251754672749,-88.2621043070675,42.525130200799,-88.2625989072131,42.5251992669336,-88.2635271064901,42.5249486672481,-88.2638985732599,42.5246744675536,-88.2644251730827,42.5241032011028,-88.2649211069229,42.5234174671433,-88.2649219738694,42.5229372669422,-88.2648607732055,42.5225712006014,-88.2644283063207,42.5223192006715,-88.2639955732365,42.5222272674753,-88.263222706662,42.5221808004045,-88.2626661063551,42.5222718010037,-88.2614595066503,42.522590800426,-88.2609649065046,42.522590267128,-88.2607487733366,42.5223842675209,-88.2607181064548,42.5222470003997,-88.2609659731006,42.5219498670936,-88.2612447071768,42.5216758004987,-88.2616163070463,42.5214016008042,-88.2622043071824,42.5211276673089,-88.2632865738157,42.520991467683,-88.2640291071569,42.5207636010603,-88.2645553067813,42.5204896010152,-88.2648649064896,42.5202154669711,-88.2655155066347,42.5194842003365,-88.2655777729952,42.5191868673809,-88.2654543068701,42.5190724007716,-88.2649291063925,42.5188890002281,-88.2634137064767,42.5190476010669,-88.2631357071465,42.5189558009703,-88.2623329066377,42.5183146670891,-88.2602327063736,42.5171688669506,-88.2593365733235,42.5168250003744,-88.2585331064171,42.5166868672061,-88.2580383066219,42.5166864004579,-88.2573269069106,42.5168914674682,-88.2559339730738,42.5177364003155,-88.2549119070582,42.5186730676089,-88.25450897301,42.5191758003238,-88.2533015063588,42.5200664672946,-88.2521861734525,42.5211404008098,-88.2514117069841,42.5218716008946,-88.2506985733798,42.5228998677356,-88.2505431066784,42.5233800670374,-88.2503879736254,42.5236086675069,-88.2500973738941,42.523739067405,-88.2498193736645,42.5239224004993,-88.2487697731059,42.5248156008602,-88.2480919738649,42.526028467041,-88.2479073070759,42.5264404006049,-88.2470127730204,42.5275850010478,-88.2469513070565,
  42.5277680004937,-88.2469833067336,42.5283626673042,-88.2472007070464,42.5287970002822,-88.2479747733165,42.5293680005337,-88.248439506977,42.5297790671511,-88.248810907197,42.5299158675242,-88.2500787066663,42.5298916676672));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (66,'19285015',19285015,'15-OCT-99',3,NULL,NULL,.32790082623,0,NULL,466,46600,'071200061006',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1742485066626,42.5250782676488,-88.1744031073169,42.5250554005872,-88.1768745738019,42.522309467309,-88.1773069066878,42.5216918003372,-88.1774921067747,42.5212798676727,-88.1775535736379,42.5209368005938,-88.1776153067004,42.5207996009217,-88.1777077731945,42.5203420672335,-88.1779547072433,42.5198388003213,-88.1780779737189,42.5194956010421,-88.1784791738741,42.5186262668896,-88.1785095736573,42.5180544671409,-88.1783237737225,42.5176886669993,-88.1780757739771,42.5168882002312,-88.1778277733324,42.5161564002985,-88.1774563740118,42.5156762009968,-88.1768995731562,42.5152418671194,-88.1767141068699,42.515196266995,-88.1766213067273,42.5152878008922,-88.1766217069256,42.5156308670718,-88.176683506538,42.5156766002958,-88.1766527065565,42.5158366670295,-88.1769003070029,42.5161110672728,-88.1769003735528,42.5162254007825,-88.1773027068538,42.5167284005961,-88.177303173602,42.5172544671209,-88.1771813739206,42.5194960003411,-88.1771197739578,42.5197934007458,-88.1769961738337,42.5198850002934,-88.1764705731578,42.5199308675165,-88.1756975069338,42.5197940005935,-88.1753571072441,42.5195426005115,-88.1752025731396,42.5195198674488,-88.174955307241,42.5195428010603,-88.1745221065094,42.5192686004664,-88.1737799733664,42.519040067446,-88.173625173962,42.5189486675479,-88.1732853066709,42.5190632007071,-88.1730071067919,42.5192462676021,-88.1719875732672,42.5202302005642,-88.1707827740052,42.5218090008856,-88.1706593735306,42.5221292674526,-88.1705667064876,42.5222436675122,-88.1701651735833,42.5231130007653,-88.1700419071077,42.5235246672305,-88.1700425735053,42.5245082008936,-88.1704449068064,42.5247826002377,-88.171032573294,42.5249652669344,-88.1724859739479,42.5251476674318,-88.1736609732747,42.5250328006242,-88.1738773069915,42.5249412676263,-88.1742485066626,42.5250782676488));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (67,'19285011',19285011,'15-OCT-99',3,NULL,NULL,.3052041259,0,NULL,466,46600,'071200061006',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1842715731739,42.529625067244,-88.1829729071733,42.5297858669251,-88.1817981065967,42.5300380008539,-88.1805613067582,42.530450267167,-88.1800977071428,42.5307250010588,-88.1796651071583,42.5310684008869,-88.1791399732305,42.5317776008565,-88.1791401072295,42.5318690673045,-88.1790473736368,42.5319148670783,-88.1790783732677,42.5319834673641,-88.178985573125,42.5320750669117,-88.1788315066681,42.5326698002719,-88.178832173965,42.5334016676537,-88.1790181069994,42.5338362002813,-88.1796059731365,42.5342704676089,-88.1801321736602,42.534659067363,-88.1812459732225,42.5350472669188,-88.1822359064613,42.5352984008015,-88.1829781736032,42.5353208676648,-88.1835037733798,42.535229200668,-88.1838747734014,42.5350916673475,-88.1847403070189,42.5346110003982,-88.1859145068483,42.5335352673396,-88.1862543066903,42.5331006007131,-88.1865321072703,42.532643000475,-88.1865935732342,42.5323226673581,-88.1865001066939,42.5315680003638,-88.1862521069485,42.5310648674506,-88.1861901067874,42.5307904672072,-88.1860351733839,42.5305846672495,-88.1860349071846,42.5301958669466,-88.1857871736385,42.5299214676025,-88.1853541069059,42.5297616005184,-88.1842715731739,42.529625067244));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (68,'19285009',19285009,'15-OCT-99',3,NULL,NULL,.18665582299,0,NULL,466,46600,'071200061006',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2555613731582,42.5348214003882,-88.254571707018,42.5348660670163,-88.2534579065565,42.5350936674397,-88.2530243730757,42.5353676674848,-88.2519711068804,42.5363272009405,-88.2508867736051,42.5372408671732,-88.2507003063734,42.5377210008244,-88.2503579731413,42.5387728002254,-88.2503563732474,42.5396190676668,-88.2504483064436,42.5400308672316,-88.2507259064748,42.5404656669579,-88.2510963066486,42.5408092007849,-88.2514669064719,42.5410840003273,-88.2523325066392,42.5413136673927,-88.2529203071259,42.5412456669549,-88.2534159064183,42.5408802670116,-88.2535089736596,42.5406974006654,-88.2536019069018,42.5406288669296,-88.2537577063524,42.5400800673422,-88.2537919732204,42.5382732007485,-88.253854173031,42.5381360676263,-88.2539165733905,42.5377930670973,-88.2540099733809,42.5374958006915,-88.2542891067562,42.5371072674873,-88.2559919730505,42.5361026672052,-88.256456706711,42.5356686004264,-88.2565807735832,42.5354628670186,-88.2565809732327,42.5353256007967,-88.2564575071077,42.5352568674114,-88.2563959736946,42.535096667578,-88.2559323731799,42.5349132004847,-88.2555613731582,42.5348214003882));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (69,'14768084',14768084,'15-OCT-99',3,'1562886','Center Lake',.49926278333,0,'07120006001651',390,39004,'071200061005',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1276493065696,42.538515400766,-88.1276493065696,42.5385480677401,-88.1276493065696,42.5388356007833,-88.1278657068362,42.5390184671294,-88.1278967073665,42.5391556677008,-88.1273091074287,42.5393844669205,-88.1268141736346,42.5396820004249,-88.1257009073703,42.540711267312,-88.1255461736164,42.5409400008812,-88.125638973759,42.5411230003271,-88.127742307261,42.5416718008138,-88.1287939070126,42.5419006009329,-88.1315467740637,42.5419002672844,-88.1327839732012,42.5416942676772,-88.1347015067685,42.5410080004198,-88.1360623069293,42.5402760008377,-88.1370827739502,42.5395440003562,-88.1377321735004,42.538926267734,-88.1380105739282,42.5385602670436,-88.1384743731931,42.538217200864,-88.139185573255,42.5380340674192,-88.1401443072133,42.5377366004647,-88.1406081739274,42.5373706006736,-88.1406389739089,42.5370962004302,-88.1399895069096,42.5368218010861,-88.1396491737697,42.5365244006815,-88.1396181732395,42.5363414668861,-88.1395255070958,42.5362958002119,-88.1394943069161,42.535495266894,-88.1396181066896,42.5353350670606,-88.140545773568,42.5351520010649,-88.1409477732205,42.5349460671082,-88.1410405068133,42.5347860003745,-88.1410095071824,42.5344428676451,-88.1409167070398,42.5343514677469,-88.1391847072078,42.533894200258,-88.1384733065972,42.533619800914,-88.1381949070687,42.5333910673448,-88.1375455066192,42.5334370002183,-88.1372671736405,42.5338030009087,-88.1372053740282,42.534100400414,-88.1370509073728,42.5343976002699,-88.1370199733924,42.5348094007342,-88.1369273072488,42.5351524669137,-88.1359689069388,42.5365478010411,-88.1357215735911,42.5371654005637,-88.1353813070011,42.5373254672974,-88.133803973474,42.5376002002899,-88.1334329069025,42.5375772675777,-88.1325669065369,42.5373486005584,-88.131453507173,42.5368684003573,-88.1306181736891,42.536937000643,-88.130154306975,42.5371428671505,-88.1300305737514,42.53725726721,-88.1299069736273,42.5386296002767,-88.1296287071984,42.5387212007237,-88.1289791736493,42.5386068006642,-88.1285771065476,42.5384696009922,-88.1276493065696,42.538515400766));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (70,'14768970',14768970,'15-OCT-99',3,NULL,NULL,.08148428022,0,'07120006001653',390,39004,'071200061006',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2342021067412,42.5403376673504,-88.2345423067814,42.5403374002517,-88.2366133069579,42.5396720674129,-88.2366403738535,42.5374762674167,-88.2363619734257,42.5374766010652,-88.2343839730413,42.5382790670262,-88.2341679064231,42.5384852006324,-88.2336423066465,42.5386228005028,-88.2317879063862,42.5393794010394,-88.2316343066773,42.5399284677255,-88.2316657065065,42.5402028670696,-88.2318515064412,42.5403628007036,-88.2321609065,42.5404312004405,-88.2334597730494,42.5403384002979,-88.2342021067412,42.5403376673504));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (71,'14768064',14768064,'15-OCT-99',3,'1574128','Silver Lake',2.07185375629,0,'07120006001642',390,39004,'071200061006',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1501125735358,42.5595322008513,-88.1517833736032,42.5596004009387,-88.1524021071709,42.559440200206,-88.1524329737022,42.5593486006583,-88.1533605740306,42.5583878009572,-88.1535769068481,42.5576558670256,-88.1538241736461,42.5571982676868,-88.1540407070124,42.55699240028,-88.1542261067488,42.5565348674911,-88.1543493066745,42.555414067606,-88.1544729067986,42.5550480669157,-88.1547203066962,42.5548878670823,-88.155153306879,42.5547048001873,-88.1562979738717,42.5547274010496,-88.1588655068371,42.5543834670243,-88.1602883737089,42.5541314670945,-88.1609689068889,42.5538796002642,-88.1618965737673,42.5532846672545,-88.1636593070307,42.5523234008052,-88.1647107071328,42.5517740670205,-88.1654529733754,42.5512020676222,-88.1656075065805,42.5509732675032,-88.165607306931,42.5507446004838,-88.1657001070736,42.5506758670985,-88.1657305068568,42.5499210670046,-88.1656683070461,42.5494408002536,-88.1654203738505,42.5489606009519,-88.1648633067956,42.5483890008526,-88.1641823068673,42.5477488004677,-88.1634395738766,42.5473602007136,-88.1623567064962,42.546926067385,-88.1619235066639,42.5466060004675,-88.1618925070329,42.5464230010216,-88.1627273072188,42.545988200396,-88.1629127735051,42.5457820676892,-88.162943373837,42.5452332006526,-88.1628195066143,42.5449358676971,-88.1617981735462,42.5441586007398,-88.1609317738816,42.5436328004143,-88.1603749739253,42.5434042008441,-88.1602511067026,42.5432898673344,-88.1579621738146,42.5430390671002,-88.1565701734741,42.5426964676687,-88.1553019738064,42.5427424670921,-88.1543125073157,42.5431774008173,-88.1536939068477,42.5435664007697,-88.1526115071147,42.5440926669439,-88.1509417736433,42.545419666985,-88.1499523071526,42.5462662006256,-88.1493647737647,42.5468152673117,-88.1489629072117,42.5471812671027,-88.1482207066197,42.5478904670723,-88.1475403739884,42.548416667596,-88.1472313066788,42.5489200010581,-88.1467983073953,42.5494004009087,-88.1453447736417,42.5504758003188,-88.1447261731737,42.5507046004379,-88.1437981735463,42.5508420006587,-88.1430249067734,42.5511852673871,-88.1426229071208,42.5515512671781,-88.1422517739995,42.5520544675405,-88.1421591069566,42.5526262672893,-88.142283107279,42.5530380003044,-88.1423449734411,42.5531066005901,-88.142530706826,42.5536554676266,-88.1426855071298,42.5540214674177,-88.1427165067607,42.5542958676611,-88.1431189066116,42.5549134006338,-88.1439235732137,
  42.5559424669722,-88.1444495731886,42.5564456007847,-88.146244506678,42.5577032010428,-88.1480085070863,42.5589150671775,-88.1482559735337,42.5590066001753,-88.1487509738777,42.5591664672596,-88.1501125735358,42.5595322008513));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (72,'14768074',14768074,'15-OCT-99',3,NULL,NULL,.02005713875,0,'07120006001649',390,39004,'071200061003',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2421979071071,42.5488610010353,-88.2418577070669,42.5489298675203,-88.2417651731236,42.5490672668418,-88.241829173377,42.5502108006888,-88.2420771731224,42.5504850003834,-88.2422939070375,42.5505762671819,-88.243221906665,42.5505752671358,-88.2435311070743,42.5505064006508,-88.2436855737296,42.5503232006561,-88.2436539733516,42.5500030671887,-88.243437107236,42.5498432010039,-88.2430963738979,42.549660466858,-88.2427245069298,42.5492720676527,-88.2421979071071,42.5488610010353));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (73,'19285181',19285181,'15-OCT-99',3,NULL,NULL,1.91641835799,0,NULL,466,46600,'071200060802',.7118,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2759261737533,42.5647340009743,-88.2762973734244,42.5647114675611,-88.2766685065457,42.5648032676576,-88.2775041071282,42.5646896005455,-88.278154307075,42.5644614668241,-88.278495106963,42.5641872671296,-88.2788669730318,42.5637530672512,-88.2793941736016,42.5629300670698,-88.2801065068092,42.5624732006786,-88.2805089066601,42.5623134675934,-88.2810349731848,42.5621994668329,-88.2825823071271,42.5620406672439,-88.2834485071422,42.5620870668656,-88.2838197068134,42.5621560007997,-88.2844693069123,42.5623622675055,-88.284685707179,42.5624082669289,-88.2854279068717,42.5627290002441,-88.2856443071384,42.5627976670796,-88.2875921730397,42.5637368668638,-88.2885201070167,42.5640806668902,-88.2894479735445,42.5642414674707,-88.2901595738047,42.5642420007686,-88.290716907059,42.5639908003361,-88.2911813736209,42.5636710005172,-88.2915845064192,42.5630080005197,-88.2921435735664,42.5613844670204,-88.292486106448,42.5596464669118,-88.2926105069687,42.5591892003222,-88.292734373292,42.5590062674262,-88.292827573633,42.5587776004068,-88.2931373729907,42.5583890006528,-88.2934783068777,42.5580004008987,-88.2938809738272,42.5576118676944,-88.294159773554,42.557223267041,-88.2944081069479,42.5566744674536,-88.2945939734325,42.5564002003099,-88.294594307081,42.55617146764,-88.2943779068143,42.5559882676453,-88.2933265067123,42.5557132010043,-88.2904807064188,42.555436667569,-88.2902023068903,42.5554364670202,-88.2898619737505,42.5554590669832,-88.2898311063199,42.5554362008209,-88.2889341063233,42.5553212009136,-88.2881301070182,42.5550918674966,-88.2873881735247,42.554656667572,-88.2869557731897,42.5541990007842,-88.2867401067699,42.5535126669769,-88.2865855735647,42.5533524005937,-88.2865549732328,42.553146600636,-88.2864007071263,42.552917800517,-88.2863389066146,42.552780466846,-88.2862463070208,42.5526660676858,-88.2862465066703,42.5525974008503,-88.2860303069525,42.5523000004456,-88.2859379070082,42.5520482676143,-88.2858453065151,42.5519110004932,-88.2857527734711,42.5516822003742,-88.2855673737347,42.551476200767,-88.2854749063412,42.5513160674834,-88.2850113067258,42.5509498005937,-88.2845167065801,42.5507664009496,-88.2834649071791,42.5508342008386,-88.2824745062928,42.5511078672352,-88.2808021737807,42.5522958671614,-88.2794399068256,42.5530722671723,-88.2792543065404,42.5530950676841,-88.2791303736672,42.5531864675823,-88.2771805733242,
  42.5537338003755,-88.2766545067994,42.5539620006467,-88.276158773508,42.5543276002394,-88.2758493068994,42.5545332005477,-88.2720707738465,42.5570914668986,-88.272008906785,42.5571600671843,-88.2717301070581,42.5573886002047,-88.2713271064601,42.5578456005949,-88.2708309738697,42.5585314002049,-88.2703029738026,42.5597660003016,-88.2703003738625,42.5614126670619,-88.2704233066896,42.5618702672999,-88.2707625066837,42.5625338671451,-88.2710097069318,42.5627628003638,-88.2711331730569,42.5629686668714,-88.271256706631,42.5630604004181,-88.2712875731623,42.5631976675392,-88.2718435736214,42.5637012672007,-88.2720597733392,42.5639302004193,-88.272925573156,42.5642510668342,-88.2750289066581,42.5646646668418,-88.2759261737533,42.5647340009743));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (74,'19285185',19285185,'15-OCT-99',3,NULL,NULL,2.38128439498,0,NULL,466,46600,'071200061003',.7653,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2319777730551,42.5597582004815,-88.2316989733283,42.5595754672349,-88.2313275065586,42.5594614008239,-88.2303987730843,42.5592106671395,-88.2294397063767,42.5591430668999,-88.2291921068296,42.5591204669369,-88.2272423739358,42.5587562675886,-88.2271493732443,42.5586648676904,-88.2269637064093,42.558619267566,-88.2264683733162,42.5584368005188,-88.2256629072168,42.557797066882,-88.2256627732178,42.5576826677218,-88.2255389068944,42.5576142005359,-88.2253839734909,42.5575000010251,-88.2253527067614,42.5572256007817,-88.2252289069878,42.5572028002699,-88.2251355735472,42.5569512670882,-88.2251041071682,42.556539600623,-88.2250419739073,42.5564252671133,-88.2250099733309,42.5557848670788,-88.2252553731363,42.5544810002988,-88.2252853070706,42.5538634007762,-88.2250369071269,42.5532688670655,-88.2247577072018,42.5528116670257,-88.2245409067368,42.5526288672294,-88.2245097731069,42.552583267105,-88.2243549737024,42.552446067433,-88.2235811070818,42.5521266003632,-88.2226835737873,42.5518756670293,-88.2223741737285,42.5518302674538,-88.2220027735086,42.5517162675926,-88.2216933069,42.5516478669564,-88.2208883066494,42.5511682675025,-88.2207335072449,42.5510998003164,-88.2197425065108,42.5503458671689,-88.2196493736191,42.5501630008227,-88.2190611072836,42.5497746007181,-88.2184111069864,42.5495692675086,-88.2180397733163,42.5495238004839,-88.2152869737142,42.5498006010178,-88.212131773362,42.5497802007965,-88.2114205067504,42.5499638009895,-88.2112349739143,42.550078201049,-88.2106167070947,42.5503532002409,-88.210215173291,42.5507194671306,-88.2094737730955,42.5515204671967,-88.2089491068152,42.5524130002607,-88.2088259068894,42.5528018671134,-88.208827106585,42.553671000717,-88.2087037070098,42.5538770003242,-88.208642107047,42.5541286009551,-88.2082405066934,42.5545176674573,-88.2079313071835,42.554700867452,-88.2076531073044,42.5547926009987,-88.2075603737117,42.5548612669348,-88.2070653068178,42.5548158673593,-88.2058279071315,42.5548624675297,-88.2056113737652,42.554931267465,-88.2048689069738,42.5549090002511,-88.2042499072068,42.5547264675533,-88.2036003071078,42.5548184007495,-88.2035077066147,42.5549784674832,-88.2035699064254,42.5552758004387,-88.2041273071289,42.5556414009308,-88.2040347731856,42.5558702010499,-88.2037255071258,42.5559846676592,-88.2035089072097,42.5559848007588,-88.2032923738433,42.555916401022,-88.2027045068069,
  42.5559626009941,-88.2023645064162,42.556123000477,-88.2021173736173,42.5564890677172,-88.2021797739768,42.5568778671208,-88.2022417732386,42.5569922006305,-88.2022729068685,42.5571294668523,-88.2023965735424,42.5571522008143,-88.2033263070628,42.5582722668526,-88.2034815066656,42.5587752675655,-88.2037291736618,42.5588208676898,-88.2039459066776,42.5589580673618,-88.2045339733635,42.5590720006732,-88.2052455070739,42.5589800009272,-88.2062347064659,42.5583616675578,-88.2063273735088,42.5582700671108,-88.2075945065806,42.557308601012,-88.2084911072781,42.5568962007,-88.2089237738124,42.5565300003601,-88.2091401731798,42.5564840009368,-88.209510973552,42.5560720008231,-88.2102525733969,42.5554996003272,-88.210283506478,42.5553624006552,-88.2104379065835,42.5552480005957,-88.2105307732759,42.5552250004343,-88.2109325067291,42.5549730670543,-88.2114273730742,42.5548584007955,-88.2132825071813,42.5541478671313,-88.2135299736287,42.5541020008076,-88.2136535737528,42.5540562010337,-88.2142103071593,42.5539412676763,-88.2156011734547,42.5531626004745,-88.2160959732499,42.5529792008304,-88.2167143731692,42.5528186007987,-88.2174569065104,42.5528180009509,-88.2178283732802,42.5529548669745,-88.2181071064572,42.5531376676701,-88.218107307006,42.5532062670565,-88.2185095737572,42.5533660675908,-88.2187575069527,42.5536402672854,-88.2187267069713,42.5537088675711,-88.2189745070672,42.5539374671413,-88.2193465736848,42.5544860670793,-88.219811306446,42.5548974007953,-88.2205233069045,42.5552398005772,-88.2210183737982,42.5553308677263,-88.2218543736798,42.555719067282,-88.2221331734066,42.5559476003024,-88.2222573068286,42.5561760676723,-88.222381173152,42.5562904002826,-88.2224435735114,42.556564800526,-88.2225985069149,42.5568162671579,-88.2225065071689,42.5573194675203,-88.2221053070137,42.5579146001796,-88.2212711066756,42.5586700010206,-88.2209621068151,42.5588532675652,-88.220560306812,42.559151000719,-88.2199423070912,42.5596546003804,-88.2194481736936,42.5602498004888,-88.219324907218,42.5605472008935,-88.2196697738403,42.5635202003978,-88.2196399064559,42.5641606669821,-88.2197951735078,42.5645722668975,-88.2198881732999,42.564663667695,-88.2199505071096,42.5649608675509,-88.220043373802,42.5650294669372,-88.2201987065044,42.5654182006903,-88.2202619072606,42.5662414670709,-88.2201699731651,42.5668820002051,-88.2199545063947,42.5675454669507,-88.2198927067823,42.5676370008478,-88.2198621064504,42.5678200002937,-88.2197385072257,42.5679802010264,
  -88.2195845064192,42.5683692009787,-88.2194299066642,42.5685294008121,-88.2191831731643,42.5690100003122,-88.2187199737472,42.5696736676066,-88.2180719069923,42.5708178004021,-88.2179797066975,42.5712294668673,-88.2181355070474,42.5719384671874,-88.218538506746,42.5724184002898,-88.2188793731839,42.5727154670461,-88.2193749068259,42.5729894670911,-88.2201797730774,42.5731718675885,-88.2203655064623,42.5731716670397,-88.2207057739517,42.5731714008404,-88.2208603737066,42.5730568676812,-88.2208909731393,42.572782400888,-88.2207667066176,42.5725080671945,-88.2207661067698,42.5721420674034,-88.2207041066086,42.5721192668915,-88.2207031731123,42.5714332001829,-88.2209501737109,42.5710898003549,-88.2212283070401,42.5708838007477,-88.2216613737727,42.5707918675516,-88.2229617736663,42.5712482006448,-88.2233335066354,42.5715224003394,-88.2234575069577,42.5716366007495,-88.2237675068643,42.571910800444,-88.2248825735713,42.5725960002061,-88.2263373735703,42.5728690676543,-88.2274209738982,42.5731882676254,-88.2276687065449,42.5733024005862,-88.2288761066463,42.5736214674577,-88.2292475734162,42.5736440674207,-88.2297111739309,42.5733234672052,-88.2301123731868,42.5727054674842,-88.2302357736614,42.5724538003035,-88.2306047735908,42.5711268668123,-88.2306657737059,42.5705550670636,-88.2307889070818,42.5701660671112,-88.2308807071782,42.5695484675886,-88.2310345065366,42.5690680002889,-88.2310957737503,42.568747667172,-88.2311883067943,42.5685646668268,-88.231402973168,42.5674436672923,-88.2314627735875,42.5662086004475,-88.2315545071341,42.5654994670277,-88.2320475064866,42.5642410672723,-88.232077907169,42.5639666004791,-88.2321701731144,42.5636920005863,-88.2322309735799,42.5630744676135,-88.2324765739341,42.5619992669535,-88.2325999069595,42.5616788672868,-88.2326607730756,42.5611300002502,-88.2325669072363,42.5604438004419,-88.2324427738143,42.5603296009313,-88.2323497731229,42.5601466671359,-88.232101573728,42.55984946728,-88.2319777730551,42.5597582004815));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (75,'14768070',14768070,'15-OCT-99',3,NULL,NULL,.03012658931,0,'07120006001648',390,39004,'071200061003',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2418035067258,42.5529556008212,-88.2425773067966,42.553183467444,-88.2428865737558,42.5532060008572,-88.2433195730392,42.5530912005993,-88.2435045069268,42.552793667095,-88.243503373781,42.5521532670605,-88.2432241064067,42.5517190006323,-88.2431613732981,42.5513072676172,-88.2430063733448,42.5511472674334,-88.2430061071455,42.5509642670881,-88.2417687731098,42.5509886009441,-88.2418035067258,42.5529556008212));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (76,'14783893',14783893,'15-OCT-99',3,'1566667','Hooker Lake',.41333409913,0,'07120004001483',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1015675732842,42.5624838009875,-88.1015987069142,42.5619348674011,-88.1015059733214,42.5618204673416,-88.1014751067901,42.5616374669964,-88.1016917067063,42.5612028669197,-88.1021871072485,42.5604940005986,-88.1026513067118,42.5600138003975,-88.1036725066802,42.5596022670319,-88.1041057074118,42.5592134676284,-88.1044461736514,42.5587104003656,-88.1051269739301,42.5582072674524,-88.105652973905,42.5580016005943,-88.1062409740411,42.5575898675792,-88.1071383067868,42.5572240674377,-88.1083141074095,42.5566066675646,-88.108437907183,42.5564466673807,-88.1084997733452,42.5562406668742,-88.1084069741019,42.5560350009155,-88.1078501732463,42.5556916676372,-88.1074791066748,42.5555544670659,-88.1069839732311,42.5555314669046,-88.1066747071714,42.5556458004143,-88.1061795737277,42.5559888009433,-88.1057463738954,42.5561032010028,-88.1030857736889,42.5562398673769,-88.1024669070215,42.5563540668876,-88.1024613734929,42.5563826671273,-88.1024359739404,42.5565142676203,-88.1020025735593,42.55685726725,-88.1016005073569,42.5570402010454,-88.1009815732403,42.557108667332,-88.0997751740844,42.5567882002161,-88.0990635738243,42.5568108676284,-88.0982899734029,42.5571080674843,-88.097763973428,42.557451067114,-88.0976401071046,42.5577254673573,-88.0976707739864,42.5580456673745,-88.097763574129,42.5582516004319,-88.0977325070489,42.5585490008366,-88.0972683066864,42.5589376671405,-88.0967729070434,42.559692267585,-88.0965251734973,42.5602640673338,-88.0959989073231,42.5608358005327,-88.0955965074722,42.5613160672836,-88.0955963069234,42.561819267646,-88.0964313733086,42.5625284676156,-88.0974523070777,42.5628260676698,-88.0990301073529,42.5631238008236,-88.0999585071787,42.5630552670878,-88.1011961739636,42.5626896009452,-88.1014127738798,42.5625294676617,-88.1015675732842,42.5624838009875));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (77,'14768052',14768052,'15-OCT-99',3,'1568037','Lilly Lake',.33039457414,0,'07120006001643',390,39004,'071200061006',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.2139723735256,42.5605972670512,-88.2119923739482,42.5606444670694,-88.2113737069304,42.5607364677147,-88.2094871064442,42.5612184009094,-88.2089615066675,42.5615160675134,-88.2087143738686,42.5617906674063,-88.2084675738188,42.562339867192,-88.208375373524,42.5627516002071,-88.2084381731825,42.563483401039,-88.2085311064248,42.5635290677132,-88.2085313069736,42.5636892009967,-88.2088105068987,42.5642380005842,-88.2089037072396,42.564489467216,-88.2089657065015,42.5645580009519,-88.2089657739507,42.5646494673999,-88.2093065738387,42.5650152009916,-88.2107929067666,42.5658146002645,-88.2116907071598,42.5661570009457,-88.2122783736474,42.5659736004022,-88.2143509737178,42.5656746675528,-88.2150005738168,42.5655368005838,-88.215618973736,42.5652390008801,-88.2161443738631,42.5648954670531,-88.2165149071366,42.5643004674935,-88.2167927068173,42.5637970674816,-88.2167909738237,42.5627220673704,-88.2164499068371,42.5622192006565,-88.2160471067879,42.5617850007781,-88.2151487730968,42.5610766668556,-88.2147771732273,42.5608710674467,-88.2139723735256,42.5605972670512));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (78,'19285183',19285183,'15-OCT-99',3,NULL,NULL,.38586517499,0,NULL,466,46600,'071200061006',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1501125735358,42.5595322008513,-88.1487509738777,42.5591664672596,-88.1482559735337,42.5590066001753,-88.1480085070863,42.5589150671775,-88.1479465734749,42.5590980675227,-88.1478851066117,42.5602416670203,-88.1476997068754,42.5605390674249,-88.1468025072293,42.5609052003156,-88.1456887733176,42.561340067491,-88.1443585734887,42.5616834007693,-88.1434615069423,42.5621866676815,-88.1427809072125,42.5626444010192,-88.1423787735609,42.5631018672583,-88.1423169073987,42.5632162673178,-88.1423171070482,42.5636278672332,-88.1424101068403,42.5638794669647,-88.1429053068338,42.5644054669397,-88.1435551065823,42.5646570010207,-88.1439263737025,42.5647254673074,-88.1446689070438,42.5646568004719,-88.1455043070775,42.5644050676407,-88.14627770695,42.5639932006266,-88.1473913068627,42.563260867396,-88.1482881072097,42.5622086668974,-88.1488449071661,42.5618654676181,-88.149247307017,42.5618882672306,-88.1498971067654,42.5620482008647,-88.1503923067589,42.5623682668829,-88.1506399737551,42.5626884669001,-88.1507023066655,42.5637862675231,-88.1507951733579,42.5639464008067,-88.1508573066188,42.5644266675575,-88.1510429734538,42.5645410001679,-88.1511977737576,42.5645408670683,-88.1516927732023,42.5646552005779,-88.1521259739339,42.5647008007023,-88.1527137735212,42.5645176672575,-88.1545699067751,42.5635794675193,-88.154848173204,42.5633506008505,-88.1553121073672,42.5627558009404,-88.1554975071036,42.562572867145,-88.1557139739201,42.5622296669665,-88.1558377071438,42.5620924007446,-88.1557445068029,42.5615206675457,-88.1554659067256,42.5611318672428,-88.1550635068747,42.5607430669399,-88.1539803732949,42.5603088670615,-88.1536089739743,42.5600116672056,-88.1524021071709,42.559440200206,-88.1517833736032,42.5596004009387,-88.1501125735358,42.5595322008513));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (79,'14783895',14783895,'15-OCT-99',3,NULL,NULL,.02587140835,0,'07120004001481',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0922231738597,42.5627332675272,-88.0939869737192,42.562688000152,-88.0943891739206,42.5625738006413,-88.09472970671,42.5623450670721,-88.0947609068897,42.5619334671567,-88.0946371071162,42.5618876673828,-88.0945755071533,42.5613616008581,-88.0942969070759,42.5611556669014,-88.0936161733471,42.5612470002498,-88.0927497071326,42.5617498669637,-88.0924711070553,42.5620700669809,-88.0922543065903,42.5624588672838,-88.0922231738597,42.5627332675272));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (80,'19285001',19285001,'15-OCT-99',3,NULL,NULL,.35748339226,0,NULL,466,46600,'071200060802',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.3028335737098,42.5746112675968,-88.3013171062988,42.574679000936,-88.3000171066035,42.5749754669451,-88.2987167732599,42.5754092009748,-88.2975093731584,42.5759574007144,-88.2951247065394,42.5773052668255,-88.2950317067472,42.5774880675212,-88.2946907063104,42.5779224670491,-88.2945045736265,42.5782882671907,-88.2944423063667,42.5785856001463,-88.2945031733821,42.579363200752,-88.2945651069934,42.5794090005259,-88.2946267735061,42.5796148670334,-88.2947813067113,42.5798208675399,-88.2950903731216,42.580072666921,-88.2952449063267,42.5802786008776,-88.2957705070027,42.5806906009914,-88.2961417066738,42.580873800986,-88.2969151730961,42.5809886668944,-88.2971317730123,42.581080400441,-88.2973793069089,42.5810576673783,-88.2982155064398,42.5806694003734,-88.3005693730775,42.5790470009193,-88.3024893734852,42.5779732005037,-88.3034181735093,42.5775392002748,-88.3044713066049,42.5768078670903,-88.3047191732506,42.5764878676219,-88.304874106654,42.5763050003764,-88.3051839734609,42.5759164006223,-88.3051533065792,42.5756418672793,-88.3044731735974,42.5750010670465,-88.3038855071098,42.5747492002163,-88.3028335737098,42.5746112675968));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (81,'19285003',19285003,'15-OCT-99',3,NULL,NULL,.54924329448,0,NULL,466,46600,'071200061006',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.181250973453,42.5742274675245,-88.1812817068846,42.5739760008926,-88.1810647067701,42.5735872005898,-88.1810335731403,42.5733584670206,-88.1807853737454,42.5727182009851,-88.1807233070343,42.5724894674159,-88.1805993732618,42.572329467232,-88.1805373065508,42.5721236672744,-88.1804135067773,42.5719864676023,-88.1802271735446,42.5714604001782,-88.1798555736751,42.5710718004241,-88.179422173294,42.5709804670758,-88.1782463735706,42.571049800309,-88.1774729071483,42.571256000465,-88.1769473739215,42.5718052002507,-88.1766075731803,42.5724456668349,-88.1762365066089,42.5728576003988,-88.175092506913,42.573978867032,-88.1749071737265,42.5744592668826,-88.1749695066368,42.5749624006951,-88.1752483072629,42.5752824676127,-88.175310373974,42.5754654670586,-88.175372306686,42.5755570009557,-88.1755277068376,42.5762202006027,-88.1754349066949,42.5763802673364,-88.1751875733472,42.5767006004533,-88.1739811732918,42.5773872670097,-88.1736407736022,42.577547600842,-88.1733623066245,42.5775934671657,-88.1733005070121,42.5776620674513,-88.1714437739104,42.5779830669659,-88.1710105731788,42.578051866901,-88.1702681738365,42.5784868006263,-88.1702685065857,42.5789670008273,-88.1705473072118,42.5793558002309,-88.1706401739042,42.5794242674169,-88.1711667071772,42.5798358007825,-88.171414373274,42.5799730004545,-88.1724669065219,42.5803384669476,-88.1731481069989,42.5804754004203,-88.1738911070883,42.5807266674027,-88.1739219736195,42.5807724006267,-88.1741077070045,42.580818000751,-88.1746341071777,42.5810464672216,-88.174974773966,42.5812980004033,-88.1752843736743,42.5814350669756,-88.1757797733172,42.5817550007936,-88.1763371065716,42.5819378005899,-88.1777297733097,42.5818686004565,-88.1784413735699,42.5816852008123,-88.1787507070788,42.5813418675341,-88.1787813739606,42.5810904009022,-88.1789047735358,42.5807244002118,-88.1789031070921,42.5787802673963,-88.1789645065061,42.5781626669744,-88.1793043737972,42.577545000902,-88.1794281070209,42.577453400455,-88.1794279739212,42.5773848001693,-88.1796135067573,42.577224600336,-88.1799843071294,42.5765610670405,-88.1801699065153,42.5763780001455,-88.1801697068659,42.5762864671477,-88.1804479732947,42.5760348674161,-88.1806643070115,42.5756916672375,-88.1807881067851,42.5756458009139,-88.1808497732978,42.5754628005687,-88.1809735065215,42.5753026672852,-88.181250973453,42.5742274675245));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (82,'14783883',14783883,'15-OCT-99',3,'1570988','Paddock Lake',.48116263893,0,'07120004001478',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1011909066344,42.5779228006976,-88.102490907229,42.5773512671482,-88.1028933736296,42.5769624002954,-88.1029863068719,42.5766878669524,-88.1029555068905,42.5761390008151,-88.1027699740544,42.5757958006366,-88.102801106785,42.5752468670502,-88.1036371066665,42.5741034006523,-88.1042871069638,42.5735546676147,-88.1048751070999,42.5732116005358,-88.1057417738631,42.5728916001681,-88.1060511739219,42.5726628674983,-88.1061751067951,42.5724342004789,-88.1061753073439,42.5718166009563,-88.1060205735899,42.5716106669996,-88.104535173259,42.5714962003902,-88.1039473736717,42.5711986668859,-88.10354530657,42.5707640668091,-88.1032049734301,42.570169266899,-88.1031123072865,42.5695746009879,-88.102833773759,42.5694144677044,-88.101998506825,42.5692312668104,-88.0987183070037,42.5694136673078,-88.0982849740716,42.5695278668185,-88.0978825733214,42.5698252006734,-88.0973563071472,42.5703054008745,-88.0972325073737,42.5705568675064,-88.0974179071101,42.571266067476,-88.0976343073767,42.5715634004315,-88.0976339737283,42.5723410675871,-88.0975101739547,42.572524067033,-88.0967049066055,42.5739878008972,-88.096735706587,42.5744452671363,-88.0969831073838,42.5748112003775,-88.0972305738313,42.575017200884,-88.0973233739739,42.5751772676177,-88.0977255067261,42.5755662010203,-88.0981277069275,42.5760008676468,-88.0985297740292,42.5763440003762,-88.0985915070917,42.5770302001845,-88.0985911068934,42.577899400338,-88.0986839735859,42.5779680671735,-88.098683907036,42.5780596001713,-88.0988385733409,42.5781738671312,-88.0998601069577,42.57817406768,-88.1011909066344,42.5779228006976));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (83,'14783885',14783885,'15-OCT-99',3,NULL,NULL,.02765846711,0,'07120004001479',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1060829739495,42.5699640002393,-88.1056187070371,42.5700096003637,-88.105216373736,42.5701696670974,-88.1051545066745,42.5704898671146,-88.1053091073288,42.5707414668461,-88.1055875068573,42.5709474008028,-88.1060207732394,42.5710390003505,-88.1078773732415,42.5710392008993,-88.1082179069302,42.5709248673896,-88.1084963739079,42.5706276009839,-88.1084037068649,42.5703760003531,-88.1080941737065,42.570147200234,-88.1072279071416,42.5699870004007,-88.1060829739495,42.5699640002393));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (84,'14768038',14768038,'15-OCT-99',3,NULL,NULL,.05645809348,0,'07120006001633',390,39004,'071200061006',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1308707734668,42.5799600673042,-88.1308399069355,42.5802802673214,-88.1309019070967,42.5806462671125,-88.1309947737892,42.5807148673981,-88.1312113737053,42.5811722670874,-88.1314281067211,42.5814696009422,-88.13176857386,42.5817670004476,-88.1321709737109,42.581995667467,-88.1326043066428,42.5820642668534,-88.1333161065525,42.5819268675318,-88.1338421739765,42.5814922674551,-88.1340277733624,42.5812178006619,-88.1341207066047,42.58119500015,-88.1342445072776,42.580920466807,-88.134275307259,42.5806460009131,-88.1342753738088,42.5805088003418,-88.1337799732665,42.5801200009382,-88.1332539067417,42.5798684668572,-88.1321707066122,42.5795940675131,-88.1315517068451,42.5795712670013,-88.1311183073634,42.5797314002848,-88.1308707734668,42.5799600673042));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (85,'14768028',14768028,'15-OCT-99',3,NULL,NULL,.02605379327,0,'07120006001634',390,39004,'071200061006',.586,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1870475734861,42.5836934669808,-88.1863047739455,42.5837166667916,-88.1859025737442,42.583968467072,-88.1857791067197,42.5841744001294,-88.185810506549,42.5846546668803,-88.1859655739514,42.5850206001215,-88.1859665065484,42.5858440005011,-88.1859665065484,42.5859812676223,-88.1860285067096,42.5860498670087,-88.1860595737896,42.586232800804,-88.1862765739041,42.5863928009879,-88.1865549734326,42.586255400767,-88.1866787066563,42.5861866673817,-88.1868021736807,42.5859122005885,-88.1868943065264,42.5851802010064,-88.1871105071435,42.5847684005421,-88.1871723067559,42.5846998002565,-88.1872033072862,42.5846082672587,-88.1873269065109,42.5844710001375,-88.1873883068243,42.5840134673485,-88.1872023072401,42.5837162674927,-88.1870475734861,42.5836934669808));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (86,'19284999',19284999,'15-OCT-99',3,NULL,NULL,.35920809931,0,NULL,466,46600,'071200061006',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1836739071245,42.5837410671974,-88.1829621072148,42.5837870675201,-88.1822815065856,42.5840162003882,-88.1806109070671,42.584840466815,-88.1795897736485,42.5852070008033,-88.1785065735189,42.5853904669974,-88.1770519066196,42.5853912008441,-88.1746993071267,42.5851178006469,-88.173151706985,42.5850728003704,-88.1720687065049,42.5854620674214,-88.1718211735077,42.5857594669268,-88.1716665072029,42.5858282003121,-88.1716665737528,42.5859424672719,-88.1712027070387,42.5864002006097,-88.1711717739576,42.5865146006692,-88.1708007739359,42.5869492672958,-88.1706769732631,42.5870408002936,-88.170398773384,42.5874068675338,-88.1702131739981,42.5876584672654,-88.1700275737129,42.5877958674862,-88.1699347735703,42.5880018005436,-88.1697801738154,42.5882076670511,-88.1696257737099,42.5886422671279,-88.1695023066854,42.5890310674307,-88.1694403739734,42.589054067592,-88.1693785734618,42.5892142008756,-88.1695023732353,42.5892598675497,-88.1701217066508,42.5893968675723,-88.1713599067336,42.5893734672126,-88.1725359070059,42.5891900675685,-88.1740835071475,42.5889148003786,-88.1756619072706,42.5887082674735,-88.1780143071139,42.5886614002044,-88.1786641068624,42.5884324004359,-88.1801489738954,42.5875168006608,-88.1803653732627,42.5872880005417,-88.1811381732874,42.5861210006846,-88.1815711734702,42.5858234671801,-88.1821281739754,42.5856172670241,-88.1827467735441,42.5851824007481,-88.183736706783,42.5846330004135,-88.1839221065193,42.5843584005207,-88.1839215732214,42.5838552676074,-88.1836739071245,42.5837410671974));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (87,'19285175',19285175,'15-OCT-99',3,NULL,NULL,.81957872041,0,NULL,466,46600,'071200061003',1,NULL,NULL,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1752345071661,42.5957988003752,-88.1752037071847,42.5960732671684,-88.1757305732067,42.5967592007774,-88.1761335072549,42.597353667039,-88.1763813739007,42.5976280007325,-88.1766291739966,42.5977652004046,-88.1771865738007,42.5978792668156,-88.1779295738901,42.5979018002288,-88.1790749072805,42.5978096673832,-88.1815511734472,42.5973738676108,-88.1823247738686,42.5970762001074,-88.1826651735583,42.5969844674601,-88.1827271071696,42.5969388007859,-88.1834699067102,42.5968698003019,-88.1858537072821,42.5967998006712,-88.1872467067695,42.5966846676642,-88.1891037069699,42.5963634001517,-88.1897225736372,42.5960886006093,-88.1917023070152,42.5946692671739,-88.192135706497,42.5946462004627,-88.1921609738492,42.5896142669857,-88.192251506801,42.5874414671509,-88.1923441072941,42.5871898008695,-88.1931173066178,42.5865718002493,-88.1932409067418,42.5864344009278,-88.1925593069658,42.5858402008655,-88.192497173705,42.5856572670701,-88.1923733064823,42.585565867172,-88.1914439731602,42.584903066824,-88.1908247071938,42.5846748009022,-88.1903295072004,42.5846064002661,-88.1889985735247,42.5847444003347,-88.1885653736924,42.5848362004312,-88.1883489734257,42.5850422009377,-88.1878545738289,42.585797267231,-88.1876389065097,42.5867808008941,-88.1876395738066,42.5874212674784,-88.1877639068782,42.5879700670658,-88.1876713072843,42.5881302668992,-88.1877953067074,42.5883360668569,-88.187703973359,42.5898684675566,-88.187580373235,42.590074400614,-88.1874879732907,42.5905090672406,-88.1872099065113,42.5910124007027,-88.1869007070014,42.5913328003693,-88.1863127734151,42.5916306009723,-88.1854151735708,42.5917682673925,-88.1851059066117,42.5919514008374,-88.1847657065715,42.5922718005041,-88.1840849737419,42.592661000106,-88.1836211070278,42.5931414674057,-88.1814249068333,42.5948122674731,-88.1806823069423,42.5951786674624,-88.1804657070261,42.5952474008478,-88.1802491071099,42.5953848001693,-88.1799395739515,42.5954992667786,-88.1788561732731,42.5956598668103,-88.1777727069442,42.5956374673961,-88.1771843066098,42.5954090674754,-88.1765651737431,42.595295000165,-88.1754197738029,42.5954328005842,-88.1752345071661,42.5957988003752));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (88,'14783875',14783875,'15-OCT-99',3,'1567916','League Lake',.06098230418,0,'07120004001474',390,39004,'071200040101',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.1039121067577,42.5854024675508,-88.1029525067522,42.5854480676751,-88.1023643735164,42.5856538001836,-88.1007855740943,42.5864312667904,-88.1005377074486,42.5868200005435,-88.1005067069183,42.587300400394,-88.1006303070424,42.5875748006375,-88.100939773651,42.5878950672045,-88.1014659067256,42.5880324008755,-88.1018683065764,42.5879638671396,-88.1030447735968,42.5874380668142,-88.1042521736982,42.5865232674357,-88.1045307737755,42.5861574672942,-88.104530973425,42.5857228672174,-88.1043763071202,42.5855626673841,-88.1039121067577,42.5854024675508));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (89,'14784243',14784243,'22-OCT-99',3,NULL,NULL,.02262435557,0,'07120004001498',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.9022801074404,42.4945564672081,-87.9016619071706,42.4947626008143,-87.9009513069566,42.4951974005405,-87.9007969743003,42.4955176005577,-87.9007973735993,42.4965012007707,-87.9009211077223,42.4966612675044,-87.9013229077254,42.4966612009546,-87.902002573959,42.495951866986,-87.902342307251,42.4955172003594,-87.9027439741544,42.4951740010802,-87.9027747741359,42.494853801063,-87.9024655071768,42.4945794008196,-87.9022801074404,42.4945564672081));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (90,'14784245',14784245,'22-OCT-99',3,NULL,NULL,.01506784006,0,'07120004001496',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.8825913074422,42.4947434002886,-87.8822203739704,42.4949492011456,-87.882034974234,42.4952008008772,-87.8820659738649,42.4959556675209,-87.8821587740076,42.4960700010306,-87.8827151072158,42.4961156677048,-87.8830861072374,42.4960242003575,-87.8835187072219,42.4956810010783,-87.8836421742463,42.4954980672829,-87.883642307346,42.4952236004897,-87.8832713073243,42.4949948678198,-87.8825913074422,42.4947434002886));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (91,'14784241',14784241,'22-OCT-99',3,NULL,NULL,.02051422319,0,'07120004001495',390,39004,'071200040104',1,'22-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-87.88410617406,42.4970076009209,-87.8834881077893,42.4973966008733,-87.8831481073986,42.4976940003787,-87.8831173074171,42.4979226673981,-87.8832101075598,42.4980142003959,-87.8841373742398,42.4981056002941,-87.8848173741219,42.498265600478,-87.8851885072432,42.4982884675397,-87.8854665740225,42.4981510673188,-87.8856827737404,42.4978080011393,-87.8856827071905,42.4975336008958,-87.885466374373,42.4973734676124,-87.884384373939,42.4970304670833,-87.88410617406,42.4970076009209));
     str_sql := 
  q'[Insert into NHDPLUS21_NHDWATERBODY_55059(objectid,permanent_identifier,nhdplus_comid,fdate,resolution,gnis_id,gnis_name,areasqkm,elevation,reachcode,ftype,fcode,wbd_huc12,wbd_huc12_percent,reachsmdate,nhdreach_cac,shape) Values (92,'14784747',14784747,'15-OCT-99',3,NULL,NULL,.03441223324,0,'07120004001504',390,39004,'071200040201',1,'15-OCT-99',1,:p01)]';
     EXECUTE IMMEDIATE str_sql USING
  MDSYS.SDO_GEOMETRY(2003,8265,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-88.0465847069181,42.4960184006296,-88.0460897740232,42.4963382669984,-88.0460889070768,42.49707020093,-88.0455935739836,42.4976874677034,-88.0455005067424,42.4980534009446,-88.0455621067052,42.4982364003905,-88.0459947066897,42.4983510009988,-88.0465203073657,42.4982140675261,-88.0478501069962,42.4976432003743,-88.0478823737719,42.4964080004298,-88.0470173734524,42.4960414673408,-88.0465847069181,42.4960184006296));
  
  END load_np21_waterbody_55059;
  /
  
  GRANT EXECUTE ON load_np21_waterbody_55059 TO public;
  
  