units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where COUNTY = 3, MNG_AGENCY = 226 and YR_EST = 0
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 13
MNG_AGENCY 1
- Laguna Hills, City of · 13 ✖
DES_TP 1
- Local Park 13
ACCESS_TYP 1
- Open Access 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
648 | 648 | 647 | {"type": "Polygon", "coordinates": [[[-117.69816, 33.60027], [-117.69806, 33.60032], [-117.69672, 33.60105], [-117.69676, 33.60074], [-117.69676, 33.60055], [-117.69669, 33.60034], [-117.69656, 33.60015], [-117.69658, 33.6001], [-117.69681, 33.59993], [-117.69693, 33.59979], [-117.69701, 33.59965], [-117.69706, 33.59965], [-117.69727, 33.59972], [-117.69816, 33.60027]]]} | Open Access 1 | 3079 | Beckenham Park | 15945 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 2.791 | Beckenham Park | 0 | Local Park 2 | 4 | |
839 | 839 | 838 | {"type": "Polygon", "coordinates": [[[-117.68266, 33.59659], [-117.68145, 33.59703], [-117.68131, 33.59674], [-117.68124, 33.59669], [-117.68112, 33.5967], [-117.68106, 33.59659], [-117.68137, 33.59648], [-117.68123, 33.59616], [-117.68168, 33.59599], [-117.68206, 33.59578], [-117.68211, 33.59577], [-117.68239, 33.5961], [-117.68253, 33.59633], [-117.68266, 33.59659]]]} | Open Access 1 | 4939 | Mackenzie Park | 21635 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 2.824 | Mackenzie Park | 0 | Local Park 2 | 4 | |
1542 | 1542 | 1541 | {"type": "Polygon", "coordinates": [[[-117.73967, 33.61989], [-117.73966, 33.61992], [-117.73964, 33.61995], [-117.73951, 33.61998], [-117.73857, 33.61997], [-117.73855, 33.61907], [-117.73897, 33.61919], [-117.73908, 33.61924], [-117.73926, 33.61934], [-117.73936, 33.61942], [-117.73947, 33.61956], [-117.73967, 33.61989]]]} | Open Access 1 | 11254 | San Remo Park | 24988 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 1.824 | San Remo Park | 0 | Local Park 2 | 4 | |
2271 | 2271 | 2270 | {"type": "Polygon", "coordinates": [[[-117.69259, 33.5984], [-117.69241, 33.59859], [-117.69218, 33.59888], [-117.69194, 33.59929], [-117.69187, 33.59936], [-117.69179, 33.59936], [-117.69162, 33.59929], [-117.69138, 33.59925], [-117.69117, 33.59922], [-117.69086, 33.59922], [-117.69083, 33.5992], [-117.69081, 33.59917], [-117.69077, 33.59859], [-117.69083, 33.59855], [-117.69105, 33.59855], [-117.69154, 33.59861], [-117.69158, 33.59848], [-117.69151, 33.59847], [-117.69148, 33.59843], [-117.69155, 33.5982], [-117.69187, 33.59779], [-117.69217, 33.59803], [-117.6921, 33.59807], [-117.69207, 33.59811], [-117.69206, 33.59817], [-117.69208, 33.59823], [-117.69213, 33.59826], [-117.69222, 33.59827], [-117.6923, 33.59825], [-117.69233, 33.59822], [-117.69259, 33.5984]]]} | Open Access 1 | 18168 | Costeau Park | 17673 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.646 | Costeau Park | 0 | Local Park 2 | 4 | |
5151 | 5151 | 5150 | {"type": "Polygon", "coordinates": [[[-117.69942, 33.59828], [-117.69939, 33.59844], [-117.69758, 33.59771], [-117.69772, 33.59739], [-117.69775, 33.59713], [-117.69817, 33.59699], [-117.69828, 33.59693], [-117.69842, 33.59677], [-117.69923, 33.59751], [-117.69942, 33.59828]]]} | Open Access 1 | 24597 | Stockpart Park | 25856 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 4.151 | Stockpart Park | 0 | Local Park 2 | 4 | |
5794 | 5794 | 5793 | {"type": "Polygon", "coordinates": [[[-117.69121, 33.59025], [-117.6909, 33.59048], [-117.69087, 33.59047], [-117.6908, 33.59046], [-117.6907, 33.59049], [-117.69068, 33.59055], [-117.69041, 33.59076], [-117.69052, 33.59083], [-117.69026, 33.59105], [-117.68995, 33.59081], [-117.68985, 33.59067], [-117.6898, 33.59062], [-117.68968, 33.5906], [-117.68957, 33.59064], [-117.68951, 33.59069], [-117.68879, 33.58992], [-117.69092, 33.58993], [-117.69121, 33.59025]]]} | Open Access 1 | 50 | El Conejo Park | 18493 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.773 | El Conejo Park | 0 | Local Park 2 | 4 | |
6534 | 6534 | 6533 | {"type": "Polygon", "coordinates": [[[-117.68006, 33.59304], [-117.68003, 33.59308], [-117.67893, 33.59359], [-117.67864, 33.59314], [-117.67835, 33.59235], [-117.67835, 33.59211], [-117.67851, 33.59213], [-117.67859, 33.5921], [-117.67863, 33.59207], [-117.6789, 33.59226], [-117.6791, 33.59214], [-117.67918, 33.59232], [-117.67948, 33.59222], [-117.67959, 33.59241], [-117.68006, 33.59304]]]} | Open Access 1 | 2952 | Knotty Pine Park | 20706 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.891 | Knotty Pine Park | 0 | Local Park 2 | 4 | |
6727 | 6727 | 6726 | {"type": "Polygon", "coordinates": [[[-117.69919, 33.58424], [-117.69912, 33.58423], [-117.69909, 33.5842], [-117.69812, 33.58307], [-117.69798, 33.58287], [-117.69789, 33.58283], [-117.6978, 33.58284], [-117.69762, 33.58253], [-117.69769, 33.58227], [-117.69769, 33.58195], [-117.69776, 33.58175], [-117.69812, 33.58183], [-117.69835, 33.58174], [-117.69837, 33.58176], [-117.69846, 33.5818], [-117.69864, 33.58202], [-117.69895, 33.58219], [-117.69891, 33.5825], [-117.69877, 33.58274], [-117.6985, 33.58292], [-117.69821, 33.58306], [-117.69863, 33.58353], [-117.69899, 33.58398], [-117.69907, 33.58395], [-117.69919, 33.58424]]]} | Open Access 1 | 5049 | Mandeville Park | 21743 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.481 | Mandeville Park | 0 | Local Park 2 | 4 | |
6789 | 6789 | 6788 | {"type": "Polygon", "coordinates": [[[-117.69771, 33.58809], [-117.69768, 33.58823], [-117.69748, 33.58839], [-117.69741, 33.5884], [-117.69728, 33.58822], [-117.69691, 33.58806], [-117.6966, 33.58771], [-117.69624, 33.58742], [-117.69588, 33.58717], [-117.69582, 33.58706], [-117.69683, 33.58661], [-117.69701, 33.58686], [-117.69707, 33.58688], [-117.69707, 33.58692], [-117.6971, 33.58698], [-117.69719, 33.58703], [-117.69718, 33.58708], [-117.69737, 33.58727], [-117.6973, 33.58732], [-117.69734, 33.58747], [-117.69767, 33.58799], [-117.69771, 33.58809]]]} | Open Access 1 | 5291 | Mendocino Park | 22149 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.794 | Mendocino Park | 0 | Local Park 2 | 4 | |
8038 | 8038 | 8037 | {"type": "Polygon", "coordinates": [[[-117.74323, 33.61692], [-117.74313, 33.6172], [-117.74313, 33.61738], [-117.74317, 33.61755], [-117.74316, 33.61759], [-117.7425, 33.61783], [-117.74246, 33.61783], [-117.74242, 33.61781], [-117.74227, 33.61763], [-117.74218, 33.61755], [-117.74202, 33.61745], [-117.74189, 33.61739], [-117.74157, 33.61732], [-117.74116, 33.61732], [-117.74111, 33.61586], [-117.74145, 33.61573], [-117.74176, 33.61557], [-117.74179, 33.61663], [-117.742, 33.61696], [-117.74323, 33.61692]]]} | Open Access 1 | 11691 | Santa Vittoria Park | 25142 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 5.152 | Santa Vittoria Park | 0 | Local Park 2 | 4 | |
8449 | 8449 | 8448 | {"type": "Polygon", "coordinates": [[[-117.68124, 33.56664], [-117.68065, 33.56693], [-117.68018, 33.56707], [-117.6798, 33.56714], [-117.6792, 33.56722], [-117.67907, 33.56722], [-117.67878, 33.56717], [-117.67865, 33.56713], [-117.67839, 33.56698], [-117.67764, 33.56646], [-117.67725, 33.5662], [-117.67711, 33.56614], [-117.67677, 33.56602], [-117.67672, 33.56593], [-117.6768, 33.56533], [-117.67749, 33.56533], [-117.67749, 33.56557], [-117.67849, 33.56625], [-117.67932, 33.5662], [-117.67951, 33.56639], [-117.68011, 33.56633], [-117.68084, 33.56604], [-117.68111, 33.56621], [-117.68124, 33.56664]]]} | Open Access 1 | 13130 | Cabot Park | 16633 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 9.236 | Cabot Park | 0 | Local Park 2 | 4 | |
9056 | 9056 | 9055 | {"type": "MultiPolygon", "coordinates": [[[[-117.73974, 33.6284], [-117.73955, 33.62838], [-117.73954, 33.62849], [-117.7358, 33.62811], [-117.73602, 33.62685], [-117.7366, 33.62724], [-117.73686, 33.62734], [-117.73709, 33.62737], [-117.7379, 33.62737], [-117.73863, 33.62752], [-117.73903, 33.62751], [-117.73917, 33.62753], [-117.73928, 33.62756], [-117.73942, 33.62764], [-117.7396, 33.6278], [-117.73971, 33.62782], [-117.73975, 33.628], [-117.73974, 33.6284]]], [[[-117.74194, 33.62895], [-117.74177, 33.62944], [-117.74064, 33.62861], [-117.73993, 33.62853], [-117.73995, 33.62799], [-117.73992, 33.62784], [-117.74042, 33.62789], [-117.74104, 33.62835], [-117.74144, 33.62841], [-117.74157, 33.62845], [-117.74166, 33.6285], [-117.74176, 33.62857], [-117.74186, 33.6287], [-117.74192, 33.62884], [-117.74194, 33.62895]]]]} | Open Access 1 | 14993 | Veeh Ranch Park | 26842 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 12.379 | Veeh Ranch Park | 0 | Local Park 2 | 4 | |
10137 | 10137 | 10136 | {"type": "Polygon", "coordinates": [[[-117.69978, 33.60333], [-117.69967, 33.6036], [-117.69943, 33.60431], [-117.69879, 33.60398], [-117.6987, 33.60397], [-117.69866, 33.60388], [-117.69845, 33.60368], [-117.69829, 33.60341], [-117.69821, 33.60322], [-117.69819, 33.60291], [-117.69823, 33.60286], [-117.69854, 33.60287], [-117.69893, 33.60285], [-117.699, 33.60288], [-117.69909, 33.603], [-117.69922, 33.60312], [-117.69945, 33.60323], [-117.69978, 33.60333]]]} | Open Access 1 | 17780 | Clarington Park | 17384 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.537 | Clarington Park | 0 | Local Park 2 | 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]);