units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, DES_TP = 3 and LABEL_NAME = "City OS"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3797 | 3797 | 3796 | {"type": "MultiPolygon", "coordinates": [[[[-117.007, 32.87455], [-117.00513, 32.87459], [-117.00513, 32.87459], [-117.0059, 32.87307], [-117.00666, 32.87307], [-117.00676, 32.87322], [-117.00643, 32.87323], [-117.00642, 32.87324], [-117.007, 32.87455]]], [[[-117.01663, 32.86839], [-117.01493, 32.86948], [-117.01329, 32.8671], [-117.01455, 32.86624], [-117.01459, 32.86612], [-117.01663, 32.86839]]], [[[-117.01772, 32.87281], [-117.01479, 32.87318], [-117.01447, 32.87138], [-117.01765, 32.87049], [-117.01772, 32.87281]]]]} | Open Access 1 | 45131 | City Open Space | 17337 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 34.702 | City OS | 0 | Local Recreation Area 3 | 4 | |
11487 | 11487 | 11486 | {"type": "Polygon", "coordinates": [[[-121.31032, 38.73631], [-121.30904, 38.73645], [-121.30901, 38.73417], [-121.31032, 38.73417], [-121.31032, 38.73631]]]} | Open Access 1 | 29436 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.835 | City OS | 0 | Local Recreation Area 3 | 4 | |
16136 | 16136 | 16135 | {"type": "MultiPolygon", "coordinates": [[[[-119.59271, 34.47931], [-119.59269, 34.48657], [-119.58367, 34.48654], [-119.58372, 34.47933], [-119.59271, 34.47931]]], [[[-119.62072, 34.50833], [-119.62065, 34.51552], [-119.60181, 34.51552], [-119.59304, 34.51554], [-119.59303, 34.51191], [-119.5974, 34.5119], [-119.59739, 34.50834], [-119.6016, 34.50832], [-119.60165, 34.50104], [-119.6096, 34.5011], [-119.60959, 34.50472], [-119.61397, 34.50473], [-119.61397, 34.50831], [-119.62072, 34.50833]]]]} | Open Access 1 | 17439 | City Open Space | 17338 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 810.91 | City OS | 0 | Local Recreation Area 3 | 4 | |
16167 | 16167 | 16166 | {"type": "MultiPolygon", "coordinates": [[[[-121.24491, 38.74107], [-121.24485, 38.74123], [-121.24457, 38.74138], [-121.24422, 38.74146], [-121.24418, 38.74154], [-121.24404, 38.74157], [-121.24404, 38.74167], [-121.24388, 38.74162], [-121.24361, 38.74174], [-121.24349, 38.74176], [-121.24336, 38.74188], [-121.24332, 38.74202], [-121.24326, 38.74209], [-121.24321, 38.74212], [-121.24305, 38.74211], [-121.24296, 38.74207], [-121.24284, 38.74199], [-121.24319, 38.74176], [-121.24334, 38.74147], [-121.24352, 38.74144], [-121.24416, 38.74138], [-121.24431, 38.74114], [-121.24424, 38.74094], [-121.24427, 38.74082], [-121.24421, 38.74072], [-121.24491, 38.74107]]], [[[-121.24785, 38.7396], [-121.24782, 38.73969], [-121.24773, 38.73968], [-121.24758, 38.73961], [-121.2475, 38.73967], [-121.24747, 38.73977], [-121.24742, 38.73982], [-121.24707, 38.73982], [-121.24693, 38.73977], [-121.2465, 38.73989], [-121.24636, 38.73987], [-121.24623, 38.74001], [-121.24596, 38.74004], [-121.24564, 38.74004], [-121.24543, 38.74002], [-121.2452, 38.73997], [-121.2451, 38.73998], [-121.24492, 38.74025], [-121.24486, 38.7404], [-121.2448, 38.74051], [-121.2447, 38.74063], [-121.24456, 38.74056], [-121.24477, 38.74033], [-121.24497, 38.73995], [-121.24464, 38.73963], [-121.2447, 38.7396], [-121.24482, 38.73963], [-121.24575, 38.73969], [-121.2459, 38.73964], [-121.24624, 38.73959], [-121.24647, 38.73948], [-121.24652, 38.73948], [-121.24659, 38.73955], [-121.24687, 38.73948], [-121.24703, 38.7395], [-121.24713, 38.73947], [-121.24715, 38.73941], [-121.2471, 38.73924], [-121.24711, 38.73914], [-121.24716, 38.7391], [-121.24725, 38.73908], [-121.24717, 38.73902], [-121.24718, 38.73889], [-121.24706, 38.73873], [-121.24772, 38.73942], [-121.24785, 38.7396]]], [[[-121.25347, 38.7387], [-121.25355, 38.7387], [-121.25361, 38.73874], [-121.25361, 38.73897], [-121.25358, 38.73925], [-121.25344, 38.73991], [-121.25342, 38.74016], [-121.25343, 38.74087], [-121.25342, 38.7409], [-121.25337, 38.74092], [-121.25329, 38.74093], [-121.2533, 38.74014], [-121.2531, 38.73997], [-121.25273, 38.73983], [-121.2527, 38.73961], [-121.2524, 38.73945], [-121.2523, 38.73954], [-121.25222, 38.73951], [-121.25215, 38.73951], [-121.25212, 38.73945], [-121.2502, 38.73947], [-121.24987, 38.73937], [-121.25006, 38.73908], [-121.25045, 38.73908], [-121.25053, 38.73904], [-121.25061, 38.73907], [-121.25072, 38.73906], [-121.2508, 38.73911], [-121.25117, 38.73907], [-121.25138, 38.73892], [-121.25157, 38.73883], [-121.25181, 38.73889], [-121.25204, 38.73889], [-121.25226, 38.73886], [-121.25227, 38.73884], [-121.25246, 38.73889], [-121.25272, 38.73904], [-121.25279, 38.73904], [-121.25282, 38.7391], [-121.25288, 38.73914], [-121.25299, 38.73915], [-121.25303, 38.7392], [-121.25341, 38.73932], [-121.25348, 38.73891], [-121.25347, 38.7387]]]]} | Open Access 1 | 20937 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 9.82 | City OS | 0 | Local Recreation Area 3 | 4 | |
16204 | 16204 | 16203 | {"type": "Polygon", "coordinates": [[[-121.23553, 38.74068], [-121.23539, 38.74086], [-121.23514, 38.74106], [-121.23489, 38.74119], [-121.23435, 38.74156], [-121.23407, 38.7416], [-121.23393, 38.74169], [-121.23375, 38.74167], [-121.23358, 38.74188], [-121.23352, 38.74209], [-121.23333, 38.74225], [-121.23302, 38.74237], [-121.23287, 38.74239], [-121.23276, 38.74249], [-121.23248, 38.74254], [-121.23238, 38.74274], [-121.23176, 38.74268], [-121.23136, 38.74271], [-121.2312, 38.74277], [-121.23094, 38.74266], [-121.23083, 38.74274], [-121.23059, 38.74277], [-121.2302, 38.74297], [-121.22966, 38.74303], [-121.22909, 38.74307], [-121.22908, 38.7427], [-121.22927, 38.74277], [-121.22951, 38.74278], [-121.23, 38.74251], [-121.23004, 38.74238], [-121.23036, 38.7422], [-121.2305, 38.74232], [-121.23084, 38.74228], [-121.2314, 38.74228], [-121.23169, 38.7422], [-121.23181, 38.74208], [-121.23207, 38.74207], [-121.23242, 38.742], [-121.23269, 38.74192], [-121.23315, 38.74164], [-121.23324, 38.7414], [-121.23344, 38.74119], [-121.23374, 38.74106], [-121.2342, 38.74085], [-121.2344, 38.74083], [-121.23447, 38.74069], [-121.23465, 38.74057], [-121.23471, 38.74048], [-121.23472, 38.74022], [-121.23454, 38.74011], [-121.23439, 38.73991], [-121.23418, 38.73977], [-121.23403, 38.73974], [-121.23367, 38.73958], [-121.23347, 38.73954], [-121.23328, 38.73946], [-121.23307, 38.73953], [-121.23289, 38.73952], [-121.23197, 38.7393], [-121.23187, 38.73941], [-121.23173, 38.73944], [-121.23159, 38.73962], [-121.23135, 38.73959], [-121.2307, 38.73978], [-121.2304, 38.73988], [-121.23003, 38.73988], [-121.22985, 38.73978], [-121.22921, 38.73951], [-121.22858, 38.73909], [-121.22824, 38.73905], [-121.2281, 38.73914], [-121.22757, 38.73919], [-121.22729, 38.73924], [-121.22708, 38.73921], [-121.22685, 38.73904], [-121.22673, 38.73886], [-121.2266, 38.73885], [-121.22655, 38.73895], [-121.22645, 38.73898], [-121.22619, 38.73895], [-121.22611, 38.73895], [-121.22604, 38.73787], [-121.22607, 38.73754], [-121.22607, 38.73741], [-121.2263, 38.73732], [-121.22674, 38.73728], [-121.22707, 38.73733], [-121.22751, 38.73732], [-121.22773, 38.73735], [-121.2279, 38.73746], [-121.228, 38.73757], [-121.22818, 38.73759], [-121.22841, 38.73789], [-121.22864, 38.73809], [-121.22878, 38.73829], [-121.22911, 38.73851], [-121.22931, 38.73872], [-121.22965, 38.73897], [-121.22984, 38.73919], [-121.22965, 38.7393], [-121.22956, 38.73944], [-121.23024, 38.73974], [-121.23203, 38.73923], [-121.23264, 38.7393], [-121.23264, 38.73865], [-121.23316, 38.73897], [-121.23339, 38.73894], [-121.23351, 38.73884], [-121.23378, 38.73876], [-121.23407, 38.73883], [-121.23455, 38.73912], [-121.23461, 38.7395], [-121.23479, 38.73937], [-121.23492, 38.73933], [-121.23519, 38.7394], [-121.23543, 38.73936], [-121.23545, 38.7401], [-121.23553, 38.74068]]]} | Open Access 1 | 31300 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 28.048 | City OS | 0 | 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]);