units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "2.732" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
6902 | 6902 | 6901 | {"type": "Polygon", "coordinates": [[[-118.41789, 34.03357], [-118.4178, 34.03361], [-118.4177, 34.03353], [-118.41757, 34.03333], [-118.41748, 34.03342], [-118.41759, 34.0336], [-118.41767, 34.0337], [-118.41738, 34.03386], [-118.41757, 34.03413], [-118.41704, 34.03441], [-118.41665, 34.03371], [-118.41633, 34.03326], [-118.41652, 34.03316], [-118.41673, 34.03311], [-118.41678, 34.03316], [-118.4169, 34.03309], [-118.41687, 34.03304], [-118.41751, 34.03264], [-118.41755, 34.03265], [-118.41766, 34.03279], [-118.4169, 34.03321], [-118.41711, 34.03345], [-118.41744, 34.0333], [-118.41758, 34.0332], [-118.41781, 34.03349], [-118.41789, 34.03357]]]} | Open Access 1 | 5746 | Palms Park | 23357 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.732 | Palms Park | 0 | Local Park 2 | 4 | |
13324 | 13324 | 13323 | {"type": "Polygon", "coordinates": [[[-119.17111, 34.29781], [-119.16993, 34.29836], [-119.16972, 34.2979], [-119.16943, 34.29782], [-119.16936, 34.29791], [-119.16924, 34.29786], [-119.16889, 34.29766], [-119.16883, 34.29757], [-119.16876, 34.29752], [-119.16869, 34.29752], [-119.16861, 34.29754], [-119.16848, 34.29745], [-119.16804, 34.29733], [-119.16793, 34.29739], [-119.16761, 34.29702], [-119.16778, 34.29692], [-119.16789, 34.29698], [-119.16878, 34.29733], [-119.17065, 34.29785], [-119.17111, 34.29781]]]} | Open Access 1 | 35391 | Ventura holding 21 | 26898 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.732 | Ventura holding 21 | 0 | Local Other or Unknown 14 | 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]);