units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 2, DES_TP = 1371 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15942 | 15942 | 15941 | {"type": "MultiPolygon", "coordinates": [[[[-117.79722, 33.62314], [-117.7972, 33.62335], [-117.79701, 33.6234], [-117.79689, 33.62348], [-117.79683, 33.62356], [-117.79654, 33.62404], [-117.79645, 33.62405], [-117.79564, 33.62387], [-117.79547, 33.62389], [-117.79534, 33.62394], [-117.79528, 33.62398], [-117.79518, 33.62408], [-117.79514, 33.62418], [-117.79512, 33.62425], [-117.79514, 33.6244], [-117.79506, 33.62482], [-117.79504, 33.62486], [-117.79499, 33.6249], [-117.7945, 33.62499], [-117.79432, 33.62499], [-117.79417, 33.62497], [-117.79368, 33.62507], [-117.79237, 33.62418], [-117.79197, 33.62362], [-117.79151, 33.62315], [-117.79046, 33.62292], [-117.78989, 33.62287], [-117.78917, 33.62309], [-117.78924, 33.62332], [-117.78953, 33.62365], [-117.78961, 33.62395], [-117.78936, 33.62414], [-117.78871, 33.6241], [-117.78761, 33.62515], [-117.78782, 33.62624], [-117.78783, 33.62775], [-117.78618, 33.62798], [-117.78553, 33.6277], [-117.78474, 33.6281], [-117.78403, 33.6281], [-117.78303, 33.62762], [-117.78202, 33.62841], [-117.78196, 33.63062], [-117.78292, 33.63264], [-117.78219, 33.63294], [-117.78155, 33.63185], [-117.78121, 33.6318], [-117.78094, 33.63179], [-117.78063, 33.63181], [-117.7804, 33.63186], [-117.78014, 33.63193], [-117.77993, 33.63201], [-117.77968, 33.63214], [-117.77947, 33.63228], [-117.77919, 33.63254], [-117.77854, 33.63327], [-117.77783, 33.63367], [-117.77765, 33.63373], [-117.77744, 33.63377], [-117.77725, 33.63376], [-117.77706, 33.63373], [-117.77687, 33.63366], [-117.77676, 33.6336], [-117.77665, 33.63352], [-117.77656, 33.63342], [-117.77639, 33.63318], [-117.77623, 33.63301], [-117.77602, 33.63286], [-117.77577, 33.63274], [-117.77553, 33.63267], [-117.77522, 33.63263], [-117.77486, 33.63265], [-117.77453, 33.63273], [-117.77416, 33.63288], [-117.77388, 33.63305], [-117.77374, 33.63318], [-117.77361, 33.63331], [-117.77352, 33.63343], [-117.77341, 33.63361], [-117.77307, 33.63433], [-117.77301, 33.63453], [-117.77299, 33.63473], [-117.77234, 33.63565], [-117.77204, 33.63725], [-117.77175, 33.63804], [-117.77147, 33.63828], [-117.77125, 33.63834], [-117.77108, 33.63841], [-117.77076, 33.63856], [-117.77051, 33.63872], [-117.77043, 33.63864], [-117.77032, 33.63859], [-117.7702, 33.63858], [-117.77007, 33.63861], [-117.76998, 33.63866], [-117.76993, 33.63871], [-117.76989, 33.63879], [-117.76987, 33.63888], [-117.76976, 33.639], [-117.76959, 33.63909], [-117.76941, 33.63913], [-117.76926, 33.63912], [-117.76913, 33.63903], [-117.76887, 33.63874], [-117.76755, 33.63857], [-117.76633, 33.63844], [-117.76593, 33.63854], [-117.76528, 33.63857], [-117.76533, 33.6395], [-117.76577, 33.64067], [-117.76559, 33.64163], [-117.76585, 33.64231], [-117.76557, 33.6432], [-117.76422, 33.63967], [-117.76417, 33.63889], [-117.76113, 33.63868], [-117.76103, 33.63793], [-117.76101, 33.63738], [-117.76102, 33.637], [-117.76099, 33.63682], [-117.76104, 33.63633], [-117.76115, 33.63567], [-117.76176, 33.63333], [-117.76188, 33.63271], [-117.76192, 33.63219], [-117.76192, 33.63172], [-117.76186, 33.63125], [-117.76177, 33.63079], [-117.76159, 33.63023], [-117.7614, 33.62979], [-117.76117, 33.62936], [-117.76086, 33.6289], [-117.76059, 33.62855], [-117.75949, 33.62727], [-117.75934, 33.62721], [-117.75758, 33.62504], [-117.77435, 33.61839], [-117.77601, 33.60166], [-117.77732, 33.60018], [-117.77901, 33.6015], [-117.78, 33.60154], [-117.7802, 33.60167], [-117.78022, 33.60175], [-117.78055, 33.60195], [-117.78067, 33.60201], [-117.78083, 33.60195], [-117.78124, 33.60203], [-117.78104, 33.60231], [-117.78079, 33.60237], [-117.78041, 33.60226], [-117.78031, 33.60243], [-117.78078, 33.60274], [-117.7812, 33.6027], [-117.7814, 33.60247], [-117.78168, 33.60253], [-117.78216, 33.60238], [-117.78348, 33.60271], [-117.78377, 33.60288], [-117.78408, 33.60293], [-117.78495, 33.60291], [-117.78547, 33.60291], [-117.78582, 33.60302], [-117.78573, 33.60339], [-117.78575, 33.60354], [-117.786, 33.60367], [-117.78643, 33.60369], [-117.78671, 33.60366], [-117.78718, 33.60367], [-117.78736, 33.60371], [-117.78815, 33.60359], [-117.7885, 33.60383], [-117.78857, 33.60386], [-117.79291, 33.61845], [-117.79284, 33.61834], [-117.79272, 33.61822], [-117.79247, 33.61804], [-117.79215, 33.6176], [-117.7918, 33.61753], [-117.79093, 33.6178], [-117.79078, 33.61809], [-117.79077, 33.6183], [-117.79088, 33.61865], [-117.79102, 33.61943], [-117.7912, 33.61985], [-117.79126, 33.61994], [-117.79135, 33.62003], [-117.7916, 33.62015], [-117.79181, 33.62029], [-117.79199, 33.62048], [-117.79212, 33.62068], [-117.7924, 33.62142], [-117.7926, 33.6221], [-117.79253, 33.62229], [-117.79252, 33.62239], [-117.79253, 33.6225], [-117.7926, 33.62264], [-117.79269, 33.62274], [-117.79276, 33.6228], [-117.79355, 33.62325], [-117.79394, 33.62326], [-117.794, 33.62322], [-117.79422, 33.6234], [-117.79435, 33.62348], [-117.79443, 33.6235], [-117.79478, 33.62354], [-117.79556, 33.62335], [-117.79628, 33.62346], [-117.79655, 33.62343], [-117.79709, 33.62321], [-117.79722, 33.62314]], [[-117.79011, 33.61595], [-117.79014, 33.61582], [-117.79013, 33.61574], [-117.79011, 33.61569], [-117.79007, 33.61567], [-117.78991, 33.61564], [-117.78989, 33.61565], [-117.7898, 33.61597], [-117.7898, 33.61598], [-117.79006, 33.61609], [-117.79011, 33.61605], [-117.79011, 33.61595]]], [[[-117.76677, 33.64717], [-117.76659, 33.64711], [-117.76653, 33.64681], [-117.76642, 33.64646], [-117.76589, 33.64506], [-117.76567, 33.64456], [-117.76538, 33.64408], [-117.76515, 33.64377], [-117.76497, 33.64355], [-117.76455, 33.64313], [-117.76425, 33.64288], [-117.76401, 33.6427], [-117.7634, 33.64232], [-117.76435, 33.64202], [-117.76436, 33.642], [-117.76155, 33.6399], [-117.76063, 33.6401], [-117.76059, 33.63987], [-117.76057, 33.63959], [-117.76064, 33.63882], [-117.76388, 33.63904], [-117.76393, 33.63972], [-117.76677, 33.64717]]]]} | Open Access 1 | 35783 | South-Shady Canyon Open Space Preserve | 31197 | 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 | Orange 3 | 1730.226 | South-Shady Canyon OSP | None 1371 |
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]);