; Script 8 ; ; General test with a large dB and multiple imports. ; ; Specify boundaries of coordinate space: world 1130000W 990000W 300000N 440000N GIS Program dbFile: db08.txt script: Script08.txt log: Log08.txt Start time: Tue Jun 25 19:02:50 EDT 2013 Quadtree children are printed in the order SW SE NE NW -------------------------------------------------------------------------------- Latitude/longitude values in index entries are shown as signed integers, in total seconds. World boundaries are set to: 158400 -406800 -356400 108000 -------------------------------------------------------------------------------- ; ; Import a large DB file: Command 1: import NM_All.txt Imported Features by name: 54508 Longest probe sequence: 25 Imported Locations: 54508 -------------------------------------------------------------------------------- ; ; Check the location and name/state indices if you dare: ;debug quad ;debug hash ; ; Try a few name/state searches: Command 2: what_is Clines Corners NM 1780014: Torrance 1054009W 350034N -------------------------------------------------------------------------------- Command 3: what_is 11476 Water Well NM 5862922: Curry 1030957W 345047N 6434255: Roosevelt 1030446W 334935N -------------------------------------------------------------------------------- Command 4: what_is Trinity Site NM 2272467: Socorro 1062831W 334038N -------------------------------------------------------------------------------- Command 5: what_is Brazos Cliffs NM 178614: Rio Arriba 1062337W 364458N -------------------------------------------------------------------------------- Command 6: what_is Tierra Amarilla NM 4945073: Rio Arriba 1063259W 364201N -------------------------------------------------------------------------------- Command 7: what_is Truth or Consequences NM 1620094: Sierra 1071510W 330742N -------------------------------------------------------------------------------- ; ; Let's see what the buffer pool looks like now: Command 8: debug pool MRU 1620094: 897496|Truth or Consequences|Populated Place|NM|35|Sierra|051|330742N|1071510W|33.1284047|-107.2528069|||||1294|4245|Cuchillo|11/13/1980|03/21/2008 4945073: 923704|Tierra Amarilla|Populated Place|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|11/13/1980|01/29/2011 178614: 886720|Brazos Cliffs|Cliff|NM|35|Rio Arriba|039|364458N|1062337W|36.7494587|-106.393641|||||2991|9813|Penasco Amarillo|11/13/1980| 2272467: 902746|Trinity Site|Locale|NM|35|Socorro|053|334038N|1062831W|33.6772929|-106.4752871|||||1500|4921|Trinity Site|01/01/1993| 6434255: 936263|11476 Water Well|Well|NM|35|Roosevelt|041|334935N|1030446W|33.8264821|-103.0793885|||||1209|3966|Lingo|09/01/1994| 5862922: 931178|11476 Water Well|Well|NM|35|Curry|009|345047N|1030957W|34.8464538|-103.1657817|||||1367|4485|Broadview|05/01/1994| 1780014: 898646|Clines Corners|Populated Place|NM|35|Torrance|057|350034N|1054009W|35.0094982|-105.6691804|||||2151|7057|Clines Corners|11/13/1980| LRU -------------------------------------------------------------------------------- ; ; Try a few location searches: Command 9: what_is_at 364201N 1063259W The following features were found at 1063259W 364201N: 4552737: Santo Niño Church Rio Arriba NM 4945073: Tierra Amarilla Rio Arriba NM 5928650: Tierra Amarilla Historical Marker Rio Arriba NM 5930927: Fort Lowell Historical Marker Rio Arriba NM 6024011: Tierra Amarilla Weather Station Rio Arriba NM 6148154: La Clinica Del Pueblo De Rio Arriba, Inc. Rio Arriba NM 6174756: Tierra Amarilla Elementary School Rio Arriba NM 6174908: Tierra Amarilla Middle School Rio Arriba NM 6175056: Escallante High School Rio Arriba NM 6376580: Tierra Amarilla Historic District Rio Arriba NM 6379696: Tierra Amarilla Community Ditch Rio Arriba NM 6621531: Tierra Amarilla Post Office Rio Arriba NM -------------------------------------------------------------------------------- ; ; And let's check the pool again; at this point, you might have some records ; in a different order than I'm showing: Command 10: debug pool MRU 6621531: 938095|Tierra Amarilla Post Office|Post Office|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|08/01/1993| 6379696: 935798|Tierra Amarilla Community Ditch|Canal|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1994| 6376580: 935767|Tierra Amarilla Historic District|Locale|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1994| 6175056: 934141|Escallante High School|School|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6174908: 934140|Tierra Amarilla Middle School|School|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6174756: 934139|Tierra Amarilla Elementary School|School|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6148154: 933928|La Clinica Del Pueblo De Rio Arriba, Inc.|Hospital|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6024011: 932548|Tierra Amarilla Weather Station|Locale|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|05/01/1994| 5930927: 931713|Fort Lowell Historical Marker|Park|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|05/01/1994| 5928650: 931697|Tierra Amarilla Historical Marker|Park|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|05/01/1994| 4945073: 923704|Tierra Amarilla|Populated Place|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|11/13/1980|01/29/2011 4552737: 920169|Santo Niño Church|Church|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|08/01/1993| 1620094: 897496|Truth or Consequences|Populated Place|NM|35|Sierra|051|330742N|1071510W|33.1284047|-107.2528069|||||1294|4245|Cuchillo|11/13/1980|03/21/2008 178614: 886720|Brazos Cliffs|Cliff|NM|35|Rio Arriba|039|364458N|1062337W|36.7494587|-106.393641|||||2991|9813|Penasco Amarillo|11/13/1980| 2272467: 902746|Trinity Site|Locale|NM|35|Socorro|053|334038N|1062831W|33.6772929|-106.4752871|||||1500|4921|Trinity Site|01/01/1993| 6434255: 936263|11476 Water Well|Well|NM|35|Roosevelt|041|334935N|1030446W|33.8264821|-103.0793885|||||1209|3966|Lingo|09/01/1994| 5862922: 931178|11476 Water Well|Well|NM|35|Curry|009|345047N|1030957W|34.8464538|-103.1657817|||||1367|4485|Broadview|05/01/1994| 1780014: 898646|Clines Corners|Populated Place|NM|35|Torrance|057|350034N|1054009W|35.0094982|-105.6691804|||||2151|7057|Clines Corners|11/13/1980| LRU -------------------------------------------------------------------------------- ; Command 11: what_is_at 351018N 1034330W The following features were found at 1034330W 351018N: 2153737: Tucumcari Area vocational School Quay NM 2182240: First Baptist Church Quay NM 2182366: First Christian Church Quay NM 2182494: First Presbyterian Church Quay NM 2184006: Full Gospel Grace Tabernacle Quay NM 2184140: First Spanish Baptist Church Quay NM 2184274: First Assembly of God Church Quay NM 2192912: Church of God Quay NM 2196732: The Church of Jesus Christ of Latter Day Saints Quay NM 2235807: Temple Baptist Quay NM 2235927: Trinity Baptist Church Quay NM 2236055: Primitive Baptist Church Quay NM 2236185: Bethel Tabernacle Quay NM 2237813: Church of the Nazarene Quay NM 2237941: Church of Christ Scientist Quay NM 2238073: Church of Christ Quay NM 2241461: Saint Michael Episcopal Church Quay NM 2243170: Center Saint United Methodist Church Quay NM 2243312: Mount Calvary Baptist Church Quay NM 2267205: Seventh Day Adventist Church Quay NM 2267339: Saint Annes Catholic Church Quay NM 3918075: Tucumcari High School Quay NM 4070746: Tucumcari Quay NM 4544859: United Pentecostal Church Quay NM 4547271: Kingdom Hall Quay NM 4556449: Christian Science Services Church Quay NM 4562766: First Church of the Nazarene Quay NM 4658105: Rayo Del Luz Baptist Church Quay NM 5631819: Rural Bookmobile East Library Quay NM 5647607: Tucumcari Area Vocational School Library Quay NM 5656386: Tucumcari Historical Research Institute Quay NM 6017755: Tucumcari Historical Marker Quay NM 6085443: Baca-Goodman House Historic Site Quay NM 6164247: Temple Baptist Academy Quay NM 6187849: Tucumcari Junior High School Quay NM 6196027: Rock Island-Southern Pacific Passenger Depot Historic Site Quay NM 6203312: Quay County Courthouse Historic Site Quay NM 6571370: Tucumcari Post Office Quay NM -------------------------------------------------------------------------------- Command 12: what_is_at 354929N 1055845W The following features were found at 1055845W 354929N: 2486588: Camel Rock Santa Fe NM -------------------------------------------------------------------------------- Command 13: what_is_at 360337N 1075801W The following features were found at 1075801W 360337N: 269596: Chaco Canyon San Juan NM -------------------------------------------------------------------------------- ; ; And a few region searches: Command 14: what_is_in 364201N 1063259W 60 60 The following 20 features were found in (1063259W +/- 60, 364201N +/- 60) 1536178: La Cañada Ditch NM 364249N 1063250W 4552737: Santo Niño Church NM 364201N 1063259W 4945073: Tierra Amarilla NM 364201N 1063259W 5928650: Tierra Amarilla Historical Marker NM 364201N 1063259W 5930927: Fort Lowell Historical Marker NM 364201N 1063259W 6024011: Tierra Amarilla Weather Station NM 364201N 1063259W 6148154: La Clinica Del Pueblo De Rio Arriba, Inc. NM 364201N 1063259W 6174756: Tierra Amarilla Elementary School NM 364201N 1063259W 6174908: Tierra Amarilla Middle School NM 364201N 1063259W 6175056: Escallante High School NM 364201N 1063259W 6376580: Tierra Amarilla Historic District NM 364201N 1063259W 6379696: Tierra Amarilla Community Ditch NM 364201N 1063259W 6621531: Tierra Amarilla Post Office NM 364201N 1063259W 5281348: Water Well 2 NM 364205N 1063322W 6376431: Rio Arriba County Courthouse NM 364200N 1063259W 7247646: Tierra Amarilla Volunteer Fire Department NM 364238N 1063331W 7184242: Tierra Amarilla Census Designated Place NM 364221N 1063354W 7207411: La Clinica Emergency Medical Services NM 364242N 1063344W 1375681: Tierra Amarilla Ditch NM 364148N 1063251W 6935095: Tierra Amarilla Division NM 364113N 1063324W -------------------------------------------------------------------------------- Command 15: what_is_in 351018N 1034330W 15 15 The following 40 features were found in (1034330W +/- 15, 351018N +/- 15) 556022: Granger School NM 351013N 1034341W 2153737: Tucumcari Area vocational School NM 351018N 1034330W 2182240: First Baptist Church NM 351018N 1034330W 2182366: First Christian Church NM 351018N 1034330W 2182494: First Presbyterian Church NM 351018N 1034330W 2184006: Full Gospel Grace Tabernacle NM 351018N 1034330W 2184140: First Spanish Baptist Church NM 351018N 1034330W 2184274: First Assembly of God Church NM 351018N 1034330W 2192912: Church of God NM 351018N 1034330W 2196732: The Church of Jesus Christ of Latter Day Saints NM 351018N 1034330W 2235807: Temple Baptist NM 351018N 1034330W 2235927: Trinity Baptist Church NM 351018N 1034330W 2236055: Primitive Baptist Church NM 351018N 1034330W 2236185: Bethel Tabernacle NM 351018N 1034330W 2237813: Church of the Nazarene NM 351018N 1034330W 2237941: Church of Christ Scientist NM 351018N 1034330W 2238073: Church of Christ NM 351018N 1034330W 2241461: Saint Michael Episcopal Church NM 351018N 1034330W 2243170: Center Saint United Methodist Church NM 351018N 1034330W 2243312: Mount Calvary Baptist Church NM 351018N 1034330W 2267205: Seventh Day Adventist Church NM 351018N 1034330W 2267339: Saint Annes Catholic Church NM 351018N 1034330W 3918075: Tucumcari High School NM 351018N 1034330W 4070746: Tucumcari NM 351018N 1034330W 4544859: United Pentecostal Church NM 351018N 1034330W 4547271: Kingdom Hall NM 351018N 1034330W 4556449: Christian Science Services Church NM 351018N 1034330W 4562766: First Church of the Nazarene NM 351018N 1034330W 4658105: Rayo Del Luz Baptist Church NM 351018N 1034330W 5631819: Rural Bookmobile East Library NM 351018N 1034330W 5647607: Tucumcari Area Vocational School Library NM 351018N 1034330W 5656386: Tucumcari Historical Research Institute NM 351018N 1034330W 6017755: Tucumcari Historical Marker NM 351018N 1034330W 6085443: Baca-Goodman House Historic Site NM 351018N 1034330W 6164247: Temple Baptist Academy NM 351018N 1034330W 6187849: Tucumcari Junior High School NM 351018N 1034330W 6196027: Rock Island-Southern Pacific Passenger Depot Historic Site NM 351018N 1034330W 6203312: Quay County Courthouse Historic Site NM 351018N 1034330W 6571370: Tucumcari Post Office NM 351018N 1034330W 6572880: Douglas Post Office (historical) NM 351018N 1034328W -------------------------------------------------------------------------------- Command 16: what_is_in 354929N 1055845W 30 30 The following 4 features were found in (1055845W +/- 30, 354929N +/- 30) 2486588: Camel Rock NM 354929N 1055845W 4816180: Water Well 2 NM 354930N 1055854W 5176499: Camel Rock 1 Water Well NM 354940N 1055850W 7192607: Camel Rock Casino NM 354918N 1055825W -------------------------------------------------------------------------------- ; ; Let's check the pool again; we should agree on the top four, although they ; could be in a different order: Command 17: debug pool MRU 7192607: 2628400|Camel Rock Casino|Building|NM|35|Santa Fe|049|354918N|1055825W|35.8216667|-105.9736111|||||1933|6342|Tesuque|05/19/2010| 5176499: 925587|Camel Rock 1 Water Well|Well|NM|35|Santa Fe|049|354940N|1055850W|35.8278049|-105.9805778|||||1915|6283|Tesuque|03/01/1994| 4816180: 922593|Water Well 2|Well|NM|35|Santa Fe|049|354930N|1055854W|35.8250272|-105.9816889|||||1909|6263|Tesuque|09/01/1993| 2486588: 904308|Camel Rock|Pillar|NM|35|Santa Fe|049|354929N|1055845W|35.8247494|-105.9791889|||||1928|6325|Tesuque|11/13/1980| 6572880: 937548|Douglas Post Office (historical)|Post Office|NM|35|Quay|037|351018N|1034328W|35.1716667|-103.7244444|||||1247|4091|Tucumcari|08/01/1993|05/12/2010 6571370: 937537|Tucumcari Post Office|Post Office|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1993| 6203312: 934351|Quay County Courthouse Historic Site|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1994| 6196027: 934301|Rock Island-Southern Pacific Passenger Depot Historic Site|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1994| 6187849: 934239|Tucumcari Junior High School|School|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1992| 6164247: 934056|Temple Baptist Academy|School|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1992| 6085443: 933468|Baca-Goodman House Historic Site|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1994| 6017755: 932387|Tucumcari Historical Marker|Park|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 5656386: 929495|Tucumcari Historical Research Institute|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 5647607: 929433|Tucumcari Area Vocational School Library|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 5631819: 929325|Rural Bookmobile East Library|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 4658105: 921243|Rayo Del Luz Baptist Church|Church|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1993| 4562766: 920291|First Church of the Nazarene|Church|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1993| 4556449: 920243|Christian Science Services Church|Church|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1993| 4547271: 920102|Kingdom Hall|Church|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1993| 4544859: 920083|United Pentecostal Church|Church|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1993| LRU -------------------------------------------------------------------------------- ; ; Now, let's import some more data: Command 18: import CO_All.txt Imported Features by name: 48966 Longest probe sequence: 25 Imported Locations: 48966 -------------------------------------------------------------------------------- ; ; And have a look at the indices, if you dare: ;debug quad ;debug hash ; ; And some searches; let's see if you're taking the state abbreviation into account: Command 19: what_is Lincoln CO 9261671: Summit 1055908W 392915N -------------------------------------------------------------------------------- Command 20: what_is Lincoln NM 4933525: Lincoln 1052302W 332931N -------------------------------------------------------------------------------- ; ; Let's try spanning the border: Command 21: what_is_in 365800N 1043030W 720 45 The following 36 features were found in (1043030W +/- 45, 365800N +/- 720) 13669318: Temple Aaron CO 370958N 1043010W 13668613: Animas Street Gospel Hall CO 370958N 1043024W 13670021: Mount Carmel Roman Catholic Church CO 370959N 1043115W 10907490: Trinidad Country Club CO 370920N 1043056W 11481182: Fisher Peak Detention FPC-2 Dam CO 370924N 1043038W 11481327: Fisher Peak Detention Reservoir FPC-2 CO 370924N 1043038W 13848523: Trinidad Fire Department Station 1 CO 370925N 1043044W 10907357: Columbian School CO 370947N 1043031W 11480880: Fisher Peak Detention FPC-1 Dam CO 370912N 1043008W 11481025: Fisher Peak Detention Reservoir FPC-1 CO 370912N 1043008W 10908014: Henderson Mine CO 370813N 1043011W 12872693: New Mary Mine CO 370814N 1043019W 12044671: KCRT-AM (Trinidad) CO 370845N 1043044W 12058530: KCRT-FM (Trinidad) CO 370845N 1043044W 12873080: Santa Fe Pit CO 370814N 1043059W 10907755: McLaughlin Mine CO 370809N 1043107W 10907628: Stevens Mine CO 370812N 1043057W 10907884: Starkville Mine CO 370803N 1043052W 10929393: Starkville Mines CO 370727N 1043046W 10908392: Starkville Number 1 Coal Mine CO 370737N 1043104W 10908142: Leone Mine CO 370808N 1043011W 10908267: Moore Mine CO 370802N 1043014W 10928173: Morley CO 370155N 1043017W 10928466: Twentythree Canyon CO 370303N 1043017W 10929657: Morley Mine CO 370158N 1043020W 7557: Rex Canyon NM 365918N 1043106W 6035172: Lynn (historical) NM 365911N 1042955W 6650697: Lynn Post Office (historical) NM 365911N 1042955W 4143777: Blossburg Number Three NM 365515N 1042953W 4095401: Dutchman Coal Mine NM 365457N 1043036W 4144138: Bartlett Mine NM 365423N 1043111W 4301381: Blossburg Number Four NM 365329N 1043110W 756673: Letton Canyon NM 365111N 1043024W 290284: Chipmunk Canyon NM 364947N 1043029W 1322515: Spruce Canyon NM 364932N 1043041W 1121795: Red River Peak NM 364821N 1043005W -------------------------------------------------------------------------------- ; ; Let's try a larger region: Command 22: what_is_in -c 370000N 1040000W 3600 3600 4053 features were found in (1040000W +/- 3600, 370000N +/- 3600) -------------------------------------------------------------------------------- ; ; And some more or less random searches: Command 23: what_is Eagle Peak NM 433478: Catron 1084116W 342320N 2721594: Catron 1083435W 334036N 2721714: Mora 1051934W 355652N -------------------------------------------------------------------------------- Command 24: what_is Scott Spring NM 3410959: Otero 1053130W 325036N 3411090: Socorro 1072007W 341808N 4371562: Lincoln 1055348W 333948N -------------------------------------------------------------------------------- Command 25: what_is Slab Mill Gulch CO 9804990: Gunnison 1070910W 383616N -------------------------------------------------------------------------------- Command 26: what_is Oak Canyon NM 987904: Union 1035310W 365356N 988058: Doña Ana 1062841W 321000N 988216: Hidalgo 1083707W 321402N 988374: Grant 1081404W 322440N 988540: Cibola 1072002W 350627N 1626753: Grant 1074731W 324110N 1982151: Grant 1075957W 324102N 3179335: Grant 1072002W 324048N 3179494: Grant 1083959W 324048N -------------------------------------------------------------------------------- Command 27: what_is Kemper School CO 8703516: Montezuma 1083437W 372105N 13158996: Montezuma 1083439W 372105N -------------------------------------------------------------------------------- Command 28: what_is_at 380806N 1073426W The following features were found at 1073426W 380806N: 10016097: Courthouse Mountain Ouray CO -------------------------------------------------------------------------------- Command 29: what_is_at 371010N 1043002W The following features were found at 1043002W 371010N: 12139530: Trinidad Las Animas CO -------------------------------------------------------------------------------- Command 30: what_is_at 402906N 1064954W The following features were found at 1064954W 402906N: 7817181: Steamboat Springs Routt CO -------------------------------------------------------------------------------- Command 31: what_is_at 334038N 1062831W The following features were found at 1062831W 334038N: 2272467: Trinity Site Socorro NM 6005155: Trinity Site Historical Marker Socorro NM -------------------------------------------------------------------------------- Command 32: what_is_at 320727N 1070347W The following features were found at 1070347W 320727N: 1937639: Pronto Doña Ana NM -------------------------------------------------------------------------------- ; ; Exit Command 33: quit Terminating execution of commands. End time: Tue Jun 25 19:07:30 EDT 2013 --------------------------------------------------------------------------------