units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AG_TYP = 2 and UNIT_NAME = "City Open Space"
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_NAME, AGNCY_WEB, COUNTY
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 | |
10204 | 10204 | 10203 | {"type": "MultiPolygon", "coordinates": [[[[-122.1346, 37.06255], [-122.13451, 37.0627], [-122.13429, 37.06276], [-122.13374, 37.06259], [-122.13341, 37.06193], [-122.13294, 37.06186], [-122.13091, 37.06209], [-122.1309, 37.06153], [-122.13169, 37.06153], [-122.1317, 37.06106], [-122.13204, 37.06106], [-122.1321, 37.06072], [-122.13132, 37.06049], [-122.13068, 37.0605], [-122.13014, 37.06066], [-122.12952, 37.06065], [-122.12907, 37.06031], [-122.12856, 37.06022], [-122.12792, 37.06045], [-122.12727, 37.06045], [-122.12681, 37.06035], [-122.12634, 37.05999], [-122.12639, 37.05903], [-122.12629, 37.05849], [-122.12619, 37.05834], [-122.12609, 37.05826], [-122.12591, 37.05819], [-122.1257, 37.05817], [-122.12543, 37.05823], [-122.12522, 37.05822], [-122.12508, 37.05819], [-122.12448, 37.05799], [-122.1244, 37.05325], [-122.13417, 37.05311], [-122.13419, 37.05491], [-122.1341, 37.05949], [-122.13395, 37.05944], [-122.13369, 37.05948], [-122.13361, 37.0596], [-122.13358, 37.05977], [-122.13367, 37.06026], [-122.13366, 37.06066], [-122.1336, 37.06095], [-122.13366, 37.06107], [-122.13367, 37.06118], [-122.1346, 37.06255]]], [[[-122.13411, 37.06163], [-122.1338, 37.06118], [-122.1338, 37.06105], [-122.13374, 37.06093], [-122.1338, 37.06066], [-122.1338, 37.06025], [-122.13372, 37.05976], [-122.13374, 37.05963], [-122.13378, 37.05958], [-122.13394, 37.05956], [-122.1341, 37.05961], [-122.13411, 37.06163]]]]} | Restricted Access 2 | 36504 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 171.465 | City OS | 0 | Local Recreation Area 3 | 4 | |
10273 | 10273 | 10272 | {"type": "Polygon", "coordinates": [[[-122.13821, 37.06755], [-122.13322, 37.06753], [-122.13183, 37.06688], [-122.13102, 37.06801], [-122.12911, 37.06708], [-122.12964, 37.06632], [-122.13212, 37.06207], [-122.13294, 37.06197], [-122.13331, 37.06202], [-122.13364, 37.06268], [-122.13429, 37.06288], [-122.13446, 37.06283], [-122.13478, 37.06318], [-122.13482, 37.06364], [-122.13514, 37.06422], [-122.1355, 37.06454], [-122.13589, 37.06459], [-122.13612, 37.06485], [-122.13613, 37.06527], [-122.13632, 37.06576], [-122.13658, 37.0661], [-122.13692, 37.06633], [-122.13711, 37.06668], [-122.13776, 37.06698], [-122.13807, 37.06725], [-122.13821, 37.06755]]]} | Restricted Access 2 | 36628 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 68.884 | 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 | |
12473 | 12473 | 12472 | {"type": "Polygon", "coordinates": [[[-122.12679, 37.0632], [-122.12622, 37.06347], [-122.12578, 37.06404], [-122.1257, 37.0644], [-122.12562, 37.06438], [-122.12569, 37.06402], [-122.1245, 37.06403], [-122.12448, 37.06146], [-122.12678, 37.06144], [-122.12679, 37.0632]]]} | Restricted Access 2 | 36506 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 13.248 | City OS | 0 | Local Recreation Area 3 | 4 | |
13908 | 13908 | 13907 | {"type": "Polygon", "coordinates": [[[-122.12623, 37.05938], [-122.12623, 37.05938], [-122.12447, 37.06105], [-122.12446, 37.05993], [-122.12455, 37.05981], [-122.12461, 37.05968], [-122.12464, 37.05948], [-122.12461, 37.05927], [-122.1245, 37.05908], [-122.1245, 37.05812], [-122.12503, 37.05829], [-122.12519, 37.05833], [-122.12545, 37.05833], [-122.12567, 37.05829], [-122.12578, 37.05828], [-122.12595, 37.05832], [-122.12604, 37.05837], [-122.12611, 37.05845], [-122.12616, 37.05853], [-122.12625, 37.05903], [-122.12623, 37.05938]]]} | Restricted Access 2 | 36507 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 7.916 | 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 | |
16227 | 16227 | 16226 | {"type": "Polygon", "coordinates": [[[-117.91283, 34.03821], [-117.91283, 34.03899], [-117.91275, 34.03962], [-117.9127, 34.0399], [-117.91261, 34.04022], [-117.9125, 34.04056], [-117.91237, 34.04089], [-117.91209, 34.04146], [-117.91176, 34.04199], [-117.91145, 34.04239], [-117.91062, 34.04338], [-117.9068, 34.0425], [-117.9068, 34.04242], [-117.90687, 34.04244], [-117.9069, 34.04236], [-117.90686, 34.04212], [-117.90703, 34.04191], [-117.907, 34.04164], [-117.90695, 34.04141], [-117.90686, 34.04117], [-117.90723, 34.04103], [-117.9074, 34.04095], [-117.9077, 34.04076], [-117.90797, 34.04194], [-117.9081, 34.04194], [-117.90836, 34.04217], [-117.90888, 34.0422], [-117.9092, 34.04178], [-117.9092, 34.04176], [-117.90879, 34.04158], [-117.90868, 34.04151], [-117.90863, 34.04145], [-117.90852, 34.04124], [-117.90817, 34.04033], [-117.90908, 34.03917], [-117.90866, 34.0401], [-117.90909, 34.04119], [-117.91045, 34.04181], [-117.91066, 34.04186], [-117.91145, 34.0417], [-117.912, 34.04119], [-117.91214, 34.04079], [-117.91193, 34.04047], [-117.91203, 34.04013], [-117.91245, 34.03993], [-117.91257, 34.03967], [-117.91242, 34.03907], [-117.91225, 34.0388], [-117.91189, 34.03836], [-117.91192, 34.03815], [-117.91215, 34.03816], [-117.91278, 34.03816], [-117.91283, 34.03821]]]} | No Public Access 3 | 45356 | City Open Space | 17340 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.nlc.org/Documents/Utility%20Navigation/About%20NLC/Awards/2008%20West%20Covina%20Nomination.pdf | Los Angeles 6 | 22.107 | 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]);