Schema
Local Emergency Operations Center (EOC) / Local Emergency Operations Center (EOC) / v1.0.0
Schema from local-emergency-operations-center-eoc.parquet, gcp-portolan-published, v1.0.0.
HSIP Local Emergency Operations Centers in the United States "The physical location at which the coordination of information and resources to support domestic incident management activities normally takes place. An Emergency Operations Center may be a temporary facility or may be located in a more central or permanently established facility, perhaps at a higher level of organization within a jurisdiction. Emergency Operations Centers may be organized by major functional disciplines (e.g., fire, law enforcement, and medical services), by jurisdiction (e.g., Federal, State, regional, county, city, tribal), or some combination thereof." (Excerpted from the National Incident Management System) The GFI source for this layer contains State and Federal Emergency Operations Centers in addition to local Emergency Operations Centers. This dataset contains these features as well. In cases where an Emergency Operations Center has a mobile unit, TechniGraphics captured the location of the mobile unit as a separate record. This record represents where the mobile unit is stored. If this location could not be verified, a point was placed in the approximate center of the Emergency Operations Centers service area. Effort was made by TechniGraphics to verify whether or not each Emergency Operations Center has a generator on-site and whether or not the Emergency Operations Center is located in a basement. This information is indicated by the values in the [GENERATOR] and [BASEMENT] fields respectively. In cases where more than one record existed for a geographical area (e.g., county, city), TechniGraphics verified whether or not one of the records represented an alternate location. This was indicated by appending "-ALTERNATE" to the value in the [NAME] field. Some Emergency Operations Centers are located at private residences. The [TYPE] field was manually evaluated during the delivery process to compare the records in which the [NAME] field contained "-ALTERNATE". In cases where these values contradicted information that was verified by TechniGraphics (e.g. [NAME] contained "-ALTERNATE" and [TYPE] = "PRIMARY"), the value in the [TYPE] field was changed to match the type indicated by the [NAME] of the verified record. TechniGraphics did not change values in this field if the type was not verified. Records with "-DOD" appended to the end of the [NAME] value are located on a military base, as defined by the Defense Installation Spatial Data Infrastructure (DISDI) military installations and military range boundaries. "#" and "*" characters were automatically removed from standard HSIP fields that TechniGraphics populated. Double spaces were replaced by single spaces in these same fields. At the request of NGA, text fields in this dataset have been set to all upper case to facilitate consistent database engine search results. At the request of NGA, 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] field. Based upon this attribute, the oldest record dates from 08/28/2009 and the newest record dates from 11/18/2009.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 5985Length: — | Examples: 2090, 2225, 1615, 26, 4591 Values: — |
| ID | string | No | 0 | — | — Range: —Length: 8 | Examples: 10210669, 10211675, 10210945, 10213703, 10210657 Values: — |
| NAME | string | No | 0 | — | — Range: —Length: 137 | Examples: COLUSA COUNTY EMERGENCY OPERATIONS CENTER, BOYLE COUNTY EMERGENCY OPERATIONS CENTER, REDDING OFFICE OF EMERGENCY OPERATIONS, TROY EMERGENCY OPERATIONS CENTER, MOHAVE COUNTY EMERGENCY OPERATION CENTER Values: — |
| TELEPHONE | string | No | 0 | — | — Range: —Length: 12 | Examples: 530-458-0200, 859-238-1220, 203-938-3400, 603-242-3775, 928-753-0753 Values: — |
| ADDRESS | string | No | 0 | — | — Range: —Length: 47 | Examples: 929 BRIDGE STREET, 801 SOUTH 4TH STREET, 96 HILL ROAD, 4 DEPOT STREET, 600 WEST BEALE STREET Values: — |
| ADDRESS2 | string | No | 0 | — | — Range: —Length: 80 | Examples: COLUSA COUNTY SHERIFFS OFFICE, BASEMENT, REDDING POLICE DEPARTMENT, KIMBALL HALL COMMUNITY CENTER, MOHAVE COUNTY SHERIFFS OFFICE Values: — |
| CITY | string | No | 0 | — | — Range: —Length: 22 | Examples: COLUSA, DANVILLE, REDDING, TROY, KINGMAN Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: CA, KY, CT, NH, AZ Values: — |
| ZIP | string | No | 0 | — | — Range: —Length: 5 | Examples: 95932, 40422, 06896, 03465, 86401 Values: — |
| ZIPP4 | string | Yes | 1 | — | — Range: —Length: 4 | Examples: 1437, 3200, 3986, , 1113 Values: — |
| COUNTY | string | No | 0 | — | — Range: —Length: 21 | Examples: COLUSA, BOYLE, FAIRFIELD, CHESHIRE, MOHAVE Values: — |
| FIPS | string | No | 0 | — | — Range: —Length: 5 | Examples: 06011, 21021, 09001, 33005, 04015 Values: — |
| DIRECTIONS | string | No | 0 | — | — Range: —Length: 246 | Examples: , , , , Values: — |
| EMERGTITLE | string | No | 0 | — | — Range: —Length: 40 | Examples: , , , EMERGENCY MANAGEMENT DIRECTOR (CELL), Values: — |
| EMERGTEL | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , 603-381-4309, Values: — |
| EMERGEXT | string | No | 0 | — | — Range: —Length: 3 | Examples: , , , , Values: , 106 |
| CONTDATE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2009-09-02T00:00:00+00:00, 2009-09-03T00:00:00+00:00, 2009-08-28T00:00:00+00:00, 2009-09-09T00:00:00+00:00, 2009-09-02T00:00:00+00:00 Values: — |
| CONTHOW | string | No | 0 | — | — Range: —Length: 7 | Examples: PHONE, PHONE, PHONE, PHONE, PHONE Values: ALT REF, EMAIL, MAIL, PHONE |
| GEODATE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2009-09-02T00:00:00+00:00, 2009-09-03T00:00:00+00:00, 2009-08-28T00:00:00+00:00, 2009-09-09T00:00:00+00:00, 2009-09-02T00:00:00+00:00 Values: — |
| GEOHOW | string | No | 0 | — | — Range: —Length: 6 | Examples: MANUAL, MANUAL, MANUAL, MANUAL, MANUAL Values: MANUAL |
| HSIPTHEMES | string | No | 0 | — | — Range: —Length: 149 | Examples: CRITICAL INFRASTRUCTURE, PDD-63; EMERGENCY SERVICES AND CONTINUITY OF GOVERNMENT; EMERGENCY MANAGEMENT AND OPERATION CENTERS; STATE AND LOCAL OFFICES, CRITICAL INFRASTRUCTURE, PDD-63; EMERGENCY SERVICES AND CONTINUITY OF GOVERNMENT; EMERGENCY MANAGEMENT AND OPERATION CENTERS; STATE AND LOCAL OFFICES, CRITICAL INFRASTRUCTURE, PDD-63; EMERGENCY SERVICES AND CONTINUITY OF GOVERNMENT; EMERGENCY MANAGEMENT AND OPERATION CENTERS; STATE AND LOCAL OFFICES, CRITICAL INFRASTRUCTURE, PDD-63; EMERGENCY SERVICES AND CONTINUITY OF GOVERNMENT; EMERGENCY MANAGEMENT AND OPERATION CENTERS; STATE AND LOCAL OFFICES, CRITICAL INFRASTRUCTURE, PDD-63; EMERGENCY SERVICES AND CONTINUITY OF GOVERNMENT; EMERGENCY MANAGEMENT AND OPERATION CENTERS; STATE AND LOCAL OFFICES Values: CRITICAL INFRASTRUCTURE, PDD-63; EMERGENCY SERVICES AND CONTINUITY OF GOVERNMENT; EMERGENCY MANAGEMENT AND OPERATION CENTERS; STATE AND LOCAL OFFICES |
| NAICSCODE | string | No | 0 | — | — Range: —Length: 6 | Examples: 922190, 922190, 922190, 922190, 922190 Values: 922190 |
| NAICSDESCR | string | No | 0 | — | — Range: —Length: 53 | Examples: EMERGENCY PLANNING AND MANAGEMENT OFFICES, GOVERNMENT, EMERGENCY PLANNING AND MANAGEMENT OFFICES, GOVERNMENT, EMERGENCY PLANNING AND MANAGEMENT OFFICES, GOVERNMENT, EMERGENCY PLANNING AND MANAGEMENT OFFICES, GOVERNMENT, EMERGENCY PLANNING AND MANAGEMENT OFFICES, GOVERNMENT Values: EMERGENCY PLANNING AND MANAGEMENT OFFICES, GOVERNMENT |
| GEOLINKID | string | No | 0 | — | — Range: —Length: 9 | Examples: 116934697, 778233345, 21473680, 89577412, 122751521 Values: — |
| X | float | No | 0 | — | — Range: -161.7669747 to -67.2864388Length: — | Examples: -122.0032196, -84.7754796, -73.3823758, -72.1838451, -114.064746 Values: — |
| Y | float | No | 0 | — | — Range: 19.715331 to 64.8188184Length: — | Examples: 39.2055961, 37.6329689, 41.3041632, 42.8251034, 35.1898891 Values: — |
| ST_VENDOR | string | No | 0 | — | — Range: —Length: 6 | Examples: NAVTEQ, NAVTEQ, NAVTEQ, NAVTEQ, NAVTEQ Values: NAVTEQ, TGS |
| ST_VERSION | string | No | 0 | — | — Range: —Length: 6 | Examples: 2009Q2, 2009Q2, 2009Q2, 2009Q2, 2009Q2 Values: 2009Q2 |
| GEOPREC | string | No | 0 | — | — Range: —Length: 11 | Examples: ONENTITY, ONENTITY, ONENTITY, ONENTITY, ONENTITY Values: APPROXIMATE, ONENTITY |
| PHONELOC | string | No | 0 | — | — Range: —Length: 3 | Examples: YES, YES, YES, YES, YES Values: , NO, YES |
| QC_QA | string | No | 0 | — | — Range: —Length: 3 | Examples: TGS, TGS, TGS, TGS, TGS Values: TGS |
| GENERATOR | string | No | 0 | — | — Range: —Length: 1 | Examples: Y, Y, Y, Y, Y Values: , N, Y |
| BASEMENT | string | No | 0 | — | — Range: —Length: 1 | Examples: N, Y, N, N, N Values: , N, Y |
| WEBSITE | string | No | 0 | — | — Range: —Length: 100 | Examples: , , , , Values: — |
| TOT_STAFF | float | No | 0 | — | — Range: 0 to 0Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| EOC_CAP | float | No | 0 | — | — Range: 0 to 0Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| HAS_FOOD | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| MED_SUPP | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| AGENONSITE | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: |
| LVLGOVOP | string | No | 0 | — | — Range: —Length: 7 | Examples: COUNTY, COUNTY, LOCAL, LOCAL, COUNTY Values: COUNTY, FEDERAL, LOCAL |
| FAX | string | No | 0 | — | — Range: —Length: 13 | Examples: , 859-239-0003, , , Values: — |
| SOURCE | string | No | 0 | — | — Range: —Length: 9 | Examples: CAOES, KYDEM, CTDEMHS, NHDOT, TAMU Values: — |
| STATE_ID | string | No | 0 | — | — Range: —Length: 24 | Examples: , , , , Values: — |
| string | No | 0 | — | — Range: —Length: 44 | Examples: , , , , Values: — | |
| CONT1PHONE | string | No | 0 | — | — Range: —Length: 13 | Examples: , , , , Values: — |
| CONT1EXT | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , , Values: , 101, 17, 202, 2101, 215, 222, 312, 4345, 48, 8447 |
| CONT1FAX | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: — |
| CONT1EMAIL | string | No | 0 | — | — Range: —Length: 30 | Examples: , , , , Values: — |
| CONT2PHONE | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: — |
| CONT2EXT | string | No | 0 | — | — Range: —Length: 3 | Examples: , , , , Values: , 135, 203 |
| CELL | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: — |
| CELL2 | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: , 505-320-1683, 505-740-0564, 505-770-8781, 505-975-2312 |
| PAGER | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: — |
| PAGER_EXT | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , , Values: , 0234, 0880, 1806, 2772, 2871, 6560, 9590, 9869 |
| OTHER | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: , 505-437-7412, 505-756-4526, 505-758-7253, 505-760-4799, 505-771-6730, 505-786-2012 |
| OTHER2 | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: , 928-871-6581 |
| DISPATCH | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: — |
| POCPHONE | string | No | 0 | — | — Range: —Length: 12 | Examples: , , , , Values: — |
| COMMENTS | string | No | 0 | — | — Range: —Length: 247 | Examples: , , , , Values: — |
| REGION | string | No | 0 | — | — Range: —Length: 2 | Examples: , , , , Values: , 1, 2, 3, 4, 5, 6, 7, 8, 9, M, NE, NW, SE, SW, WC |
| TYPE | string | No | 0 | — | — Range: —Length: 9 | Examples: , , , , Values: , ALTERNATE, PRIMARY |
| PERMANENT_ | string | No | 0 | — | — Range: —Length: 3 | Examples: , , , , Values: , NO, YES |
| CLASS | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , , Values: , EFEO |
| COVERAGE | string | No | 0 | — | — Range: —Length: 13 | Examples: , , , , Values: , COUNTY, LOCAL - LARGE, LOCAL - SMALL |
| RULEID | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
