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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
13557 | 13557 | 13556 | {"type": "Polygon", "coordinates": [[[-117.83137, 33.6759], [-117.83143, 33.67615], [-117.83143, 33.67634], [-117.83138, 33.67665], [-117.83126, 33.67707], [-117.83108, 33.6774], [-117.83082, 33.67732], [-117.83104, 33.67696], [-117.83113, 33.67673], [-117.83121, 33.67648], [-117.83122, 33.67629], [-117.8312, 33.6759], [-117.83137, 33.6759]]]} | Open Access 1 | 35872 | Irvine holding 16 | 20245 | 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.872 | Irvine holding 16 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
13579 | 13579 | 13578 | {"type": "Polygon", "coordinates": [[[-117.82563, 33.61488], [-117.82507, 33.61487], [-117.825, 33.61481], [-117.82503, 33.61468], [-117.82522, 33.61452], [-117.82531, 33.61442], [-117.82536, 33.61419], [-117.82522, 33.61403], [-117.82504, 33.61397], [-117.82492, 33.6138], [-117.82486, 33.61356], [-117.82484, 33.61335], [-117.82476, 33.61312], [-117.82463, 33.61295], [-117.82436, 33.61283], [-117.8241, 33.61282], [-117.82358, 33.61303], [-117.82347, 33.61318], [-117.82332, 33.61358], [-117.82309, 33.61385], [-117.82289, 33.61395], [-117.8226, 33.61396], [-117.82246, 33.61388], [-117.82243, 33.61369], [-117.82278, 33.61324], [-117.82148, 33.61261], [-117.82108, 33.61319], [-117.82077, 33.61309], [-117.82041, 33.61347], [-117.82072, 33.61367], [-117.8209, 33.61355], [-117.82164, 33.61414], [-117.82196, 33.61401], [-117.8223, 33.61422], [-117.82259, 33.61426], [-117.82291, 33.61417], [-117.82316, 33.61407], [-117.82331, 33.61393], [-117.82344, 33.61373], [-117.82365, 33.61328], [-117.82385, 33.6131], [-117.82402, 33.61302], [-117.82429, 33.61299], [-117.82453, 33.61313], [-117.82465, 33.61339], [-117.82474, 33.61367], [-117.82477, 33.61391], [-117.82485, 33.61409], [-117.82507, 33.61419], [-117.82508, 33.61437], [-117.82481, 33.61459], [-117.82473, 33.61474], [-117.82483, 33.6149], [-117.82516, 33.61501], [-117.82457, 33.61513], [-117.82426, 33.61514], [-117.82405, 33.61534], [-117.82381, 33.61544], [-117.82351, 33.61549], [-117.82341, 33.61569], [-117.82311, 33.61579], [-117.8228, 33.61572], [-117.82206, 33.61586], [-117.82171, 33.61607], [-117.82062, 33.61665], [-117.82034, 33.61682], [-117.82014, 33.61629], [-117.81988, 33.61598], [-117.81942, 33.61556], [-117.81906, 33.61526], [-117.81787, 33.61315], [-117.81724, 33.61228], [-117.81621, 33.61128], [-117.81566, 33.61094], [-117.81508, 33.61055], [-117.81446, 33.61023], [-117.81382, 33.60999], [-117.81243, 33.60959], [-117.81255, 33.60929], [-117.81263, 33.6093], [-117.81356, 33.60773], [-117.81431, 33.60767], [-117.81518, 33.60771], [-117.81613, 33.60791], [-117.81712, 33.60817], [-117.81811, 33.60849], [-117.81888, 33.6087], [-117.81974, 33.60875], [-117.82059, 33.60874], [-117.82059, 33.60907], [-117.8209, 33.60913], [-117.82115, 33.60911], [-117.82134, 33.60937], [-117.82147, 33.60938], [-117.8218, 33.60987], [-117.82214, 33.6102], [-117.8223, 33.61041], [-117.82235, 33.61055], [-117.82259, 33.61066], [-117.82293, 33.61073], [-117.8233, 33.61083], [-117.82356, 33.61103], [-117.82388, 33.61124], [-117.82421, 33.61135], [-117.82458, 33.61133], [-117.82497, 33.61154], [-117.8254, 33.61182], [-117.82567, 33.61371], [-117.82567, 33.61428], [-117.82563, 33.61488]]]} | Open Access 1 | 35910 | Irvine holding 29 | 20259 | 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 | 140.28 | Irvine holding 29 | 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 | |
13581 | 13581 | 13580 | {"type": "Polygon", "coordinates": [[[-117.82618, 33.62079], [-117.82531, 33.62145], [-117.82379, 33.62061], [-117.82443, 33.62051], [-117.82478, 33.62026], [-117.82498, 33.61989], [-117.82509, 33.61926], [-117.82491, 33.61905], [-117.82477, 33.61886], [-117.82468, 33.61853], [-117.82468, 33.61806], [-117.82476, 33.61702], [-117.82445, 33.61717], [-117.82345, 33.61752], [-117.82274, 33.61757], [-117.82201, 33.6176], [-117.82157, 33.61755], [-117.82103, 33.61764], [-117.82074, 33.61773], [-117.82058, 33.6171], [-117.82105, 33.61684], [-117.82151, 33.61674], [-117.82196, 33.61684], [-117.82232, 33.61688], [-117.82271, 33.61698], [-117.82322, 33.61703], [-117.82374, 33.61671], [-117.82405, 33.61637], [-117.82432, 33.61626], [-117.82473, 33.61636], [-117.82497, 33.61655], [-117.82524, 33.61666], [-117.82549, 33.61668], [-117.8257, 33.61658], [-117.82578, 33.61658], [-117.82593, 33.61808], [-117.82596, 33.61921], [-117.82618, 33.62079]]]} | Open Access 1 | 35915 | Irvine holding 28 | 20258 | 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 | 22.328 | Irvine holding 28 | 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 | |
13585 | 13585 | 13584 | {"type": "Polygon", "coordinates": [[[-117.80728, 33.65595], [-117.8071, 33.65617], [-117.80699, 33.65623], [-117.80688, 33.6565], [-117.80619, 33.65604], [-117.80526, 33.65309], [-117.80397, 33.653], [-117.80342, 33.65245], [-117.80294, 33.65193], [-117.80251, 33.65149], [-117.80225, 33.65111], [-117.80202, 33.65073], [-117.80187, 33.65029], [-117.80179, 33.64988], [-117.80176, 33.64869], [-117.80155, 33.64818], [-117.80126, 33.64758], [-117.80082, 33.64675], [-117.80073, 33.64643], [-117.80072, 33.64581], [-117.80077, 33.64553], [-117.80094, 33.64516], [-117.80114, 33.64484], [-117.80142, 33.64454], [-117.80176, 33.64425], [-117.80185, 33.64478], [-117.80221, 33.64497], [-117.80231, 33.64525], [-117.80213, 33.64549], [-117.80214, 33.64577], [-117.80227, 33.64605], [-117.80224, 33.64656], [-117.80257, 33.64701], [-117.80322, 33.64727], [-117.80369, 33.64716], [-117.80456, 33.64648], [-117.80467, 33.64685], [-117.80457, 33.64746], [-117.80457, 33.64759], [-117.80431, 33.64778], [-117.80418, 33.64815], [-117.80419, 33.64848], [-117.80432, 33.64881], [-117.80447, 33.64914], [-117.80455, 33.64938], [-117.80438, 33.64975], [-117.80449, 33.65002], [-117.80501, 33.65003], [-117.80525, 33.64976], [-117.80557, 33.6496], [-117.80596, 33.64923], [-117.8062, 33.64924], [-117.80586, 33.64977], [-117.80567, 33.65027], [-117.80574, 33.65061], [-117.80571, 33.65089], [-117.80559, 33.65128], [-117.80576, 33.65151], [-117.80611, 33.65171], [-117.80676, 33.65147], [-117.80557, 33.65302], [-117.80587, 33.65319], [-117.80583, 33.6537], [-117.80589, 33.65395], [-117.80611, 33.65414], [-117.80633, 33.65487], [-117.80659, 33.65525], [-117.80728, 33.65595]]]} | Open Access 1 | 35918 | Irvine holding 20 | 20250 | 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 | 60.956 | Irvine holding 20 | 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]);