superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1, MNG_AGENCY = 32 and YR_EST = 1978
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1992 | 1992 | 1991 | {"type": "Polygon", "coordinates": [[[-121.89592, 37.31933], [-121.89588, 37.32002], [-121.89304, 37.31991], [-121.89309, 37.31912], [-121.89526, 37.3192], [-121.89525, 37.3194], [-121.89529, 37.31941], [-121.89538, 37.31938], [-121.89542, 37.31931], [-121.89592, 37.31933]]]} | Open Access 1 | Biebrach Park | 16071 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.305 | Biebrach Park | 1978 | |
2451 | 2451 | 2450 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30261], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02376, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | Calabazas | 16668 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 16.77 | Calabazas | 1978 | |
2474 | 2474 | 2473 | {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} | Open Access 1 | Cahalan | 16655 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.756 | Cahalan | 1978 | |
4150 | 4150 | 4149 | {"type": "Polygon", "coordinates": [[[-121.82711, 37.33885], [-121.82645, 37.33931], [-121.82597, 37.33976], [-121.82509, 37.34035], [-121.82503, 37.34034], [-121.82348, 37.33884], [-121.8235, 37.33878], [-121.82558, 37.33734], [-121.82566, 37.33737], [-121.82711, 37.33885]]]} | Open Access 1 | Hillview Park | 19994 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 13.613 | Hillview Park | 1978 | |
4288 | 4288 | 4287 | {"type": "Polygon", "coordinates": [[[-121.85272, 37.23577], [-121.85243, 37.2366], [-121.85264, 37.23691], [-121.85239, 37.23705], [-121.85219, 37.23711], [-121.85198, 37.23713], [-121.85162, 37.2371], [-121.85147, 37.23711], [-121.85126, 37.23716], [-121.85122, 37.23715], [-121.85108, 37.23701], [-121.85096, 37.2369], [-121.85064, 37.23671], [-121.85053, 37.23661], [-121.8504, 37.23645], [-121.85033, 37.23629], [-121.85033, 37.23621], [-121.85035, 37.23607], [-121.85042, 37.23587], [-121.85051, 37.23575], [-121.85073, 37.23558], [-121.85084, 37.2359], [-121.85102, 37.23602], [-121.85121, 37.23584], [-121.85211, 37.23531], [-121.8522, 37.23564], [-121.85225, 37.23572], [-121.85272, 37.23577]]]} | Open Access 1 | Foothill Park | 18979 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.911 | Foothill Park | 1978 | |
8228 | 8228 | 8227 | {"type": "Polygon", "coordinates": [[[-121.85019, 37.25398], [-121.85019, 37.25444], [-121.85016, 37.25448], [-121.84869, 37.25448], [-121.84852, 37.25447], [-121.84847, 37.25442], [-121.8485, 37.25429], [-121.84877, 37.25364], [-121.84912, 37.25368], [-121.84947, 37.25375], [-121.84951, 37.25381], [-121.84958, 37.25384], [-121.84965, 37.25384], [-121.84974, 37.25381], [-121.84979, 37.25381], [-121.85002, 37.25388], [-121.85017, 37.25395], [-121.85019, 37.25398]]]} | Open Access 1 | Playa Del Rey Park | 23774 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.792 | Playa Del Rey Park | 1978 | |
8927 | 8927 | 8926 | {"type": "Polygon", "coordinates": [[[-121.87433, 37.3454], [-121.87431, 37.34541], [-121.87413, 37.3459], [-121.87387, 37.34635], [-121.87387, 37.34678], [-121.8738, 37.34722], [-121.87341, 37.34738], [-121.8724, 37.34787], [-121.87134, 37.34646], [-121.87242, 37.34597], [-121.87186, 37.3452], [-121.8739, 37.34423], [-121.87425, 37.34471], [-121.87433, 37.3454]]]} | Open Access 1 | Roosevelt | 24592 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 15.023 | Roosevelt | 1978 | |
9261 | 9261 | 9260 | {"type": "Polygon", "coordinates": [[[-121.97624, 37.27999], [-121.97415, 37.28001], [-121.97397, 37.27964], [-121.97428, 37.2795], [-121.97443, 37.27938], [-121.97475, 37.27907], [-121.97486, 37.27901], [-121.97499, 37.27896], [-121.97526, 37.27891], [-121.97613, 37.27893], [-121.97617, 37.27894], [-121.97619, 37.27898], [-121.97617, 37.27919], [-121.97624, 37.27999]]]} | Open Access 1 | San Tomas Park | 24995 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.804 | San Tomas Park | 1978 | |
9337 | 9337 | 9336 | {"type": "Polygon", "coordinates": [[[-121.94552, 37.31845], [-121.94347, 37.31848], [-121.94348, 37.31762], [-121.94351, 37.31759], [-121.94354, 37.31758], [-121.94357, 37.31765], [-121.94365, 37.31768], [-121.9437, 37.31764], [-121.94369, 37.31755], [-121.94377, 37.31753], [-121.94543, 37.31734], [-121.94548, 37.31734], [-121.94551, 37.31739], [-121.94552, 37.31845]]]} | Open Access 1 | Santana Park | 25148 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.009 | Santana Park | 1978 |
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]);