units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where DES_TP = 2 and MNG_AGENCY = 101
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
3654 | 3654 | 3653 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11707, 33.00365], [-117.11615, 33.00356], [-117.11606, 33.00392], [-117.11566, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 29594 | 4S Ranch Community Park | 29225 | 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/4SRanchSports.html | San Diego 4 | 5.809 | 4S Ranch Community 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 |
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 | |
4392 | 4392 | 4391 | {"type": "Polygon", "coordinates": [[[-117.00165, 32.68355], [-117.0004, 32.68385], [-117.00037, 32.6838], [-117.0005, 32.68375], [-117.00074, 32.68356], [-117.00061, 32.68345], [-117.00052, 32.68333], [-117.00036, 32.6829], [-116.99999, 32.68213], [-116.9997, 32.68168], [-117.00012, 32.68136], [-117.00066, 32.68121], [-117.00114, 32.68245], [-117.00116, 32.68249], [-117.00127, 32.68246], [-117.00165, 32.68355]]]} | Open Access 1 | 46008 | Eastview County Park | 29272 | 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/Eastview.html | San Diego 4 | 6.275 | Eastview County Park | 0 | Local Park 2 | 4 |
5169 | 5169 | 5168 | {"type": "Polygon", "coordinates": [[[-117.00943, 32.73979], [-117.00879, 32.74076], [-117.00745, 32.74078], [-117.00746, 32.7413], [-117.00611, 32.74132], [-117.00567, 32.74102], [-117.00581, 32.74078], [-117.00581, 32.74032], [-117.00681, 32.7403], [-117.00728, 32.74009], [-117.00728, 32.7398], [-117.00943, 32.73979]]]} | Open Access 1 | 4968 | Lamar Park | 29243 | 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/LamarPark.html | San Diego 4 | 8.725 | Lamar Park | 0 | Local Park 2 | 4 |
5190 | 5190 | 5189 | {"type": "Polygon", "coordinates": [[[-116.9854, 32.75274], [-116.98539, 32.75383], [-116.98392, 32.75381], [-116.98395, 32.75166], [-116.98499, 32.75167], [-116.98497, 32.75273], [-116.9854, 32.75274]]]} | Open Access 1 | 4996 | Estrella Park | 29276 | 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 | 6.925 | Estrella Park | 0 | Local Park 2 | 4 | |
5793 | 5793 | 5792 | {"type": "MultiPolygon", "coordinates": [[[[-117.19381, 32.75393], [-117.19314, 32.75468], [-117.19139, 32.75359], [-117.19142, 32.75354], [-117.19096, 32.75325], [-117.19099, 32.75319], [-117.1896, 32.75233], [-117.18989, 32.752], [-117.19175, 32.75315], [-117.19204, 32.75283], [-117.19381, 32.75393]]], [[[-117.19427, 32.7534], [-117.19392, 32.7538], [-117.19353, 32.75356], [-117.19387, 32.75316], [-117.19427, 32.7534]]]]} | Open Access 1 | 45 | Heritage Park | 19842 | 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/Heritage.html | San Diego 4 | 8.454 | Heritage 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 | |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 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 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
6279 | 6279 | 6278 | {"type": "MultiPolygon", "coordinates": [[[[-116.5945, 33.07228], [-116.59436, 33.07252], [-116.59429, 33.0727], [-116.59418, 33.07323], [-116.5941, 33.07322], [-116.59199, 33.07255], [-116.59212, 33.07111], [-116.59258, 33.07138], [-116.59266, 33.07128], [-116.59267, 33.07125], [-116.5945, 33.07228]]], [[[-116.59395, 33.07136], [-116.59383, 33.07151], [-116.59306, 33.07107], [-116.59317, 33.07094], [-116.59335, 33.07099], [-116.59352, 33.071], [-116.59365, 33.07102], [-116.59376, 33.07108], [-116.59385, 33.07115], [-116.5939, 33.07122], [-116.59395, 33.07136]]]]} | Open Access 1 | 1401 | Jess Martin Park | 20404 | 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/JessMartin.html | San Diego 4 | 8.398 | Jess Martin Park | 0 | Local Park 2 | 4 |
6604 | 6604 | 6603 | {"type": "Polygon", "coordinates": [[[-116.53259, 32.82597], [-116.53029, 32.82583], [-116.52923, 32.82339], [-116.52988, 32.82262], [-116.53041, 32.82294], [-116.53063, 32.82271], [-116.5311, 32.82315], [-116.53135, 32.82342], [-116.53176, 32.82398], [-116.53193, 32.82426], [-116.53209, 32.82458], [-116.53231, 32.82509], [-116.53259, 32.82597]]]} | Open Access 1 | 4165 | Pine Valley Park | 23685 | 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/PineValley.html | San Diego 4 | 17.146 | Pine Valley Park | 0 | Local Park 2 | 4 |
6687 | 6687 | 6686 | {"type": "Polygon", "coordinates": [[[-116.92088, 32.85993], [-116.9178, 32.86035], [-116.91751, 32.86037], [-116.91746, 32.86039], [-116.91742, 32.86035], [-116.91622, 32.8598], [-116.91318, 32.85833], [-116.91254, 32.85841], [-116.91224, 32.85676], [-116.91305, 32.85644], [-116.91363, 32.85637], [-116.91375, 32.85656], [-116.91402, 32.85653], [-116.91407, 32.8568], [-116.91465, 32.85672], [-116.91468, 32.85685], [-116.91509, 32.85681], [-116.91526, 32.85677], [-116.91592, 32.85668], [-116.91599, 32.85711], [-116.9161, 32.85721], [-116.91627, 32.85723], [-116.91776, 32.85703], [-116.91824, 32.85695], [-116.9183, 32.8569], [-116.91832, 32.85684], [-116.91826, 32.85653], [-116.91907, 32.85643], [-116.91937, 32.85652], [-116.91959, 32.85772], [-116.92044, 32.8576], [-116.92088, 32.85993]]]} | Open Access 1 | 4881 | Lindo Lake Park | 29244 | 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/LindoLake.html | San Diego 4 | 57.094 | Lindo Lake Park | 0 | Local Park 2 | 4 |
6692 | 6692 | 6691 | {"type": "Polygon", "coordinates": [[[-116.92544, 32.74521], [-116.92529, 32.74527], [-116.92388, 32.74556], [-116.92186, 32.74538], [-116.92193, 32.7451], [-116.92209, 32.74475], [-116.92224, 32.74452], [-116.9224, 32.74436], [-116.92264, 32.74419], [-116.9229, 32.74407], [-116.92313, 32.74401], [-116.92344, 32.74397], [-116.92381, 32.744], [-116.92395, 32.74404], [-116.92412, 32.74409], [-116.92441, 32.74424], [-116.92459, 32.74438], [-116.92544, 32.74521]]]} | Open Access 1 | 4972 | Hilton Head Park | 19997 | 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/HiltonHead.html | San Diego 4 | 9.882 | Hilton Head 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 |
6699 | 6699 | 6698 | {"type": "Polygon", "coordinates": [[[-116.91331, 32.73733], [-116.9132, 32.73762], [-116.91318, 32.73772], [-116.91317, 32.73796], [-116.91319, 32.7381], [-116.91135, 32.7385], [-116.91054, 32.73884], [-116.91055, 32.73722], [-116.91319, 32.73724], [-116.91331, 32.73733]]]} | Open Access 1 | 4984 | Steele Canyon Park | 25819 | 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/SteeleCanyon.html | San Diego 4 | 8.122 | Steele Canyon Park | 0 | Local Park 2 | 4 |
6700 | 6700 | 6699 | {"type": "Polygon", "coordinates": [[[-116.91742, 32.75157], [-116.91715, 32.75181], [-116.9163, 32.75233], [-116.91649, 32.75258], [-116.91616, 32.75277], [-116.91612, 32.75277], [-116.91608, 32.75275], [-116.91571, 32.75227], [-116.9156, 32.75217], [-116.91491, 32.75174], [-116.9151, 32.75147], [-116.91522, 32.75105], [-116.91702, 32.75139], [-116.91725, 32.75147], [-116.91742, 32.75157]]]} | Open Access 1 | 4985 | Cottonwood County Park | 29270 | 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/Cottonwood.html | San Diego 4 | 5.47 | Cottonwood County Park | 0 | Local Park 2 | 4 |
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-116.94512, 32.75532], [-116.94511, 32.75706], [-116.94501, 32.75707], [-116.94501, 32.75859], [-116.94202, 32.75855], [-116.94197, 32.75818], [-116.94278, 32.7581], [-116.94286, 32.75813], [-116.94295, 32.75812], [-116.94301, 32.75808], [-116.94303, 32.75805], [-116.94303, 32.758], [-116.94301, 32.75794], [-116.94294, 32.75789], [-116.94297, 32.75783], [-116.94254, 32.75687], [-116.94212, 32.75672], [-116.94171, 32.75665], [-116.94122, 32.7557], [-116.94096, 32.75447], [-116.94109, 32.75444], [-116.94116, 32.75429], [-116.94127, 32.75428], [-116.94133, 32.75425], [-116.94136, 32.7542], [-116.94165, 32.75423], [-116.94281, 32.75501], [-116.94287, 32.75503], [-116.94512, 32.75532]]]} | Open Access 1 | 5000 | Damon Lane Park | 17902 | 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/DamonLane.html | San Diego 4 | 29.5 | Damon Lane Park | 0 | Local Park 2 | 4 |
6705 | 6705 | 6704 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00109, 32.76047], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | 5007 | Eucalyptus Park | 18739 | 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/Eucalyptus.html | San Diego 4 | 6.737 | Eucalyptus Park | 0 | Local Park 2 | 4 |
6707 | 6707 | 6706 | {"type": "Polygon", "coordinates": [[[-116.91296, 32.75687], [-116.91276, 32.75701], [-116.91261, 32.75719], [-116.91188, 32.75864], [-116.91182, 32.75873], [-116.9117, 32.75885], [-116.91165, 32.7589], [-116.91152, 32.75896], [-116.9113, 32.75902], [-116.91117, 32.75904], [-116.91059, 32.75906], [-116.91052, 32.75901], [-116.91047, 32.75878], [-116.91034, 32.75853], [-116.91033, 32.75848], [-116.91058, 32.75828], [-116.91181, 32.75682], [-116.91193, 32.7567], [-116.91216, 32.75651], [-116.91231, 32.75641], [-116.91258, 32.75627], [-116.91296, 32.75687]]]} | Open Access 1 | 5011 | Woodhaven Park | 27713 | 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/Woodhaven.html | San Diego 4 | 8.241 | Woodhaven 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]);