; Script 7 ; ; Test of searches and the buffer pool with another large database file. ; ; Specify boundaries of coordinate space: world 1100000W 1020000W 303000N 383000N GIS Program dbFile: db.txt script: Script07.txt log: McLog07.txt Start time: Mon Mar 26 20:27:45 EDT 2018 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: 138600 -396000 -367200 109800 -------------------------------------------------------------------------------- ; ; Import a large DB file: Command 1: import NM_All.txt Imported Features by name: 57295 Longest probe sequence: 2577 Imported Locations: 54760 Average name length: 16 -------------------------------------------------------------------------------- ; ; 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 (105d 40m 9s West, 35d 0m 34s North) -------------------------------------------------------------------------------- Command 3: what_is 11476 Water Well NM 6051198: Curry (103d 9m 57s West, 34d 50m 47s North) 6651211: Roosevelt (103d 4m 46s West, 33d 49m 35s North) -------------------------------------------------------------------------------- Command 4: what_is Trinity Site NM 2340590: Socorro (106d 28m 31s West, 33d 40m 38s North) -------------------------------------------------------------------------------- Command 5: what_is Brazos Cliffs NM 206013: Rio Arriba (106d 23m 37s West, 36d 44m 58s North) -------------------------------------------------------------------------------- Command 6: what_is Tierra Amarilla NM 5114619: Rio Arriba (106d 32m 59s West, 36d 42m 1s North) -------------------------------------------------------------------------------- Command 7: what_is Truth or Consequences NM 1647335: Sierra (107d 15m 10s West, 33d 7m 42s North) -------------------------------------------------------------------------------- ; ; 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 (106d 32m 59s West, 36d 42m 1s North): 6388265: Escallante High School Rio Arriba NM 6120559: Fort Lowell Historical Marker Rio Arriba NM 6361195: La Clinica Del Pueblo De Rio Arriba, Inc. Rio Arriba NM 4678409: Santo Nino Church Rio Arriba NM 5114619: Tierra Amarilla Rio Arriba NM 6594565: Tierra Amarilla Community Ditch Rio Arriba NM 6387965: Tierra Amarilla Elementary School Rio Arriba NM 6591450: Tierra Amarilla Historic District Rio Arriba NM 6118282: Tierra Amarilla Historical Marker Rio Arriba NM 6388117: Tierra Amarilla Middle School Rio Arriba NM 6889066: Tierra Amarilla Post Office Rio Arriba NM 6214003: Tierra Amarilla Weather Station 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| 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 4678409: 920169|Santo Nino Church|Church|NM|35|Rio Arriba|039|364201N|1063259W|36.7002922|-106.5497566|||||2295|7529|Tierra Amarilla|08/01/1993| 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 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| LRU -------------------------------------------------------------------------------- ; Command 11: what_is_at 351018N 1034330W The following features were found at (103d 43m 30s West, 35d 10m 18s North): 6298397: Baca-Goodman House Historic Site Quay NM 2298252: Bethel Tabernacle Quay NM 2306145: Center Saint United Methodist Church Quay NM 4686849: Christian Science Services Church Quay NM 2300250: Church of Christ Quay NM 2300118: Church of Christ Scientist Quay NM 2250068: Church of God Quay NM 2299990: Church of the Nazarene Quay NM 2238903: First Assembly of God Church Quay NM 2236869: First Baptist Church Quay NM 2236995: First Christian Church Quay NM 4693166: First Church of the Nazarene Quay NM 2237123: First Presbyterian Church Quay NM 2238769: First Spanish Baptist Church Quay NM 2238635: Full Gospel Grace Tabernacle Quay NM 4670442: Kingdom Hall Quay NM 2306287: Mount Calvary Baptist Church Quay NM 2298122: Primitive Baptist Church Quay NM 6416511: Quay County Courthouse Historic Site Quay NM 4811107: Rayo Del Luz Baptist Church Quay NM 6409229: Rock Island-Southern Pacific Passenger Depot Historic Site Quay NM 5819240: Rural Bookmobile East Library Quay NM 2334493: Saint Annes Catholic Church Quay NM 2304436: Saint Michael Episcopal Church Quay NM 2334359: Seventh Day Adventist Church Quay NM 2297874: Temple Baptist Quay NM 6377456: Temple Baptist Academy Quay NM 2255970: The Church of Jesus Christ of Latter Day Saints Quay NM 2297994: Trinity Baptist Church Quay NM 4151646: Tucumcari Quay NM 5835135: Tucumcari Area Vocational School Library Quay NM 2188288: Tucumcari Area vocational School Quay NM 3994731: Tucumcari High School Quay NM 6207470: Tucumcari Historical Marker Quay NM 5843914: Tucumcari Historical Research Institute Quay NM 6401052: Tucumcari Junior High School Quay NM 6815430: Tucumcari Post Office Quay NM 4668036: United Pentecostal Church Quay NM -------------------------------------------------------------------------------- Command 12: what_is_at 354929N 1055845W The following features were found at (105d 58m 45s West, 35d 49m 29s North): 2557172: Camel Rock Santa Fe NM -------------------------------------------------------------------------------- Command 13: what_is_at 360337N 1075801W The following features were found at (107d 58m 1s West, 36d 3m 37s North): 296953: Chaco Canyon San Juan NM -------------------------------------------------------------------------------- ; ; And a few region searches, some with modifiers: Command 14: what_is_in 364201N 1063259W 60 60 The following 20 features were found in (106d 32m 59s West +/- 60, 36d 42m 1s North +/- 60) 6388265: Escallante High School NM (106d 32m 59s West, 36d 42m 1s North) 6120559: Fort Lowell Historical Marker NM (106d 32m 59s West, 36d 42m 1s North) 1563133: La Canada Ditch NM (106d 32m 50s West, 36d 42m 49s North) 6361195: La Clinica Del Pueblo De Rio Arriba, Inc. NM (106d 32m 59s West, 36d 42m 1s North) 7504558: La Clinica Emergency Medical Services NM (106d 33m 44s West, 36d 42m 42s North) 6591301: Rio Arriba County Courthouse NM (106d 32m 59s West, 36d 42m 0s North) 4678409: Santo Nino Church NM (106d 32m 59s West, 36d 42m 1s North) 5114619: Tierra Amarilla NM (106d 32m 59s West, 36d 42m 1s North) 7481252: Tierra Amarilla Census Designated Place NM (106d 33m 54s West, 36d 42m 21s North) 6594565: Tierra Amarilla Community Ditch NM (106d 32m 59s West, 36d 42m 1s North) 1402686: Tierra Amarilla Ditch NM (106d 32m 51s West, 36d 41m 48s North) 7231328: Tierra Amarilla Division NM (106d 33m 24s West, 36d 41m 13s North) 6387965: Tierra Amarilla Elementary School NM (106d 32m 59s West, 36d 42m 1s North) 6591450: Tierra Amarilla Historic District NM (106d 32m 59s West, 36d 42m 1s North) 6118282: Tierra Amarilla Historical Marker NM (106d 32m 59s West, 36d 42m 1s North) 6388117: Tierra Amarilla Middle School NM (106d 32m 59s West, 36d 42m 1s North) 6889066: Tierra Amarilla Post Office NM (106d 32m 59s West, 36d 42m 1s North) 7544781: Tierra Amarilla Volunteer Fire Department NM (106d 33m 31s West, 36d 42m 38s North) 6214003: Tierra Amarilla Weather Station NM (106d 32m 59s West, 36d 42m 1s North) 5463058: Water Well 2 NM (106d 33m 22s West, 36d 42m 5s North) -------------------------------------------------------------------------------- Command 15: what_is_in 351018N 1034330W 15 15 The following 40 features were found in (103d 43m 30s West +/- 15, 35d 10m 18s North +/- 15) 6298397: Baca-Goodman House Historic Site NM (103d 43m 30s West, 35d 10m 18s North) 2298252: Bethel Tabernacle NM (103d 43m 30s West, 35d 10m 18s North) 2306145: Center Saint United Methodist Church NM (103d 43m 30s West, 35d 10m 18s North) 4686849: Christian Science Services Church NM (103d 43m 30s West, 35d 10m 18s North) 2300250: Church of Christ NM (103d 43m 30s West, 35d 10m 18s North) 2300118: Church of Christ Scientist NM (103d 43m 30s West, 35d 10m 18s North) 2250068: Church of God NM (103d 43m 30s West, 35d 10m 18s North) 2299990: Church of the Nazarene NM (103d 43m 30s West, 35d 10m 18s North) 6816940: Douglas Post Office (historical) NM (103d 43m 28s West, 35d 10m 18s North) 2238903: First Assembly of God Church NM (103d 43m 30s West, 35d 10m 18s North) 2236869: First Baptist Church NM (103d 43m 30s West, 35d 10m 18s North) 2236995: First Christian Church NM (103d 43m 30s West, 35d 10m 18s North) 4693166: First Church of the Nazarene NM (103d 43m 30s West, 35d 10m 18s North) 2237123: First Presbyterian Church NM (103d 43m 30s West, 35d 10m 18s North) 2238769: First Spanish Baptist Church NM (103d 43m 30s West, 35d 10m 18s North) 2238635: Full Gospel Grace Tabernacle NM (103d 43m 30s West, 35d 10m 18s North) 583370: Granger School NM (103d 43m 41s West, 35d 10m 13s North) 4670442: Kingdom Hall NM (103d 43m 30s West, 35d 10m 18s North) 2306287: Mount Calvary Baptist Church NM (103d 43m 30s West, 35d 10m 18s North) 2298122: Primitive Baptist Church NM (103d 43m 30s West, 35d 10m 18s North) 6416511: Quay County Courthouse Historic Site NM (103d 43m 30s West, 35d 10m 18s North) 4811107: Rayo Del Luz Baptist Church NM (103d 43m 30s West, 35d 10m 18s North) 6409229: Rock Island-Southern Pacific Passenger Depot Historic Site NM (103d 43m 30s West, 35d 10m 18s North) 5819240: Rural Bookmobile East Library NM (103d 43m 30s West, 35d 10m 18s North) 2334493: Saint Annes Catholic Church NM (103d 43m 30s West, 35d 10m 18s North) 2304436: Saint Michael Episcopal Church NM (103d 43m 30s West, 35d 10m 18s North) 2334359: Seventh Day Adventist Church NM (103d 43m 30s West, 35d 10m 18s North) 2297874: Temple Baptist NM (103d 43m 30s West, 35d 10m 18s North) 6377456: Temple Baptist Academy NM (103d 43m 30s West, 35d 10m 18s North) 2255970: The Church of Jesus Christ of Latter Day Saints NM (103d 43m 30s West, 35d 10m 18s North) 2297994: Trinity Baptist Church NM (103d 43m 30s West, 35d 10m 18s North) 4151646: Tucumcari NM (103d 43m 30s West, 35d 10m 18s North) 5835135: Tucumcari Area Vocational School Library NM (103d 43m 30s West, 35d 10m 18s North) 2188288: Tucumcari Area vocational School NM (103d 43m 30s West, 35d 10m 18s North) 3994731: Tucumcari High School NM (103d 43m 30s West, 35d 10m 18s North) 6207470: Tucumcari Historical Marker NM (103d 43m 30s West, 35d 10m 18s North) 5843914: Tucumcari Historical Research Institute NM (103d 43m 30s West, 35d 10m 18s North) 6401052: Tucumcari Junior High School NM (103d 43m 30s West, 35d 10m 18s North) 6815430: Tucumcari Post Office NM (103d 43m 30s West, 35d 10m 18s North) 4668036: United Pentecostal Church NM (103d 43m 30s West, 35d 10m 18s North) -------------------------------------------------------------------------------- Command 16: what_is_in 354929N 1055845W 30 30 The following 4 features were found in (105d 58m 45s West +/- 30, 35d 49m 29s North +/- 30) 2557172: Camel Rock NM (105d 58m 45s West, 35d 49m 29s North) 5351777: Camel Rock 1 Water Well NM (105d 58m 50s West, 35d 49m 40s North) 7489617: Camel Rock Casino NM (105d 58m 25s West, 35d 49m 18s North) 4976251: Water Well 2 NM (105d 58m 54s West, 35d 49m 30s North) -------------------------------------------------------------------------------- Command 17: what_is_in -long 354929N 1055845W 30 30 The following 4 features were found in (105d 58m 45s West +/- 30, 35d 49m 29s North +/- 30) Feature ID : 904308 Feature Name : Camel Rock Feature Cat : Pillar State : NM County : Santa Fe Longitude : 105d 58m 45s West Latitude : 35d 49m 29s North Elev in ft : 6325 USGS Quad : Tesuque Date created : 11/13/1980 Feature ID : 925587 Feature Name : Camel Rock 1 Water Well Feature Cat : Well State : NM County : Santa Fe Longitude : 105d 58m 50s West Latitude : 35d 49m 40s North Elev in ft : 6283 USGS Quad : Tesuque Date created : 03/01/1994 Feature ID : 2628400 Feature Name : Camel Rock Casino Feature Cat : Building State : NM County : Santa Fe Longitude : 105d 58m 25s West Latitude : 35d 49m 18s North Elev in ft : 6342 USGS Quad : Tesuque Date created : 05/19/2010 Feature ID : 922593 Feature Name : Water Well 2 Feature Cat : Well State : NM County : Santa Fe Longitude : 105d 58m 54s West Latitude : 35d 49m 30s North Elev in ft : 6263 USGS Quad : Tesuque Date created : 09/01/1993 -------------------------------------------------------------------------------- ; ; Let's check the pool again; we should agree on the top four, although they ; could be in a different order: Command 18: 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| 6298397: 933468|Baca-Goodman House Historic Site|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|08/01/1994| 6207470: 932387|Tucumcari Historical Marker|Park|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 5843914: 929495|Tucumcari Historical Research Institute|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 5835135: 929433|Tucumcari Area Vocational School Library|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| 5819240: 929325|Rural Bookmobile East Library|Building|NM|35|Quay|037|351018N|1034330W|35.171723|-103.7249662|||||1247|4091|Tucumcari|05/01/1994| LRU -------------------------------------------------------------------------------- ; ; Exit Command 19: quit Terminating execution of commands. End time: Mon Mar 26 20:28:04 EDT 2018 --------------------------------------------------------------------------------