superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8914 | 8914 | 8913 | {"type": "Polygon", "coordinates": [[[-121.75463, 37.93253], [-121.75397, 37.93253], [-121.75318, 37.93094], [-121.75369, 37.93096], [-121.75381, 37.93109], [-121.75385, 37.93149], [-121.75395, 37.93166], [-121.7541, 37.93184], [-121.75449, 37.93215], [-121.75463, 37.93253]]]} | Open Access 1 | Rolling Hills Park | 24577 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 2.082 | Rolling Hills Park | 2002 | |
8939 | 8939 | 8938 | {"type": "Polygon", "coordinates": [[[-121.72264, 37.9652], [-121.72261, 37.96561], [-121.7224, 37.96585], [-121.72214, 37.96593], [-121.72184, 37.96594], [-121.72155, 37.96582], [-121.7209, 37.96515], [-121.72205, 37.96446], [-121.72239, 37.96483], [-121.72264, 37.9652]]]} | Open Access 1 | Rose Garden Park | 24608 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.817 | Rose Garden Park | ||
9857 | 9857 | 9856 | {"type": "Polygon", "coordinates": [[[-121.69418, 37.91989], [-121.69378, 37.92012], [-121.69347, 37.91978], [-121.69389, 37.91954], [-121.69418, 37.91989]]]} | Open Access 1 | Spirit Park | 25725 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.522 | Spirit Park | ||
10059 | 10059 | 10058 | {"type": "Polygon", "coordinates": [[[-121.71757, 37.93894], [-121.71719, 37.9393], [-121.71718, 37.93998], [-121.71723, 37.94015], [-121.71721, 37.94019], [-121.71703, 37.94018], [-121.71584, 37.93936], [-121.71585, 37.93876], [-121.71616, 37.93875], [-121.7162, 37.93712], [-121.71667, 37.93707], [-121.7167, 37.93662], [-121.71649, 37.93661], [-121.71647, 37.93649], [-121.71711, 37.93655], [-121.71714, 37.93833], [-121.71757, 37.93894]]]} | Open Access 1 | Summerwood Park | 25963 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 8.376 | Summerwood Park | ||
10803 | 10803 | 10802 | {"type": "Polygon", "coordinates": [[[-121.70958, 37.92667], [-121.70943, 37.92742], [-121.70767, 37.92741], [-121.70765, 37.92742], [-121.70622, 37.92743], [-121.70621, 37.92742], [-121.70653, 37.92713], [-121.70686, 37.92711], [-121.70703, 37.92706], [-121.70715, 37.92701], [-121.70724, 37.927], [-121.70725, 37.92699], [-121.7072, 37.92693], [-121.70717, 37.92697], [-121.70703, 37.92703], [-121.70685, 37.92709], [-121.70652, 37.92711], [-121.70618, 37.92741], [-121.70575, 37.9271], [-121.7054, 37.92676], [-121.70524, 37.92649], [-121.7051, 37.92615], [-121.70504, 37.92587], [-121.70503, 37.92565], [-121.70515, 37.92561], [-121.70876, 37.9256], [-121.70878, 37.92589], [-121.70958, 37.92667]], [[-121.70697, 37.92638], [-121.70699, 37.92637], [-121.70694, 37.9263], [-121.70691, 37.92631], [-121.70697, 37.92638]], [[-121.70698, 37.9266], [-121.70697, 37.92659], [-121.70695, 37.9266], [-121.70696, 37.92662], [-121.70698, 37.9266]], [[-121.70703, 37.92655], [-121.70702, 37.92654], [-121.70701, 37.92656], [-121.70702, 37.92656], [-121.70703, 37.92655]], [[-121.70734, 37.92716], [-121.70735, 37.92715], [-121.70732, 37.92712], [-121.70731, 37.92714], [-121.70734, 37.92716]], [[-121.70765, 37.92738], [-121.70766, 37.92738], [-121.70766, 37.92736], [-121.70764, 37.92736], [-121.70765, 37.92738]]]} | Open Access 1 | Veteran's Park | http://gis.brentwoodca.gov/parksfinder/ | 27016 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 16.859 | Veteran's Park | |
11006 | 11006 | 11005 | {"type": "Polygon", "coordinates": [[[-121.69387, 37.92234], [-121.69316, 37.92234], [-121.69306, 37.92255], [-121.6929, 37.92262], [-121.69292, 37.92275], [-121.69279, 37.92277], [-121.69283, 37.92286], [-121.69282, 37.92307], [-121.69228, 37.92319], [-121.69153, 37.92233], [-121.69354, 37.92131], [-121.69381, 37.9216], [-121.69388, 37.92184], [-121.69387, 37.92234]]]} | Open Access 1 | Walnut Park | 27238 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 5.19 | Walnut Park | ||
11426 | 11426 | 11425 | {"type": "Polygon", "coordinates": [[[-121.72839, 37.95212], [-121.72745, 37.9521], [-121.72746, 37.95152], [-121.72839, 37.9515], [-121.72839, 37.95212]]]} | Open Access 1 | Yokut Park | 27773 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.362 | Yokut Park | ||
399 | 399 | 398 | {"type": "MultiPolygon", "coordinates": [[[[-121.74781, 37.93934], [-121.74693, 37.93984], [-121.74693, 37.9397], [-121.74681, 37.93944], [-121.74647, 37.93923], [-121.74662, 37.93903], [-121.74649, 37.93872], [-121.74644, 37.93871], [-121.74645, 37.93864], [-121.74641, 37.93858], [-121.74645, 37.93844], [-121.74635, 37.93823], [-121.74569, 37.93842], [-121.74512, 37.93853], [-121.74512, 37.93852], [-121.74516, 37.93848], [-121.74572, 37.93837], [-121.74615, 37.93825], [-121.74648, 37.93812], [-121.74682, 37.93797], [-121.74701, 37.9382], [-121.74707, 37.9383], [-121.74708, 37.93865], [-121.74743, 37.93872], [-121.74743, 37.93883], [-121.74736, 37.93893], [-121.74738, 37.93902], [-121.74744, 37.93907], [-121.74753, 37.93909], [-121.74757, 37.93919], [-121.74781, 37.93934]]], [[[-121.74657, 37.93787], [-121.74655, 37.93791], [-121.74606, 37.9381], [-121.74596, 37.93812], [-121.74591, 37.9381], [-121.74578, 37.93783], [-121.74538, 37.93731], [-121.74532, 37.93722], [-121.74527, 37.93704], [-121.74527, 37.93687], [-121.7453, 37.93678], [-121.74528, 37.93671], [-121.74539, 37.93662], [-121.74539, 37.93635], [-121.74625, 37.93634], [-121.7461, 37.93645], [-121.74602, 37.93646], [-121.74595, 37.93649], [-121.74591, 37.93655], [-121.7459, 37.93661], [-121.74594, 37.93667], [-121.74603, 37.93673], [-121.74605, 37.93676], [-121.74611, 37.93708], [-121.74622, 37.93737], [-121.74634, 37.93756], [-121.74656, 37.93783], [-121.74657, 37.93787]]]]} | Open Access 1 | Black Gold Park | 32010 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.247 | Black Gold Park | ||
400 | 400 | 399 | {"type": "Polygon", "coordinates": [[[-121.69761, 37.94167], [-121.69761, 37.94193], [-121.69738, 37.94194], [-121.69738, 37.94174], [-121.69746, 37.94173], [-121.69756, 37.94167], [-121.69761, 37.94167]]]} | Open Access 1 | Curtis Park | 32011 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.127 | Curtis Park | ||
403 | 403 | 402 | {"type": "Polygon", "coordinates": [[[-121.73893, 37.93421], [-121.73889, 37.93425], [-121.73874, 37.93424], [-121.73856, 37.93418], [-121.73841, 37.93409], [-121.73829, 37.93399], [-121.73882, 37.93382], [-121.7389, 37.93401], [-121.73893, 37.93411], [-121.73893, 37.93421]]]} | Open Access 1 | Berkshire Park | 32013 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.395 | Berkshire Park | ||
448 | 448 | 447 | {"type": "Polygon", "coordinates": [[[-121.69153, 37.94118], [-121.69124, 37.94131], [-121.69115, 37.94124], [-121.69108, 37.94124], [-121.69101, 37.94125], [-121.69085, 37.94096], [-121.69115, 37.94096], [-121.69136, 37.94101], [-121.69153, 37.94118]]]} | Open Access 1 | Windsor Park | 32048 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.349 | Windsor Park | ||
452 | 452 | 451 | {"type": "Polygon", "coordinates": [[[-121.68782, 37.93181], [-121.68752, 37.93182], [-121.68752, 37.93182], [-121.68753, 37.93177], [-121.68757, 37.93171], [-121.68782, 37.93158], [-121.68782, 37.93181]]]} | Open Access 1 | Almanor Pocket Park | 32049 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.107 | Almanor PP | ||
456 | 456 | 455 | {"type": "Polygon", "coordinates": [[[-121.73593, 37.94812], [-121.73565, 37.94812], [-121.73554, 37.94817], [-121.73546, 37.94809], [-121.73534, 37.94805], [-121.73409, 37.94804], [-121.73404, 37.948], [-121.73403, 37.94789], [-121.73398, 37.94779], [-121.73391, 37.94774], [-121.73378, 37.94771], [-121.73545, 37.94772], [-121.73593, 37.94812]]]} | Open Access 1 | Almond Park | 32050 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.389 | Almond Park | ||
13171 | 13171 | 13170 | {"type": "Polygon", "coordinates": [[[-121.73096, 37.96109], [-121.73096, 37.9614], [-121.73047, 37.9614], [-121.73066, 37.9611], [-121.73074, 37.96112], [-121.73086, 37.96109], [-121.73096, 37.96109]]]} | Open Access 1 | Amber Park | 32051 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.281 | Amber Park | ||
13172 | 13172 | 13171 | {"type": "Polygon", "coordinates": [[[-121.72201, 37.96679], [-121.72201, 37.96728], [-121.72153, 37.96728], [-121.72144, 37.96729], [-121.72139, 37.96728], [-121.72136, 37.96725], [-121.72135, 37.96721], [-121.72137, 37.96716], [-121.72138, 37.96697], [-121.72142, 37.96684], [-121.72142, 37.96679], [-121.72146, 37.96675], [-121.72152, 37.96673], [-121.7217, 37.96677], [-121.72201, 37.96679]]]} | Open Access 1 | Anastasia Park | 32052 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.774 | Anastasia Park | ||
13173 | 13173 | 13172 | {"type": "Polygon", "coordinates": [[[-121.71759, 37.96654], [-121.71759, 37.96707], [-121.7171, 37.96707], [-121.71701, 37.96717], [-121.71692, 37.96715], [-121.71683, 37.96717], [-121.71674, 37.96707], [-121.71625, 37.96707], [-121.71625, 37.96654], [-121.71759, 37.96654]]]} | Open Access 1 | Granville Green Park | 32053 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.759 | Granville Green Park | ||
13174 | 13174 | 13173 | {"type": "Polygon", "coordinates": [[[-121.7172, 37.96308], [-121.71719, 37.96372], [-121.71649, 37.96372], [-121.71651, 37.96308], [-121.7172, 37.96308]]]} | Open Access 1 | Pistachio Park | 32056 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.074 | Pistachio Park | ||
478 | 478 | 477 | {"type": "Polygon", "coordinates": [[[-121.71487, 37.96473], [-121.71469, 37.96499], [-121.71459, 37.96524], [-121.71411, 37.96524], [-121.71413, 37.96451], [-121.71416, 37.96449], [-121.7144, 37.96449], [-121.71463, 37.96446], [-121.71475, 37.96461], [-121.71486, 37.96469], [-121.71487, 37.96473]]]} | Open Access 1 | Steeplechase Park | 32061 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.12 | Steeplechase Park | ||
498 | 498 | 497 | {"type": "Polygon", "coordinates": [[[-121.71934, 37.96296], [-121.71931, 37.96301], [-121.71905, 37.96319], [-121.71887, 37.96326], [-121.71868, 37.96331], [-121.71867, 37.96328], [-121.7183, 37.96328], [-121.71827, 37.96326], [-121.71828, 37.96276], [-121.71867, 37.96275], [-121.71867, 37.96227], [-121.71878, 37.96245], [-121.71891, 37.96261], [-121.71909, 37.96276], [-121.71931, 37.9629], [-121.71934, 37.96296]]]} | Open Access 1 | Medallion Park | 32079 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.349 | Medallion Park | ||
12974 | 12974 | 12973 | {"type": "Polygon", "coordinates": [[[-121.71875, 37.96018], [-121.71874, 37.9607], [-121.71874, 37.9607], [-121.71844, 37.96018], [-121.71875, 37.96018]]]} | Open Access 1 | Gann Street Pocket Park | 32080 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.189 | Gann Street PP |
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]);