units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 2, MNG_AGENCY = 465 and SUID_NMA = 11898

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

MNG_AGENCY 1

  • Santa Clara County Parks and Recreation Dept., County of · 1 ✖

ACCESS_TYP 1

  • Open Access · 1 ✖
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
9487 9487 9486 {"type": "MultiPolygon", "coordinates": [[[[-121.8622, 37.44432], [-121.86079, 37.44468], [-121.85883, 37.44487], [-121.85867, 37.44492], [-121.85846, 37.44504], [-121.85834, 37.44514], [-121.85827, 37.44528], [-121.85807, 37.4451], [-121.8577, 37.44492], [-121.85754, 37.44481], [-121.85704, 37.44461], [-121.85665, 37.44452], [-121.85578, 37.44424], [-121.85534, 37.44413], [-121.85481, 37.44395], [-121.85462, 37.44383], [-121.85429, 37.44369], [-121.85413, 37.44366], [-121.85373, 37.44364], [-121.85312, 37.44348], [-121.85291, 37.44345], [-121.85256, 37.44337], [-121.85212, 37.44334], [-121.85203, 37.4433], [-121.85193, 37.44318], [-121.85175, 37.44306], [-121.85144, 37.44292], [-121.85123, 37.44279], [-121.85103, 37.44285], [-121.85132, 37.44301], [-121.85165, 37.44316], [-121.85181, 37.44326], [-121.85194, 37.44341], [-121.85203, 37.44345], [-121.85213, 37.44348], [-121.85251, 37.4435], [-121.85307, 37.4436], [-121.85375, 37.44378], [-121.85411, 37.44379], [-121.85425, 37.44382], [-121.85454, 37.44395], [-121.85479, 37.44408], [-121.85528, 37.44425], [-121.85563, 37.44434], [-121.8565, 37.44462], [-121.85696, 37.44472], [-121.85741, 37.44489], [-121.85761, 37.44502], [-121.85797, 37.44521], [-121.85809, 37.4453], [-121.85819, 37.44542], [-121.85811, 37.44555], [-121.85801, 37.44567], [-121.85781, 37.44584], [-121.85766, 37.44589], [-121.85755, 37.4459], [-121.85744, 37.44589], [-121.85704, 37.44577], [-121.85681, 37.44574], [-121.85574, 37.44587], [-121.85485, 37.44604], [-121.85382, 37.44644], [-121.8531, 37.44667], [-121.85279, 37.44672], [-121.85207, 37.44675], [-121.8517, 37.44682], [-121.85147, 37.4469], [-121.8473, 37.44856], [-121.84709, 37.44862], [-121.84688, 37.44861], [-121.84668, 37.44855], [-121.84577, 37.44795], [-121.84562, 37.44787], [-121.84509, 37.4477], [-121.84495, 37.44763], [-121.84483, 37.44755], [-121.84383, 37.44667], [-121.84382, 37.44629], [-121.84488, 37.44572], [-121.84529, 37.44616], [-121.84977, 37.44357], [-121.85083, 37.443], [-121.85082, 37.44299], [-121.8506, 37.44304], [-121.85046, 37.44296], [-121.8489, 37.44087], [-121.85167, 37.4402], [-121.85699, 37.44096], [-121.8622, 37.44432]]], [[[-121.879, 37.47266], [-121.87698, 37.47472], [-121.87706, 37.47483], [-121.87714, 37.47517], [-121.87595, 37.47584], [-121.87489, 37.47665], [-121.87279, 37.47895], [-121.87121, 37.47991], [-121.87032, 37.48097], [-121.87029, 37.48192], [-121.87008, 37.48213], [-121.86586, 37.48473], [-121.8607, 37.48469], [-121.86083, 37.48075], [-121.86265, 37.48072], [-121.86255, 37.47893], [-121.86213, 37.47676], [-121.85634, 37.47677], [-121.85627, 37.47283], [-121.85774, 37.47277], [-121.86055, 37.47209], [-121.86097, 37.47085], [-121.86108, 37.47005], [-121.86191, 37.4677], [-121.86013, 37.46629], [-121.86037, 37.4658], [-121.86114, 37.46551], [-121.86177, 37.46518], [-121.85991, 37.46346], [-121.85946, 37.46308], [-121.85805, 37.46255], [-121.85543, 37.46171], [-121.85531, 37.46128], [-121.85507, 37.46076], [-121.85452, 37.45979], [-121.85428, 37.45924], [-121.85903, 37.45722], [-121.8566, 37.45623], [-121.8538, 37.45684], [-121.85248, 37.4551], [-121.85288, 37.45491], [-121.85264, 37.45447], [-121.85154, 37.45306], [-121.85163, 37.45229], [-121.85057, 37.4522], [-121.84979, 37.45222], [-121.84887, 37.45144], [-121.84867, 37.45091], [-121.84828, 37.45036], [-121.84667, 37.4507], [-121.84396, 37.44695], [-121.84473, 37.44762], [-121.84487, 37.44772], [-121.84503, 37.4478], [-121.84556, 37.44797], [-121.84569, 37.44803], [-121.84653, 37.4486], [-121.84666, 37.44867], [-121.8468, 37.44871], [-121.84695, 37.44873], [-121.84719, 37.44871], [-121.84731, 37.44868], [-121.84801, 37.4484], [-121.8487, 37.44935], [-121.85031, 37.44873], [-121.85029, 37.44853], [-121.84977, 37.4477], [-121.85154, 37.447], [-121.85175, 37.44693], [-121.85209, 37.44687], [-121.8528, 37.44683], [-121.85307, 37.44679], [-121.85387, 37.44655], [-121.85471, 37.44621], [-121.855, 37.44612], [-121.85577, 37.44597], [-121.85674, 37.44585], [-121.85688, 37.44585], [-121.857, 37.44588], [-121.85739, 37.446], [-121.85763, 37.44601], [-121.85776, 37.4468], [-121.85824, 37.44809], [-121.85892, 37.44851], [-121.85981, 37.4491], [-121.86001, 37.44929], [-121.86017, 37.44949], [-121.86041, 37.45014], [-121.86051, 37.45008], [-121.86075, 37.45015], [-121.8613, 37.45017], [-121.86321, 37.44981], [-121.86396, 37.44981], [-121.86463, 37.4499], [-121.86502, 37.44989], [-121.86584, 37.44968], [-121.86613, 37.44949], [-121.8667, 37.45073], [-121.86367, 37.45168], [-121.86366, 37.45169], [-121.86657, 37.45404], [-121.87544, 37.46159], [-121.87751, 37.4639], [-121.87614, 37.46401], [-121.87511, 37.46441], [-121.87625, 37.46579], [-121.87607, 37.46607], [-121.87552, 37.46656], [-121.87552, 37.46658], [-121.87557, 37.46658], [-121.87548, 37.46688], [-121.87507, 37.46739], [-121.87493, 37.46763], [-121.87476, 37.46778], [-121.87449, 37.46824], [-121.87423, 37.46846], [-121.87362, 37.46869], [-121.87322, 37.46881], [-121.87478, 37.47015], [-121.87606, 37.47083], [-121.87781, 37.47162], [-121.87805, 37.47175], [-121.87856, 37.47219], [-121.879, 37.47266]]], [[[-121.86377, 37.44976], [-121.86319, 37.44975], [-121.86129, 37.45012], [-121.86076, 37.4501], [-121.8605, 37.45002], [-121.8603, 37.44945], [-121.86013, 37.44922], [-121.8599, 37.44902], [-121.85901, 37.44842], [-121.85836, 37.44802], [-121.85789, 37.44677], [-121.85776, 37.44598], [-121.8579, 37.44591], [-121.85811, 37.44575], [-121.85825, 37.44559], [-121.85846, 37.4452], [-121.85861, 37.44508], [-121.85874, 37.44502], [-121.85894, 37.44497], [-121.86081, 37.44478], [-121.86232, 37.4444], [-121.86304, 37.44708], [-121.86184, 37.44736], [-121.86183, 37.44738], [-121.86377, 37.44976]]]]} Open Access 1 15882 Edward R. Levin Park 11898 326 Santa Clara County Parks and Recreation Dept., County of 472 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx County 3 326 Santa Clara County Parks and Recreation Dept., County of 465 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/parkfinder/Pages/Ed-Levin.aspx Santa Clara 19 1555.167 Edward R. Levin Park 1964 Local Park 2 4

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]);