; 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: Log07.txt Start time: Wed Apr 01 22:34:28 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: 138600 -396000 -367200 109800 -------------------------------------------------------------------------------- ; ; Import a large DB file: Command 1: import NM_All.txt Imported Features by name: 57295 Longest probe sequence: 32 Imported Locations: 54760 -------------------------------------------------------------------------------- ; ; 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, some with modifiers: Command 14: what_is_in 364201N 1063259W 60 60 The following 20 features were found in (1063259W +/- 60, 364201N +/- 60) 7481252: Tierra Amarilla Census Designated Place NM 364221N 1063354W 1563133: La Canada Ditch NM 364249N 1063250W 7504558: La Clinica Emergency Medical Services NM 364242N 1063344W 7544781: Tierra Amarilla Volunteer Fire Department NM 364238N 1063331W 1402686: Tierra Amarilla Ditch NM 364148N 1063251W 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 7231328: Tierra Amarilla Division NM 364113N 1063324W -------------------------------------------------------------------------------- Command 15: what_is_in -c 351018N 1034330W 15 15 40 features were found in (1034330W +/- 15, 351018N +/- 15) -------------------------------------------------------------------------------- Command 16: 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 17: 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 -------------------------------------------------------------------------------- Command 18: what_is_in -l 354929N 1055845W 30 30 The following 4 features were found in (1055845W +/- 30, 354929N +/- 30) Feature ID : 904308 Feature Name : Camel Rock Feature Cat : Pillar State : NM County : Santa Fe Latitude : 354929N Longitude : 1055845W Elev in ft : 6325 USGS Quad : Tesuque Date created : 11/13/1980 Feature ID : 922593 Feature Name : Water Well 2 Feature Cat : Well State : NM County : Santa Fe Latitude : 354930N Longitude : 1055854W Elev in ft : 6263 USGS Quad : Tesuque Date created : 09/01/1993 Feature ID : 925587 Feature Name : Camel Rock 1 Water Well Feature Cat : Well State : NM County : Santa Fe Latitude : 354940N Longitude : 1055850W 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 Latitude : 354918N Longitude : 1055825W Elev in ft : 6342 USGS Quad : Tesuque Date created : 05/19/2010 -------------------------------------------------------------------------------- ; ; Let's check the pool again; we should agree on the top four, although they ; could be in a different order: Command 19: 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 -------------------------------------------------------------------------------- ; ; Exit Command 20: quit Terminating execution of commands. End time: Wed Apr 01 22:34:41 EDT 2015 --------------------------------------------------------------------------------