Schema
Truck Driving Schools / Truck Driving Schools / v1.0.0
Schema from truck-driving-schools.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
Truck Driving Schools in the United States This dataset is composed of any type of Post Secondary Education facility such as: colleges, universities, technical schools, or trade schools that provide training and certification in the field of professional truck driving. This dataset does not include Administration Only locations. No entities located in American Samoa, the Northern Mariana Islands, or the Virgin Islands are included in this dataset. Text fields in this dataset have been set to all upper case to facilitate consistent database engine search results. All diacritics (e.g. the German umlaut or the Spanish tilde) have been replaced with their closest equivalent English character to facilitate use with database systems that may not support diacritics. The currentness of this dataset is indicated by the [CONTDATE] attribute. Based upon this attribute, the oldest record dates from 12/19/2006 and the newest record dates from 1/8/2007.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| NGAID | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| SRCLNKID | string | No | 0 | — | — Range: —Length: 7 | Examples: TDS_793, TDS_764, TDS_287, TDS_673, TDS_339 Values: — |
| METLNKID | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| FEATTYPE | string | No | 0 | — | — Range: —Length: 5 | Examples: POINT, POINT, POINT, POINT, POINT Values: POINT |
| NAME | string | No | 0 | — | — Range: —Length: 119 | Examples: TENNESSEE TECH CENTER-SHELBYVILLE, HORRY-GEORGETOWN TECHNICAL COLLEGE - TRUCK DRIVER TRAINING, GEORGIA DRIVING ACADEMY, SOUTHERN STATE COMMUNITY COLLEGE TRUCK DRIVING ACADEMY- XENIA, SWIFT DRIVING ACADEMY Values: — |
| AREA_ | string | No | 0 | — | — Range: —Length: 3 | Examples: 931, 843, 800, 800, 800 Values: — |
| PHONE | string | No | 0 | — | — Range: —Length: 8 | Examples: 685-2180, 347-3186, 711-4301, 344-6058, 345-3732 Values: — |
| ADDRESS | string | No | 0 | — | — Range: —Length: 42 | Examples: 1405 MADISON STREET, 2050 UNITED STATES HIGHWAY 501 EAST, 1449 VFW DRIVE, 2960 WEST ENON ROAD, 1616 6TH AVENUE N Values: — |
| ADDRESS2 | string | No | 0 | — | — Range: —Length: 38 | Examples: , , , , Values: — |
| CITY | string | No | 0 | — | — Range: —Length: 19 | Examples: SHELBYVILLE, CONWAY, CONYERS, XENIA, LEWISTON Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: TN, SC, GA, OH, ID Values: — |
| ZIP | string | No | 0 | — | — Range: —Length: 5 | Examples: 37160, 29526, 30012, 45385, 83501 Values: — |
| ZIPP4 | string | No | 0 | — | — Range: —Length: 4 | Examples: 3629, , 5237, 8548, 1539 Values: — |
| COUNTY | string | No | 0 | — | — Range: —Length: 20 | Examples: BEDFORD, HORRY, ROCKDALE, GREENE, NEZ PERCE Values: — |
| FIPS | string | No | 0 | — | — Range: —Length: 5 | Examples: 47003, 45051, 13247, 39057, 16069 Values: — |
| DIRECTIONS | string | No | 0 | — | — Range: —Length: 248 | Examples: , LOCATED ON THE SOUTHWEST SIDE OF UNITED STATES HIGHWAY 501 EAST, .10 MILE SOUTHEAST OF THE INTERSECTION OF SC-S-26-953 AND UNITED STATES HIGHWAY 501 EAST., WEST SIDE OF VFW DR 0.09 MILE NORTH OF DOGWOOD DR, LOCATED ON EAST SIDE OF WEST ENON ROAD, 0.40 MI NE OF OH-235., Values: — |
| EMERGTITLE | string | No | 0 | — | — Range: —Length: 18 | Examples: , , , , Values: , DIRECTOR-CELL, WICHITA CO SHERIFF |
| EMERGPHONE | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: , 734-891-5786, 940-766-8170 |
| EMERGEXT | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| CONTDATE | string | Yes | 224 | — | — Range: —Length: 25 | Examples: 2006-12-26T00:00:00+00:00, 2006-12-20T00:00:00+00:00, 2006-12-22T00:00:00+00:00, 2006-12-21T00:00:00+00:00, 2006-12-27T00:00:00+00:00 Values: 2006-12-19T00:00:00+00:00, 2006-12-20T00:00:00+00:00, 2006-12-21T00:00:00+00:00, 2006-12-22T00:00:00+00:00, 2006-12-26T00:00:00+00:00, 2006-12-27T00:00:00+00:00, 2006-12-29T00:00:00+00:00, 2007-01-02T00:00:00+00:00, 2007-01-03T00:00:00+00:00, 2007-01-08T00:00:00+00:00 |
| CONTHOW | string | No | 0 | — | — Range: —Length: 5 | Examples: , PHONE, PHONE, PHONE, Values: , PHONE |
| GEODATE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2006-12-19T00:00:00+00:00, 2006-12-20T00:00:00+00:00, 2006-12-21T00:00:00+00:00, 2006-12-21T00:00:00+00:00, 2006-12-19T00:00:00+00:00 Values: 2006-12-19T00:00:00+00:00, 2006-12-20T00:00:00+00:00, 2006-12-21T00:00:00+00:00, 2006-12-22T00:00:00+00:00, 2006-12-26T00:00:00+00:00, 2006-12-27T00:00:00+00:00, 2006-12-29T00:00:00+00:00, 2007-01-02T00:00:00+00:00, 2007-01-03T00:00:00+00:00, 2007-01-08T00:00:00+00:00 |
| GEOHOW | string | No | 0 | — | — Range: —Length: 6 | Examples: AUTO, MANUAL, MANUAL, MANUAL, AUTO Values: AUTO, MANUAL |
| HSIPTHEMES | string | No | 0 | — | — Range: —Length: 33 | Examples: MISCELLANEOUS; EDUCATION; SCHOOLS, MISCELLANEOUS; EDUCATION; SCHOOLS, MISCELLANEOUS; EDUCATION; SCHOOLS, MISCELLANEOUS; EDUCATION; SCHOOLS, MISCELLANEOUS; EDUCATION; SCHOOLS Values: MISCELLANEOUS; EDUCATION; SCHOOLS |
| NAICSCODE | string | No | 0 | — | — Range: —Length: 6 | Examples: 611519, 611519, 611519, 611519, 611519 Values: 611519 |
| NAICSDESCR | string | No | 0 | — | — Range: —Length: 21 | Examples: TRUCK DRIVING SCHOOLS, TRUCK DRIVING SCHOOLS, TRUCK DRIVING SCHOOLS, TRUCK DRIVING SCHOOLS, TRUCK DRIVING SCHOOLS Values: TRUCK DRIVING SCHOOLS |
| GEOLINKID | string | No | 0 | — | — Range: —Length: 9 | Examples: 115700108, 102090898, 111692672, 111996212, 98995721 Values: — |
| SOURCE | string | No | 0 | — | — Range: —Length: 3 | Examples: TGS, TGS, TGS, TGS, TGS Values: TGS |
| X | float | No | 0 | — | — Range: -157.98600000000002 to -68.03459Length: — | Examples: -86.42372, -79.0032, -84.03541, -83.947, -117.00979 Values: — |
| Y | float | No | 0 | — | — Range: 21.394489999999998 to 71.33003Length: — | Examples: 35.484829999999995, 33.79669, 33.66807, 39.76969, 46.426289999999995 Values: — |
| ST_VENDOR | string | No | 0 | — | — Range: —Length: 6 | Examples: NAVTEQ, NAVTEQ, NAVTEQ, NAVTEQ, NAVTEQ Values: NAVTEQ |
| ST_VERSION | string | No | 0 | — | — Range: —Length: 6 | Examples: 2006Q3, 2006Q3, 2006Q3, 2006Q3, 2006Q3 Values: 2006Q3 |
| GEOPREC | string | No | 0 | — | — Range: —Length: 9 | Examples: BLOCKFACE, BLOCKFACE, BLOCKFACE, BLOCKFACE, BLOCKFACE Values: BLOCKFACE, ONENTITY |
| PHONELOC | string | No | 0 | — | — Range: —Length: 3 | Examples: , YES, YES, NO, Values: , NO, YES |
| QC_QA | string | No | 0 | — | — Range: —Length: 3 | Examples: , TGS, TGS, TGS, Values: , TGS |
