units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_ID = 1148, DES_TP = 1369 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15880 | 15880 | 15879 | {"type": "MultiPolygon", "coordinates": [[[[-117.78835, 33.64454], [-117.78646, 33.64642], [-117.78655, 33.64735], [-117.78633, 33.64761], [-117.78513, 33.64894], [-117.78475, 33.64943], [-117.78393, 33.64893], [-117.78367, 33.64919], [-117.78317, 33.64846], [-117.78248, 33.648], [-117.78202, 33.64772], [-117.78166, 33.64753], [-117.78096, 33.64727], [-117.78028, 33.64704], [-117.7799, 33.64687], [-117.77942, 33.64662], [-117.77881, 33.64625], [-117.77868, 33.64594], [-117.77848, 33.64596], [-117.77846, 33.64594], [-117.77845, 33.64589], [-117.77836, 33.64584], [-117.77806, 33.64556], [-117.77785, 33.64539], [-117.77772, 33.64513], [-117.7774, 33.64425], [-117.77737, 33.64402], [-117.77737, 33.64367], [-117.77731, 33.64337], [-117.77657, 33.64159], [-117.77598, 33.64079], [-117.77567, 33.64041], [-117.77526, 33.64001], [-117.77408, 33.63906], [-117.77336, 33.63862], [-117.773, 33.63844], [-117.77278, 33.63835], [-117.77257, 33.63829], [-117.7722, 33.63823], [-117.77185, 33.63823], [-117.77148, 33.63828], [-117.77175, 33.63804], [-117.77204, 33.63725], [-117.77234, 33.63564], [-117.77299, 33.63473], [-117.77301, 33.63491], [-117.77304, 33.63507], [-117.7731, 33.63523], [-117.77318, 33.63537], [-117.77404, 33.63662], [-117.77421, 33.63678], [-117.77442, 33.6369], [-117.77458, 33.63696], [-117.77477, 33.63699], [-117.77494, 33.63699], [-117.77513, 33.63696], [-117.77658, 33.63641], [-117.77754, 33.6366], [-117.77791, 33.63676], [-117.77796, 33.63693], [-117.77798, 33.63732], [-117.77776, 33.63791], [-117.77807, 33.63876], [-117.77957, 33.64148], [-117.78073, 33.64275], [-117.78176, 33.64336], [-117.7844, 33.64454], [-117.78598, 33.64417], [-117.78664, 33.64341], [-117.78723, 33.6434], [-117.78793, 33.6442], [-117.78835, 33.64454]], [[-117.77297, 33.63584], [-117.77295, 33.63584], [-117.77284, 33.63598], [-117.77292, 33.63607], [-117.77298, 33.6361], [-117.77305, 33.63611], [-117.77314, 33.63608], [-117.77318, 33.63603], [-117.77319, 33.63599], [-117.77317, 33.63592], [-117.7731, 33.63586], [-117.77297, 33.63584]], [[-117.77516, 33.63846], [-117.77504, 33.63848], [-117.77494, 33.63853], [-117.77487, 33.63861], [-117.77484, 33.6387], [-117.77486, 33.6388], [-117.77491, 33.63888], [-117.775, 33.63894], [-117.77512, 33.63897], [-117.77524, 33.63896], [-117.77534, 33.63891], [-117.77542, 33.63883], [-117.77545, 33.63873], [-117.77544, 33.63865], [-117.77538, 33.63856], [-117.77527, 33.63848], [-117.77516, 33.63846]]], [[[-117.80292, 33.65785], [-117.80263, 33.65772], [-117.80235, 33.65776], [-117.8024, 33.65812], [-117.80155, 33.6583], [-117.80085, 33.6585], [-117.80018, 33.65875], [-117.79954, 33.65904], [-117.79905, 33.65932], [-117.79859, 33.65961], [-117.79815, 33.65994], [-117.79773, 33.66029], [-117.79768, 33.66026], [-117.79761, 33.66027], [-117.79724, 33.66055], [-117.79703, 33.66066], [-117.79644, 33.66129], [-117.79628, 33.66142], [-117.79591, 33.66167], [-117.79547, 33.66185], [-117.79499, 33.66218], [-117.79476, 33.66229], [-117.79445, 33.66238], [-117.79414, 33.66242], [-117.79307, 33.66239], [-117.7924, 33.66231], [-117.79146, 33.662], [-117.79124, 33.66195], [-117.7905, 33.66171], [-117.79038, 33.66173], [-117.79031, 33.66179], [-117.79017, 33.66224], [-117.78896, 33.66209], [-117.78795, 33.66192], [-117.78728, 33.66177], [-117.7863, 33.66149], [-117.78566, 33.66128], [-117.78472, 33.66091], [-117.7838, 33.66049], [-117.78293, 33.66003], [-117.78227, 33.65965], [-117.78086, 33.65867], [-117.78061, 33.65844], [-117.7804, 33.65818], [-117.78132, 33.65882], [-117.78134, 33.65881], [-117.78132, 33.65868], [-117.78133, 33.6586], [-117.78148, 33.65847], [-117.7816, 33.65847], [-117.78166, 33.65849], [-117.78171, 33.65844], [-117.78178, 33.65825], [-117.78175, 33.65809], [-117.78184, 33.65797], [-117.78191, 33.65775], [-117.78194, 33.65755], [-117.78199, 33.65742], [-117.78205, 33.65735], [-117.78211, 33.65733], [-117.78201, 33.65722], [-117.78201, 33.65713], [-117.78198, 33.65705], [-117.78199, 33.65698], [-117.78205, 33.65685], [-117.78205, 33.6567], [-117.78215, 33.6566], [-117.78206, 33.65636], [-117.78189, 33.65624], [-117.78191, 33.65622], [-117.78169, 33.65606], [-117.78129, 33.65563], [-117.78126, 33.65557], [-117.78136, 33.65554], [-117.782, 33.655], [-117.78204, 33.65502], [-117.78198, 33.65512], [-117.78249, 33.65538], [-117.78264, 33.65518], [-117.78277, 33.65524], [-117.78299, 33.65494], [-117.78287, 33.65487], [-117.78292, 33.65475], [-117.78297, 33.6547], [-117.78298, 33.65463], [-117.78392, 33.65368], [-117.78306, 33.65309], [-117.78338, 33.65273], [-117.78357, 33.65249], [-117.78384, 33.65208], [-117.78403, 33.65174], [-117.78458, 33.65042], [-117.78491, 33.64977], [-117.78502, 33.64961], [-117.78487, 33.6495], [-117.78537, 33.64888], [-117.78657, 33.64755], [-117.78658, 33.64763], [-117.78742, 33.64821], [-117.78767, 33.64829], [-117.78784, 33.64832], [-117.78797, 33.64831], [-117.78814, 33.64829], [-117.78841, 33.64819], [-117.78991, 33.64736], [-117.79046, 33.64636], [-117.79073, 33.64541], [-117.7909, 33.64506], [-117.79178, 33.64436], [-117.79236, 33.64423], [-117.79258, 33.64426], [-117.79247, 33.64432], [-117.79246, 33.64438], [-117.7928, 33.64447], [-117.79321, 33.64438], [-117.79367, 33.64446], [-117.79377, 33.64452], [-117.79389, 33.64455], [-117.79414, 33.64455], [-117.79501, 33.6447], [-117.79537, 33.645], [-117.79544, 33.64521], [-117.79517, 33.64533], [-117.79478, 33.64589], [-117.79493, 33.646], [-117.7948, 33.64601], [-117.79452, 33.6463], [-117.79437, 33.64623], [-117.79356, 33.64641], [-117.79337, 33.64651], [-117.79315, 33.64682], [-117.79313, 33.64712], [-117.79317, 33.64756], [-117.79327, 33.64773], [-117.79332, 33.64792], [-117.79328, 33.64824], [-117.79367, 33.64834], [-117.79388, 33.64851], [-117.79451, 33.64878], [-117.79557, 33.65098], [-117.79667, 33.6526], [-117.80009, 33.65338], [-117.80164, 33.65459], [-117.80292, 33.65785]], [[-117.78925, 33.65327], [-117.78944, 33.65323], [-117.78963, 33.65315], [-117.78979, 33.65305], [-117.78992, 33.65291], [-117.79002, 33.65276], [-117.79008, 33.65259], [-117.79009, 33.65242], [-117.79006, 33.65224], [-117.78999, 33.65208], [-117.78988, 33.65193], [-117.78973, 33.65181], [-117.78956, 33.65171], [-117.78937, 33.65165], [-117.78916, 33.65162], [-117.78895, 33.65162], [-117.78875, 33.65167], [-117.78855, 33.65175], [-117.78837, 33.65188], [-117.78823, 33.65204], [-117.78814, 33.65221], [-117.7881, 33.65241], [-117.78812, 33.65261], [-117.7882, 33.6528], [-117.78833, 33.65298], [-117.78818, 33.65328], [-117.78912, 33.65357], [-117.78925, 33.65327]]]]} | Open Access 1 | 47478 | South-Quail Hill Open Space Preserve | 31198 | 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 | 734.119 | South-Quail Hill OSP | None 1369 |
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]);