units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, AGNCY_TYP = 4, COUNTY = 6 and DES_TP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9412 | 9412 | 9411 | {"type": "MultiPolygon", "coordinates": [[[[-118.325, 33.74497], [-118.32496, 33.74508], [-118.32486, 33.74519], [-118.32456, 33.74533], [-118.32442, 33.74537], [-118.32395, 33.74544], [-118.32322, 33.74543], [-118.3231, 33.74545], [-118.32306, 33.74525], [-118.32227, 33.74479], [-118.32072, 33.74441], [-118.32074, 33.74435], [-118.32074, 33.74405], [-118.32121, 33.74405], [-118.32221, 33.74426], [-118.32253, 33.74419], [-118.32309, 33.74458], [-118.32347, 33.74443], [-118.32349, 33.74426], [-118.32378, 33.74428], [-118.32388, 33.74432], [-118.32395, 33.74437], [-118.32399, 33.74443], [-118.32399, 33.74446], [-118.32372, 33.74453], [-118.32355, 33.7448], [-118.32364, 33.745], [-118.32437, 33.7452], [-118.3247, 33.74515], [-118.3249, 33.74496], [-118.32482, 33.74477], [-118.32486, 33.74475], [-118.32491, 33.74475], [-118.32498, 33.74479], [-118.325, 33.74486], [-118.325, 33.74497]]], [[[-118.32439, 33.74432], [-118.32422, 33.74439], [-118.3242, 33.7443], [-118.32416, 33.74425], [-118.32407, 33.74417], [-118.32392, 33.74413], [-118.32376, 33.74413], [-118.3239, 33.74396], [-118.32439, 33.74432]]]]} | Open Access 1 | 47834 | Frascati Trail | 31776 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 5.92 | Frascati Trail | 0 | Local Recreation Area 3 | 4 | |
9521 | 9521 | 9520 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} | Open Access 1 | 47832 | Colinita Trail | 31775 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 3.136 | Colinita Trail | 0 | Local Recreation Area 3 | 4 | |
9534 | 9534 | 9533 | {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32478, 33.74839], [-118.32442, 33.74859], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.3215, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32037, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.74651], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32235, 33.74655], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} | Open Access 1 | 47835 | Sienna Loop Trail | 31777 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 9.915 | Sienna Loop Trail | 0 | Local Recreation Area 3 | 4 | |
9548 | 9548 | 9547 | {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75138], [-118.31871, 33.75148]]]} | Open Access 1 | 47839 | Lorraine Trail | 31782 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 2.557 | Lorraine Trail | 0 | Local Recreation Area 3 | 4 | |
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
16242 | 16242 | 16241 | {"type": "MultiPolygon", "coordinates": [[[[-118.32493, 34.46206], [-118.3165, 34.46217], [-118.31673, 34.46716], [-118.30797, 34.4671], [-118.30834, 34.47368], [-118.3073, 34.47399], [-118.30707, 34.47431], [-118.29944, 34.47423], [-118.29095, 34.47423], [-118.29036, 34.46695], [-118.29911, 34.46705], [-118.29899, 34.4637], [-118.3033, 34.46372], [-118.30331, 34.46371], [-118.30302, 34.45961], [-118.30302, 34.45872], [-118.29879, 34.45874], [-118.29876, 34.45784], [-118.30301, 34.45782], [-118.30302, 34.45603], [-118.30735, 34.45602], [-118.30743, 34.45419], [-118.30754, 34.45442], [-118.30769, 34.45462], [-118.30781, 34.45473], [-118.30803, 34.45485], [-118.30818, 34.45491], [-118.30834, 34.45494], [-118.30903, 34.45498], [-118.30929, 34.45502], [-118.30953, 34.45513], [-118.30968, 34.45523], [-118.30981, 34.45535], [-118.30996, 34.45557], [-118.31006, 34.45581], [-118.31017, 34.45657], [-118.31024, 34.45681], [-118.31032, 34.45703], [-118.3105, 34.45735], [-118.31065, 34.45755], [-118.31082, 34.45772], [-118.31101, 34.45788], [-118.31689, 34.46109], [-118.31722, 34.4612], [-118.31757, 34.46125], [-118.3178, 34.46125], [-118.31832, 34.4612], [-118.31848, 34.4612], [-118.31872, 34.46126], [-118.31908, 34.46141], [-118.31931, 34.46143], [-118.31947, 34.46142], [-118.31962, 34.46138], [-118.32019, 34.4611], [-118.32035, 34.46104], [-118.32058, 34.461], [-118.32081, 34.46101], [-118.32098, 34.46105], [-118.32113, 34.46112], [-118.32171, 34.46151], [-118.32187, 34.46159], [-118.32203, 34.46164], [-118.32221, 34.46167], [-118.32441, 34.46185], [-118.32465, 34.46192], [-118.32493, 34.46206]]], [[[-118.30086, 34.44875], [-118.29626, 34.44876], [-118.29623, 34.44508], [-118.29843, 34.44508], [-118.29844, 34.44502], [-118.29852, 34.44504], [-118.29863, 34.4451], [-118.29866, 34.44515], [-118.29868, 34.44523], [-118.29866, 34.4455], [-118.29868, 34.44559], [-118.29873, 34.44568], [-118.29884, 34.44583], [-118.29891, 34.44587], [-118.29899, 34.44589], [-118.29908, 34.44589], [-118.29916, 34.44586], [-118.29968, 34.44552], [-118.29985, 34.44543], [-118.29995, 34.4454], [-118.30011, 34.44538], [-118.30024, 34.44538], [-118.30035, 34.44542], [-118.30042, 34.4455], [-118.30044, 34.44557], [-118.30043, 34.44562], [-118.29993, 34.44672], [-118.29988, 34.44689], [-118.29989, 34.44701], [-118.29992, 34.44714], [-118.3, 34.44732], [-118.30011, 34.44747], [-118.30023, 34.44756], [-118.30051, 34.44772], [-118.30058, 34.44777], [-118.30092, 34.44818], [-118.30096, 34.44828], [-118.30097, 34.44843], [-118.30086, 34.44875]]], [[[-118.29955, 34.44144], [-118.29872, 34.44246], [-118.29865, 34.44259], [-118.29858, 34.44279], [-118.29841, 34.44299], [-118.2984, 34.44193], [-118.29864, 34.44175], [-118.29897, 34.44144], [-118.29955, 34.44144]]], [[[-118.30293, 34.44875], [-118.30107, 34.44875], [-118.30114, 34.44853], [-118.30117, 34.4484], [-118.30115, 34.44823], [-118.3011, 34.4481], [-118.30102, 34.44799], [-118.30077, 34.4477], [-118.30067, 34.44761], [-118.30039, 34.44745], [-118.30024, 34.44734], [-118.30017, 34.44723], [-118.30008, 34.44697], [-118.30009, 34.44687], [-118.30011, 34.44678], [-118.30063, 34.44565], [-118.30064, 34.44552], [-118.30059, 34.44541], [-118.30048, 34.44529], [-118.30035, 34.44523], [-118.30025, 34.44522], [-118.30003, 34.44522], [-118.29989, 34.44524], [-118.29968, 34.44531], [-118.29907, 34.44571], [-118.299, 34.44572], [-118.29897, 34.4457], [-118.29886, 34.44551], [-118.29888, 34.44518], [-118.29885, 34.44509], [-118.29881, 34.44503], [-118.29874, 34.44496], [-118.29866, 34.44491], [-118.29843, 34.44485], [-118.29842, 34.44384], [-118.29853, 34.44381], [-118.2986, 34.44374], [-118.29864, 34.44363], [-118.29861, 34.44352], [-118.29849, 34.44326], [-118.29848, 34.44321], [-118.2985, 34.44316], [-118.29873, 34.44291], [-118.29879, 34.4428], [-118.29885, 34.44262], [-118.2989, 34.44253], [-118.29979, 34.44144], [-118.30283, 34.44143], [-118.30285, 34.44496], [-118.30293, 34.44875]]], [[[-118.29988, 34.45603], [-118.29867, 34.45604], [-118.29861, 34.4544], [-118.29981, 34.4544], [-118.29988, 34.45603]]], [[[-118.32511, 34.46196], [-118.32475, 34.46178], [-118.3246, 34.46172], [-118.32444, 34.46169], [-118.32225, 34.46151], [-118.32207, 34.46147], [-118.32183, 34.46138], [-118.32134, 34.46105], [-118.32118, 34.46095], [-118.32101, 34.46089], [-118.32083, 34.46085], [-118.32054, 34.46084], [-118.32026, 34.46089], [-118.32009, 34.46096], [-118.31953, 34.46123], [-118.31934, 34.46127], [-118.31915, 34.46125], [-118.31873, 34.46109], [-118.31847, 34.46104], [-118.3183, 34.46103], [-118.31767, 34.46109], [-118.31744, 34.46107], [-118.31722, 34.46102], [-118.317, 34.46095], [-118.3168, 34.46085], [-118.31117, 34.45778], [-118.31099, 34.45763], [-118.31083, 34.45747], [-118.31069, 34.45728], [-118.31051, 34.45698], [-118.31043, 34.45677], [-118.31037, 34.45655], [-118.31028, 34.45589], [-118.31023, 34.45571], [-118.31012, 34.45546], [-118.31001, 34.4553], [-118.30988, 34.45517], [-118.30974, 34.45505], [-118.30958, 34.45495], [-118.30932, 34.45485], [-118.30904, 34.45481], [-118.30839, 34.45478], [-118.30817, 34.45473], [-118.30804, 34.45467], [-118.30792, 34.45458], [-118.30781, 34.45448], [-118.30772, 34.45436], [-118.30744, 34.45375], [-118.3075, 34.45246], [-118.30747, 34.45144], [-118.31176, 34.45132], [-118.31178, 34.45223], [-118.31604, 34.452], [-118.31637, 34.45913], [-118.32481, 34.45873], [-118.32511, 34.46196]]], [[[-118.33441, 34.46314], [-118.33439, 34.46541], [-118.32983, 34.46533], [-118.32965, 34.46398], [-118.33071, 34.46324], [-118.3306, 34.46304], [-118.33441, 34.46314]]]]} | Open Access 1 | 46241 | Rio Dulce Open Space | 33246 | 2390 | Santa Clarita Watershed Recreation and Conservation Authority 776 | Special District 4 | Recreation/Parks District 4 | http://smmc.ca.gov/SCWRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1015.301 | Rio Dulce OS | 2012 | 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]);