; 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: Sun Apr 05 16:41:25 EDT 2015 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: 57295 Longest probe sequence: 32 Imported Locations: 54772 -------------------------------------------------------------------------------- ; ; 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 1807716: Torrance 1054009W 350034N -------------------------------------------------------------------------------- Command 3: what_is 11476 Water Well NM 6051198: Curry 1030957W 345047N 6651211: Roosevelt 1030446W 334935N -------------------------------------------------------------------------------- Command 4: what_is Trinity Site NM 2340590: Socorro 1062831W 334038N -------------------------------------------------------------------------------- Command 5: what_is Brazos Cliffs NM 206013: Rio Arriba 1062337W 364458N -------------------------------------------------------------------------------- Command 6: what_is Tierra Amarilla NM 5114619: Rio Arriba 1063259W 364201N -------------------------------------------------------------------------------- Command 7: what_is Truth or Consequences NM 1647335: Sierra 1071510W 330742N -------------------------------------------------------------------------------- ; ; Let's see what the buffer pool looks like now: Command 8: debug pool MRU 1647335: 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 5114619: 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 206013: 886720|Brazos Cliffs|Cliff|NM|35|Rio Arriba|039|364458N|1062337W|36.7494587|-106.393641|||||2991|9813|Penasco Amarillo|11/13/1980| 2340590: 902746|Trinity Site|Locale|NM|35|Socorro|053|334038N|1062831W|33.6772929|-106.4752871|||||1500|4921|Trinity Site|01/01/1993| 6651211: 936263|11476 Water Well|Well|NM|35|Roosevelt|041|334935N|1030446W|33.8264821|-103.0793885|||||1209|3966|Lingo|09/01/1994| 6051198: 931178|11476 Water Well|Well|NM|35|Curry|009|345047N|1030957W|34.8464538|-103.1657817|||||1367|4485|Broadview|05/01/1994| 1807716: 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: 4678409: Santo Nino Church Rio Arriba NM 5114619: Tierra Amarilla Rio Arriba NM 6118282: Tierra Amarilla Historical Marker Rio Arriba NM 6120559: Fort Lowell Historical Marker Rio Arriba NM 6214003: Tierra Amarilla Weather Station Rio Arriba NM 6361195: La Clinica Del Pueblo De Rio Arriba, Inc. Rio Arriba NM 6387965: Tierra Amarilla Elementary School Rio Arriba NM 6388117: Tierra Amarilla Middle School Rio Arriba NM 6388265: Escallante High School Rio Arriba NM 6591450: Tierra Amarilla Historic District Rio Arriba NM 6594565: Tierra Amarilla Community Ditch Rio Arriba NM 6889066: 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 6889066: 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| 6594565: 935798|Tierra Amarilla Community Ditch|Canal|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1994| 6591450: 935767|Tierra Amarilla Historic District|Locale|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1994| 6388265: 934141|Escallante High School|School|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6388117: 934140|Tierra Amarilla Middle School|School|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6387965: 934139|Tierra Amarilla Elementary School|School|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|09/01/1992| 6361195: 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| 6214003: 932548|Tierra Amarilla Weather Station|Locale|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|05/01/1994| 6120559: 931713|Fort Lowell Historical Marker|Park|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|05/01/1994| 6118282: 931697|Tierra Amarilla Historical Marker|Park|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|05/01/1994| LRU -------------------------------------------------------------------------------- ; Command 11: what_is_at 351018N 1034330W The following features were found at 1034330W 351018N: 2188288: Tucumcari Area vocational School Quay NM 2236869: First Baptist Church Quay NM 2236995: First Christian Church Quay NM 2237123: First Presbyterian Church Quay NM 2238635: Full Gospel Grace Tabernacle Quay NM 2238769: First Spanish Baptist Church Quay NM 2238903: First Assembly of God Church Quay NM 2250068: Church of God Quay NM 2255970: The Church of Jesus Christ of Latter Day Saints Quay NM 2297874: Temple Baptist Quay NM 2297994: Trinity Baptist Church Quay NM 2298122: Primitive Baptist Church Quay NM 2298252: Bethel Tabernacle Quay NM 2299990: Church of the Nazarene Quay NM 2300118: Church of Christ Scientist Quay NM 2300250: Church of Christ Quay NM 2304436: Saint Michael Episcopal Church Quay NM 2306145: Center Saint United Methodist Church Quay NM 2306287: Mount Calvary Baptist Church Quay NM 2334359: Seventh Day Adventist Church Quay NM 2334493: Saint Annes Catholic Church Quay NM 3994731: Tucumcari High School Quay NM 4151646: Tucumcari Quay NM 4668036: United Pentecostal Church Quay NM 4670442: Kingdom Hall Quay NM 4686849: Christian Science Services Church Quay NM 4693166: First Church of the Nazarene Quay NM 4811107: Rayo Del Luz Baptist Church Quay NM 5819240: Rural Bookmobile East Library Quay NM 5835135: Tucumcari Area Vocational School Library Quay NM 5843914: Tucumcari Historical Research Institute Quay NM 6207470: Tucumcari Historical Marker Quay NM 6298397: Baca-Goodman House Historic Site Quay NM 6377456: Temple Baptist Academy Quay NM 6401052: Tucumcari Junior High School Quay NM 6409229: Rock Island-Southern Pacific Passenger Depot Historic Site Quay NM 6416511: Quay County Courthouse Historic Site Quay NM 6815430: Tucumcari Post Office Quay NM -------------------------------------------------------------------------------- Command 12: what_is_at 354929N 1055845W The following features were found at 1055845W 354929N: 2557172: Camel Rock Santa Fe NM -------------------------------------------------------------------------------- Command 13: what_is_at 360337N 1075801W The following features were found at 1075801W 360337N: 296953: 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) 1563133: La Canada Ditch NM 364249N 1063250W 4678409: Santo Nino Church NM 364201N 1063259W 5114619: Tierra Amarilla NM 364201N 1063259W 6118282: Tierra Amarilla Historical Marker NM 364201N 1063259W 6120559: Fort Lowell Historical Marker NM 364201N 1063259W 6214003: Tierra Amarilla Weather Station NM 364201N 1063259W 6361195: La Clinica Del Pueblo De Rio Arriba, Inc. NM 364201N 1063259W 6387965: Tierra Amarilla Elementary School NM 364201N 1063259W 6388117: Tierra Amarilla Middle School NM 364201N 1063259W 6388265: Escallante High School NM 364201N 1063259W 6591450: Tierra Amarilla Historic District NM 364201N 1063259W 6594565: Tierra Amarilla Community Ditch NM 364201N 1063259W 6889066: Tierra Amarilla Post Office NM 364201N 1063259W 5463058: Water Well 2 NM 364205N 1063322W 6591301: Rio Arriba County Courthouse NM 364200N 1063259W 7544781: Tierra Amarilla Volunteer Fire Department NM 364238N 1063331W 7481252: Tierra Amarilla Census Designated Place NM 364221N 1063354W 7504558: La Clinica Emergency Medical Services NM 364242N 1063344W 1402686: Tierra Amarilla Ditch NM 364148N 1063251W 7231328: 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) 583370: Granger School NM 351013N 1034341W 2188288: Tucumcari Area vocational School NM 351018N 1034330W 2236869: First Baptist Church NM 351018N 1034330W 2236995: First Christian Church NM 351018N 1034330W 2237123: First Presbyterian Church NM 351018N 1034330W 2238635: Full Gospel Grace Tabernacle NM 351018N 1034330W 2238769: First Spanish Baptist Church NM 351018N 1034330W 2238903: First Assembly of God Church NM 351018N 1034330W 2250068: Church of God NM 351018N 1034330W 2255970: The Church of Jesus Christ of Latter Day Saints NM 351018N 1034330W 2297874: Temple Baptist NM 351018N 1034330W 2297994: Trinity Baptist Church NM 351018N 1034330W 2298122: Primitive Baptist Church NM 351018N 1034330W 2298252: Bethel Tabernacle NM 351018N 1034330W 2299990: Church of the Nazarene NM 351018N 1034330W 2300118: Church of Christ Scientist NM 351018N 1034330W 2300250: Church of Christ NM 351018N 1034330W 2304436: Saint Michael Episcopal Church NM 351018N 1034330W 2306145: Center Saint United Methodist Church NM 351018N 1034330W 2306287: Mount Calvary Baptist Church NM 351018N 1034330W 2334359: Seventh Day Adventist Church NM 351018N 1034330W 2334493: Saint Annes Catholic Church NM 351018N 1034330W 3994731: Tucumcari High School NM 351018N 1034330W 4151646: Tucumcari NM 351018N 1034330W 4668036: United Pentecostal Church NM 351018N 1034330W 4670442: Kingdom Hall NM 351018N 1034330W 4686849: Christian Science Services Church NM 351018N 1034330W 4693166: First Church of the Nazarene NM 351018N 1034330W 4811107: Rayo Del Luz Baptist Church NM 351018N 1034330W 5819240: Rural Bookmobile East Library NM 351018N 1034330W 5835135: Tucumcari Area Vocational School Library NM 351018N 1034330W 5843914: Tucumcari Historical Research Institute NM 351018N 1034330W 6207470: Tucumcari Historical Marker NM 351018N 1034330W 6298397: Baca-Goodman House Historic Site NM 351018N 1034330W 6377456: Temple Baptist Academy NM 351018N 1034330W 6401052: Tucumcari Junior High School NM 351018N 1034330W 6409229: Rock Island-Southern Pacific Passenger Depot Historic Site NM 351018N 1034330W 6416511: Quay County Courthouse Historic Site NM 351018N 1034330W 6815430: Tucumcari Post Office NM 351018N 1034330W 6816940: 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) 2557172: Camel Rock NM 354929N 1055845W 4976251: Water Well 2 NM 354930N 1055854W 5351777: Camel Rock 1 Water Well NM 354940N 1055850W 7489617: 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 7489617: 2628400|Camel Rock Casino|Building|NM|35|Santa Fe|049|354918N|1055825W|35.8216667|-105.9736111|||||1933|6342|Tesuque|05/19/2010| 5351777: 925587|Camel Rock 1 Water Well|Well|NM|35|Santa Fe|049|354940N|1055850W|35.8278049|-105.9805778|||||1915|6283|Tesuque|03/01/1994| 4976251: 922593|Water Well 2|Well|NM|35|Santa Fe|049|354930N|1055854W|35.8250272|-105.9816889|||||1909|6263|Tesuque|09/01/1993| 2557172: 904308|Camel Rock|Pillar|NM|35|Santa Fe|049|354929N|1055845W|35.8247494|-105.9791889|||||1928|6325|Tesuque|11/13/1980| 6816940: 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 6815430: 937537|Tucumcari Post Office|Post Office|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1993| 6416511: 934351|Quay County Courthouse Historic Site|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1994| 6409229: 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| 6401052: 934239|Tucumcari Junior High School|School|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1992| 6377456: 934056|Temple Baptist Academy|School|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|09/01/1992| LRU -------------------------------------------------------------------------------- ; ; Now, let's import some more data: Command 18: import CO_All.txt Imported Features by name: 49421 Longest probe sequence: 19 Imported Locations: 49328 -------------------------------------------------------------------------------- ; ; 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 9573196: Summit 1055908W 392915N -------------------------------------------------------------------------------- Command 20: what_is Lincoln NM 5103072: Lincoln 1052302W 332931N -------------------------------------------------------------------------------- ; ; Let's try spanning the border: Command 21: what_is_in 365800N 1043030W 720 45 The following 37 features were found in (1043030W +/- 45, 365800N +/- 720) 14034430: Temple Aaron CO 370958N 1043010W 14033725: Animas Street Gospel Hall CO 370958N 1043024W 14035133: Mount Carmel Roman Catholic Church CO 370959N 1043115W 11221976: Trinidad Country Club CO 370920N 1043056W 11802788: Fisher Peak Detention FPC-2 Dam CO 370924N 1043038W 11802933: Fisher Peak Detention Reservoir FPC-2 CO 370924N 1043038W 14213634: Trinidad Fire Department Station 1 CO 370925N 1043044W 11221843: Columbian School CO 370947N 1043031W 11802486: Fisher Peak Detention FPC-1 Dam CO 370912N 1043008W 11802631: Fisher Peak Detention Reservoir FPC-1 CO 370912N 1043008W 11222500: Henderson Mine CO 370813N 1043011W 13231300: New Mary Mine CO 370814N 1043019W 12370831: KCRT-AM (Trinidad) CO 370845N 1043044W 12384690: KCRT-FM (Trinidad) CO 370845N 1043044W 13231687: Santa Fe Pit CO 370814N 1043059W 11222241: McLaughlin Mine CO 370809N 1043107W 11222114: Stevens Mine CO 370812N 1043057W 11222370: Starkville Mine CO 370803N 1043052W 11243879: Starkville Mines CO 370727N 1043046W 11222878: Starkville Number 1 Coal Mine CO 370737N 1043104W 11222628: Leone Mine CO 370808N 1043011W 11222753: Moore Mine CO 370802N 1043014W 11242659: Morley CO 370155N 1043017W 11242952: Twentythree Canyon CO 370303N 1043017W 11244143: Morley Mine CO 370158N 1043020W 31243: Rex Canyon NM 365918N 1043106W 11260546: Rex Canyon NM 365918N 1043106W 6232320: Lynn (historical) NM 365911N 1042955W 6925081: Lynn Post Office (historical) NM 365911N 1042955W 4227408: Blossburg Number Three NM 365515N 1042953W 4176381: Dutchman Coal Mine NM 365457N 1043036W 4227769: Bartlett Mine NM 365423N 1043111W 4394617: Blossburg Number Four NM 365329N 1043110W 783933: Letton Canyon NM 365111N 1043024W 317636: Chipmunk Canyon NM 364947N 1043029W 1349539: Spruce Canyon NM 364932N 1043041W 1148900: Red River Peak NM 364821N 1043005W -------------------------------------------------------------------------------- ; ; Let's try a larger region: Command 22: what_is_in -c 370000N 1040000W 3600 3600 4136 features were found in (1040000W +/- 3600, 370000N +/- 3600) -------------------------------------------------------------------------------- ; ; And some more or less random searches: Command 23: what_is Eagle Peak NM 460873: Catron 1084116W 342320N 2791811: Catron 1083435W 334036N 2791931: Mora 1051934W 355652N -------------------------------------------------------------------------------- Command 24: what_is Scott Spring NM 3481282: Otero 1053130W 325036N 3481413: Socorro 1072007W 341808N 4466448: Lincoln 1055348W 333948N -------------------------------------------------------------------------------- Command 25: what_is Slab Mill Gulch CO 10118164: Gunnison 1070910W 383616N -------------------------------------------------------------------------------- Command 26: what_is Oak Canyon NM 1015071: Union 1035310W 365356N 1015225: Dona Ana 1062841W 321000N 1015382: Hidalgo 1083707W 321402N 1015540: Grant 1081404W 322440N 1015706: Cibola 1072002W 350627N 1654154: Grant 1074731W 324110N 2009810: Grant 1075957W 324102N 3249532: Grant 1072002W 324048N 3249691: Grant 1083959W 324048N -------------------------------------------------------------------------------- Command 27: what_is Kemper School CO 9013040: Montezuma 1083437W 372105N 13517719: Montezuma 1083439W 372105N -------------------------------------------------------------------------------- Command 28: what_is_at 380806N 1073426W The following features were found at 1073426W 380806N: 10329270: Courthouse Mountain Ouray CO -------------------------------------------------------------------------------- Command 29: what_is_at 371010N 1043002W The following features were found at 1043002W 371010N: 12466104: Trinidad Las Animas CO -------------------------------------------------------------------------------- Command 30: what_is_at 402906N 1064954W The following features were found at 1064954W 402906N: 8124189: Steamboat Springs Routt CO -------------------------------------------------------------------------------- Command 31: what_is_at 334038N 1062831W The following features were found at 1062831W 334038N: 2340590: Trinity Site Socorro NM 6194871: Trinity Site Historical Marker Socorro NM -------------------------------------------------------------------------------- Command 32: what_is_at 320727N 1070347W The following features were found at 1070347W 320727N: 1965311: Pronto Dona Ana NM -------------------------------------------------------------------------------- ; ; Exit Command 33: quit Terminating execution of commands. End time: Sun Apr 05 16:41:48 EDT 2015 --------------------------------------------------------------------------------