units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 32
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 12
ACCESS_TYP 1
- Open Access · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1397 | 1397 | 1396 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.2322], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | 8689 | Albertson Parkway | 15341 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.047 | Albertson Parkway | 1998 | Local Recreation Area 3 | 4 | |
1414 | 1414 | 1413 | {"type": "Polygon", "coordinates": [[[-121.8079, 37.3073], [-121.80762, 37.30745], [-121.80746, 37.30774], [-121.80743, 37.30773], [-121.80752, 37.30753], [-121.80727, 37.30715], [-121.80759, 37.30702], [-121.80764, 37.30702], [-121.80768, 37.30704], [-121.8079, 37.3073]]]} | Open Access 1 | 8882 | Brigadoon Tot Lot | 16388 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.454 | Brigadoon Tot Lot | 1996 | Local Recreation Area 3 | 4 | |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 4 |
4313 | 4313 | 4312 | {"type": "Polygon", "coordinates": [[[-121.84378, 37.30875], [-121.84355, 37.30896], [-121.84336, 37.30881], [-121.84333, 37.30882], [-121.84321, 37.30875], [-121.84336, 37.3085], [-121.84378, 37.30875]]]} | Open Access 1 | 45393 | La Raggione Tot Lot | 27912 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities?clear=True | Santa Clara 19 | 0.304 | La Raggione Tot Lot | 0 | Local Recreation Area 3 | 4 |
5020 | 5020 | 5019 | {"type": "Polygon", "coordinates": [[[-121.92594, 37.3438], [-121.92465, 37.3447], [-121.92459, 37.34464], [-121.92486, 37.34438], [-121.9254, 37.34394], [-121.92553, 37.34388], [-121.92575, 37.34382], [-121.92594, 37.3438]]]} | Open Access 1 | 1034 | Southside Community Center | 25697 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.528 | Southside Community Ctr. | 1980 | Local Recreation Area 3 | 4 | |
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-121.93454, 37.26366], [-121.93454, 37.26383], [-121.93449, 37.26388], [-121.93447, 37.26395], [-121.93446, 37.2643], [-121.93449, 37.26439], [-121.93448, 37.26468], [-121.9316, 37.2647], [-121.9316, 37.26461], [-121.93187, 37.26459], [-121.93183, 37.26378], [-121.93196, 37.2638], [-121.93212, 37.26384], [-121.93211, 37.26389], [-121.93241, 37.26393], [-121.93261, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93378, 37.26427], [-121.93379, 37.26407], [-121.93376, 37.26406], [-121.93375, 37.26376], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93396, 37.26373], [-121.93439, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | 6499 | Camden Park Center | 16755 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.013 | Camden Park Ctr. | 1961 | Local Recreation Area 3 | 4 | |
8589 | 8589 | 8588 | {"type": "Polygon", "coordinates": [[[-121.8648, 37.33265], [-121.8647, 37.33318], [-121.86433, 37.33313], [-121.86441, 37.33274], [-121.8648, 37.33265]]]} | Open Access 1 | 13657 | Forestdale Tot Lot | 18999 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.418 | Forestdale Tot Lot | 1988 | Local Recreation Area 3 | 4 | |
8593 | 8593 | 8592 | {"type": "Polygon", "coordinates": [[[-121.90177, 37.31871], [-121.90143, 37.31907], [-121.90143, 37.31907], [-121.90145, 37.3187], [-121.90177, 37.31871]]]} | Open Access 1 | 13668 | Gregory Plaza Tot Lot | 19501 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.146 | Gregory Plaza Tot Lot | 1998 | Local Recreation Area 3 | 4 | |
8596 | 8596 | 8595 | {"type": "Polygon", "coordinates": [[[-121.91488, 37.26568], [-121.91464, 37.26579], [-121.9143, 37.2652], [-121.91456, 37.26513], [-121.91488, 37.26568]]]} | Open Access 1 | 13673 | Huerta Tot Lot | 20137 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.427 | Huerta Tot Lot | 2002 | Local Recreation Area 3 | 4 | |
8604 | 8604 | 8603 | {"type": "Polygon", "coordinates": [[[-121.77261, 37.22524], [-121.77226, 37.22632], [-121.77218, 37.22638], [-121.77202, 37.22639], [-121.77177, 37.22636], [-121.7713, 37.22671], [-121.77114, 37.22687], [-121.76979, 37.22607], [-121.77015, 37.22476], [-121.77007, 37.22474], [-121.77007, 37.22473], [-121.77243, 37.22517], [-121.77261, 37.22524]]]} | Open Access 1 | 13691 | Martin Murphy Playfield | 21923 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.388 | Martin Murphy Playfield | 1984 | Local Recreation Area 3 | 4 | |
9369 | 9369 | 9368 | {"type": "Polygon", "coordinates": [[[-121.8548, 37.31737], [-121.85467, 37.31744], [-121.8546, 37.31739], [-121.85458, 37.31695], [-121.85444, 37.31663], [-121.85461, 37.31658], [-121.85474, 37.31677], [-121.8548, 37.31705], [-121.85478, 37.31731], [-121.8548, 37.31737]]]} | Open Access 1 | 15651 | Rocksprings Playground | 24534 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.408 | Rocksprings Playground | 1962 | Local Recreation Area 3 | 4 | |
17019 | 17019 | 17018 | {"type": "Polygon", "coordinates": [[[-121.82044, 37.31685], [-121.82017, 37.31701], [-121.81994, 37.31677], [-121.82016, 37.31665], [-121.82022, 37.31664], [-121.82025, 37.31666], [-121.82044, 37.31685]], [[-121.82037, 37.31683], [-121.82037, 37.31681], [-121.82025, 37.31669], [-121.82013, 37.31676], [-121.82025, 37.31689], [-121.82037, 37.31683]]]} | Open Access 1 | 8945 | Meadowfair Center | 22084 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.182 | Meadowfair Ctr. | 0 | Local Recreation Area 3 | 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]);