units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 271, DES_TP = 1370 and MNG_AGENCY = 790
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15893 | 15893 | 15892 | {"type": "Polygon", "coordinates": [[[-117.81962, 33.61813], [-117.81951, 33.61818], [-117.81938, 33.61821], [-117.81928, 33.61821], [-117.81893, 33.61814], [-117.81863, 33.61813], [-117.81847, 33.61815], [-117.81813, 33.61823], [-117.81785, 33.61836], [-117.81684, 33.61861], [-117.81668, 33.61869], [-117.81655, 33.61881], [-117.81646, 33.61894], [-117.8164, 33.61914], [-117.81636, 33.61922], [-117.81605, 33.61955], [-117.81584, 33.61972], [-117.81552, 33.61988], [-117.81527, 33.61996], [-117.81508, 33.61998], [-117.8146, 33.61999], [-117.81446, 33.62003], [-117.81428, 33.62013], [-117.81416, 33.62017], [-117.81381, 33.62013], [-117.81336, 33.62012], [-117.81285, 33.62016], [-117.81245, 33.62023], [-117.8121, 33.6202], [-117.81097, 33.62083], [-117.8109, 33.62094], [-117.81089, 33.62103], [-117.81096, 33.62172], [-117.80905, 33.62377], [-117.80884, 33.62409], [-117.80873, 33.62432], [-117.80865, 33.62455], [-117.8086, 33.62491], [-117.80861, 33.62532], [-117.80871, 33.62571], [-117.80887, 33.62607], [-117.80885, 33.6262], [-117.80875, 33.6264], [-117.80872, 33.62652], [-117.8087, 33.62664], [-117.80871, 33.62686], [-117.80876, 33.62701], [-117.80886, 33.62721], [-117.80898, 33.62735], [-117.80912, 33.62747], [-117.80915, 33.62752], [-117.80914, 33.62755], [-117.80903, 33.62765], [-117.80894, 33.62778], [-117.80888, 33.62793], [-117.80886, 33.62805], [-117.80886, 33.62818], [-117.80891, 33.62832], [-117.80897, 33.62844], [-117.80906, 33.62855], [-117.80859, 33.62925], [-117.80879, 33.62973], [-117.80845, 33.62988], [-117.80813, 33.63004], [-117.80699, 33.6307], [-117.80676, 33.63044], [-117.80662, 33.63025], [-117.80654, 33.63009], [-117.80637, 33.62966], [-117.80636, 33.62965], [-117.80639, 33.63], [-117.80667, 33.63052], [-117.80697, 33.63085], [-117.80641, 33.63119], [-117.80586, 33.63155], [-117.80516, 33.6319], [-117.80553, 33.63157], [-117.80604, 33.63033], [-117.80589, 33.62977], [-117.80561, 33.62915], [-117.80484, 33.62869], [-117.80491, 33.62835], [-117.80494, 33.62806], [-117.80393, 33.62709], [-117.80372, 33.62684], [-117.80351, 33.62655], [-117.80335, 33.62628], [-117.8035, 33.62577], [-117.80351, 33.62564], [-117.80349, 33.62555], [-117.80332, 33.62517], [-117.80324, 33.62505], [-117.80315, 33.62498], [-117.80281, 33.62478], [-117.8027, 33.62473], [-117.80259, 33.62471], [-117.80248, 33.62471], [-117.8023, 33.62475], [-117.80222, 33.62472], [-117.80219, 33.62449], [-117.8021, 33.62435], [-117.802, 33.62427], [-117.8016, 33.6241], [-117.8014, 33.62388], [-117.80091, 33.62341], [-117.80088, 33.62325], [-117.80077, 33.62312], [-117.80055, 33.62299], [-117.80022, 33.62286], [-117.79964, 33.62243], [-117.79957, 33.62235], [-117.79959, 33.62213], [-117.79958, 33.62203], [-117.79953, 33.62192], [-117.79932, 33.6216], [-117.79914, 33.62145], [-117.7986, 33.62122], [-117.798, 33.62138], [-117.79767, 33.62152], [-117.79714, 33.62192], [-117.79705, 33.62208], [-117.79664, 33.62214], [-117.79654, 33.62154], [-117.79604, 33.62068], [-117.79566, 33.62059], [-117.79534, 33.62021], [-117.79535, 33.62001], [-117.79533, 33.6199], [-117.79525, 33.61974], [-117.79516, 33.61964], [-117.79502, 33.61954], [-117.7949, 33.6195], [-117.79475, 33.61947], [-117.79456, 33.61947], [-117.79401, 33.61955], [-117.79385, 33.62019], [-117.79367, 33.61996], [-117.79351, 33.61979], [-117.79286, 33.61925], [-117.79295, 33.61907], [-117.79299, 33.61896], [-117.793, 33.61878], [-117.79298, 33.61863], [-117.78857, 33.60386], [-117.78887, 33.604], [-117.78953, 33.60444], [-117.79025, 33.60471], [-117.79079, 33.6046], [-117.79212, 33.60517], [-117.79241, 33.60512], [-117.79262, 33.60531], [-117.79273, 33.60565], [-117.79272, 33.60584], [-117.79286, 33.60623], [-117.79306, 33.60628], [-117.79334, 33.60624], [-117.7936, 33.60626], [-117.79374, 33.60639], [-117.79415, 33.60648], [-117.79446, 33.60638], [-117.7948, 33.60647], [-117.79526, 33.60675], [-117.79541, 33.60709], [-117.79537, 33.60735], [-117.79583, 33.60731], [-117.79661, 33.60688], [-117.79717, 33.60676], [-117.79784, 33.6069], [-117.79777, 33.60711], [-117.798, 33.6075], [-117.79806, 33.60772], [-117.79867, 33.60796], [-117.79926, 33.60808], [-117.79936, 33.60811], [-117.7994, 33.60837], [-117.79937, 33.60852], [-117.79947, 33.60854], [-117.80009, 33.60821], [-117.80066, 33.60806], [-117.80096, 33.60864], [-117.80099, 33.60895], [-117.80138, 33.60936], [-117.80142, 33.60959], [-117.8016, 33.6098], [-117.80155, 33.60994], [-117.80175, 33.61004], [-117.8021, 33.61044], [-117.80225, 33.61075], [-117.80238, 33.61071], [-117.80245, 33.61011], [-117.80261, 33.60983], [-117.80274, 33.60982], [-117.80295, 33.60973], [-117.80311, 33.60974], [-117.8033, 33.60972], [-117.80356, 33.60988], [-117.80381, 33.61014], [-117.80386, 33.61047], [-117.80395, 33.61076], [-117.80405, 33.61087], [-117.80476, 33.61056], [-117.80498, 33.6104], [-117.80531, 33.61005], [-117.80544, 33.61006], [-117.80558, 33.60998], [-117.8059, 33.6095], [-117.80669, 33.60961], [-117.80711, 33.61013], [-117.80761, 33.61045], [-117.80787, 33.61039], [-117.80814, 33.61052], [-117.80849, 33.61059], [-117.80871, 33.61074], [-117.81049, 33.61078], [-117.81089, 33.61098], [-117.8103, 33.61012], [-117.81124, 33.61026], [-117.81189, 33.6104], [-117.81268, 33.61063], [-117.8133, 33.61086], [-117.8136, 33.61098], [-117.81418, 33.61126], [-117.81474, 33.61157], [-117.81501, 33.61174], [-117.81553, 33.6121], [-117.8159, 33.61238], [-117.81624, 33.61269], [-117.81668, 33.61312], [-117.81698, 33.61345], [-117.81726, 33.6138], [-117.81752, 33.61416], [-117.8179, 33.61479], [-117.81899, 33.61691], [-117.81902, 33.6169], [-117.81913, 33.61711], [-117.8191, 33.61713], [-117.81962, 33.61813]]]} | Open Access 1 | 6723 | South-Bommer Canyon Open Space Preserve | 31196 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | http://www.cityofirvine.org/cityhall/cs/openspace/bommer_canyon.asp | Orange 3 | 923.74 | South-Bommer Canyon OSP | None 1370 |
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]);