units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where MNG_AGENCY = 19 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | 27 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | 154 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 7.57 | El Salvador Park | 0 | Local Park 2 | 4 | |
203 | 203 | 202 | {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87387, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.8717, 33.77141], [-117.87384, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} | Open Access 1 | 544 | Fisher Park | 18919 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 3.993 | Fisher Park | 0 | Local Park 2 | 4 | |
5941 | 5941 | 5940 | {"type": "Polygon", "coordinates": [[[-117.87624, 33.74536], [-117.87445, 33.74536], [-117.87444, 33.74444], [-117.8755, 33.74444], [-117.87551, 33.74454], [-117.87624, 33.74455], [-117.87624, 33.74536]]]} | Open Access 1 | 565 | Tennis Center | 26244 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 3.988 | Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
5992 | 5992 | 5991 | {"type": "Polygon", "coordinates": [[[-117.86446, 33.75326], [-117.86421, 33.75286], [-117.86445, 33.75275], [-117.86445, 33.75275], [-117.86446, 33.75326]]]} | Open Access 1 | 693 | French Park | 19107 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.159 | French Park | 0 | Local Park 2 | 4 | |
6212 | 6212 | 6211 | {"type": "Polygon", "coordinates": [[[-117.90172, 33.69991], [-117.90004, 33.69991], [-117.90002, 33.69916], [-117.90004, 33.69834], [-117.9017, 33.69832], [-117.90172, 33.69991]]]} | Open Access 1 | 1266 | Griset Park | 19521 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.746 | Griset Park | 0 | Local Park 2 | 4 | |
626 | 626 | 625 | {"type": "MultiPolygon", "coordinates": [[[[-117.898, 33.73463], [-117.89798, 33.73688], [-117.896, 33.73688], [-117.896, 33.73629], [-117.89607, 33.73628], [-117.89607, 33.7346], [-117.89791, 33.7346], [-117.89792, 33.73463], [-117.898, 33.73463]]], [[[-117.89922, 33.73798], [-117.89813, 33.73798], [-117.89812, 33.7346], [-117.8992, 33.7346], [-117.89922, 33.73798]]]]} | Open Access 1 | 2440 | Jerome Park | 20399 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 20.542 | Jerome Park | 0 | Local Park 2 | 4 | |
702 | 702 | 701 | {"type": "Polygon", "coordinates": [[[-117.87512, 33.70458], [-117.87514, 33.70468], [-117.87508, 33.70483], [-117.87466, 33.70522], [-117.87465, 33.70537], [-117.87317, 33.70536], [-117.87318, 33.70507], [-117.87307, 33.70502], [-117.8731, 33.70494], [-117.87309, 33.7049], [-117.87324, 33.70484], [-117.87324, 33.70429], [-117.87311, 33.70424], [-117.87312, 33.70419], [-117.8731, 33.70413], [-117.87324, 33.70407], [-117.87325, 33.70355], [-117.87311, 33.70348], [-117.87312, 33.70343], [-117.87311, 33.70338], [-117.87325, 33.70332], [-117.87325, 33.70277], [-117.87454, 33.70277], [-117.87471, 33.7028], [-117.87468, 33.70416], [-117.87512, 33.70458]]]} | Open Access 1 | 4154 | Lillie King Park | 21237 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 10.431 | Lillie King Park | 0 | Local Park 2 | 4 | |
725 | 725 | 724 | {"type": "Polygon", "coordinates": [[[-117.85796, 33.75435], [-117.85756, 33.75436], [-117.85755, 33.75394], [-117.85795, 33.75394], [-117.85796, 33.75435]]]} | Open Access 1 | 4606 | Chepa's Park | 17163 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.418 | Chepa's Park | 0 | Local Park 2 | 4 | |
6690 | 6690 | 6689 | {"type": "Polygon", "coordinates": [[[-117.84375, 33.75726], [-117.84345, 33.75726], [-117.84345, 33.75709], [-117.84364, 33.75703], [-117.84335, 33.75636], [-117.84363, 33.75568], [-117.84344, 33.75561], [-117.84351, 33.75544], [-117.84344, 33.75528], [-117.84364, 33.75521], [-117.84337, 33.75456], [-117.84364, 33.75385], [-117.84235, 33.75346], [-117.84234, 33.75318], [-117.84172, 33.75318], [-117.84171, 33.75289], [-117.84374, 33.75288], [-117.84375, 33.75726]]]} | Open Access 1 | 4925 | Mabury Park | 21620 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 5.436 | Mabury Park | 0 | Local Park 2 | 4 | |
774 | 774 | 773 | {"type": "Polygon", "coordinates": [[[-117.87227, 33.7464], [-117.87227, 33.74703], [-117.87226, 33.74705], [-117.87221, 33.74708], [-117.87092, 33.74709], [-117.87092, 33.7464], [-117.87227, 33.7464]]]} | Open Access 1 | 5035 | Birch Park | 16117 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.354 | Birch Park | 0 | Local Park 2 | 4 | |
777 | 777 | 776 | {"type": "Polygon", "coordinates": [[[-117.89784, 33.71694], [-117.89618, 33.71696], [-117.89617, 33.71572], [-117.89619, 33.71566], [-117.89621, 33.71564], [-117.89626, 33.71563], [-117.89784, 33.71561], [-117.89784, 33.71694]]]} | Open Access 1 | 5185 | Adams Park | 15263 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 5.604 | Adams Park | 0 | Local Park 2 | 4 | |
853 | 853 | 852 | {"type": "Polygon", "coordinates": [[[-117.88029, 33.77453], [-117.88029, 33.77595], [-117.87873, 33.77595], [-117.87869, 33.7759], [-117.87867, 33.77536], [-117.87881, 33.77504], [-117.8788, 33.77496], [-117.87918, 33.77496], [-117.87918, 33.77454], [-117.88029, 33.77453]]]} | Open Access 1 | 5521 | Morrison Park | 22500 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 5.147 | Morrison Park | 0 | Local Park 2 | 4 | |
1022 | 1022 | 1021 | {"type": "Polygon", "coordinates": [[[-117.89958, 33.76217], [-117.89942, 33.76258], [-117.89937, 33.76277], [-117.89924, 33.76363], [-117.89922, 33.76392], [-117.89854, 33.76383], [-117.89853, 33.76343], [-117.89856, 33.76335], [-117.89876, 33.76312], [-117.89885, 33.76298], [-117.89887, 33.76283], [-117.89891, 33.76271], [-117.89947, 33.76213], [-117.89958, 33.76217]]]} | Open Access 1 | 5639 | Edna Park | 18451 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.29 | Edna Park | 0 | Local Park 2 | 4 | |
1031 | 1031 | 1030 | {"type": "Polygon", "coordinates": [[[-117.89901, 33.74171], [-117.89886, 33.74172], [-117.89885, 33.74179], [-117.89876, 33.74179], [-117.89875, 33.74163], [-117.89901, 33.74163], [-117.89901, 33.74171]]]} | Open Access 1 | 5649 | Friendship Park | 19122 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.074 | Friendship Park | 0 | Local Park 2 | 4 | |
1076 | 1076 | 1075 | {"type": "Polygon", "coordinates": [[[-117.93514, 33.73981], [-117.93478, 33.74004], [-117.93455, 33.74022], [-117.93426, 33.74049], [-117.93398, 33.7408], [-117.93383, 33.74101], [-117.93354, 33.74148], [-117.93336, 33.74182], [-117.9331, 33.74245], [-117.93308, 33.74147], [-117.93261, 33.74146], [-117.93261, 33.73985], [-117.93299, 33.73995], [-117.93393, 33.73994], [-117.93402, 33.73984], [-117.93402, 33.73981], [-117.93514, 33.73981]]]} | Open Access 1 | 5664 | Heritage Park | 19854 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.795 | Heritage Park | 0 | Local Park 2 | 4 | |
5377 | 5377 | 5376 | {"type": "Polygon", "coordinates": [[[-117.85825, 33.72699], [-117.85823, 33.72841], [-117.85656, 33.72842], [-117.85658, 33.72705], [-117.8566, 33.727], [-117.85666, 33.72698], [-117.85825, 33.72699]]]} | Open Access 1 | 5703 | Madison Park | 21659 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.057 | Madison Park | 0 | Local Park 2 | 4 | |
5023 | 5023 | 5022 | {"type": "Polygon", "coordinates": [[[-117.88043, 33.69733], [-117.8804, 33.69987], [-117.87871, 33.69989], [-117.87874, 33.69733], [-117.88043, 33.69733]]]} | Open Access 1 | 7476 | Bomo Koral Park | 16251 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 10.961 | Bomo Koral Park | 0 | Local Park 2 | 4 | |
7730 | 7730 | 7729 | {"type": "Polygon", "coordinates": [[[-117.84737, 33.75203], [-117.84691, 33.75172], [-117.84623, 33.75118], [-117.8459, 33.75088], [-117.84631, 33.75087], [-117.84635, 33.75098], [-117.84642, 33.75106], [-117.84691, 33.75144], [-117.8472, 33.75164], [-117.84728, 33.75167], [-117.84736, 33.75167], [-117.84737, 33.75203]]]} | Open Access 1 | 8086 | Saddleback View Park | 24777 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.943 | Saddleback View Park | 0 | Local Park 2 | 4 | |
1407 | 1407 | 1406 | {"type": "Polygon", "coordinates": [[[-117.84454, 33.76473], [-117.84453, 33.76707], [-117.84317, 33.76707], [-117.84318, 33.76477], [-117.84329, 33.76474], [-117.84333, 33.7647], [-117.84334, 33.76464], [-117.84333, 33.76458], [-117.84329, 33.76454], [-117.84318, 33.7645], [-117.84318, 33.7643], [-117.84402, 33.76431], [-117.84403, 33.76453], [-117.84406, 33.76459], [-117.84411, 33.76465], [-117.84419, 33.7647], [-117.84429, 33.76473], [-117.84454, 33.76473]]]} | Open Access 1 | 8825 | Portola Park | 23912 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 8.958 | Portola Park | 0 | Local Park 2 | 4 | |
1416 | 1416 | 1415 | {"type": "Polygon", "coordinates": [[[-117.84375, 33.74542], [-117.84305, 33.74542], [-117.84218, 33.74442], [-117.84174, 33.74394], [-117.84116, 33.74342], [-117.84038, 33.74289], [-117.84036, 33.74214], [-117.84257, 33.74211], [-117.8437, 33.74211], [-117.84375, 33.74542]]]} | Open Access 1 | 8907 | Prentice Park | 23983 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 18.524 | Prentice 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]);