units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, MNG_AGENCY = 32, MNG_AG_TYP = 2 and YR_EST = 1962
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2742 | 2742 | 2741 | {"type": "Polygon", "coordinates": [[[-121.85257, 37.34148], [-121.84776, 37.34453], [-121.84758, 37.34434], [-121.8473, 37.34393], [-121.84727, 37.34384], [-121.84727, 37.34377], [-121.84728, 37.34371], [-121.84732, 37.34362], [-121.84737, 37.34356], [-121.84804, 37.34292], [-121.8502, 37.34167], [-121.8504, 37.34158], [-121.85073, 37.34146], [-121.85108, 37.34137], [-121.85137, 37.34133], [-121.85163, 37.34134], [-121.85257, 37.34148]]]} | Open Access 1 | 18411 | P.A.L. Sportscenter | 23287 | 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 | 13.753 | P.A.L. Sportscenter | 1962 | None 227 | ||
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 | |
9977 | 9977 | 9976 | {"type": "Polygon", "coordinates": [[[-121.86436, 37.32449], [-121.86277, 37.32544], [-121.86265, 37.32553], [-121.86248, 37.32557], [-121.86223, 37.32554], [-121.86213, 37.32557], [-121.86205, 37.32555], [-121.86197, 37.32556], [-121.86167, 37.32565], [-121.86132, 37.32587], [-121.86139, 37.32606], [-121.86101, 37.32624], [-121.861, 37.32635], [-121.86093, 37.32652], [-121.861, 37.32662], [-121.86057, 37.3271], [-121.8609, 37.32761], [-121.86112, 37.32772], [-121.85953, 37.32881], [-121.85297, 37.32221], [-121.85254, 37.32176], [-121.85209, 37.32147], [-121.85155, 37.32086], [-121.85073, 37.32013], [-121.8527, 37.31876], [-121.85442, 37.31764], [-121.85452, 37.31752], [-121.85459, 37.31753], [-121.85456, 37.31756], [-121.85453, 37.3178], [-121.85598, 37.31917], [-121.85403, 37.31875], [-121.85358, 37.31878], [-121.85292, 37.3191], [-121.85295, 37.3193], [-121.85337, 37.31946], [-121.85374, 37.31951], [-121.85506, 37.31936], [-121.85577, 37.31971], [-121.85625, 37.31956], [-121.85664, 37.31937], [-121.85688, 37.31921], [-121.85731, 37.31911], [-121.85852, 37.3184], [-121.86171, 37.32174], [-121.86436, 37.32449]], [[-121.85952, 37.32512], [-121.85951, 37.32513], [-121.85957, 37.32527], [-121.85957, 37.32523], [-121.85952, 37.32512]]]} | Open Access 1 | 17167 | Kelley Park | 20576 | 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 | 164.316 | Kelley Park | 1962 | 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]);