CREATE TABLE parcel (pid INTEGER PRIMARY KEY, groundplan POLYGON, firstname VARCHAR, lastname VARCHAR);
insert into parcel values (1, '((1022736,1075525),(1027862,1080007),(1026960,1073399),(1039123,1067376),(1037880,1065051),(1029660,1049663),(1027464,1045552),(1022411,1036092),(1005921,1044901),(1011271,1054645),(1013067,1057916),(1018617,1068023))','Kenya','Sloane');
insert into parcel values (2, '((1065244,1030290),(1054154,1051095),(1052881,1052619),(1041616,1066111),(1039628,1068546),(1034672,1074614),(1029435,1081026),(1063453,1102233),(1070665,1105804),(1083317,1108828),(1095007,1110223),(1096284,1107533),(1102532,1110187),(1108996,1106440),(1110682,1102225),(1110975,1100761),(1111812,1096587),(1117941,1082575),(1115611,1078556),(1121962,1056109),(1126894,1055610),(1126681,1053274),(1126099,1046869),(1125865,1043477),(1125605,1039703),(1125914,1037976),(1122307,1036698),(1091623,1025610),(1093053,1022412),(1068954,1023329))','Julio','Kerfien');
insert into parcel values (3, '((1184261,772108),(1191405,746718),(1153396,736819),(1148829,755168),(1152152,761175))','Jessie','Mceachin');
insert into parcel values (4, '((1078590,1004578),(1068954,1023329),(1093053,1022412),(1091642,1016718),(1089507,1016409),(1089625,1015389),(1090362,1009034),(1090750,1005689))','Karen','Najera');
insert into parcel values (5, '((1116474,1005538),(1090750,1005689),(1090362,1009034),(1089625,1015389),(1089507,1016409),(1091642,1016718),(1115076,1018035),(1129238,1004293))','Jesse','Mize');
insert into parcel values (6, '((1083266,718421),(1105787,733624),(1139042,756210),(1148342,720222),(1155598,691688))','Elnora','Kring');
insert into parcel values (7, '((1110670,1154336),(1111460,1150374),(1117351,1123650),(1116859,1117564),(1108099,1122893),(1107530,1122806),(1102962,1122112),(1097271,1122095),(1091274,1121928),(1085273,1121050),(1079523,1119511),(1073769,1117567),(1069141,1116884),(1063264,1119760),(1045102,1150193),(1038102,1161923),(1036460,1164693),(1029960,1175654),(1028139,1178726),(986374,1249198),(992656,1254742),(1082913,1276994),(1127727,1195283),(1129345,1193903),(1130874,1190810),(1135314,1181828),(1144412,1163421),(1143590,1161954))','Wayne','Gilbertson');
insert into parcel values (8, '((1073459,919420),(1060653,919814),(1054095,920016),(1030449,924660),(1020417,942559),(1018742,945457),(1018174,946041),(1060727,938145),(1074042,930324),(1089664,921148),(1076253,919581))','Douglas','Sadler');
insert into parcel values (9, '((1150890,811051),(1159092,812817),(1167307,788818),(1169506,782395),(1171066,777835),(1149207,770396),(1144620,773011),(1135954,807834))','Natalie','Kendall');
insert into parcel values (10, '((1011548,1156753),(1021721,1167196),(1034002,1147131),(1029619,1144464),(1020315,1138804),(1004681,1129293),(994979,1138535),(994575,1138943))','Tonya','Gillespie');
insert into parcel values (11, '((1107604,828337),(1113334,829552),(1119858,830936),(1123311,816936),(1131140,786655),(1130126,786042),(1125918,783185),(1118190,784276),(1106200,789869),(1099815,792846),(1103306,797122),(1095283,810092),(1089948,824593))','Annette','Fielding');
insert into parcel values (12, '((1086044,836764),(1085209,842802),(1085853,847830),(1086002,848795),(1086229,850162),(1086844,853867),(1089088,867386),(1098036,865322),(1107500,863139),(1114263,861580),(1113814,859243),(1119858,830936),(1113334,829552),(1107604,828337),(1089948,824593),(1089177,827180))','Anita','Cavazos');
insert into parcel values (13, '((1122189,1211737),(1085916,1277734),(1233804,1314194),(1238553,1309548),(1229766,1248228),(1225617,1219276),(1220731,1185175),(1216149,1153203),(1209902,1109602),(1202397,1103507),(1191445,1098854),(1180688,1113705),(1173802,1123212),(1165736,1134169),(1154538,1149530),(1144412,1163421),(1135314,1181828),(1130874,1190810),(1129345,1193903),(1131384,1195007))','June','Bixby');
insert into parcel values (14, '((874657,925397),(888707,918834),(899385,912931),(902751,919042),(919784,909080),(919153,907939),(909348,889870),(853997,915508),(838729,922580),(846351,938619),(874513,925464))','Cynthia','Bevins');
insert into parcel values (15, '((1297951,750261),(1288395,766546),(1284872,772550),(1307317,785699),(1327870,757275))','Rachel','Hoppe');
insert into parcel values (16, '((530084,2003203),(532608,2003470),(537267,1995053),(536545,1992516),(530835,1988678),(523462,2000286))','Jonathan','Norris');
insert into parcel values (17, '((1101730,914639),(1091313,914646),(1088873,914648),(1088303,917743),(1081954,917011),(1082393,913537),(1077395,912681),(1076253,919581),(1089664,921148),(1092490,926691),(1098553,922193),(1105322,919270),(1111676,918581),(1123358,920294),(1127311,923607),(1122530,910088),(1115560,912298),(1110632,912079),(1109636,911587))','Bobby','Tennyson');
insert into parcel values (18, '((1002909,960746),(1005516,966150),(1008128,964891),(1005521,959486))','Tony','Mancini');
insert into parcel values (19, '((861899,970599),(889831,957857),(935324,937352),(926587,921421),(922005,913149),(905032,923183),(902751,919042),(899385,912931),(888707,918834),(874657,925397),(874513,925464),(846351,938619),(838729,922580),(787856,945959),(697269,988328),(710741,1040093),(857887,972444))','Vincent','Haupt');
insert into parcel values (20, '((1077210,964757),(1094862,959101),(1094025,945989),(1089317,933229),(1092490,926691),(1069482,940452))','Charles','Sherlock');
insert into parcel values (21, '((1186250,795171),(1178744,817049),(1180422,817490),(1190770,820210),(1202035,823266),(1209013,802513),(1211034,796504),(1212564,791955),(1189990,784274),(1188340,789083))','Erma','Eldredge');
insert into parcel values (22, '((1227162,1145246),(1228455,1153497),(1236629,1205645),(1278721,1217724),(1274264,1188142),(1267238,1141503),(1264081,1120543),(1225397,1109154),(1221906,1111712))','Vincent','Dahlberg');
insert into parcel values (23, '((1147976,841449),(1150890,811051),(1135954,807834),(1127915,839361))','Clarence','Jorgenson');
insert into parcel values (24, '((1071265,977747),(1073068,1000827),(1074999,1001186),(1097826,1000724),(1097500,996374),(1096899,988377),(1096540,983597),(1095702,970942),(1094837,971093),(1070889,972925))','Kathleen','Pelletier');
insert into parcel values (25, '((1120535,959559),(1136975,949937),(1139266,948824),(1136788,942366),(1132553,944755),(1126914,947935),(1121926,950720),(1114087,955278),(1094862,959101),(1095702,970942),(1096540,983597),(1117446,978303),(1117549,977541))','Ramona','Streeter');
insert into parcel values (26, '((1171066,777835),(1169506,782395),(1167307,788818),(1159092,812817),(1170219,815213),(1178744,817049),(1186250,795171),(1188340,789083),(1189990,784274))','Albert','Chaney');
insert into parcel values (27, '((1098128,898332),(1102758,896621),(1106170,894652),(1105362,892974),(1117880,888091),(1119065,887525),(1114263,861580),(1107500,863139),(1098036,865322),(1089088,867386),(1090480,876325),(1092558,887361),(1095769,904416),(1101730,914639))','Billy','Hale');
insert into parcel values (28, '((1122879,860043),(1124271,865989),(1129223,890887),(1132344,906435),(1134194,912333),(1136685,911774),(1158919,906782),(1166294,905400),(1174233,903159),(1178729,898463),(1187571,888664),(1195235,870737),(1185380,860177),(1174970,849158),(1126668,844633))','Joseph','Redd');
insert into parcel values (29, '((1002909,960746),(1000297,962006),(1002903,967410),(1005516,966150))','William','Dorsett');
insert into parcel values (30, '((1211034,796504),(1209013,802513),(1202035,823266),(1219544,827725),(1230123,796313),(1218144,793711),(1212564,791955))','Blanca','Peden');
insert into parcel values (31, '((1010740,963631),(1013352,962371),(1010745,956967),(1008133,958227))','Marvin','Packard');
insert into parcel values (32, '((1118190,784276),(1125918,783185),(1130056,761323),(1112060,749431),(1071385,763083),(1040610,773412),(1039645,773736),(1028775,777384),(1026872,827991),(1037726,825151),(1093985,810431),(1095283,810092),(1103306,797122),(1099815,792846),(1106200,789869))','Chad','Lowe');
insert into parcel values (33, '((856122,813647),(673672,897658),(686013,945081),(697269,988328),(787856,945959),(838729,922580),(853997,915508),(909348,889870),(889588,854181),(887363,852205),(881711,847786),(874425,837234))','Edward','Alcantar');
insert into parcel values (34, '((890161,831808),(895159,841165),(898349,847118),(928382,903157),(929963,906047),(955140,952064),(964492,969156),(969930,969878),(981641,964375),(1012574,949841),(1018174,946041),(1018742,945457),(1020417,942559),(1030449,924660),(1054095,920016),(1054107,916564),(1056698,902155),(1047506,900501),(1024230,901135),(1024236,899359),(1026872,827991),(1028775,777384),(997465,787807),(986039,791610),(892376,823083),(888292,828400))','Nicholas','Raley');
insert into parcel values (35, '((1187528,1067323),(1194816,1083508),(1198431,1087669),(1206750,1090190),(1215535,1063834),(1201955,1052051),(1188933,1066035))');
insert into parcel values (36, '((1315913,894949),(1272073,958415),(1270886,960134),(1260876,974633),(1256313,981242),(1255978,981728),(1249424,981870),(1242003,978119),(1224911,970362),(1212017,964511),(1188143,953676),(1185284,952379),(1184686,953199),(1184225,952960),(1181467,964479),(1179900,971025),(1173611,968323),(1173116,969294),(1173329,970002),(1178585,982562),(1180191,992180),(1176690,999992),(1177462,1000691),(1193031,1013005),(1178034,1045892),(1187528,1067323),(1188933,1066035),(1201955,1052051),(1215535,1063834),(1206750,1090190),(1284409,1112287),(1287398,1111636),(1291005,1107830),(1295480,1101626),(1296454,1100276),(1296835,1099452),(1300393,1091756),(1314068,1046670),(1317297,1035990),(1351772,921985))','Opal','Dugas');
insert into parcel values (37, '((1262638,757034),(1262209,758828),(1260255,767138),(1259350,768258),(1243724,789839),(1256674,801177),(1279286,811095),(1283575,807210),(1293771,800342),(1294170,800077),(1296725,797859),(1301459,793747),(1307317,785699),(1284872,772550),(1288395,766546),(1297951,750261),(1327870,757275),(1337059,744235),(1338637,738616),(1364153,647708),(1310966,632227),(1282644,623872),(1258223,717944),(1271215,721212))','Louis','Callaway');
insert into parcel values (38, '((1234545,830348),(1232729,832821),(1235200,834675),(1247105,843609),(1264401,820202),(1250436,808706),(1239467,823645),(1236253,828022))','Jo','Everson');
insert into parcel values (39, '((1268839,859760),(1272770,862629),(1274861,859816),(1278108,855448),(1286074,844733),(1271221,828004),(1254899,849589))','Brian','Moseley');
insert into parcel values (40, '((1254965,660064),(1244645,700208),(1207961,689554),(1204647,700998),(1197641,725187),(1194837,734868),(1191405,746718),(1184261,772108),(1185210,772419),(1190294,774086),(1206188,779295),(1211017,766720),(1226032,772359),(1233017,745645),(1241478,713286),(1257614,717789),(1258223,717944),(1282644,623872),(1266306,619165))','Elizabeth','Amaro');
insert into parcel values (41, '((1008133,958227),(1005521,959486),(1008128,964891),(1010740,963631))','Adrienne','Mora');
insert into parcel values (42, '((1287162,873537),(1299300,855590),(1295078,852510),(1286074,844733),(1278108,855448),(1274861,859816),(1272770,862629),(1276844,865717))','Peter','Rabinowitz');
insert into parcel values (43, '((1088303,917743),(1088873,914648),(1082393,913537),(1081954,917011))','Louise','Farina');
insert into parcel values (44, '((1243724,789839),(1259350,768258),(1260255,767138),(1262209,758828),(1262638,757034),(1271215,721212),(1258223,717944),(1257614,717789),(1241478,713286),(1233017,745645),(1226032,772359),(1224712,777410),(1223852,780697),(1223017,784956),(1239778,786468))','Antonio','Lussier');
insert into parcel values (45, '((1098128,898332),(1101730,914639),(1105964,909881),(1109636,911587),(1122593,906585),(1121426,900281),(1120879,897325),(1119065,887525),(1117880,888091),(1105362,892974),(1106170,894652),(1102758,896621))','James','Strom');
insert into parcel values (46, '((1154247,942465),(1154981,942897),(1163581,947966),(1166012,943735),(1166420,943024),(1167196,941674),(1171904,944747),(1187997,916421),(1174233,903159),(1166294,905400),(1158919,906782),(1161132,930751))','Maxine','Christman');
insert into parcel values (47, '((1150890,811051),(1147976,841449),(1167581,843281),(1170125,816216),(1170219,815213),(1159092,812817))','Gerald','Hertz');
insert into parcel values (48, '((1134194,912333),(1144819,936914),(1145793,937560),(1154247,942465),(1161132,930751),(1158919,906782),(1136685,911774))','Gary','Borst');
insert into parcel values (49, '((1036664,977837),(1051586,973092),(1054927,972030),(1052688,965198),(1052127,963486),(1046844,947369),(1021060,951992),(1032266,966039))','Carl','Penley');
insert into parcel values (50, '((1051586,973092),(1036664,977837),(1042780,994923),(1059397,998360),(1073068,1000827),(1071265,977747),(1070889,972925),(1070342,966979),(1066706,968171),(1061650,969827),(1054927,972030))','Nancy','Burton');
insert into parcel values (51, '((1325787,865459),(1320932,871122),(1306427,888040),(1292655,877700),(1287162,873537),(1276844,865717),(1272770,862629),(1268839,859760),(1254899,849589),(1253483,848363),(1248031,844299),(1247105,843609),(1235200,834675),(1232729,832821),(1229983,830997),(1229032,830365),(1203513,851900),(1201381,856751),(1198422,863485),(1195235,870737),(1187571,888664),(1178729,898463),(1174233,903159),(1187997,916421),(1171904,944747),(1175940,945508),(1177092,944325),(1181211,944470),(1182707,946073),(1183748,951538),(1185284,952379),(1188143,953676),(1212017,964511),(1224911,970362),(1242003,978119),(1249424,981870),(1255978,981728),(1256313,981242),(1260876,974633),(1270886,960134),(1272073,958415),(1315913,894949),(1351772,921985),(1357457,903607),(1361034,892042))','Jonathan','Fifield');
insert into parcel values (52, '((1065244,1030290),(1068954,1023329),(1078590,1004578),(1074840,1004235),(1039519,998575),(1036826,998163),(1037324,1003194),(1038996,1012716),(1040279,1020022),(1040841,1023222),(1043060,1031763),(1053697,1050383),(1054154,1051095))','Nathan','Dover');
insert into parcel values (53, '((1234545,830348),(1236253,828022),(1239467,823645),(1250436,808706),(1237077,797873),(1230123,796313),(1219544,827725),(1226787,829740),(1229032,830365),(1229983,830997),(1232729,832821))','Todd','Henley');
insert into parcel values (54, '((1024236,899359),(1024230,901135),(1047506,900501),(1056698,902155),(1054107,916564),(1073977,916426),(1074246,912366),(1077395,912681),(1082393,913537),(1088873,914648),(1091313,914646),(1101730,914639),(1095769,904416),(1092558,887361),(1090480,876325),(1089088,867386),(1086844,853867),(1086229,850162),(1086002,848795),(1085853,847830),(1085209,842802),(1086044,836764),(1089177,827180),(1089948,824593),(1095283,810092),(1093985,810431),(1037726,825151),(1026872,827991))','Stephanie','Ouellette');
insert into parcel values (55, '((1013357,955707),(1010745,956967),(1013352,962371),(1015964,961111))','Shawn','Dearing');
insert into parcel values (56, '((1092490,926691),(1089317,933229),(1094025,945989),(1094862,959101),(1114087,955278),(1121926,950720),(1126914,947935),(1123437,942099),(1116873,931083),(1111676,918581),(1105322,919270),(1098553,922193))','Tina','Crooks');
insert into parcel values (57, '((1178158,844273),(1178540,839750),(1179617,827917),(1180350,818418),(1180422,817490),(1178744,817049),(1170219,815213),(1170125,816216),(1167581,843281))','Paul','Stribling');
insert into parcel values (58, '((1299300,855590),(1287162,873537),(1292655,877700),(1306427,888040),(1320932,871122),(1305584,860175))','John','Fiore');
insert into parcel values (59, '((1015964,961111),(1018576,959851),(1015969,954447),(1013357,955707))','Willie','Woodbury');
insert into parcel values (60, '((1203513,851900),(1229032,830365),(1226787,829740),(1219544,827725),(1202035,823266),(1190770,820210),(1188811,845273),(1194623,851446),(1185380,860177),(1195235,870737),(1198422,863485),(1201381,856751))','Samuel','Giles');
insert into parcel values (61, '((1178158,844273),(1188811,845273),(1190770,820210),(1180422,817490),(1180350,818418),(1179617,827917),(1178540,839750))','Clara','Menke');
insert into parcel values (62, '((1062865,944352),(1046844,947369),(1052127,963486),(1052688,965198),(1054927,972030),(1061650,969827),(1066706,968171),(1070342,966979),(1077210,964757),(1069482,940452))','Evelyn','Belcher');
insert into parcel values (63, '((1096899,988377),(1097500,996374),(1097826,1000724),(1102597,1000712),(1109367,1000696),(1128890,1000380),(1131895,997744),(1132819,993325),(1134869,985198),(1123030,982176))','Michael','Briones');
insert into parcel values (64, '((1116873,931083),(1123437,942099),(1126914,947935),(1132553,944755),(1136788,942366),(1132065,930172),(1131660,929663),(1127311,923607),(1123358,920294),(1111676,918581))','Joanna','Burd');
insert into parcel values (65, '((1139266,948824),(1136975,949937),(1120535,959559),(1117549,977541),(1117446,978303),(1122532,977145),(1135998,980373),(1141074,959702),(1140833,952943))','Arthur','Nunez');
insert into parcel values (66, '((1120252,1115565),(1126829,1129100),(1132505,1140778),(1132594,1140963),(1143590,1161954),(1144412,1163421),(1154538,1149530),(1165736,1134169),(1173802,1123212),(1180688,1113705),(1191445,1098854),(1171851,1093440),(1166815,1092607),(1157021,1094746),(1156568,1094906),(1152356,1096397),(1146732,1099323))','Bessie','Hardeman');
insert into parcel values (67, '((1158205,1083113),(1166392,1081859),(1170004,1080901),(1172450,1078060),(1174642,1075168),(1176074,1071258),(1176083,1066837),(1175226,1063025),(1168465,1063489),(1161859,1063943),(1151532,1064654),(1127737,1066080),(1129673,1088188),(1138207,1091915),(1147216,1086902))','Pam','Saddler');
insert into parcel values (68, '((1125914,1037976),(1125605,1039703),(1125865,1043477),(1126099,1046869),(1126681,1053274),(1126894,1055610),(1127737,1066080),(1151532,1064654),(1149901,1041886),(1158763,1034282),(1134715,1010707))','Joshua','Markey');
insert into parcel values (69, '((1165834,1023785),(1168236,1018521),(1169613,1015503),(1171027,1012404),(1176690,999992),(1180191,992180),(1178585,982562),(1173329,970002),(1167261,968565),(1155482,969441),(1146105,978655),(1144859,984152),(1142426,995704),(1144977,1007440),(1164504,1026700))','Bruce','Rueda');
insert into parcel values (70, '((963932,998526),(962158,999197),(969891,1009654),(973540,1008009),(969123,1000017))','Andrew','Kepler');
insert into parcel values (71, '((1337059,744235),(1327870,757275),(1307317,785699),(1301459,793747),(1296725,797859),(1294170,800077),(1293771,800342),(1283575,807210),(1279286,811095),(1275988,813678),(1273878,815329),(1282415,825172),(1289934,835211),(1293540,838964),(1300580,844412),(1301844,842985),(1328112,862605),(1362388,888228),(1380672,827910),(1384824,814212),(1428003,671767),(1424773,665844),(1364153,647708),(1338637,738616))','Chad','Eckert');
insert into parcel values (72, '((969623,1059259),(968810,1059740),(982919,1083047),(1005842,1066674),(994079,1044774),(989316,1047595),(983543,1051014),(980665,1052719),(970988,1058451))','Vincent','Crozier');
insert into parcel values (73, '((982609,1024217),(956983,1038325),(968810,1059740),(969623,1059259),(970988,1058451),(980665,1052719),(983543,1051014),(989316,1047595),(994079,1044774),(989663,1036834))','Samuel','Noles');
insert into parcel values (74, '((984126,1005569),(998019,1031013),(1002882,1039560),(1005921,1044901),(1022411,1036092),(1027464,1045552),(1029660,1049663),(1037880,1065051),(1039123,1067376),(1041616,1066111),(1052881,1052619),(1054154,1051095),(1053697,1050383),(1043060,1031763),(1040841,1023222),(1040279,1020022),(1038996,1012716),(1037324,1003194),(1036826,998163),(1039519,998575),(1042780,994923),(1038773,990494),(1036598,985408),(1032266,966039),(1021060,951992),(1015969,954447),(1018576,959851),(1015964,961111),(1013352,962371),(1010740,963631),(1008128,964891),(1005516,966150),(1002903,967410),(1000297,962006),(992720,965660),(983707,970007),(972560,976235),(970420,978619),(970113,980143),(975070,989106),(976776,992190),(980242,998457))','Willie','Chamness');
insert into parcel values (75, '((1120252,1115565),(1116859,1117564),(1117351,1123650),(1111460,1150374),(1110670,1154336),(1143590,1161954),(1132594,1140963),(1132505,1140778),(1126829,1129100))','Dale','Dimaggio');
insert into parcel values (76, '((1000464,1103086),(979085,1122748),(991968,1136168),(994575,1138943),(994979,1138535),(1004681,1129293),(1020315,1138804),(1029619,1144464),(1034002,1147131),(1037928,1140714),(1052471,1116273),(1053529,1114694),(1052173,1108714),(1034637,1099026),(1018270,1113057),(1013301,1117318),(1007028,1110363))','Patrick','Harwell');
insert into parcel values (77, '((1018663,1086994),(1005070,1099014),(1000464,1103086),(1007028,1110363),(1013301,1117318),(1018270,1113057),(1034637,1099026))','Kenneth','Holm');
insert into parcel values (78, '((1317033,1227943),(1314043,1204723),(1311390,1184115),(1310633,1178235),(1309011,1165638),(1308395,1160853),(1306828,1148676),(1304741,1132462),(1293701,1129199),(1264081,1120543),(1267238,1141503),(1274264,1188142),(1278721,1217724))','Debra','Madewell');
insert into parcel values (79, '((1149901,1041886),(1151532,1064654),(1161859,1063943),(1168465,1063489),(1175226,1063025),(1165510,1041308),(1158763,1034282))','Justin','Thorson');
insert into parcel values (80, '((1168236,1018521),(1165834,1023785),(1164504,1026700),(1174256,1037269),(1178034,1045892),(1193031,1013005),(1177462,1000691),(1176690,999992),(1171027,1012404),(1169613,1015503))','Eric','Culp');