units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, DES_TP = 4 and YR_EST = 1994
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15587 | 15587 | 15586 | {"type": "Polygon", "coordinates": [[[-117.25406, 33.55451], [-117.25253, 33.56096], [-117.24683, 33.5616], [-117.24552, 33.56023], [-117.24566, 33.55849], [-117.24724, 33.55612], [-117.24602, 33.55264], [-117.24327, 33.55101], [-117.24324, 33.54786], [-117.24168, 33.54458], [-117.24149, 33.54456], [-117.24152, 33.54438], [-117.24157, 33.54416], [-117.24171, 33.54383], [-117.24191, 33.54353], [-117.24204, 33.54337], [-117.24225, 33.54317], [-117.2408, 33.54033], [-117.23339, 33.54632], [-117.22864, 33.54271], [-117.22887, 33.54253], [-117.22887, 33.54252], [-117.22643, 33.54067], [-117.22561, 33.54005], [-117.22537, 33.54023], [-117.2253, 33.54017], [-117.226, 33.53963], [-117.22419, 33.53825], [-117.22281, 33.53721], [-117.22209, 33.53775], [-117.21106, 33.52939], [-117.21102, 33.52829], [-117.21103, 33.52817], [-117.21106, 33.528], [-117.21112, 33.52783], [-117.2112, 33.52767], [-117.21131, 33.5275], [-117.21143, 33.52738], [-117.21158, 33.52724], [-117.21173, 33.52713], [-117.21191, 33.52704], [-117.21221, 33.52692], [-117.21278, 33.52679], [-117.213, 33.5267], [-117.21319, 33.52659], [-117.21335, 33.52648], [-117.2135, 33.52634], [-117.21363, 33.52619], [-117.21374, 33.52601], [-117.21385, 33.52572], [-117.21409, 33.52468], [-117.21437, 33.52406], [-117.21445, 33.52382], [-117.21448, 33.52363], [-117.21448, 33.52344], [-117.21445, 33.52325], [-117.21439, 33.52308], [-117.21866, 33.52143], [-117.22166, 33.51869], [-117.21882, 33.51411], [-117.21989, 33.51229], [-117.22153, 33.51238], [-117.22236, 33.50986], [-117.22285, 33.5099], [-117.22321, 33.50995], [-117.22368, 33.51004], [-117.22428, 33.51022], [-117.22491, 33.51048], [-117.22532, 33.5107], [-117.22566, 33.51092], [-117.22599, 33.51116], [-117.22692, 33.51191], [-117.22726, 33.51215], [-117.22766, 33.51238], [-117.22809, 33.5126], [-117.22861, 33.51281], [-117.22889, 33.51291], [-117.23077, 33.51346], [-117.23127, 33.51364], [-117.2316, 33.51379], [-117.23215, 33.51409], [-117.23256, 33.51437], [-117.23298, 33.51471], [-117.23341, 33.51513], [-117.2337, 33.51489], [-117.23662, 33.51215], [-117.23969, 33.51163], [-117.24188, 33.50703], [-117.24828, 33.50454], [-117.25383, 33.51734], [-117.25377, 33.5195], [-117.24323, 33.52422], [-117.24132, 33.52305], [-117.24029, 33.52069], [-117.23797, 33.5209], [-117.23768, 33.51976], [-117.23719, 33.51948], [-117.23606, 33.52001], [-117.23536, 33.51836], [-117.23254, 33.52021], [-117.2309, 33.51924], [-117.23011, 33.51651], [-117.22905, 33.51536], [-117.22688, 33.51494], [-117.22433, 33.51347], [-117.22264, 33.51402], [-117.2206, 33.51356], [-117.22059, 33.51357], [-117.22518, 33.51826], [-117.22448, 33.51937], [-117.22218, 33.51968], [-117.2206, 33.52139], [-117.22061, 33.5214], [-117.22413, 33.52116], [-117.224, 33.52437], [-117.22322, 33.52492], [-117.2242, 33.52581], [-117.22559, 33.5261], [-117.22588, 33.52645], [-117.22633, 33.52759], [-117.22621, 33.52965], [-117.22676, 33.53007], [-117.2286, 33.52873], [-117.23179, 33.5306], [-117.2308, 33.53201], [-117.23041, 33.53267], [-117.23223, 33.53295], [-117.23305, 33.53376], [-117.23405, 33.53327], [-117.23607, 33.53089], [-117.2367, 33.53318], [-117.23592, 33.53433], [-117.23733, 33.53479], [-117.23864, 33.53444], [-117.23992, 33.53463], [-117.23958, 33.53654], [-117.24223, 33.53693], [-117.25139, 33.55059], [-117.25406, 33.55451]]]} | Open Access 1 | 12823 | Santa Rosa Plateau Ecological Reserve | 9507 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | Riverside 10 | 1994.248 | Santa Rosa Plateau ER | 1994 | Local Conservation Area 4 | 2 |
15591 | 15591 | 15590 | {"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.28221, 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.27297, 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.28039, 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.296, 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 | 12824 | Santa Rosa Plateau Ecological Reserve | 9398 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | Riverside 10 | 986.313 | Santa Rosa Plateau ER | 1994 | Local Conservation Area 4 | 2 |
15779 | 15779 | 15778 | {"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.00348], [-122.62559, 38.00335], [-122.62539, 38.00324], [-122.62519, 38.00308], [-122.62446, 38.00148], [-122.62656, 38.00167], [-122.62717, 37.99744], [-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 | 2057 | White Hill Open Space Preserve | 31490 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/depts/pk/divisions/open-space/white-hill | Marin 23 | 381.946 | White Hill OSP | 1994 | Local Conservation Area 4 | 2 |
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]);