units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where ACCESS_TYP = 1, COUNTY = 3 and MNG_AGENCY = 19
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 | |
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 | |
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 | |
1303 | 1303 | 1302 | {"type": "MultiPolygon", "coordinates": [[[[-117.93099, 33.75064], [-117.93019, 33.75124], [-117.92901, 33.75214], [-117.929, 33.75066], [-117.93099, 33.75064]]], [[[-117.93104, 33.75232], [-117.93042, 33.75232], [-117.92911, 33.75234], [-117.93103, 33.75087], [-117.93104, 33.75232]]]]} | Open Access 1 | 10471 | Rosita Park | 24672 | 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.322 | Rosita 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 | |
1476 | 1476 | 1475 | {"type": "Polygon", "coordinates": [[[-117.89696, 33.76234], [-117.89368, 33.76487], [-117.8934, 33.76471], [-117.89336, 33.76466], [-117.89451, 33.76336], [-117.89488, 33.76291], [-117.89616, 33.76156], [-117.89685, 33.76135], [-117.8963, 33.76208], [-117.8964, 33.76213], [-117.89696, 33.76234]]]} | Open Access 1 | 10105 | River View Park | 24427 | 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.115 | River View Park | 0 | Local Park 2 | 4 | |
1825 | 1825 | 1824 | {"type": "Polygon", "coordinates": [[[-117.91384, 33.75005], [-117.91354, 33.75006], [-117.91355, 33.75063], [-117.91213, 33.75064], [-117.91213, 33.74905], [-117.91311, 33.74904], [-117.91312, 33.74902], [-117.91336, 33.74902], [-117.91337, 33.74904], [-117.9135, 33.74905], [-117.91354, 33.74909], [-117.91355, 33.74937], [-117.91384, 33.74937], [-117.91384, 33.75005]]]} | Open Access 1 | 13894 | Campesino Park | 16781 | 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.257 | Campesino Park | 0 | Local Park 2 | 4 | |
2459 | 2459 | 2458 | {"type": "Polygon", "coordinates": [[[-117.87752, 33.74703], [-117.87672, 33.74704], [-117.87667, 33.74702], [-117.87664, 33.74697], [-117.87662, 33.74636], [-117.87751, 33.74635], [-117.87752, 33.74703]]]} | Open Access 1 | 17385 | Angeles Park | 15494 | 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 | 1.531 | Angeles Park | 0 | Local Park 2 | 4 | |
2775 | 2775 | 2774 | {"type": "Polygon", "coordinates": [[[-117.86187, 33.71588], [-117.86187, 33.71593], [-117.85943, 33.71591], [-117.85943, 33.71477], [-117.86041, 33.71478], [-117.86042, 33.71469], [-117.86078, 33.71471], [-117.86106, 33.71478], [-117.86186, 33.7148], [-117.86187, 33.71531], [-117.8616, 33.71552], [-117.8614, 33.71553], [-117.86139, 33.71587], [-117.86187, 33.71588]]]} | Open Access 1 | 18530 | Delhi Park | 18066 | 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.656 | Delhi Park | 0 | Local Park 2 | 4 | |
2953 | 2953 | 2952 | {"type": "Polygon", "coordinates": [[[-117.88143, 33.70905], [-117.8815, 33.70906], [-117.88153, 33.70911], [-117.88152, 33.70962], [-117.88149, 33.70965], [-117.87994, 33.70965], [-117.88027, 33.70954], [-117.88143, 33.70905]]]} | Open Access 1 | 20418 | Segerstrom Triangle | 25286 | 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 | 1.234 | Segerstrom Triangle | 0 | Local Other or Unknown 14 | 4 | |
3165 | 3165 | 3164 | {"type": "Polygon", "coordinates": [[[-117.87774, 33.77841], [-117.87719, 33.77827], [-117.87698, 33.77808], [-117.87623, 33.77734], [-117.87668, 33.77726], [-117.87672, 33.77734], [-117.87683, 33.77748], [-117.87759, 33.77824], [-117.87768, 33.77837], [-117.87774, 33.77841]]]} | Open Access 1 | 21955 | William Eldridge Park | 27543 | 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 | 1.2 | William Eldridge 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]);