units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where DES_TP = 14 and MNG_AGENCY = 266 sorted by UNIT_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13569 | 13569 | 13568 | {"type": "Polygon", "coordinates": [[[-117.83143, 33.67563], [-117.83123, 33.6757], [-117.83111, 33.67534], [-117.83103, 33.67494], [-117.83089, 33.67409], [-117.83092, 33.6736], [-117.8311, 33.6731], [-117.83133, 33.67316], [-117.83119, 33.67364], [-117.83119, 33.67456], [-117.83127, 33.67498], [-117.83137, 33.67533], [-117.83143, 33.67563]]]} | Open Access 1 | 35913 | Irvine holding 30 | 20261 | 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 | 1.639 | Irvine holding 30 | 0 | Local Other or Unknown 14 | 4 | |
13555 | 13555 | 13554 | {"type": "Polygon", "coordinates": [[[-117.7619, 33.65817], [-117.76161, 33.65818], [-117.76142, 33.65812], [-117.76107, 33.65789], [-117.76088, 33.65788], [-117.76065, 33.65783], [-117.76042, 33.65775], [-117.76, 33.65766], [-117.76008, 33.65751], [-117.76077, 33.6577], [-117.76132, 33.65782], [-117.76189, 33.65787], [-117.7619, 33.65817]]]} | Open Access 1 | 35912 | Irvine holding 31 | 20262 | 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 | 0.95 | Irvine holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13582 | 13582 | 13581 | {"type": "Polygon", "coordinates": [[[-117.8353, 33.67402], [-117.83521, 33.67442], [-117.83504, 33.6743], [-117.83174, 33.6732], [-117.83183, 33.67292], [-117.8353, 33.67402]]]} | Open Access 1 | 35916 | Irvine holding 32 | 20263 | 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 | 3.024 | Irvine holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13583 | 13583 | 13582 | {"type": "Polygon", "coordinates": [[[-117.7653, 33.65872], [-117.76509, 33.6588], [-117.76437, 33.65776], [-117.76351, 33.65795], [-117.76318, 33.65841], [-117.76248, 33.65813], [-117.76217, 33.65813], [-117.76223, 33.65785], [-117.76297, 33.65781], [-117.76335, 33.65777], [-117.76452, 33.65754], [-117.7653, 33.65872]]]} | Open Access 1 | 35917 | Irvine holding 33 | 20264 | 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 | 2.659 | Irvine holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13580 | 13580 | 13579 | {"type": "Polygon", "coordinates": [[[-117.80396, 33.64107], [-117.80396, 33.64112], [-117.80374, 33.64164], [-117.80314, 33.64277], [-117.80274, 33.64322], [-117.80242, 33.64354], [-117.80194, 33.64391], [-117.80165, 33.6441], [-117.80106, 33.64457], [-117.80096, 33.64445], [-117.80118, 33.64398], [-117.80083, 33.64358], [-117.80062, 33.64323], [-117.80029, 33.64303], [-117.79964, 33.64319], [-117.79923, 33.64338], [-117.79861, 33.64339], [-117.79819, 33.64357], [-117.79816, 33.64384], [-117.79842, 33.6443], [-117.79882, 33.64487], [-117.79941, 33.64501], [-117.79997, 33.64541], [-117.80051, 33.64544], [-117.80045, 33.64562], [-117.79855, 33.64577], [-117.79854, 33.64522], [-117.79733, 33.64384], [-117.79708, 33.64124], [-117.79687, 33.63574], [-117.797, 33.63513], [-117.79746, 33.63464], [-117.79784, 33.63446], [-117.79835, 33.63423], [-117.79904, 33.63419], [-117.79949, 33.6352], [-117.79913, 33.63538], [-117.7986, 33.63499], [-117.79819, 33.63499], [-117.79775, 33.63574], [-117.79766, 33.63616], [-117.7978, 33.63669], [-117.79787, 33.63705], [-117.79733, 33.63747], [-117.79752, 33.63777], [-117.7974, 33.6381], [-117.79773, 33.63832], [-117.79808, 33.63834], [-117.79815, 33.63864], [-117.79798, 33.63865], [-117.79783, 33.63892], [-117.7982, 33.6397], [-117.79843, 33.63997], [-117.79891, 33.64006], [-117.79921, 33.64003], [-117.79918, 33.64027], [-117.79892, 33.64018], [-117.79847, 33.64017], [-117.79785, 33.64092], [-117.79796, 33.64133], [-117.79803, 33.64169], [-117.79838, 33.64186], [-117.79881, 33.64176], [-117.7991, 33.64121], [-117.79939, 33.6412], [-117.7999, 33.64134], [-117.80033, 33.64144], [-117.8006, 33.64133], [-117.80085, 33.64103], [-117.80101, 33.64066], [-117.80106, 33.64024], [-117.80109, 33.63981], [-117.80132, 33.63976], [-117.80168, 33.64014], [-117.80205, 33.64044], [-117.80238, 33.64062], [-117.80272, 33.64077], [-117.80382, 33.64099], [-117.80396, 33.64107]]]} | Open Access 1 | 35911 | Irvine holding 34 | 20265 | 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 | 63.416 | Irvine holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13538 | 13538 | 13537 | {"type": "Polygon", "coordinates": [[[-117.76951, 33.68855], [-117.76951, 33.68855], [-117.76852, 33.68958], [-117.76819, 33.68897], [-117.76902, 33.68816], [-117.76951, 33.68855]]]} | Open Access 1 | 35844 | Irvine holding 4 | 20266 | 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 | 2.119 | Irvine holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13532 | 13532 | 13531 | {"type": "Polygon", "coordinates": [[[-117.82579, 33.63067], [-117.82576, 33.63101], [-117.82562, 33.63135], [-117.8253, 33.63154], [-117.82491, 33.63161], [-117.82461, 33.6317], [-117.82416, 33.63189], [-117.82369, 33.63218], [-117.82301, 33.63266], [-117.8228, 33.63283], [-117.82281, 33.63285], [-117.82337, 33.63302], [-117.82376, 33.63321], [-117.82415, 33.63334], [-117.82428, 33.63371], [-117.82372, 33.63362], [-117.82314, 33.63346], [-117.82196, 33.63293], [-117.82176, 33.63274], [-117.822, 33.63248], [-117.82205, 33.63225], [-117.82198, 33.63195], [-117.82151, 33.6313], [-117.82103, 33.63096], [-117.82052, 33.63067], [-117.8199, 33.63039], [-117.81912, 33.63021], [-117.81844, 33.63011], [-117.81779, 33.63022], [-117.81727, 33.63036], [-117.81698, 33.63066], [-117.81673, 33.63119], [-117.81528, 33.63065], [-117.81547, 33.63016], [-117.8155, 33.62975], [-117.8154, 33.62927], [-117.81523, 33.62878], [-117.81498, 33.62824], [-117.81487, 33.62783], [-117.81496, 33.62732], [-117.81519, 33.62673], [-117.81529, 33.62622], [-117.81557, 33.62505], [-117.81611, 33.6246], [-117.81668, 33.62426], [-117.8168, 33.62461], [-117.81637, 33.62493], [-117.81606, 33.62529], [-117.81583, 33.62584], [-117.81577, 33.62629], [-117.816, 33.62673], [-117.81661, 33.62715], [-117.8176, 33.62743], [-117.81882, 33.62762], [-117.81962, 33.62768], [-117.82014, 33.62783], [-117.82069, 33.62807], [-117.82115, 33.62832], [-117.82137, 33.62849], [-117.82193, 33.62934], [-117.82205, 33.62965], [-117.82223, 33.63002], [-117.8223, 33.63033], [-117.82245, 33.6307], [-117.82267, 33.63095], [-117.82284, 33.63118], [-117.82301, 33.63124], [-117.82328, 33.63125], [-117.82352, 33.63118], [-117.82409, 33.63075], [-117.82442, 33.63056], [-117.82477, 33.63039], [-117.82531, 33.63041], [-117.82568, 33.63046], [-117.82579, 33.63067]]]} | Open Access 1 | 35834 | Irvine holding 6 | 20268 | 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 | 72.041 | Irvine holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13494 | 13494 | 13493 | {"type": "Polygon", "coordinates": [[[-117.77983, 33.65548], [-117.7798, 33.65552], [-117.77979, 33.65558], [-117.77851, 33.65647], [-117.77823, 33.6566], [-117.778, 33.65664], [-117.77774, 33.65665], [-117.77762, 33.65663], [-117.77719, 33.65649], [-117.77632, 33.65612], [-117.77577, 33.65585], [-117.77516, 33.65553], [-117.77424, 33.65501], [-117.77447, 33.65474], [-117.77524, 33.6545], [-117.7755, 33.65426], [-117.77538, 33.65387], [-117.77492, 33.65292], [-117.77516, 33.65247], [-117.77556, 33.65224], [-117.77626, 33.65256], [-117.77759, 33.65307], [-117.77762, 33.65313], [-117.77766, 33.65315], [-117.7774, 33.65362], [-117.77767, 33.65433], [-117.7776, 33.65471], [-117.77735, 33.655], [-117.77734, 33.65509], [-117.77738, 33.65534], [-117.77747, 33.65565], [-117.7776, 33.65595], [-117.77771, 33.65618], [-117.77777, 33.65626], [-117.77783, 33.6563], [-117.77795, 33.65633], [-117.7781, 33.65634], [-117.77833, 33.6563], [-117.77839, 33.65634], [-117.77976, 33.65544], [-117.77983, 33.65548]]]} | Open Access 1 | 35780 | Irvine holding 7 | 20269 | 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.501 | Irvine holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13499 | 13499 | 13498 | {"type": "Polygon", "coordinates": [[[-117.75437, 33.70597], [-117.75271, 33.70675], [-117.75166, 33.70713], [-117.75164, 33.70707], [-117.75344, 33.70529], [-117.75437, 33.70597]]]} | Open Access 1 | 35784 | Irvine holding 9 | 20270 | 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 | 4.154 | Irvine holding 9 | 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]);