units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where COUNTY = 4 and MNG_AGENCY = 101 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 11
- Local Park 68
- Local Conservation Area 37
- Local Recreation Area 7
- Local Other or Unknown 4
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_NAME 4 ✖
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 123
MNG_AGENCY 1
- San Diego, County of · 123 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} | Open Access 1 | 704 | Seaside Gardens County Park | 25250 | 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 | 0.15 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
3171 | 3171 | 3170 | {"type": "Polygon", "coordinates": [[[-117.07154, 32.66675], [-117.07129, 32.66682], [-117.07133, 32.66693], [-117.07096, 32.66703], [-117.07084, 32.66671], [-117.07146, 32.66654], [-117.07154, 32.66675]]]} | Open Access 1 | 26057 | Lincoln Acres Park | 21245 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/LincolnAcres.html | San Diego 4 | 0.484 | Lincoln Acres Park | 0 | Local Park 2 | 4 |
15153 | 15153 | 15152 | {"type": "Polygon", "coordinates": [[[-117.01386, 32.72777], [-117.0139, 32.72806], [-117.0139, 32.72816], [-117.01388, 32.72821], [-117.01382, 32.7283], [-117.01375, 32.72838], [-117.01357, 32.72848], [-117.01357, 32.7277], [-117.01378, 32.72776], [-117.01386, 32.72777]]]} | Open Access 1 | 45999 | Ildica Street Park | 29205 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/IldicaStreetPark.html | San Diego 4 | 0.504 | Ildica Street Park | 0 | Local Park 2 | 4 |
3908 | 3908 | 3907 | {"type": "Polygon", "coordinates": [[[-116.93617, 32.74656], [-116.93581, 32.74674], [-116.93549, 32.74631], [-116.93585, 32.74615], [-116.93617, 32.74656]]]} | Open Access 1 | 45998 | Hillsdale Park | 29204 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Hillsdale.html | San Diego 4 | 0.53 | Hillsdale Park | 0 | Local Park 2 | 4 |
14928 | 14928 | 14927 | {"type": "Polygon", "coordinates": [[[-117.25461, 33.36874], [-117.2546, 33.3693], [-117.25423, 33.3693], [-117.25423, 33.36873], [-117.25461, 33.36874]]]} | Open Access 1 | 45505 | Clemmens Lane County Park | 28337 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Clemmens.html | San Diego 4 | 0.544 | Clemmens Lane County Park | 2009 | Local Park 2 | 4 |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | 5304 | Don Dussault Park | 18203 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/DonDussault.html | San Diego 4 | 0.746 | Don Dussault Park | 0 | Local Park 2 | 4 |
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 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 | http://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
848 | 848 | 847 | {"type": "Polygon", "coordinates": [[[-117.00957, 32.73712], [-117.00956, 32.73771], [-117.00891, 32.7377], [-117.00892, 32.73676], [-117.00933, 32.73677], [-117.00933, 32.73712], [-117.00957, 32.73712]]]} | Open Access 1 | 4981 | Goodland Acres Park | 19403 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/GoodlandAcres.html | San Diego 4 | 1.35 | Goodland Acres Park | 0 | Local Park 2 | 4 |
6823 | 6823 | 6822 | {"type": "Polygon", "coordinates": [[[-116.60352, 33.07735], [-116.60296, 33.07789], [-116.60246, 33.07753], [-116.60288, 33.07712], [-116.60264, 33.07693], [-116.60277, 33.07681], [-116.60352, 33.07735]]]} | Open Access 1 | 5406 | Julian Museum and Pioneer Park | 29242 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/JulianMuseum.html | San Diego 4 | 1.352 | Julian Museum and Pioneer Park | 0 | Local Park 2 | 4 |
15157 | 15157 | 15156 | {"type": "Polygon", "coordinates": [[[-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.0117], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151]]]} | Open Access 1 | 46006 | 4S Ranch Homestead Park | 29267 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | San Diego 4 | 1.801 | 4S Ranch Homestead Park | 0 | Local Park 2 | 4 |
4240 | 4240 | 4239 | {"type": "Polygon", "coordinates": [[[-117.30167, 33.05611], [-117.30158, 33.05598], [-117.30138, 33.05554], [-117.30104, 33.05461], [-117.30076, 33.05468], [-117.30008, 33.0527], [-117.30033, 33.05262], [-117.30167, 33.05611]]]} | Open Access 1 | 1699 | Seaside Gardens County Park | 25250 | 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 | 1.833 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
6722 | 6722 | 6721 | {"type": "Polygon", "coordinates": [[[-116.86518, 32.80929], [-116.86498, 32.80983], [-116.8637, 32.80982], [-116.86371, 32.80929], [-116.86518, 32.80929]]]} | Open Access 1 | 5038 | Nancy Jane County Park | 22624 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/NancyJane.html | San Diego 4 | 1.898 | Nancy Jane County Park | 0 | Local Park 2 | 4 |
6026 | 6026 | 6025 | {"type": "Polygon", "coordinates": [[[-117.3003, 33.05251], [-117.30004, 33.05256], [-117.29996, 33.05233], [-117.29941, 33.05098], [-117.29921, 33.05081], [-117.29929, 33.05081], [-117.29929, 33.0508], [-117.2992, 33.05012], [-117.29918, 33.04985], [-117.29908, 33.04958], [-117.29912, 33.04946], [-117.29967, 33.05081], [-117.29972, 33.05081], [-117.30002, 33.05167], [-117.30005, 33.05183], [-117.3003, 33.05251]]]} | Open Access 1 | 706 | Seaside Gardens County Park | 25250 | 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 | 2.1 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
7619 | 7619 | 7618 | {"type": "Polygon", "coordinates": [[[-116.82786, 32.82212], [-116.82777, 32.82238], [-116.82768, 32.82304], [-116.82756, 32.82342], [-116.82751, 32.82344], [-116.82696, 32.82328], [-116.82688, 32.82324], [-116.82678, 32.8231], [-116.82662, 32.82264], [-116.8266, 32.82253], [-116.82663, 32.82209], [-116.82665, 32.82201], [-116.82738, 32.82222], [-116.82739, 32.82221], [-116.82738, 32.82197], [-116.82786, 32.82212]]]} | Open Access 1 | 47633 | Old Ironsides County Park | 31372 | 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 | 3.365 | Old Ironsides County Park | 0 | Local Park 2 | 4 | |
6804 | 6804 | 6803 | {"type": "Polygon", "coordinates": [[[-116.86005, 33.31388], [-116.86006, 33.31401], [-116.86005, 33.31413], [-116.85991, 33.31447], [-116.85907, 33.31471], [-116.85906, 33.31388], [-116.85861, 33.31387], [-116.85861, 33.31286], [-116.85864, 33.31285], [-116.85865, 33.31273], [-116.85907, 33.31274], [-116.85908, 33.31311], [-116.85934, 33.31313], [-116.85934, 33.31387], [-116.86005, 33.31388]]]} | Open Access 1 | 5328 | Palomar County Park | 31534 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Palomar.html | San Diego 4 | 3.548 | Palomar County Park | 0 | Local Park 2 | 4 |
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-117.15085, 33.41386], [-117.14988, 33.41386], [-117.14987, 33.41211], [-117.15083, 33.4121], [-117.15085, 33.41386]]]} | Open Access 1 | 5212 | Rainbow Park | 24087 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Rainbow.html | San Diego 4 | 4.328 | Rainbow Park | 0 | Local Park 2 | 4 |
763 | 763 | 762 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00081, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.0002, 32.74539], [-117.00067, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | 4973 | Bancroft Park | 15792 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | San Diego 4 | 4.676 | Bancroft Park | 0 | Local Park 2 | 4 |
15150 | 15150 | 15149 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11261, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 45993 | 4S Ranch Liberty Park | 29187 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 4.774 | 4S Ranch Liberty Park | 0 | Local Park 2 | 4 |
15160 | 15160 | 15159 | {"type": "Polygon", "coordinates": [[[-116.93134, 32.608], [-116.93126, 32.60819], [-116.93077, 32.60814], [-116.92998, 32.60819], [-116.92945, 32.60825], [-116.92907, 32.60836], [-116.92898, 32.60832], [-116.92901, 32.60821], [-116.92941, 32.60736], [-116.92939, 32.60723], [-116.92945, 32.60712], [-116.93046, 32.60712], [-116.9308, 32.60725], [-116.93096, 32.60738], [-116.9311, 32.60753], [-116.93127, 32.60761], [-116.93121, 32.60792], [-116.93134, 32.608]]]} | Open Access 1 | 46009 | Otay Lakes County Park | 29273 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/OtayLakes.html | San Diego 4 | 5.178 | Otay Lakes County Park | 0 | Local Park 2 | 4 |
6696 | 6696 | 6695 | {"type": "Polygon", "coordinates": [[[-116.95847, 32.74943], [-116.95847, 32.75121], [-116.95732, 32.75118], [-116.95732, 32.74942], [-116.95847, 32.74943]]]} | Open Access 1 | 4976 | Lonny Brewer Park | 29245 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/LonnyBrewer.html | San Diego 4 | 5.232 | Lonny Brewer 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]);