units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Leo A. Carrillo and Edith Carrillo Memorial Park" and MNG_AG_TYP = 6 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15046 | 15046 | 15045 | {"type": "Polygon", "coordinates": [[[-118.90651, 34.06383], [-118.90262, 34.06382], [-118.90264, 34.06738], [-118.89828, 34.06737], [-118.89828, 34.06378], [-118.89646, 34.06375], [-118.8968, 34.06351], [-118.89691, 34.06336], [-118.89695, 34.0632], [-118.89689, 34.0625], [-118.89697, 34.06222], [-118.89718, 34.06196], [-118.89827, 34.06243], [-118.89828, 34.06118], [-118.89984, 34.06168], [-118.89985, 34.06167], [-118.89983, 34.05809], [-118.89774, 34.0581], [-118.89778, 34.05804], [-118.89781, 34.05797], [-118.8978, 34.05785], [-118.89775, 34.05778], [-118.89768, 34.05772], [-118.89755, 34.05768], [-118.89745, 34.05769], [-118.89736, 34.05772], [-118.89703, 34.05794], [-118.89733, 34.05746], [-118.89756, 34.05695], [-118.89758, 34.05686], [-118.89757, 34.05676], [-118.89749, 34.05663], [-118.89709, 34.05627], [-118.89694, 34.05607], [-118.89696, 34.05605], [-118.8969, 34.05598], [-118.89675, 34.05591], [-118.89663, 34.0559], [-118.89652, 34.05591], [-118.8968, 34.05557], [-118.89685, 34.0556], [-118.8969, 34.05557], [-118.89712, 34.05553], [-118.89739, 34.05543], [-118.89752, 34.0554], [-118.89795, 34.05533], [-118.89798, 34.05538], [-118.89815, 34.05533], [-118.89831, 34.05522], [-118.89853, 34.05493], [-118.89867, 34.05483], [-118.89864, 34.05478], [-118.89878, 34.05465], [-118.89886, 34.05449], [-118.89887, 34.05437], [-118.89883, 34.05421], [-118.89876, 34.0541], [-118.89867, 34.05402], [-118.89862, 34.05406], [-118.89827, 34.05379], [-118.8982, 34.05369], [-118.89799, 34.05327], [-118.89822, 34.05319], [-118.8983, 34.05314], [-118.89835, 34.05306], [-118.89838, 34.05294], [-118.89907, 34.05269], [-118.89911, 34.05275], [-118.89924, 34.05269], [-118.89936, 34.05261], [-118.89946, 34.05251], [-118.89954, 34.05239], [-118.8997, 34.05204], [-118.89973, 34.05182], [-118.89972, 34.05168], [-118.89967, 34.05154], [-118.89953, 34.05124], [-118.89939, 34.05106], [-118.89926, 34.05096], [-118.89883, 34.05068], [-118.89855, 34.05056], [-118.89823, 34.05035], [-118.89811, 34.05014], [-118.89783, 34.04988], [-118.89774, 34.04971], [-118.89772, 34.04953], [-118.89766, 34.04952], [-118.89767, 34.04937], [-118.89761, 34.04936], [-118.8976, 34.04925], [-118.89756, 34.04915], [-118.89749, 34.04906], [-118.89733, 34.04894], [-118.8973, 34.04889], [-118.89719, 34.04848], [-118.89751, 34.04891], [-118.89761, 34.04898], [-118.89769, 34.049], [-118.89782, 34.04899], [-118.8979, 34.04896], [-118.89798, 34.04887], [-118.898, 34.04876], [-118.89795, 34.04866], [-118.89765, 34.0484], [-118.8976, 34.04832], [-118.89757, 34.04833], [-118.8975, 34.04798], [-118.89753, 34.04778], [-118.8976, 34.04764], [-118.89769, 34.04753], [-118.89792, 34.04731], [-118.89798, 34.04723], [-118.89801, 34.04714], [-118.898, 34.04704], [-118.89797, 34.04695], [-118.89772, 34.0466], [-118.89769, 34.0465], [-118.89787, 34.04606], [-118.89791, 34.04606], [-118.89794, 34.04596], [-118.89794, 34.04585], [-118.89797, 34.04584], [-118.89797, 34.04578], [-118.89793, 34.04567], [-118.89772, 34.04537], [-118.89714, 34.04477], [-118.89702, 34.04461], [-118.8969, 34.04435], [-118.89685, 34.04405], [-118.89725, 34.04406], [-118.89717, 34.04396], [-118.89716, 34.04382], [-118.89731, 34.04365], [-118.89717, 34.04349], [-118.8973, 34.04302], [-118.89729, 34.042], [-118.89966, 34.04232], [-118.89936, 34.04392], [-118.90586, 34.0448], [-118.90584, 34.06359], [-118.90651, 34.06383]]]} | Open Access 1 | 45710 | Leo A. Carrillo and Edith Carrillo Memorial Park | 29639 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 425.464 | Leo A. Carrillo and Edith Carrillo Memorial Park | 0 | Local Park 2 | 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]);