units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1, MNG_AGENCY = 96, MNG_AG_TYP = 2 and YR_EST = 1961
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 13 ✖
MNG_AGENCY 1
- San Mateo, City of · 13 ✖
ACCESS_TYP 1
- Open Access · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 238 | 237 | {"type": "Polygon", "coordinates": [[[-122.30466, 37.56871], [-122.3034, 37.56958], [-122.30328, 37.56965], [-122.30262, 37.56848], [-122.30364, 37.56777], [-122.30466, 37.56871]]]} | Open Access 1 | 771 | Shoreview Park | 25430 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 4.751 | Shoreview Park | 1961 | Local Park 2 | 4 | |
1833 | 1833 | 1832 | {"type": "Polygon", "coordinates": [[[-122.31523, 37.58098], [-122.31449, 37.58149], [-122.31363, 37.58076], [-122.31441, 37.58023], [-122.31523, 37.58098]]]} | Open Access 1 | 14016 | Harborview | 19669 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.434 | Harborview | 1961 | None 143 | ||
1836 | 1836 | 1835 | {"type": "Polygon", "coordinates": [[[-122.29796, 37.56767], [-122.29795, 37.56824], [-122.29718, 37.56827], [-122.29719, 37.56766], [-122.29738, 37.56766], [-122.29739, 37.5677], [-122.29776, 37.5677], [-122.29777, 37.56767], [-122.29796, 37.56767]]]} | Open Access 1 | 14064 | Dale Avenue | 17893 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.07 | Dale Avenue | 1961 | None 144 | ||
1844 | 1844 | 1843 | {"type": "Polygon", "coordinates": [[[-122.32314, 37.54969], [-122.32289, 37.54988], [-122.3213, 37.54842], [-122.32142, 37.54837], [-122.32155, 37.54836], [-122.32166, 37.54838], [-122.32176, 37.54843], [-122.32314, 37.54969]]]} | Open Access 1 | 14083 | Borel Park | 16283 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.55 | Borel Park | 1961 | Local Park 2 | 4 | |
8682 | 8682 | 8681 | {"type": "Polygon", "coordinates": [[[-122.29358, 37.56203], [-122.29325, 37.56211], [-122.29295, 37.56166], [-122.29246, 37.56112], [-122.29168, 37.56068], [-122.29147, 37.5605], [-122.29138, 37.56039], [-122.29133, 37.56029], [-122.29129, 37.56017], [-122.29127, 37.56002], [-122.2913, 37.55979], [-122.29141, 37.55957], [-122.29147, 37.5596], [-122.29328, 37.56156], [-122.29358, 37.56203]]]} | Open Access 1 | 14024 | Parkside Aquatic | 23447 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 3.141 | Parkside Aquatic | 1961 | None 732 | ||
8684 | 8684 | 8683 | {"type": "Polygon", "coordinates": [[[-122.30386, 37.5286], [-122.30295, 37.52897], [-122.30258, 37.5289], [-122.30234, 37.52882], [-122.30231, 37.52883], [-122.30205, 37.52845], [-122.3034, 37.52789], [-122.30386, 37.5286]]]} | Open Access 1 | 14042 | Indian Springs | 20207 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.707 | Indian Springs | 1961 | None 733 | ||
8685 | 8685 | 8684 | {"type": "Polygon", "coordinates": [[[-122.30777, 37.53501], [-122.30722, 37.53524], [-122.30688, 37.53471], [-122.30691, 37.53452], [-122.30676, 37.53428], [-122.30662, 37.53422], [-122.30713, 37.53401], [-122.30777, 37.53501]]]} | Open Access 1 | 14044 | West Hillsdale | 27361 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.56 | West Hillsdale | 1961 | None 734 | ||
8686 | 8686 | 8685 | {"type": "Polygon", "coordinates": [[[-122.30409, 37.53651], [-122.3036, 37.53671], [-122.30288, 37.53523], [-122.30346, 37.53505], [-122.30372, 37.5359], [-122.30409, 37.53651]]]} | Open Access 1 | 14046 | East Hillsdale | 18371 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.027 | East Hillsdale | 1961 | None 735 | ||
8691 | 8691 | 8690 | {"type": "Polygon", "coordinates": [[[-122.29641, 37.55058], [-122.29569, 37.55093], [-122.29572, 37.55098], [-122.29509, 37.55128], [-122.29477, 37.5511], [-122.29445, 37.55084], [-122.29433, 37.5509], [-122.29395, 37.55051], [-122.29439, 37.55025], [-122.2946, 37.55016], [-122.296, 37.54977], [-122.29613, 37.55], [-122.2961, 37.55003], [-122.29602, 37.55005], [-122.29602, 37.55007], [-122.29641, 37.55058]]]} | Open Access 1 | 14054 | Fiesta Meadows | 18892 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 4.905 | Fiesta Meadows | 1961 | None 737 | ||
8692 | 8692 | 8691 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53399], [-122.28207, 37.53415], [-122.28213, 37.53423], [-122.28187, 37.53439], [-122.28187, 37.53441], [-122.28178, 37.53444], [-122.28173, 37.5345], [-122.2817, 37.53449], [-122.28144, 37.53464], [-122.28081, 37.53396], [-122.2823, 37.53395], [-122.28234, 37.53399]]]} | Open Access 1 | 14058 | Casanova | 16932 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.375 | Casanova | 1961 | None 738 | ||
9126 | 9126 | 9125 | {"type": "Polygon", "coordinates": [[[-122.30914, 37.55926], [-122.30919, 37.55927], [-122.30921, 37.55932], [-122.30909, 37.55976], [-122.30879, 37.55971], [-122.30855, 37.55964], [-122.30909, 37.55927], [-122.30914, 37.55926]]]} | Open Access 1 | 15133 | Sunnybrae Park | 26005 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.408 | Sunnybrae Park | 1961 | Local Park 2 | 4 | |
9127 | 9127 | 9126 | {"type": "Polygon", "coordinates": [[[-122.30455, 37.55525], [-122.30397, 37.55534], [-122.30391, 37.55508], [-122.30448, 37.55498], [-122.30455, 37.55525]]]} | Open Access 1 | 15136 | Connie Park | 17591 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.389 | Connie Park | 1961 | Local Park 2 | 4 | |
10066 | 10066 | 10065 | {"type": "Polygon", "coordinates": [[[-122.31684, 37.53809], [-122.31636, 37.53823], [-122.31625, 37.53818], [-122.31614, 37.53821], [-122.31449, 37.53937], [-122.31379, 37.53974], [-122.31339, 37.53932], [-122.313, 37.53886], [-122.31264, 37.53839], [-122.31231, 37.5379], [-122.31581, 37.53648], [-122.31684, 37.53809]]]} | Open Access 1 | 18917 | Beresford Park | 16020 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 17.934 | Beresford Park | 1961 | Local Park 2 | 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]);