superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 sorted by PARK_NAME descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
374 | 374 | 373 | {"type": "Polygon", "coordinates": [[[-121.7385, 37.95126], [-121.7385, 37.95176], [-121.73807, 37.95175], [-121.73798, 37.95173], [-121.73794, 37.95169], [-121.73791, 37.95162], [-121.73793, 37.95146], [-121.73794, 37.95141], [-121.73799, 37.95136], [-121.73807, 37.95133], [-121.7383, 37.95128], [-121.7385, 37.95126]]]} | Open Access 1 | Palamino Park | 32101 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.608 | Palamino Park | ||
7738 | 7738 | 7737 | {"type": "Polygon", "coordinates": [[[-121.70481, 37.91848], [-121.7048, 37.91967], [-121.70475, 37.9197], [-121.70317, 37.9197], [-121.70313, 37.91968], [-121.70311, 37.91965], [-121.70311, 37.91848], [-121.70312, 37.91845], [-121.70317, 37.91843], [-121.70474, 37.91843], [-121.70478, 37.91844], [-121.70481, 37.91848]]]} | Open Access 1 | Orchard Park | 23189 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 5.171 | Orchard Park | ||
7569 | 7569 | 7568 | {"type": "Polygon", "coordinates": [[[-121.74099, 37.92084], [-121.74088, 37.92104], [-121.73758, 37.92103], [-121.73758, 37.92009], [-121.73789, 37.92015], [-121.7388, 37.91986], [-121.73899, 37.91952], [-121.73934, 37.91955], [-121.73955, 37.91953], [-121.73976, 37.91948], [-121.73999, 37.91936], [-121.74004, 37.91935], [-121.7403, 37.91955], [-121.74008, 37.91976], [-121.74047, 37.92002], [-121.74069, 37.92022], [-121.74085, 37.92045], [-121.74099, 37.92069], [-121.74099, 37.92084]]]} | Open Access 1 | Oak Meadow Park | 22987 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 9.683 | Oak Meadow Park | ||
7082 | 7082 | 7081 | {"type": "Polygon", "coordinates": [[[-121.72032, 37.95387], [-121.72018, 37.95386], [-121.71935, 37.95216], [-121.71878, 37.95215], [-121.71868, 37.95125], [-121.71883, 37.9506], [-121.7191, 37.95044], [-121.71918, 37.95013], [-121.71908, 37.94982], [-121.71878, 37.94918], [-121.71903, 37.9487], [-121.71921, 37.9488], [-121.71925, 37.94937], [-121.71934, 37.94948], [-121.7194, 37.94964], [-121.7196, 37.94968], [-121.7196, 37.94986], [-121.71979, 37.94989], [-121.71995, 37.95087], [-121.71995, 37.95309], [-121.72015, 37.95329], [-121.72032, 37.95387]]]} | Open Access 1 | Miwok Park and Trail | 22332 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 8.099 | Miwok Park and Trail | ||
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 | ||
6796 | 6796 | 6795 | {"type": "Polygon", "coordinates": [[[-121.69897, 37.92733], [-121.69896, 37.92916], [-121.69801, 37.92915], [-121.69802, 37.92899], [-121.69829, 37.92877], [-121.69827, 37.92732], [-121.69897, 37.92733]]]} | Open Access 1 | McClarren Park | 21997 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.187 | McClarren Park | ||
13185 | 13185 | 13184 | {"type": "Polygon", "coordinates": [[[-121.69775, 37.95242], [-121.69746, 37.95249], [-121.69733, 37.95221], [-121.69767, 37.95211], [-121.69775, 37.95242]]]} | Open Access 1 | Marsh Creek Vista Park | 32086 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.245 | Marsh Creek Vista Park | ||
13214 | 13214 | 13213 | {"type": "Polygon", "coordinates": [[[-121.71713, 37.90384], [-121.71711, 37.90397], [-121.71694, 37.90428], [-121.71665, 37.90416], [-121.71633, 37.90462], [-121.71622, 37.90488], [-121.71619, 37.90507], [-121.71619, 37.90528], [-121.71643, 37.90632], [-121.71645, 37.90648], [-121.71643, 37.90664], [-121.71638, 37.90683], [-121.71629, 37.90701], [-121.71618, 37.90715], [-121.71593, 37.90741], [-121.71582, 37.90761], [-121.71578, 37.90774], [-121.71576, 37.90785], [-121.71576, 37.90855], [-121.71555, 37.90902], [-121.71539, 37.90919], [-121.71532, 37.90932], [-121.71529, 37.90942], [-121.71528, 37.90968], [-121.71538, 37.9101], [-121.71538, 37.91036], [-121.71549, 37.91042], [-121.71546, 37.91049], [-121.7154, 37.91049], [-121.71539, 37.91051], [-121.71544, 37.9106], [-121.71554, 37.91065], [-121.71554, 37.91091], [-121.71511, 37.91091], [-121.71509, 37.91064], [-121.7149, 37.90999], [-121.7149, 37.90984], [-121.71491, 37.90969], [-121.71496, 37.90955], [-121.71532, 37.90868], [-121.71537, 37.90849], [-121.71541, 37.90822], [-121.7154, 37.90772], [-121.71544, 37.90754], [-121.71555, 37.90735], [-121.71588, 37.907], [-121.71597, 37.90689], [-121.71605, 37.90674], [-121.71609, 37.90658], [-121.71609, 37.90645], [-121.71608, 37.90634], [-121.71584, 37.90532], [-121.71584, 37.90506], [-121.71589, 37.90481], [-121.71595, 37.90463], [-121.71604, 37.90446], [-121.71651, 37.90379], [-121.7171, 37.90379], [-121.71713, 37.90384]]]} | Open Access 1 | Marsh Creek Trailhead Park | 32140 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.784 | Marsh Creek Trailhead Park | ||
13205 | 13205 | 13204 | {"type": "Polygon", "coordinates": [[[-121.68551, 37.94267], [-121.68464, 37.94266], [-121.68454, 37.94269], [-121.68446, 37.94275], [-121.68445, 37.942], [-121.68453, 37.94206], [-121.68463, 37.94208], [-121.68551, 37.94206], [-121.68551, 37.94267]]]} | Open Access 1 | Mallard Park | 32126 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.527 | Mallard Park | ||
6319 | 6319 | 6318 | {"type": "Polygon", "coordinates": [[[-121.73692, 37.94085], [-121.73677, 37.94122], [-121.73616, 37.94185], [-121.73409, 37.94184], [-121.73387, 37.94158], [-121.73356, 37.94143], [-121.7337, 37.94082], [-121.73646, 37.94077], [-121.73648, 37.94084], [-121.73692, 37.94085]]]} | Open Access 1 | Loma Vista Park | 21410 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 7.251 | Loma Vista Park | ||
4861 | 4861 | 4860 | {"type": "Polygon", "coordinates": [[[-121.74367, 37.92592], [-121.74365, 37.92608], [-121.74279, 37.92626], [-121.7424, 37.92624], [-121.74238, 37.92541], [-121.74303, 37.92543], [-121.74304, 37.92568], [-121.74367, 37.92592]]]} | Open Access 1 | Lake Park | 20958 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.795 | Lake Park | ||
613 | 613 | 612 | {"type": "Polygon", "coordinates": [[[-121.7244, 37.95094], [-121.72439, 37.95128], [-121.72409, 37.95128], [-121.7241, 37.95099], [-121.72412, 37.95095], [-121.72417, 37.95094], [-121.7244, 37.95094]]]} | Open Access 1 | La Pergola Pocket Park | 32096 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.244 | La Pergola PP | ||
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-121.72108, 37.94512], [-121.72097, 37.94543], [-121.72086, 37.94556], [-121.7208, 37.9457], [-121.72078, 37.9459], [-121.72077, 37.94628], [-121.72073, 37.94643], [-121.72069, 37.94645], [-121.72067, 37.94649], [-121.72069, 37.94652], [-121.72068, 37.94658], [-121.71946, 37.94658], [-121.71946, 37.94628], [-121.71953, 37.94627], [-121.71959, 37.94624], [-121.71962, 37.9462], [-121.71964, 37.94614], [-121.71963, 37.94545], [-121.71958, 37.94537], [-121.71953, 37.94534], [-121.71946, 37.94533], [-121.71946, 37.94531], [-121.71996, 37.94531], [-121.72028, 37.94528], [-121.72066, 37.94522], [-121.72108, 37.94512]]]} | Open Access 1 | King Park | 20656 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.946 | King Park | ||
5226 | 5226 | 5225 | {"type": "Polygon", "coordinates": [[[-121.69461, 37.95525], [-121.69461, 37.95525], [-121.69322, 37.95527], [-121.69369, 37.95481], [-121.69394, 37.95494], [-121.6946, 37.95493], [-121.69461, 37.95525]]]} | Open Access 1 | Homecoming Park | 20059 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.004 | Homecoming Park | ||
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-121.68708, 37.93859], [-121.68708, 37.93885], [-121.687, 37.9389], [-121.687, 37.9391], [-121.68708, 37.93909], [-121.68708, 37.93924], [-121.687, 37.93929], [-121.687, 37.93949], [-121.68708, 37.93948], [-121.68708, 37.9398], [-121.68705, 37.93986], [-121.68697, 37.93989], [-121.68496, 37.9399], [-121.68473, 37.93992], [-121.68441, 37.93996], [-121.68393, 37.93997], [-121.68394, 37.93831], [-121.6842, 37.93831], [-121.68421, 37.93859], [-121.68669, 37.93859], [-121.68689, 37.93859], [-121.68689, 37.93832], [-121.68694, 37.93832], [-121.68702, 37.93834], [-121.68702, 37.93858], [-121.68708, 37.93859]]]} | Open Access 1 | Heron Park | 19878 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 10.188 | Heron 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 | ||
4612 | 4612 | 4611 | {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} | Open Access 1 | Glory Park | 19349 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.072 | Glory Park | ||
614 | 614 | 613 | {"type": "Polygon", "coordinates": [[[-121.7242, 37.95297], [-121.72419, 37.95332], [-121.72412, 37.95332], [-121.72407, 37.9533], [-121.72405, 37.95326], [-121.72406, 37.95297], [-121.7242, 37.95297]]]} | Open Access 1 | Giotto Pocket Park | 32097 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.112 | Giotto PP | ||
4534 | 4534 | 4533 | {"type": "Polygon", "coordinates": [[[-121.72277, 37.96245], [-121.72218, 37.96276], [-121.72178, 37.96232], [-121.72187, 37.96225], [-121.72195, 37.96226], [-121.72255, 37.96226], [-121.72277, 37.96245]]]} | Open Access 1 | Gemini Park | 19252 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.705 | Gemini Park | ||
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-121.6885, 37.93079], [-121.68764, 37.93079], [-121.68768, 37.92743], [-121.68846, 37.92741], [-121.68847, 37.92742], [-121.6885, 37.93079]]]} | Open Access 1 | Garin Park | 19219 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.719 | Garin Park |
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]);