superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_TYP = 4 and YR_EST = 1994
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13747 | 13747 | 13746 | {"type": "MultiPolygon", "coordinates": [[[[-122.73292, 38.36331], [-122.7329, 38.36345], [-122.73137, 38.36624], [-122.73123, 38.36644], [-122.73112, 38.36655], [-122.73092, 38.3667], [-122.7306, 38.36684], [-122.73047, 38.36688], [-122.72932, 38.36712], [-122.72931, 38.36331], [-122.73292, 38.36331]]], [[[-122.73279, 38.3648], [-122.73263, 38.36594], [-122.73211, 38.36694], [-122.73176, 38.36739], [-122.73122, 38.36763], [-122.73104, 38.36765], [-122.73058, 38.36752], [-122.73046, 38.36736], [-122.73085, 38.36726], [-122.73121, 38.36709], [-122.73148, 38.36691], [-122.73165, 38.36676], [-122.73175, 38.36664], [-122.73189, 38.36645], [-122.73279, 38.3648]]]]} | No Public Access 3 | San Francisco Archdiocese | 31255 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 26.415 | San Francisco Archdiocese | 1994 | |
14481 | 14481 | 14480 | {"type": "Polygon", "coordinates": [[[-117.30212, 33.52516], [-117.30028, 33.52911], [-117.29792, 33.53406], [-117.29703, 33.53775], [-117.29677, 33.53867], [-117.29553, 33.54139], [-117.29365, 33.54205], [-117.29295, 33.54294], [-117.28821, 33.54579], [-117.28777, 33.54435], [-117.28727, 33.54342], [-117.2852, 33.54184], [-117.28378, 33.54002], [-117.28222, 33.53975], [-117.27324, 33.54364], [-117.27138, 33.54321], [-117.2717, 33.54223], [-117.27183, 33.54172], [-117.27195, 33.54103], [-117.27201, 33.54033], [-117.27209, 33.53702], [-117.27206, 33.53615], [-117.27192, 33.53432], [-117.27192, 33.53403], [-117.27197, 33.53357], [-117.27205, 33.53314], [-117.27267, 33.53064], [-117.27278, 33.53023], [-117.27298, 33.52969], [-117.27346, 33.52855], [-117.27706, 33.52778], [-117.27748, 33.52772], [-117.27781, 33.5277], [-117.27813, 33.52771], [-117.27977, 33.52793], [-117.28008, 33.52795], [-117.28038, 33.52794], [-117.2804, 33.52793], [-117.2807, 33.5279], [-117.28101, 33.52785], [-117.28201, 33.5276], [-117.28234, 33.52753], [-117.28272, 33.52749], [-117.2831, 33.52748], [-117.28584, 33.5276], [-117.28614, 33.52763], [-117.28646, 33.52768], [-117.28692, 33.52781], [-117.28726, 33.52796], [-117.28882, 33.52881], [-117.28926, 33.529], [-117.28963, 33.5291], [-117.29, 33.52916], [-117.29044, 33.52918], [-117.29083, 33.52916], [-117.29109, 33.52913], [-117.29141, 33.52905], [-117.29181, 33.52892], [-117.29205, 33.52881], [-117.29233, 33.52865], [-117.29254, 33.5285], [-117.29273, 33.52834], [-117.29291, 33.52817], [-117.29315, 33.52786], [-117.2933, 33.52762], [-117.29422, 33.52577], [-117.29437, 33.5255], [-117.29462, 33.52513], [-117.29514, 33.52451], [-117.29576, 33.5249], [-117.29601, 33.525], [-117.2964, 33.52509], [-117.29671, 33.5251], [-117.29697, 33.52508], [-117.29806, 33.52484], [-117.29827, 33.52483], [-117.29844, 33.52484], [-117.29873, 33.52491], [-117.29901, 33.52503], [-117.29924, 33.52519], [-117.29937, 33.52531], [-117.29972, 33.52575], [-117.29988, 33.52589], [-117.30011, 33.52601], [-117.30029, 33.52607], [-117.30048, 33.52609], [-117.30067, 33.5261], [-117.30082, 33.52608], [-117.30097, 33.52604], [-117.30117, 33.52596], [-117.30141, 33.52579], [-117.30185, 33.52533], [-117.30212, 33.52516]]]} | Open Access 1 | Santa Rosa Plateau Ecological Reserve | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | 9398 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 986.338 | Santa Rosa Plateau ER | 1994 |
14768 | 14768 | 14767 | {"type": "Polygon", "coordinates": [[[-122.6294, 37.99579], [-122.62855, 37.99996], [-122.62822, 38.00173], [-122.6276, 38.00522], [-122.62017, 38.01095], [-122.61898, 38.01124], [-122.61833, 38.01117], [-122.61794, 38.01079], [-122.61785, 38.01024], [-122.61771, 38.00996], [-122.61788, 38.0094], [-122.61776, 38.00838], [-122.61685, 38.0075], [-122.61614, 38.00705], [-122.61495, 38.00587], [-122.61456, 38.00502], [-122.61447, 38.00407], [-122.61499, 38.00404], [-122.61547, 38.00408], [-122.61594, 38.00419], [-122.61658, 38.00436], [-122.61743, 38.00447], [-122.61794, 38.00448], [-122.6185, 38.00444], [-122.61967, 38.00433], [-122.62004, 38.00432], [-122.62046, 38.00432], [-122.62598, 38.00528], [-122.62596, 38.00505], [-122.62563, 38.00349], [-122.62559, 38.00335], [-122.62539, 38.00324], [-122.62519, 38.00308], [-122.62446, 38.00148], [-122.62656, 38.00166], [-122.62717, 37.99745], [-122.62538, 37.99623], [-122.62482, 37.99216], [-122.61932, 37.99143], [-122.61789, 37.99085], [-122.61444, 37.9868], [-122.62556, 37.98353], [-122.6294, 37.99579]]]} | Open Access 1 | White Hill Open Space Preserve | http://www.marincountyparks.org/depts/pk/divisions/open-space/white-hill | 31490 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 382.008 | White Hill OSP | 1994 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);