units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where COUNTY = 4 and DES_TP = 14 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_LEV
MNG_AGENCY 15
- Poway, City of 35
- Encinitas, City of 21
- San Diego, City of 15
- Escondido, City of 9
- San Diego, County of 4
- San Marcos, City of 4
- Vista, City of 2
- Ramona Municipal Water District 2
- Santee, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Borrego Water District 1
- Helix Water District 1
- Olivenhain Municipal Water District 1
- North County Transit District 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Other or Unknown · 99 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15141 | 15141 | 15140 | {"type": "Polygon", "coordinates": [[[-117.32181, 33.23522], [-117.32171, 33.23556], [-117.32162, 33.23557], [-117.32159, 33.23552], [-117.32146, 33.23545], [-117.32138, 33.23537], [-117.32154, 33.23522], [-117.32176, 33.23511], [-117.32181, 33.23522]]]} | Open Access 1 | 45966 | Mission Wells Historical Lot | 29115 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#9 | San Diego 4 | 0.286 | Mission Wells Historical Lot | 0 | Local Other or Unknown 14 | 4 |
14808 | 14808 | 14807 | {"type": "Polygon", "coordinates": [[[-117.00394, 33.01294], [-117.00388, 33.01486], [-117.00029, 33.01496], [-117.00055, 33.01283], [-117.00251, 33.0123], [-117.00285, 33.01294], [-117.00394, 33.01294]]]} | Unknown Access 4 | 45224 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 19.711 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14807 | 14807 | 14806 | {"type": "Polygon", "coordinates": [[[-116.93609, 33.0511], [-116.92755, 33.05108], [-116.92754, 33.04241], [-116.93205, 33.04305], [-116.93259, 33.04035], [-116.92753, 33.03962], [-116.92753, 33.03643], [-116.93601, 33.03655], [-116.93601, 33.04036], [-116.93609, 33.0511]]]} | Unknown Access 4 | 45223 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 283.724 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14774 | 14774 | 14773 | {"type": "MultiPolygon", "coordinates": [[[[-117.3104, 33.20185], [-117.31053, 33.20215], [-117.31063, 33.20246], [-117.31076, 33.20299], [-117.31074, 33.20304], [-117.31069, 33.20307], [-117.31012, 33.2032], [-117.30901, 33.2034], [-117.308, 33.20353], [-117.30733, 33.20359], [-117.30597, 33.20366], [-117.30496, 33.20366], [-117.30145, 33.20359], [-117.30076, 33.20359], [-117.30007, 33.20361], [-117.29904, 33.20369], [-117.29686, 33.20395], [-117.29686, 33.20297], [-117.30621, 33.20241], [-117.30709, 33.20231], [-117.30775, 33.20222], [-117.31037, 33.2018], [-117.3104, 33.20185]]], [[[-117.31023, 33.20153], [-117.3077, 33.20193], [-117.30618, 33.20213], [-117.29686, 33.2027], [-117.29686, 33.20126], [-117.3063, 33.20135], [-117.31012, 33.20136], [-117.31023, 33.20153]]]]} | Unknown Access 4 | 45152 | North County Transit District Mitigation | 22817 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 69.998 | North County Transit District Mitigation | 0 | Local Other or Unknown 14 | 4 | |
14716 | 14716 | 14715 | {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} | Unknown Access 4 | 47814 | Unnamed site - San Diego, County of | 31715 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 87.174 | 0 | Local Other or Unknown 14 | 4 | ||
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
13992 | 13992 | 13991 | {"type": "Polygon", "coordinates": [[[-117.02354, 33.00205], [-117.02349, 33.0021], [-117.02338, 33.0021], [-117.02348, 33.00185], [-117.02347, 33.00124], [-117.02325, 33.00034], [-117.02352, 33.00034], [-117.02356, 33.00132], [-117.02356, 33.00176], [-117.02354, 33.00205]]]} | Open Access 1 | 36674 | Poway holding 33 | 23958 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.628 | Poway holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13953 | 13953 | 13952 | {"type": "Polygon", "coordinates": [[[-117.01467, 32.96351], [-117.01068, 32.96361], [-117.01063, 32.96125], [-117.01119, 32.96125], [-117.01145, 32.96129], [-117.01165, 32.96145], [-117.012, 32.96202], [-117.01304, 32.96183], [-117.01339, 32.96141], [-117.01338, 32.96072], [-117.01418, 32.96145], [-117.01434, 32.96161], [-117.01464, 32.96196], [-117.01467, 32.96351]]]} | Open Access 1 | 36589 | Poway holding 36 | 23961 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 20.871 | Poway holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13573 | 13573 | 13572 | {"type": "Polygon", "coordinates": [[[-117.02693, 33.00207], [-117.02671, 33.00227], [-117.02652, 33.0025], [-117.02693, 33.00285], [-117.02677, 33.00296], [-117.0267, 33.00296], [-117.02655, 33.00283], [-117.02615, 33.00258], [-117.0265, 33.00173], [-117.02682, 33.00172], [-117.02693, 33.00207]]]} | Open Access 1 | 35892 | Poway holding 21 | 23945 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.303 | Poway holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13572 | 13572 | 13571 | {"type": "Polygon", "coordinates": [[[-117.02405, 33.00214], [-117.02394, 33.00214], [-117.02394, 33.00177], [-117.02401, 33.00177], [-117.02405, 33.00214]]]} | Open Access 1 | 35891 | Poway holding 22 | 23946 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.091 | Poway holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13571 | 13571 | 13570 | {"type": "Polygon", "coordinates": [[[-117.03068, 33.02743], [-117.03049, 33.02762], [-117.03026, 33.02759], [-117.02995, 33.02739], [-117.02999, 33.0271], [-117.0306, 33.02717], [-117.03068, 33.02743]]]} | Open Access 1 | 35890 | Poway holding 16 | 23939 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.701 | Poway holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13570 | 13570 | 13569 | {"type": "Polygon", "coordinates": [[[-117.02761, 33.01797], [-117.0268, 33.01789], [-117.02633, 33.01779], [-117.02581, 33.01761], [-117.02556, 33.0175], [-117.02533, 33.01736], [-117.02512, 33.01722], [-117.02493, 33.01706], [-117.02462, 33.01673], [-117.02435, 33.01626], [-117.0242, 33.01588], [-117.02413, 33.01561], [-117.02411, 33.01538], [-117.02404, 33.01406], [-117.02405, 33.00967], [-117.02421, 33.00752], [-117.02423, 33.00748], [-117.02427, 33.00746], [-117.02452, 33.00747], [-117.02444, 33.00763], [-117.02428, 33.00781], [-117.02427, 33.00824], [-117.02433, 33.00874], [-117.02453, 33.00876], [-117.02567, 33.00915], [-117.02558, 33.00927], [-117.02493, 33.00904], [-117.02432, 33.00886], [-117.02415, 33.00934], [-117.02414, 33.01027], [-117.02433, 33.01055], [-117.02416, 33.01078], [-117.02428, 33.01198], [-117.02412, 33.01289], [-117.02413, 33.0135], [-117.02423, 33.01492], [-117.02433, 33.01536], [-117.02454, 33.0158], [-117.02464, 33.01648], [-117.02518, 33.01699], [-117.02543, 33.01719], [-117.02575, 33.0174], [-117.0261, 33.01757], [-117.02641, 33.01769], [-117.02668, 33.01774], [-117.02694, 33.01776], [-117.02718, 33.01774], [-117.02748, 33.01768], [-117.02761, 33.01797]]]} | Open Access 1 | 35889 | Poway holding 19 | 23942 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 5.896 | Poway holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13567 | 13567 | 13566 | {"type": "Polygon", "coordinates": [[[-117.06327, 32.94069], [-117.06306, 32.94078], [-117.06169, 32.94128], [-117.0611, 32.94144], [-117.06072, 32.9415], [-117.06022, 32.94152], [-117.05984, 32.94149], [-117.05853, 32.94129], [-117.05793, 32.94123], [-117.05736, 32.94113], [-117.05799, 32.93991], [-117.05821, 32.93985], [-117.05851, 32.93909], [-117.0584, 32.93834], [-117.0578, 32.93806], [-117.05733, 32.93674], [-117.05925, 32.93567], [-117.05995, 32.93537], [-117.05998, 32.93542], [-117.06001, 32.93541], [-117.06008, 32.93543], [-117.0604, 32.93597], [-117.06052, 32.93624], [-117.06071, 32.93649], [-117.06182, 32.93759], [-117.0621, 32.93796], [-117.06238, 32.9384], [-117.06325, 32.94015], [-117.06327, 32.94069]]]} | Open Access 1 | 35884 | Poway holding 24 | 23948 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 60.262 | Poway holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13565 | 13565 | 13564 | {"type": "Polygon", "coordinates": [[[-117.02115, 33.0368], [-117.02121, 33.03705], [-117.0212, 33.03732], [-117.02117, 33.03749], [-117.02106, 33.03778], [-117.01992, 33.03762], [-117.01916, 33.03763], [-117.01847, 33.03811], [-117.01844, 33.03675], [-117.01851, 33.03601], [-117.01863, 33.03599], [-117.01867, 33.03628], [-117.01921, 33.03685], [-117.01949, 33.03686], [-117.01956, 33.03695], [-117.01967, 33.03697], [-117.01975, 33.03695], [-117.01984, 33.03688], [-117.01992, 33.03686], [-117.02016, 33.03684], [-117.02051, 33.03686], [-117.02086, 33.03683], [-117.02109, 33.03678], [-117.02115, 33.0368]]]} | Open Access 1 | 35879 | Poway holding 23 | 23947 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.883 | Poway holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13562 | 13562 | 13561 | {"type": "Polygon", "coordinates": [[[-117.00336, 33.02647], [-117.00107, 33.02643], [-117.00114, 33.02272], [-117.00329, 33.02279], [-117.00336, 33.02647]]]} | Open Access 1 | 35877 | Poway holding 20 | 23944 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 21.006 | Poway holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13559 | 13559 | 13558 | {"type": "Polygon", "coordinates": [[[-117.04405, 32.94565], [-117.04344, 32.94627], [-117.0432, 32.94661], [-117.04302, 32.94695], [-117.04291, 32.94721], [-117.04284, 32.94748], [-117.04268, 32.94849], [-117.04261, 32.94875], [-117.04244, 32.94924], [-117.04222, 32.9497], [-117.04196, 32.95008], [-117.04164, 32.95046], [-117.04123, 32.95084], [-117.04107, 32.95104], [-117.04093, 32.95105], [-117.04101, 32.94915], [-117.04098, 32.94491], [-117.04177, 32.94509], [-117.04247, 32.94521], [-117.04364, 32.94544], [-117.04405, 32.94565]]]} | Open Access 1 | 35874 | Poway holding 25 | 23949 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 25.737 | Poway holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13558 | 13558 | 13557 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.96348], [-117.01891, 32.96349], [-117.01891, 32.96168], [-117.01906, 32.96168], [-117.01907, 32.9623], [-117.0192, 32.96265], [-117.0194, 32.96284], [-117.01979, 32.96292], [-117.01991, 32.9627], [-117.02, 32.96238], [-117.02, 32.96233], [-117.02056, 32.96236], [-117.02085, 32.96229], [-117.02135, 32.96256], [-117.02155, 32.96272], [-117.02155, 32.96348]]]} | Open Access 1 | 35873 | Poway holding 26 | 23950 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.785 | Poway holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13553 | 13553 | 13552 | {"type": "Polygon", "coordinates": [[[-117.25074, 33.0247], [-117.25039, 33.02472], [-117.25041, 33.02454], [-117.25054, 33.02417], [-117.25072, 33.02415], [-117.25075, 33.02464], [-117.25074, 33.0247]]]} | Open Access 1 | 35869 | Encinitas holding 18 | 18649 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.403 | Encinitas holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13552 | 13552 | 13551 | {"type": "Polygon", "coordinates": [[[-117.28549, 33.07638], [-117.28536, 33.07638], [-117.28543, 33.07582], [-117.28549, 33.07638], [-117.28549, 33.07638]]]} | Open Access 1 | 35868 | Encinitas holding 17 | 18648 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.092 | Encinitas holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13551 | 13551 | 13550 | {"type": "Polygon", "coordinates": [[[-117.25536, 33.02438], [-117.25535, 33.02541], [-117.25342, 33.02542], [-117.25342, 33.02439], [-117.25362, 33.02439], [-117.25363, 33.02473], [-117.25402, 33.02473], [-117.2542, 33.02486], [-117.25429, 33.02485], [-117.25449, 33.02468], [-117.25468, 33.02484], [-117.25469, 33.02535], [-117.25502, 33.02536], [-117.25504, 33.02527], [-117.2549, 33.0252], [-117.25481, 33.02506], [-117.25478, 33.02493], [-117.25484, 33.02488], [-117.255, 33.02488], [-117.25511, 33.02493], [-117.25512, 33.02466], [-117.25501, 33.02445], [-117.25501, 33.02442], [-117.25504, 33.02438], [-117.25536, 33.02438]]]} | Open Access 1 | 35867 | Encinitas holding 19 | 18650 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.335 | Encinitas holding 19 | 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]);