units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 3 sorted by DES_TP
This data as json, copyable, CSV (advanced)
MNG_AGENCY 4
DES_TP 3
- Local Other or Unknown 4
- None 1
- None 1
MNG_AG_TYP 1
- County Agency · 6 ✖
ACCESS_TYP 1
- No Public Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7421 | 7421 | 7420 | {"type": "MultiPolygon", "coordinates": [[[[-117.03935, 32.56205], [-117.03896, 32.56244], [-117.03867, 32.56267], [-117.0382, 32.563], [-117.03798, 32.56312], [-117.03799, 32.56315], [-117.03687, 32.56394], [-117.03653, 32.56411], [-117.03624, 32.56419], [-117.03603, 32.56422], [-117.0356, 32.56422], [-117.03527, 32.56414], [-117.03507, 32.56405], [-117.03489, 32.56394], [-117.03478, 32.56389], [-117.03462, 32.56384], [-117.03447, 32.56381], [-117.03419, 32.56381], [-117.0341, 32.56383], [-117.03301, 32.56389], [-117.03268, 32.56395], [-117.03246, 32.56402], [-117.03233, 32.56408], [-117.03243, 32.56189], [-117.03219, 32.55451], [-117.03357, 32.55452], [-117.03369, 32.55819], [-117.03658, 32.55822], [-117.03665, 32.56184], [-117.03935, 32.56184], [-117.03935, 32.56205]], [[-117.03532, 32.56185], [-117.03521, 32.56166], [-117.03511, 32.5616], [-117.03493, 32.56161], [-117.03517, 32.56209], [-117.03524, 32.56207], [-117.0353, 32.56197], [-117.03527, 32.56192], [-117.03532, 32.56185]]], [[[-117.03934, 32.56405], [-117.03934, 32.56405], [-117.03714, 32.56405], [-117.0382, 32.56327], [-117.03934, 32.56308], [-117.03934, 32.56405]]], [[[-117.03935, 32.56227], [-117.03935, 32.56266], [-117.03899, 32.56267], [-117.03898, 32.56259], [-117.03935, 32.56227]]]]} | No Public Access 3 | 47593 | Furby-North Property | 31320 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 89.107 | Furby-North Property | 0 | Local Other or Unknown 14 | 4 | |
13013 | 13013 | 13012 | {"type": "MultiPolygon", "coordinates": [[[[-121.91526, 38.26143], [-121.91525, 38.26144], [-121.91516, 38.26502], [-121.90682, 38.27189], [-121.89801, 38.2782], [-121.89805, 38.27195], [-121.89805, 38.26472], [-121.87929, 38.26469], [-121.87927, 38.27171], [-121.87387, 38.27167], [-121.87397, 38.27128], [-121.87929, 38.26469], [-121.89614, 38.24998], [-121.89617, 38.24991], [-121.89819, 38.24991], [-121.89826, 38.24289], [-121.91522, 38.24301], [-121.91521, 38.25733], [-121.91525, 38.26116], [-121.91523, 38.26117], [-121.91526, 38.26143]]], [[[-121.91491, 38.27353], [-121.91447, 38.28644], [-121.90677, 38.28644], [-121.89698, 38.28637], [-121.90575, 38.28009], [-121.90633, 38.27971], [-121.91491, 38.27353]]]]} | No Public Access 3 | 31205 | Wilcox Ranch | 27494 | 344 | Solano, County of 1037 | County 3 | County Agency 3 | http://www.co.solano.ca.us/depts/rm/countypark/homepage.asp | County 3 | 344 | Solano, County of 999 | County 3 | County Agency 3 | Solano 26 | 1870.595 | Wilcox Ranch | 0 | Local Other or Unknown 14 | 4 | |
13225 | 13225 | 13224 | {"type": "Polygon", "coordinates": [[[-117.12022, 33.25594], [-117.11798, 33.25608], [-117.11133, 33.25648], [-117.11148, 33.25634], [-117.11161, 33.25629], [-117.11177, 33.25622], [-117.11191, 33.25612], [-117.11201, 33.25602], [-117.11211, 33.256], [-117.11224, 33.25577], [-117.11221, 33.25567], [-117.11279, 33.25455], [-117.11293, 33.25435], [-117.11314, 33.25414], [-117.11321, 33.25417], [-117.11343, 33.25402], [-117.11339, 33.25397], [-117.11357, 33.25388], [-117.11582, 33.25311], [-117.1161, 33.25299], [-117.11637, 33.25284], [-117.12005, 33.2528], [-117.12022, 33.25594]]]} | No Public Access 3 | 45242 | Old Castle Mitigation Area | 23082 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 58.565 | Old Castle Mitigation Area | 0 | Local Other or Unknown 14 | 4 | |
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
10153 | 10153 | 10152 | {"type": "MultiPolygon", "coordinates": [[[[-122.29059, 38.19681], [-122.29041, 38.19715], [-122.29034, 38.19712], [-122.29051, 38.19678], [-122.29059, 38.19681]]], [[[-122.29191, 38.20038], [-122.29055, 38.20043], [-122.2914, 38.20204], [-122.29027, 38.20392], [-122.28486, 38.20226], [-122.28426, 38.20202], [-122.28598, 38.20205], [-122.28594, 38.20041], [-122.28621, 38.20041], [-122.28668, 38.1989], [-122.2867, 38.19724], [-122.28864, 38.19723], [-122.28862, 38.19828], [-122.28863, 38.19829], [-122.28948, 38.19828], [-122.2895, 38.19722], [-122.29003, 38.19722], [-122.29029, 38.19732], [-122.29035, 38.19736], [-122.29043, 38.19746], [-122.29124, 38.19913], [-122.29191, 38.20038]]], [[[-122.29464, 38.2057], [-122.2895, 38.2074], [-122.28904, 38.20603], [-122.28981, 38.20478], [-122.2898, 38.20476], [-122.28893, 38.20603], [-122.28875, 38.20556], [-122.28109, 38.20701], [-122.28354, 38.20197], [-122.28383, 38.20197], [-122.28443, 38.20222], [-122.28523, 38.2025], [-122.29025, 38.20409], [-122.29024, 38.20413], [-122.29464, 38.2057]]], [[[-122.27809, 38.20598], [-122.28047, 38.2056], [-122.28031, 38.20701], [-122.27844, 38.2073], [-122.26729, 38.20941], [-122.26593, 38.2095], [-122.26542, 38.20875], [-122.2652, 38.20834], [-122.27809, 38.20598]]], [[[-122.27938, 38.22578], [-122.27823, 38.22816], [-122.27804, 38.22835], [-122.27662, 38.22843], [-122.27572, 38.22842], [-122.27301, 38.22761], [-122.27312, 38.22738], [-122.27323, 38.2274], [-122.27442, 38.22463], [-122.27452, 38.22466], [-122.27493, 38.22383], [-122.27552, 38.22469], [-122.27938, 38.22578]]]]} | No Public Access 3 | 17693 | Napa Airport Clear Zone | 22628 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 240.442 | Napa Airport Clear Zone | 0 | None 881 | ||
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.819 | Casa Del Caballero | None 1306 |
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]);