units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "36.363" and MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16252 | 16252 | 16251 | {"type": "MultiPolygon", "coordinates": [[[[-117.96366, 33.97258], [-117.96126, 33.97259], [-117.96126, 33.97247], [-117.9615, 33.97245], [-117.96176, 33.97236], [-117.96197, 33.97222], [-117.96214, 33.97202], [-117.96218, 33.97203], [-117.96226, 33.97185], [-117.96228, 33.97166], [-117.96225, 33.97165], [-117.96223, 33.97147], [-117.96217, 33.97133], [-117.96204, 33.97114], [-117.9622, 33.97105], [-117.96227, 33.97088], [-117.96243, 33.97101], [-117.96266, 33.97101], [-117.9629, 33.97107], [-117.96328, 33.97149], [-117.96366, 33.97258]]], [[[-117.96794, 33.97257], [-117.96656, 33.97258], [-117.96551, 33.97127], [-117.96533, 33.97112], [-117.9648, 33.97082], [-117.96593, 33.97054], [-117.96624, 33.97079], [-117.96645, 33.97069], [-117.96751, 33.97084], [-117.96766, 33.97089], [-117.96776, 33.97088], [-117.96791, 33.97121], [-117.96773, 33.97135], [-117.96722, 33.97149], [-117.96695, 33.97152], [-117.96694, 33.97153], [-117.96794, 33.97257]]], [[[-117.97666, 33.97483], [-117.97401, 33.97407], [-117.96878, 33.97258], [-117.97664, 33.97254], [-117.97666, 33.97483]]]]} | Open Access 1 | 46389 | Arroyo San Miguel Open Space | 29672 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 36.363 | Arroyo San Miguel OS | 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]);