units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, MNG_AGENCY = 32, MNG_AG_TYP = 2 and YR_EST = 1980
This data as json, copyable, CSV (advanced)
DES_TP 6
- Local Park 1
- Local Recreation Area 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 6 ✖
MNG_AGENCY 1
- San Jose, City of · 6 ✖
ACCESS_TYP 1
- Open Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
870 | 870 | 869 | {"type": "Polygon", "coordinates": [[[-121.81872, 37.23996], [-121.81869, 37.24127], [-121.8181, 37.24107], [-121.81777, 37.241], [-121.81742, 37.24099], [-121.81736, 37.24095], [-121.81724, 37.24045], [-121.81706, 37.23993], [-121.81872, 37.23996]]]} | Open Access 1 | 5610 | Calero Park | 16680 | 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 | 4.064 | Calero Park | 1980 | Local Park 2 | 4 | |
1420 | 1420 | 1419 | {"type": "Polygon", "coordinates": [[[-121.87631, 37.40276], [-121.87599, 37.40296], [-121.87594, 37.40287], [-121.87584, 37.40275], [-121.87572, 37.40268], [-121.87554, 37.4026], [-121.87545, 37.40254], [-121.87456, 37.40155], [-121.87443, 37.40145], [-121.87422, 37.40134], [-121.87407, 37.40129], [-121.87384, 37.40126], [-121.87369, 37.40126], [-121.87353, 37.40129], [-121.87332, 37.40137], [-121.87154, 37.40238], [-121.87135, 37.40245], [-121.87107, 37.40248], [-121.87083, 37.40256], [-121.87028, 37.40286], [-121.87021, 37.40285], [-121.86956, 37.40213], [-121.8695, 37.40209], [-121.86942, 37.40207], [-121.86929, 37.40208], [-121.86659, 37.40363], [-121.86648, 37.40364], [-121.86643, 37.40363], [-121.86638, 37.40358], [-121.86565, 37.4026], [-121.86496, 37.4016], [-121.86511, 37.40159], [-121.86516, 37.40165], [-121.86521, 37.40167], [-121.86528, 37.40166], [-121.86534, 37.40161], [-121.86534, 37.40154], [-121.86538, 37.4015], [-121.86584, 37.40127], [-121.8659, 37.40127], [-121.86596, 37.40131], [-121.86627, 37.40174], [-121.86641, 37.40187], [-121.86649, 37.40191], [-121.86665, 37.40199], [-121.8668, 37.40203], [-121.86696, 37.40206], [-121.8672, 37.40205], [-121.86743, 37.402], [-121.86766, 37.40189], [-121.86873, 37.40129], [-121.86887, 37.40123], [-121.86914, 37.40118], [-121.86929, 37.40114], [-121.8699, 37.4008], [-121.86996, 37.40082], [-121.87035, 37.40125], [-121.87054, 37.40138], [-121.87068, 37.40144], [-121.87092, 37.4015], [-121.87108, 37.40151], [-121.87124, 37.4015], [-121.8714, 37.40146], [-121.87162, 37.40137], [-121.87371, 37.40016], [-121.87375, 37.40013], [-121.87377, 37.40008], [-121.87386, 37.40009], [-121.87423, 37.39987], [-121.87494, 37.40039], [-121.87514, 37.40056], [-121.87531, 37.40075], [-121.87546, 37.40095], [-121.8757, 37.40137], [-121.87631, 37.40276]]]} | Open Access 1 | 9047 | Cataldi | 16968 | 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 | 32.695 | Cataldi | 1980 | None 120 | ||
2409 | 2409 | 2408 | {"type": "Polygon", "coordinates": [[[-121.81675, 37.33738], [-121.81662, 37.33744], [-121.81651, 37.3375], [-121.81637, 37.33766], [-121.81631, 37.33779], [-121.81629, 37.33789], [-121.81629, 37.33799], [-121.81632, 37.33808], [-121.80608, 37.34136], [-121.80603, 37.34134], [-121.80305, 37.33809], [-121.80306, 37.33807], [-121.80298, 37.33798], [-121.80134, 37.33613], [-121.8011, 37.33581], [-121.80108, 37.33574], [-121.80111, 37.33567], [-121.80115, 37.33563], [-121.80158, 37.3355], [-121.80194, 37.33536], [-121.80226, 37.3352], [-121.80259, 37.33498], [-121.80377, 37.33405], [-121.80417, 37.33375], [-121.80429, 37.33368], [-121.80458, 37.33353], [-121.80485, 37.33342], [-121.80537, 37.33326], [-121.80567, 37.33321], [-121.80599, 37.33318], [-121.80648, 37.33319], [-121.80692, 37.33325], [-121.80771, 37.33342], [-121.80815, 37.33346], [-121.80854, 37.33347], [-121.80902, 37.33342], [-121.80942, 37.33334], [-121.80978, 37.33323], [-121.81024, 37.33304], [-121.81026, 37.33311], [-121.81052, 37.333], [-121.81058, 37.33299], [-121.81063, 37.333], [-121.81067, 37.33303], [-121.81086, 37.33336], [-121.81099, 37.33349], [-121.81116, 37.33357], [-121.81131, 37.33361], [-121.81141, 37.33361], [-121.81151, 37.3336], [-121.8134, 37.33323], [-121.81414, 37.33373], [-121.81422, 37.33379], [-121.81675, 37.33738]]]} | Open Access 1 | 17244 | Lake Cunningham | 11172 | 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/Facility/Details/179 | Santa Clara 19 | 201.676 | Lake Cunningham | 1980 | None 202 | |
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 | |
5730 | 5730 | 5729 | {"type": "Polygon", "coordinates": [[[-121.91133, 37.3038], [-121.91123, 37.3038], [-121.91097, 37.30388], [-121.90824, 37.30512], [-121.90819, 37.30509], [-121.90757, 37.30397], [-121.90756, 37.30393], [-121.90758, 37.30385], [-121.90764, 37.3038], [-121.90819, 37.30361], [-121.90826, 37.30356], [-121.9083, 37.30351], [-121.90832, 37.30346], [-121.9083, 37.30333], [-121.9083, 37.30327], [-121.90832, 37.30322], [-121.90839, 37.30317], [-121.90993, 37.30256], [-121.91003, 37.30249], [-121.91012, 37.30238], [-121.91112, 37.30232], [-121.91131, 37.30232], [-121.91133, 37.3038]]]} | Open Access 1 | 2258 | Bramhall | 16328 | 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 | 14.619 | Bramhall | 1980 | None 461 | ||
10529 | 10529 | 10528 | {"type": "Polygon", "coordinates": [[[-121.86047, 37.35798], [-121.86039, 37.35799], [-121.85985, 37.35783], [-121.85954, 37.35777], [-121.85736, 37.35764], [-121.85711, 37.35765], [-121.85691, 37.35767], [-121.85672, 37.35771], [-121.85651, 37.35778], [-121.85668, 37.35763], [-121.8588, 37.3562], [-121.85878, 37.35623], [-121.85879, 37.35626], [-121.86046, 37.35796], [-121.86047, 37.35798]]]} | Open Access 1 | 18733 | Plata Arroyo | 23771 | 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 | 6.812 | Plata Arroyo | 1980 | None 922 |
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]);