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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12563 | 12563 | 12562 | {"type": "Polygon", "coordinates": [[[-121.68727, 37.95453], [-121.68722, 37.958], [-121.68594, 37.95802], [-121.68585, 37.95799], [-121.68575, 37.95789], [-121.6857, 37.95786], [-121.68568, 37.95807], [-121.68225, 37.95812], [-121.6823, 37.95455], [-121.68573, 37.95452], [-121.68575, 37.95455], [-121.68727, 37.95453]]]} | Open Access 1 | Sunset Park Athletic Complex | 32444 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 42.256 | Sunset Park Athletic Complex | ||
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 | ||
704 | 704 | 703 | {"type": "Polygon", "coordinates": [[[-121.72415, 37.91698], [-121.72365, 37.91747], [-121.7235, 37.91767], [-121.7234, 37.91777], [-121.72327, 37.91786], [-121.72308, 37.91794], [-121.72297, 37.91789], [-121.723, 37.91701], [-121.72295, 37.91576], [-121.72267, 37.91307], [-121.72262, 37.91281], [-121.72256, 37.9126], [-121.72222, 37.91184], [-121.72214, 37.91162], [-121.72206, 37.91131], [-121.72207, 37.91124], [-121.72237, 37.91122], [-121.7229, 37.91125], [-121.72292, 37.91138], [-121.7229, 37.91172], [-121.72297, 37.91196], [-121.72309, 37.91216], [-121.72331, 37.91239], [-121.72353, 37.91275], [-121.72409, 37.9139], [-121.7241, 37.91405], [-121.72403, 37.9143], [-121.72336, 37.91543], [-121.7233, 37.9156], [-121.72328, 37.91577], [-121.72329, 37.9159], [-121.72333, 37.91603], [-121.72344, 37.91635], [-121.72354, 37.91652], [-121.72362, 37.91661], [-121.72375, 37.91673], [-121.72415, 37.91698]]]} | Open Access 1 | Summerset Commons Park | 32136 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 13.071 | Summerset Commons Park | ||
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.69024, 37.95121], [-121.69023, 37.95177], [-121.69021, 37.95181], [-121.69016, 37.95182], [-121.6894, 37.95182], [-121.68941, 37.95131], [-121.68938, 37.95125], [-121.68945, 37.95122], [-121.6895, 37.95117], [-121.68955, 37.95121], [-121.69024, 37.95121]]]} | Open Access 1 | Daytona Park | 32129 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.222 | Daytona Park | ||
13206 | 13206 | 13205 | {"type": "Polygon", "coordinates": [[[-121.68867, 37.94427], [-121.68866, 37.94482], [-121.68793, 37.94481], [-121.68787, 37.94478], [-121.68787, 37.94432], [-121.6879, 37.94427], [-121.68794, 37.94426], [-121.68867, 37.94427]]]} | Open Access 1 | Pelican Park | 32127 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.051 | Pelican 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 | ||
13204 | 13204 | 13203 | {"type": "Polygon", "coordinates": [[[-121.68994, 37.94182], [-121.68992, 37.94186], [-121.68987, 37.94187], [-121.68889, 37.94188], [-121.68888, 37.94128], [-121.68987, 37.94127], [-121.68992, 37.94128], [-121.68994, 37.94132], [-121.68994, 37.94182]]]} | Open Access 1 | Egret Park | 32125 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.538 | Egret Park | ||
13203 | 13203 | 13202 | {"type": "Polygon", "coordinates": [[[-121.6856, 37.93691], [-121.6856, 37.93746], [-121.68543, 37.93746], [-121.68543, 37.93691], [-121.6856, 37.93691]]]} | Open Access 1 | Sawyer Pocket Park | 32123 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.225 | Sawyer PP | ||
13202 | 13202 | 13201 | {"type": "Polygon", "coordinates": [[[-121.68684, 37.93578], [-121.68654, 37.93578], [-121.68655, 37.9355], [-121.68663, 37.93552], [-121.68674, 37.93557], [-121.68678, 37.93562], [-121.68684, 37.93578]]]} | Open Access 1 | Crocket Pocket Park | 32122 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.147 | Crocket PP | ||
536 | 536 | 535 | {"type": "Polygon", "coordinates": [[[-121.68502, 37.93332], [-121.68478, 37.93333], [-121.68477, 37.93286], [-121.68501, 37.93286], [-121.68502, 37.93332]]]} | Open Access 1 | Rice Pocket Park | 32117 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.271 | Rice PP | ||
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-121.72041, 37.93322], [-121.72041, 37.93341], [-121.72006, 37.93341], [-121.72011, 37.93326], [-121.72014, 37.93323], [-121.72041, 37.93322]]]} | Open Access 1 | Stonehaven Park | 32114 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.141 | Stonehaven Park | ||
627 | 627 | 626 | {"type": "Polygon", "coordinates": [[[-121.72094, 37.92872], [-121.7209, 37.92878], [-121.72062, 37.92883], [-121.72056, 37.92863], [-121.71954, 37.92735], [-121.71988, 37.92718], [-121.71997, 37.92722], [-121.72007, 37.92724], [-121.72052, 37.92724], [-121.72059, 37.92728], [-121.72061, 37.92733], [-121.72057, 37.928], [-121.72058, 37.92857], [-121.72061, 37.92864], [-121.72068, 37.92868], [-121.72074, 37.9287], [-121.72094, 37.9287], [-121.72094, 37.92872]]]} | Open Access 1 | Sage Glen Park | 32110 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 2.004 | Sage Glen Park | ||
625 | 625 | 624 | {"type": "Polygon", "coordinates": [[[-121.73817, 37.92637], [-121.737, 37.92675], [-121.73669, 37.92711], [-121.73655, 37.92748], [-121.73652, 37.92788], [-121.73674, 37.92832], [-121.73685, 37.92845], [-121.73682, 37.9285], [-121.73652, 37.92854], [-121.73641, 37.92799], [-121.7364, 37.92779], [-121.73641, 37.92759], [-121.7365, 37.9273], [-121.73675, 37.9268], [-121.73678, 37.92658], [-121.73687, 37.92662], [-121.73804, 37.92622], [-121.73817, 37.92637]]]} | Open Access 1 | Cortona Trailhead | 32108 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.301 | Cortona Trailhead | ||
630 | 630 | 629 | {"type": "Polygon", "coordinates": [[[-121.73673, 37.92927], [-121.73653, 37.92935], [-121.73643, 37.92901], [-121.7365, 37.92903], [-121.7366, 37.92915], [-121.73673, 37.92927]]]} | Open Access 1 | Carrara Pocket Park | 32107 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.103 | Carrara PP | ||
621 | 621 | 620 | {"type": "Polygon", "coordinates": [[[-121.73791, 37.93053], [-121.73775, 37.93058], [-121.7371, 37.93028], [-121.73713, 37.93021], [-121.7373, 37.93016], [-121.73735, 37.93021], [-121.73741, 37.93024], [-121.73749, 37.93025], [-121.73757, 37.93022], [-121.73763, 37.93035], [-121.73776, 37.93046], [-121.73787, 37.93046], [-121.73791, 37.93053]]]} | Open Access 1 | Cortona Park | 32104 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.308 | Cortona Park | ||
620 | 620 | 619 | {"type": "Polygon", "coordinates": [[[-121.73383, 37.94934], [-121.73383, 37.94951], [-121.73379, 37.94955], [-121.73343, 37.94958], [-121.73313, 37.94958], [-121.73309, 37.94957], [-121.73306, 37.94953], [-121.73306, 37.94933], [-121.73383, 37.94934]]]} | Open Access 1 | Cherry Park | 32103 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.435 | Cherry Park | ||
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 | ||
619 | 619 | 618 | {"type": "Polygon", "coordinates": [[[-121.74031, 37.95246], [-121.74031, 37.95295], [-121.73971, 37.95295], [-121.73971, 37.95246], [-121.74031, 37.95246]]]} | Open Access 1 | Appaloosa Park | 32100 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.713 | Appaloosa Park | ||
618 | 618 | 617 | {"type": "Polygon", "coordinates": [[[-121.72506, 37.94971], [-121.72502, 37.94983], [-121.72487, 37.94983], [-121.72487, 37.94959], [-121.72504, 37.94968], [-121.72506, 37.94971]]]} | Open Access 1 | Fiorita Pocket Park | 32099 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.083 | Fiorita PP | ||
612 | 612 | 611 | {"type": "Polygon", "coordinates": [[[-121.73119, 37.95185], [-121.73119, 37.95226], [-121.73077, 37.95226], [-121.73077, 37.9519], [-121.73078, 37.95186], [-121.73119, 37.95185]]]} | Open Access 1 | Fruitwood Park | 32098 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.417 | Fruitwood 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]);