← All datasets

# curated.facility_fire_stations
HFD fire stations (94, including 4 airport stations) (94 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 94/94 | e.g.: 75; 13; 93
- attrs->>'ADDRESS' | string | 94/94 | e.g.: 8675 CLINTON DR; 14300 BRIAR FOREST DR; 8602 BISSONNET ST
- attrs->>'Admin' | string | 94/24 | e.g.: 34; 4; 78
- attrs->>'DC' | number | 94/22 | e.g.: 20; 102; 5
- attrs->>'DISTANCE' | null | 93/22 | e.g.: 22848; 34371; 13690
- attrs->>'DIST_STA' | string | 93/2 | values:  ; Y
- attrs->>'ENG' | null | 93/1 | values:  
- attrs->>'FEATURE_CL' | number | 93/1 | values: 2
- attrs->>'IN_DIST' | number | 94/22 | e.g.: 64; 20; 102
- attrs->>'LABEL' | number | 94/94 | e.g.: 75; 96; 13
- attrs->>'LADDERS' | null | 93/2 | values: N; Y
- attrs->>'LastUpdate' | string | 94/2 | values: 4/30/2015 10:25:49 AM; 4/30/2015 10:27:46 AM
- attrs->>'LAT' | number | 94/94 | e.g.: 29.715663; 29.59017196; 29.80279493
- attrs->>'LAYER' | number | 93/1 | values: 93
- attrs->>'LONG' | number | 94/94 | e.g.: -95.60602298; -95.39000992; -95.49011283
- attrs->>'NOTES' | string | 94/15 | e.g.: 110202_TAN_EditedPosition; AddressEdited; TAN_AddressEdited
- attrs->>'TAC_assign' | number | 93/3 | values: 2; 4; 3
- attrs->>'TEXT_' | string | 94/94 | e.g.: 75; 96; 13
- attrs->>'Tool' | string | 94/1 | values: Editor_Editor_EditTool
- attrs->>'Version' | string | 94/1 | values: TNOYES.V_NOYES
- attrs->>'X_COORD' | number | 94/94 | e.g.: 3126707.91179071; 3158418.13183472; 3174167.11378814
- attrs->>'Y_COORD' | number | 94/94 | e.g.: 13873557.77503572; 13808161.14500248; 13826885.94482315
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.