units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1,190 rows where DES_TP = 14

View and edit SQL

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, YR_EST

DES_TP

  • Local Other or Unknown · 1,190
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
108 107 {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} Unknown Access 4 295 San Antonio Creek 24829 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 1.291 San Antonio Creek 0 Local Other or Unknown 14 4
133 132 {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} Unknown Access 4 414 San Roque Creek 24990 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 0.477 San Roque Creek 0 Local Other or Unknown 14 4
185 184 {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} Unknown Access 4 592 Santa Monica Creek 25117 1047 Carpinteria, City of 72 City 2 City Agency 2 http://www.carpinteria.ca.us/parks_rec/index.shtml City 2 1047 Carpinteria, City of 70 City 2 City Agency 2   Santa Barbara 7 0.489 Santa Monica Creek 0 Local Other or Unknown 14 4
208 207 {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} No Public Access 3 654 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 16.798 Reidy Canyon Creek 0 Local Other or Unknown 14 4
235 234 {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} No Public Access 3 684 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 4.055 Reidy Canyon Creek 0 Local Other or Unknown 14 4
236 235 {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} No Public Access 3 687 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 2.732 Reidy Canyon Creek 0 Local Other or Unknown 14 4
251 250 {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} No Public Access 3 683 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 0.966 Reidy Canyon Creek 0 Local Other or Unknown 14 4
275 274 {"type": "Polygon", "coordinates": [[[-119.19704, 34.28676], [-119.1969, 34.28706], [-119.19612, 34.28715], [-119.19612, 34.28713], [-119.19635, 34.28707], [-119.19658, 34.28696], [-119.19673, 34.28683], [-119.19685, 34.28668], [-119.19704, 34.28676]]]} Open Access 1 35439 Ventura holding 73 26955 1366 Ventura, City of 113 City 2 City Agency 2 http://www.cityofventura.net/prcp City 2 1366 Ventura, City of 110 City 2 City Agency 2   Ventura 8 0.367 Ventura holding 73 0 Local Other or Unknown 14 4
276 275 {"type": "Polygon", "coordinates": [[[-119.17054, 34.28047], [-119.17066, 34.2806], [-119.17066, 34.28063], [-119.17064, 34.28066], [-119.16734, 34.28261], [-119.16727, 34.2826], [-119.16717, 34.28249], [-119.16745, 34.28232], [-119.16748, 34.28234], [-119.16892, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047]]]} Open Access 1 35440 Ventura holding 72 26954 1366 Ventura, City of 113 City 2 City Agency 2 http://www.cityofventura.net/prcp City 2 1366 Ventura, City of 110 City 2 City Agency 2   Ventura 8 1.844 Ventura holding 72 0 Local Other or Unknown 14 4
364 363 {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} Unknown Access 4 1276 Sycamore Creek 26121 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.446 Sycamore Creek 0 Local Other or Unknown 14 4
392 391 {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} Open Access 1 35760 Orange holding 14 23161 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 0.99 Orange holding 14 0 Local Other or Unknown 14 4
393 392 {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} Open Access 1 35761 Orange holding 15 23162 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 1.023 Orange holding 15 0 Local Other or Unknown 14 4
472 471 {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} Open Access 1 35762 Los Angeles holding 8 21495 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.024 Los Angeles holding 8 0 Local Other or Unknown 14 4
740 739 {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} Open Access 1 5519 Diamond Hights Lot3 18142 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1300 San Francisco, City and County of 21 City 2 City Agency 2   San Francisco 13 2.023 Diamond Hights Lot3 0 Local Other or Unknown 14 4
884 883 {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} Open Access 1 35936 Lake holding 49 20938 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 0.292 Lake holding 49 0 Local Other or Unknown 14 4
927 926 {"type": "Polygon", "coordinates": [[[-122.84377, 39.00039], [-122.84353, 39.00038], [-122.84353, 38.99972], [-122.84377, 38.99973], [-122.84377, 39.00039]]]} Open Access 1 35937 Lake holding 33 20921 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 0.38 Lake holding 33 0 Local Other or Unknown 14 4
928 927 {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59848, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} Open Access 1 6426 Topanga Creek 26407 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 1.477 Topanga Creek 0 Local Other or Unknown 14 4
1046 1045 {"type": "Polygon", "coordinates": [[[-118.34139, 34.12342], [-118.34119, 34.12342], [-118.34101, 34.12338], [-118.34082, 34.12338], [-118.34041, 34.12313], [-118.34051, 34.12301], [-118.34068, 34.12311], [-118.34077, 34.12313], [-118.34087, 34.12313], [-118.341, 34.12307], [-118.34139, 34.12342]]]} Open Access 1 6900 Unnamed site - Mountains Recreation and Conservation Authority 29458 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.464   0 Local Other or Unknown 14 4
1066 1065 {"type": "Polygon", "coordinates": [[[-118.16257, 34.20755], [-118.16261, 34.2077], [-118.16261, 34.20779], [-118.16252, 34.20798], [-118.16232, 34.20798], [-118.16232, 34.20756], [-118.16257, 34.20755]]]} Open Access 1 6963 Unnamed site - Mountains Recreation and Conservation Authority 29458 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.283   0 Local Other or Unknown 14 4
1149 1148 {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} Restricted Access 2 6734 Hillcrest And Ocean View Lots 19962 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 321 San Francisco - Public Utilities Commission, City and County of 30 County 3 County Agency - Other 8   San Mateo 15 0.08 Hillcrest And Ocean View Lots 0 Local Other or Unknown 14 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 473.815ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette