units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 3 and PARK_URL = "http://www.laparks.org/dos/reccenter/facility/hansendamRC.htm"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 1 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16795 | 16795 | 16794 | {"type": "MultiPolygon", "coordinates": [[[[-118.35638, 34.26783], [-118.35593, 34.26829], [-118.35584, 34.26829], [-118.35537, 34.2677], [-118.35638, 34.26783]]], [[[-118.40076, 34.26685], [-118.3982, 34.26992], [-118.39688, 34.27114], [-118.39396, 34.27326], [-118.39345, 34.27322], [-118.39305, 34.27306], [-118.39242, 34.27288], [-118.39167, 34.27275], [-118.39148, 34.27273], [-118.3913, 34.27261], [-118.39115, 34.27271], [-118.39048, 34.27273], [-118.3895, 34.27285], [-118.38271, 34.27375], [-118.38204, 34.27395], [-118.38165, 34.27413], [-118.38166, 34.27415], [-118.38199, 34.27411], [-118.38149, 34.27448], [-118.37505, 34.27381], [-118.37326, 34.27372], [-118.3728, 34.27074], [-118.37311, 34.26911], [-118.37307, 34.26894], [-118.37297, 34.26886], [-118.3728, 34.26881], [-118.3725, 34.26887], [-118.36836, 34.26898], [-118.36556, 34.26923], [-118.36779, 34.27246], [-118.3682, 34.27267], [-118.3682, 34.27331], [-118.36827, 34.27335], [-118.36339, 34.27298], [-118.36215, 34.27292], [-118.36205, 34.27265], [-118.36168, 34.27244], [-118.36149, 34.27222], [-118.36028, 34.27139], [-118.35844, 34.27155], [-118.35617, 34.26871], [-118.35695, 34.26791], [-118.35827, 34.26807], [-118.35863, 34.26622], [-118.36449, 34.26628], [-118.36534, 34.26618], [-118.36553, 34.26608], [-118.36603, 34.26587], [-118.36643, 34.26563], [-118.36663, 34.26571], [-118.36732, 34.26584], [-118.36782, 34.26584], [-118.36997, 34.26526], [-118.36978, 34.2624], [-118.37166, 34.25994], [-118.37265, 34.25872], [-118.37328, 34.25818], [-118.3738, 34.25783], [-118.37343, 34.25859], [-118.37343, 34.25862], [-118.37506, 34.25861], [-118.37614, 34.2584], [-118.37725, 34.25823], [-118.37816, 34.25822], [-118.37936, 34.25812], [-118.38042, 34.25817], [-118.38262, 34.25846], [-118.38325, 34.25843], [-118.38394, 34.2583], [-118.38448, 34.25843], [-118.38587, 34.25895], [-118.3865, 34.2579], [-118.38713, 34.25817], [-118.38665, 34.259], [-118.3866, 34.26034], [-118.38666, 34.26042], [-118.38925, 34.26121], [-118.3894, 34.26086], [-118.39031, 34.26113], [-118.39073, 34.26043], [-118.39103, 34.26066], [-118.39148, 34.26078], [-118.39335, 34.2618], [-118.39344, 34.2618], [-118.3935, 34.26157], [-118.3954, 34.26242], [-118.39631, 34.26249], [-118.39746, 34.26329], [-118.39782, 34.26398], [-118.39843, 34.26433], [-118.39897, 34.26483], [-118.39946, 34.26558], [-118.39988, 34.26605], [-118.40076, 34.26685]]], [[[-118.39867, 34.27251], [-118.39763, 34.27327], [-118.39688, 34.27256], [-118.3959, 34.27251], [-118.39568, 34.27231], [-118.39725, 34.27116], [-118.39867, 34.27251]]], [[[-118.40091, 34.26912], [-118.40073, 34.26966], [-118.40042, 34.27118], [-118.40039, 34.27126], [-118.39882, 34.2724], [-118.39739, 34.27105], [-118.3978, 34.2707], [-118.39826, 34.27023], [-118.39995, 34.26822], [-118.40091, 34.26912]]], [[[-118.4014, 34.26764], [-118.40094, 34.26903], [-118.40001, 34.26815], [-118.40119, 34.26673], [-118.4014, 34.26764]]]]} | Open Access 1 | 1374 | Hansen Dam Recreation Area | 30957 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/reccenter/facility/hansendamRC.htm | Los Angeles 6 | 1140.78 | Hansen Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);