units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where COUNTY = 4 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, YR_EST, GAP_STS
MNG_AGENCY 11
- The Environmental Trust 21
- Fallbrook Land Conservancy 15
- Center for Natural Lands Management 13
- San Dieguito River Valley Land Conservancy 6
- Back Country Land Trust 4
- The Nature Conservancy 3
- Escondido Creek Conservancy 2
- Anza-Borrego Foundation 2
- San Elijo Lagoon Conservancy 1
- The Conservation Fund - California 1
- Volcan Mountain Preserve Foundation 1
DES_TP 4
ACCESS_TYP 4
MNG_AG_TYP 1
- Non Profit - Land Trust · 69 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14625 | 14625 | 14624 | {"type": "Polygon", "coordinates": [[[-117.26035, 32.96792], [-117.26005, 32.96812], [-117.25973, 32.9678], [-117.2599, 32.96778], [-117.2601, 32.96779], [-117.26023, 32.96784], [-117.26035, 32.96792]]]} | Open Access 1 | 44860 | San Dieguito Lagoon | 24865 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sandieguitorivervalleyconservancy.org/sdrvc1_projects_acquisitions1.html | San Diego 4 | 0.286 | San Dieguito Lagoon | 0 | Private Conservation 16 | 2 |
8169 | 8169 | 8168 | {"type": "Polygon", "coordinates": [[[-117.01797, 32.65356], [-117.01795, 32.65355], [-117.01732, 32.65317], [-117.01775, 32.65304], [-117.01797, 32.65356]]]} | No Public Access 3 | 12372 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.332 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8160 | 8160 | 8159 | {"type": "Polygon", "coordinates": [[[-117.14404, 32.97655], [-117.14403, 32.97699], [-117.14363, 32.97685], [-117.14365, 32.97679], [-117.14365, 32.97656], [-117.14404, 32.97655]]]} | No Public Access 3 | 12367 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.366 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8178 | 8178 | 8177 | {"type": "Polygon", "coordinates": [[[-117.14201, 32.97455], [-117.14188, 32.97462], [-117.14104, 32.97463], [-117.14104, 32.97435], [-117.14107, 32.97432], [-117.14158, 32.97431], [-117.14176, 32.97445], [-117.14201, 32.97446], [-117.14201, 32.97455]]]} | No Public Access 3 | 12383 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.632 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8181 | 8181 | 8180 | {"type": "Polygon", "coordinates": [[[-117.30491, 33.0932], [-117.30453, 33.09207], [-117.30484, 33.09153], [-117.30491, 33.09304], [-117.30491, 33.0932]]]} | No Public Access 3 | 12389 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.747 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8179 | 8179 | 8178 | {"type": "Polygon", "coordinates": [[[-117.28623, 33.14129], [-117.28623, 33.14129], [-117.28489, 33.14169], [-117.28558, 33.1409], [-117.28623, 33.14129]]]} | No Public Access 3 | 12385 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.011 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
1282 | 1282 | 1281 | {"type": "Polygon", "coordinates": [[[-117.23197, 33.35767], [-117.23195, 33.35817], [-117.23163, 33.35818], [-117.2314, 33.35817], [-117.23119, 33.35811], [-117.23111, 33.35808], [-117.23108, 33.35804], [-117.2311, 33.358], [-117.23133, 33.35781], [-117.23146, 33.35767], [-117.2318, 33.35723], [-117.2319, 33.35729], [-117.23197, 33.35767]]]} | Open Access 1 | 7247 | Palomares House | 23367 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/palomares-house-and-park.html | San Diego 4 | 1.248 | Palomares House | 0 | Private Conservation 16 | 2 |
8180 | 8180 | 8179 | {"type": "Polygon", "coordinates": [[[-117.14409, 32.97117], [-117.14395, 32.97109], [-117.14349, 32.97116], [-117.14334, 32.9712], [-117.14311, 32.97129], [-117.14298, 32.97143], [-117.14283, 32.97134], [-117.14262, 32.97134], [-117.14241, 32.97126], [-117.14226, 32.97152], [-117.14221, 32.97148], [-117.14212, 32.97145], [-117.142, 32.97148], [-117.14191, 32.97142], [-117.14158, 32.97142], [-117.14184, 32.97106], [-117.14409, 32.97105], [-117.14409, 32.97117]]]} | No Public Access 3 | 12386 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.452 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
14622 | 14622 | 14621 | {"type": "Polygon", "coordinates": [[[-117.27099, 33.11486], [-117.27071, 33.11529], [-117.27021, 33.11588], [-117.27021, 33.11462], [-117.27039, 33.11459], [-117.27068, 33.11463], [-117.27068, 33.11466], [-117.27084, 33.11474], [-117.27085, 33.11484], [-117.2709, 33.11482], [-117.27099, 33.11486]]]} | No Public Access 3 | 44873 | Cassia Professional Offices Preserve | 16944 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.462 | Cassia Professional Offices Preserve | 0 | Private Conservation 16 | 2 | |
8165 | 8165 | 8164 | {"type": "Polygon", "coordinates": [[[-117.02171, 32.65451], [-117.02033, 32.65449], [-117.01985, 32.65443], [-117.01953, 32.65435], [-117.02146, 32.65381], [-117.02171, 32.65451]]]} | No Public Access 3 | 12368 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 2.163 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
7564 | 7564 | 7563 | {"type": "Polygon", "coordinates": [[[-117.23847, 33.42888], [-117.2383, 33.42892], [-117.23814, 33.42891], [-117.23796, 33.42885], [-117.23784, 33.42878], [-117.23755, 33.42869], [-117.23723, 33.42713], [-117.23723, 33.42663], [-117.2379, 33.42694], [-117.23799, 33.427], [-117.23802, 33.42704], [-117.23804, 33.42711], [-117.23807, 33.42759], [-117.23817, 33.4276], [-117.23825, 33.42826], [-117.23847, 33.42888]]]} | Open Access 1 | 7252 | Santa Margarita River Lands | 3669 | 2034 | Fallbrook Public Utility District 870 | Special District 4 | Water District 13 | https://www.fpud.com/ | Special District 4 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/santa-margarita-river-trail.html | San Diego 4 | 4.166 | Santa Margarita River Lands | None 628 | ||
8156 | 8156 | 8155 | {"type": "Polygon", "coordinates": [[[-117.06244, 32.94866], [-117.0619, 32.94857], [-117.06188, 32.94879], [-117.06125, 32.9488], [-117.0604, 32.94906], [-117.05975, 32.94933], [-117.0592, 32.94962], [-117.0591, 32.94967], [-117.0591, 32.9497], [-117.05853, 32.94975], [-117.05843, 32.94897], [-117.0585, 32.94904], [-117.05852, 32.94919], [-117.0586, 32.94933], [-117.05864, 32.94936], [-117.05867, 32.94936], [-117.05927, 32.94899], [-117.06002, 32.94867], [-117.06069, 32.94846], [-117.06109, 32.94836], [-117.06167, 32.9483], [-117.06193, 32.94833], [-117.06232, 32.94842], [-117.06244, 32.94856], [-117.06244, 32.94866]]]} | No Public Access 3 | 12362 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.784 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
1625 | 1625 | 1624 | {"type": "Polygon", "coordinates": [[[-117.03443, 32.57835], [-117.03338, 32.57837], [-117.03339, 32.57655], [-117.03443, 32.57653], [-117.03443, 32.57835]]]} | No Public Access 3 | 12395 | Newport 5 Preserve | 22731 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.919 | Newport 5 Preserve | 0 | Private Conservation 16 | 2 | ||
6800 | 6800 | 6799 | {"type": "Polygon", "coordinates": [[[-116.32668, 33.22441], [-116.32666, 33.22675], [-116.32578, 33.22675], [-116.32579, 33.22442], [-116.32668, 33.22441]]]} | No Public Access 3 | 5312 | Mesquite Bosque | 28286 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 5.285 | Mesquite Bosque | 0 | Private Conservation 16 | 2 | |
8175 | 8175 | 8174 | {"type": "Polygon", "coordinates": [[[-117.14408, 32.9718], [-117.14406, 32.97356], [-117.14366, 32.97373], [-117.14361, 32.97379], [-117.14344, 32.97374], [-117.14342, 32.97375], [-117.14341, 32.97381], [-117.1428, 32.97381], [-117.14271, 32.97416], [-117.1422, 32.97415], [-117.14219, 32.97414], [-117.14219, 32.97335], [-117.14224, 32.97304], [-117.14249, 32.97305], [-117.14268, 32.97301], [-117.14321, 32.97288], [-117.14349, 32.97275], [-117.14374, 32.97241], [-117.14386, 32.9722], [-117.14393, 32.97197], [-117.14408, 32.9718]]]} | No Public Access 3 | 12375 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 5.393 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8170 | 8170 | 8169 | {"type": "Polygon", "coordinates": [[[-117.31369, 33.22397], [-117.31367, 33.22603], [-117.31264, 33.22629], [-117.31264, 33.22547], [-117.31196, 33.22473], [-117.31161, 33.22423], [-117.3111, 33.22435], [-117.31051, 33.22469], [-117.31045, 33.22461], [-117.31046, 33.2246], [-117.3104, 33.22453], [-117.31045, 33.22451], [-117.31051, 33.2245], [-117.31054, 33.22448], [-117.31073, 33.22451], [-117.31079, 33.22448], [-117.31122, 33.22413], [-117.31136, 33.22399], [-117.31142, 33.22396], [-117.31153, 33.22396], [-117.31163, 33.22401], [-117.31169, 33.22401], [-117.31178, 33.22395], [-117.31181, 33.22387], [-117.3126, 33.22409], [-117.31337, 33.22425], [-117.31369, 33.22397]]]} | No Public Access 3 | 12374 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 8.217 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8235 | 8235 | 8234 | {"type": "Polygon", "coordinates": [[[-117.00398, 32.95858], [-117.00347, 32.95885], [-117.00267, 32.95902], [-117.00248, 32.9592], [-117.00238, 32.95921], [-117.00228, 32.95927], [-117.00224, 32.95935], [-117.00223, 32.95942], [-117.00187, 32.95949], [-117.00142, 32.95963], [-117.00107, 32.95966], [-117.0005, 32.9599], [-117.00031, 32.95999], [-117.00015, 32.96009], [-116.99999, 32.96022], [-116.99938, 32.96082], [-116.99922, 32.961], [-116.999, 32.96116], [-116.99869, 32.96076], [-116.9986, 32.96055], [-116.99857, 32.96041], [-116.99857, 32.96028], [-116.99889, 32.96032], [-116.99894, 32.96017], [-116.99903, 32.96003], [-116.99919, 32.9599], [-117.0004, 32.9591], [-117.00022, 32.95889], [-117.00036, 32.95882], [-117.00045, 32.9588], [-117.00053, 32.95908], [-117.00071, 32.95907], [-117.0009, 32.95908], [-117.00109, 32.95914], [-117.00158, 32.95908], [-117.00154, 32.9589], [-117.00171, 32.95887], [-117.00396, 32.95799], [-117.00398, 32.95858]]]} | No Public Access 3 | 12569 | Poway Creek Riparian Preserve | 23931 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 10.021 | Poway Creek Riparian Preserve | 0 | Private Conservation 16 | 2 | ||
7317 | 7317 | 7316 | {"type": "Polygon", "coordinates": [[[-117.16715, 33.33888], [-117.16588, 33.3392], [-117.16534, 33.33971], [-117.16475, 33.33998], [-117.16499, 33.33744], [-117.16645, 33.33732], [-117.16704, 33.33813], [-117.16715, 33.33888]]]} | Open Access 1 | 7212 | Engel Family Preserve | 18674 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/engel-preserve.html | San Diego 4 | 10.291 | Engel Family Preserve | 0 | Private Conservation 16 | 2 |
1301 | 1301 | 1300 | {"type": "MultiPolygon", "coordinates": [[[[-117.13039, 33.09966], [-117.12847, 33.0991], [-117.12813, 33.09906], [-117.12781, 33.09906], [-117.12747, 33.0991], [-117.12747, 33.09743], [-117.12941, 33.09743], [-117.1294, 33.09846], [-117.13038, 33.09848], [-117.13039, 33.09966]]], [[[-117.13063, 33.0997], [-117.13052, 33.09975], [-117.13053, 33.0991], [-117.13063, 33.09923], [-117.13063, 33.0997]]]]} | No Public Access 3 | 10457 | Quarry Property | 24058 | 3021 | Escondido Creek Conservancy 344 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.escondidocreek.org/ | Non Governmental Organization 10 | 3021 | Escondido Creek Conservancy 341 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 11.308 | Quarry Property | 0 | Private Conservation 16 | 2 | |
5414 | 5414 | 5413 | {"type": "Polygon", "coordinates": [[[-117.23382, 33.35463], [-117.23345, 33.3551], [-117.23265, 33.3558], [-117.23252, 33.35594], [-117.23126, 33.35761], [-117.23105, 33.3578], [-117.23083, 33.35794], [-117.23058, 33.35806], [-117.23051, 33.35804], [-117.23049, 33.35801], [-117.23046, 33.35577], [-117.23067, 33.35574], [-117.23087, 33.35566], [-117.23097, 33.35558], [-117.2311, 33.35543], [-117.23121, 33.35539], [-117.23145, 33.35518], [-117.23195, 33.35489], [-117.23227, 33.35462], [-117.23382, 33.35463]]]} | Open Access 1 | 7208 | Dinwiddie Preserve | 18159 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/dinwiddie.html | San Diego 4 | 12.888 | Dinwiddie Preserve | 0 | Private Conservation 16 | 2 |
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]);