units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Arroyo Park" and MNG_AGENCY = 52
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6858 | 6858 | 6857 | {"type": "Polygon", "coordinates": [[[-117.85946, 33.634], [-117.85948, 33.63441], [-117.85935, 33.63552], [-117.8593, 33.63562], [-117.85881, 33.63618], [-117.85882, 33.63629], [-117.85886, 33.63639], [-117.85897, 33.63653], [-117.85908, 33.6366], [-117.8592, 33.63664], [-117.85944, 33.63667], [-117.85941, 33.63701], [-117.85935, 33.637], [-117.85929, 33.63705], [-117.85887, 33.63704], [-117.85886, 33.63702], [-117.85886, 33.63682], [-117.85864, 33.63666], [-117.85845, 33.63648], [-117.85847, 33.63616], [-117.85839, 33.6359], [-117.85816, 33.63579], [-117.85774, 33.63521], [-117.85789, 33.63512], [-117.85802, 33.635], [-117.85815, 33.63486], [-117.85827, 33.63468], [-117.85839, 33.63443], [-117.85849, 33.6341], [-117.85852, 33.63394], [-117.85852, 33.63379], [-117.85849, 33.63353], [-117.85855, 33.63332], [-117.85855, 33.6332], [-117.85852, 33.63308], [-117.85843, 33.63287], [-117.85814, 33.63262], [-117.85808, 33.63219], [-117.85798, 33.63194], [-117.85789, 33.63179], [-117.85751, 33.63134], [-117.85764, 33.63115], [-117.8577, 33.63098], [-117.8577, 33.63074], [-117.85774, 33.63052], [-117.85773, 33.63018], [-117.85778, 33.62994], [-117.85796, 33.62978], [-117.85802, 33.62952], [-117.85859, 33.6296], [-117.85917, 33.62962], [-117.85907, 33.63001], [-117.85882, 33.63027], [-117.85856, 33.6306], [-117.8585, 33.63078], [-117.85849, 33.631], [-117.85853, 33.63122], [-117.85864, 33.63143], [-117.8588, 33.63161], [-117.85906, 33.63183], [-117.85915, 33.63232], [-117.8592, 33.63271], [-117.85925, 33.63289], [-117.85928, 33.6331], [-117.85939, 33.63344], [-117.8594, 33.63379], [-117.85938, 33.63397], [-117.85946, 33.634]]]} | Open Access 1 | 5492 | Arroyo Park | 15615 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 18.387 | Arroyo Park | 0 | 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]);