units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 14 and SUID_NMA = 20241
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13501 | 13501 | 13500 | {"type": "Polygon", "coordinates": [[[-117.81321, 33.64251], [-117.81302, 33.64277], [-117.81281, 33.64297], [-117.81241, 33.64324], [-117.81217, 33.64336], [-117.81034, 33.644], [-117.80987, 33.64413], [-117.80942, 33.64423], [-117.80844, 33.64442], [-117.80836, 33.64437], [-117.80828, 33.64415], [-117.80819, 33.64398], [-117.80804, 33.64378], [-117.80767, 33.64338], [-117.80736, 33.64317], [-117.80679, 33.64284], [-117.80642, 33.64263], [-117.80633, 33.64255], [-117.80619, 33.64244], [-117.80578, 33.64201], [-117.80533, 33.64158], [-117.80517, 33.64139], [-117.80482, 33.64112], [-117.80442, 33.6409], [-117.80462, 33.64049], [-117.80467, 33.64034], [-117.80476, 33.63961], [-117.80482, 33.63946], [-117.80491, 33.63934], [-117.80509, 33.6392], [-117.80533, 33.63909], [-117.80545, 33.63906], [-117.80563, 33.63904], [-117.80585, 33.63905], [-117.80512, 33.63939], [-117.80504, 33.63949], [-117.80495, 33.63984], [-117.80492, 33.64023], [-117.80485, 33.64024], [-117.80481, 33.64043], [-117.80486, 33.64061], [-117.80499, 33.64069], [-117.80503, 33.64082], [-117.80535, 33.64094], [-117.80566, 33.64082], [-117.80575, 33.64095], [-117.80593, 33.64088], [-117.80608, 33.6407], [-117.8061, 33.64066], [-117.80615, 33.64065], [-117.80617, 33.64062], [-117.80682, 33.64088], [-117.8069, 33.64136], [-117.80705, 33.64158], [-117.80725, 33.64149], [-117.80731, 33.64153], [-117.80742, 33.64153], [-117.80748, 33.6415], [-117.80751, 33.64146], [-117.80833, 33.64167], [-117.80846, 33.64189], [-117.80866, 33.64194], [-117.80863, 33.64213], [-117.80892, 33.64247], [-117.80872, 33.64264], [-117.80896, 33.64289], [-117.8089, 33.64325], [-117.80917, 33.64342], [-117.80939, 33.64348], [-117.80962, 33.64351], [-117.8097, 33.64362], [-117.80983, 33.64373], [-117.81002, 33.64371], [-117.81051, 33.64356], [-117.81073, 33.64336], [-117.81107, 33.6433], [-117.81158, 33.64308], [-117.81179, 33.64316], [-117.81224, 33.64304], [-117.81256, 33.64285], [-117.81267, 33.64283], [-117.81321, 33.64251]]]} | Open Access 1 | 35785 | Irvine holding 12 | 20241 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 23.017 | Irvine holding 12 | 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]);