Database and Spatial Versions
This script retrieves the database and spatial versions that are in the Soils database.
Text highlighted in yellow in the example script can be changed for a particular area, or you can use wildcards to get an entire State. Examples can be found on the Tips page.
Tips Page
Copy and paste the script below into the query page on the Soil Data Access site.
Soil Data Access Query Page
Example Script
SELECT sc.areasymbol AS Survey_symbol, sc.areaname AS Survey_name, saversion AS Database_version,
saverest AS Database_date, spatialversion AS Spatial_version, spatialverest AS Spatial_version_date
FROM sacatalog AS sc
INNER JOIN saspatialver AS sp ON sc.areasymbol=sp.areasymbol
WHERE sc.areasymbol LIKE
'HI%'
ORDER BY spatialverest DESC
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
Survey_symbol |
Survey_name |
Database_version |
Database_date |
Spatial_version |
Spatial_version_date |
|
HI701 |
Hawaii Volcanoes National Park, Hawaii |
6 |
9/20/2016 10:39:55 PM |
2 |
12/17/2013 8:35:26 PM |
|
HI990 |
Island of Oahu, Hawaii |
11 |
9/22/2016 9:49:17 PM |
2 |
12/7/2013 2:36:46 AM |
|
HI970 |
Island of Lanai, Hawaii |
11 |
9/20/2016 10:45:41 PM |
2 |
12/6/2013 5:18:53 AM |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.