units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 3, COUNTY = 26 and MNG_AGENCY = 524

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

DES_TP 5

MNG_AG_TYP 1

MNG_AGENCY 1

  • Vallejo, City of · 5 ✖

ACCESS_TYP 1

  • No Public Access · 5 ✖
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
6218 6218 6217 {"type": "Polygon", "coordinates": [[[-122.22564, 38.15293], [-122.22516, 38.15364], [-122.22485, 38.15405], [-122.22462, 38.15394], [-122.22416, 38.15388], [-122.22394, 38.15359], [-122.2239, 38.15324], [-122.22435, 38.15302], [-122.22465, 38.15275], [-122.22491, 38.15266], [-122.22559, 38.15271], [-122.22564, 38.15293]]]} No Public Access 3 1275 Summit Reservoir 25968 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 3.617 Summit Reservoir 0 Local Recreation Area 3 4
9676 9676 9675 {"type": "Polygon", "coordinates": [[[-122.19255, 38.29554], [-122.19255, 38.29564], [-122.19104, 38.2956], [-122.19096, 38.29567], [-122.19099, 38.29593], [-122.19087, 38.29605], [-122.19071, 38.29609], [-122.19073, 38.29628], [-122.19076, 38.29637], [-122.19081, 38.29641], [-122.19091, 38.29658], [-122.19096, 38.2967], [-122.19101, 38.29691], [-122.19099, 38.2971], [-122.19094, 38.29711], [-122.19055, 38.2969], [-122.1903, 38.29687], [-122.19006, 38.29702], [-122.18984, 38.29702], [-122.18977, 38.29714], [-122.18971, 38.29735], [-122.18961, 38.29751], [-122.18938, 38.29755], [-122.1893, 38.29748], [-122.18904, 38.29688], [-122.18901, 38.29648], [-122.18903, 38.29625], [-122.18912, 38.29602], [-122.1893, 38.2958], [-122.18933, 38.29555], [-122.1893, 38.29542], [-122.18934, 38.29521], [-122.18948, 38.29491], [-122.18929, 38.29469], [-122.18907, 38.2945], [-122.18888, 38.29431], [-122.18864, 38.29413], [-122.18847, 38.29387], [-122.18849, 38.29365], [-122.18872, 38.29353], [-122.18872, 38.29346], [-122.1887, 38.29338], [-122.18863, 38.2933], [-122.18853, 38.29308], [-122.18853, 38.29294], [-122.18849, 38.29274], [-122.18821, 38.29253], [-122.18811, 38.29231], [-122.18803, 38.29218], [-122.18796, 38.29208], [-122.18787, 38.292], [-122.18782, 38.29186], [-122.18748, 38.29129], [-122.18714, 38.291], [-122.18685, 38.29066], [-122.18678, 38.29053], [-122.1867, 38.29021], [-122.18658, 38.29004], [-122.18648, 38.28997], [-122.18641, 38.28989], [-122.18645, 38.28981], [-122.18655, 38.28976], [-122.18705, 38.28964], [-122.18752, 38.28944], [-122.18768, 38.28946], [-122.1878, 38.28947], [-122.18809, 38.28932], [-122.18818, 38.2892], [-122.18818, 38.28883], [-122.18812, 38.28842], [-122.18804, 38.2883], [-122.188, 38.28816], [-122.18807, 38.28803], [-122.18825, 38.28789], [-122.18833, 38.28793], [-122.18837, 38.28803], [-122.18849, 38.28815], [-122.18881, 38.28836], [-122.18891, 38.28859], [-122.18896, 38.2889], [-122.18908, 38.28918], [-122.18916, 38.28937], [-122.18925, 38.28941], [-122.18932, 38.2895], [-122.18937, 38.28963], [-122.18949, 38.28972], [-122.18966, 38.28974], [-122.18976, 38.28973], [-122.1898, 38.28974], [-122.18985, 38.28979], [-122.18993, 38.29004], [-122.19002, 38.29014], [-122.19039, 38.29045], [-122.19046, 38.29056], [-122.19058, 38.29091], [-122.19071, 38.29101], [-122.19077, 38.29098], [-122.19089, 38.29107], [-122.19089, 38.29128], [-122.19105, 38.29154], [-122.19119, 38.2918], [-122.19131, 38.29193], [-122.19126, 38.2921], [-122.19112, 38.29228], [-122.19104, 38.29246], [-122.19092, 38.29262], [-122.1909, 38.29274], [-122.19094, 38.29299], [-122.19107, 38.29329], [-122.19114, 38.29353], [-122.19093, 38.29384], [-122.19096, 38.29416], [-122.19109, 38.29435], [-122.19133, 38.29438], [-122.1914, 38.29445], [-122.19144, 38.29453], [-122.19142, 38.29462], [-122.19128, 38.29475], [-122.19128, 38.29483], [-122.19134, 38.29495], [-122.19155, 38.29515], [-122.19169, 38.29521], [-122.19208, 38.29529], [-122.19221, 38.29528], [-122.19236, 38.29531], [-122.19248, 38.29542], [-122.19255, 38.29554]]]} No Public Access 3 16321 Lake Frey 20892 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 51.566 Lake Frey 0 None 829  
9677 9677 9676 {"type": "Polygon", "coordinates": [[[-122.19813, 38.30518], [-122.19811, 38.30572], [-122.19746, 38.30695], [-122.19709, 38.30803], [-122.19629, 38.30861], [-122.19561, 38.30937], [-122.19533, 38.31033], [-122.19566, 38.3109], [-122.1948, 38.3118], [-122.19463, 38.31263], [-122.19472, 38.31293], [-122.19525, 38.31315], [-122.19566, 38.31317], [-122.19627, 38.31316], [-122.19668, 38.3129], [-122.19688, 38.3129], [-122.1966, 38.31346], [-122.1966, 38.31374], [-122.19682, 38.31398], [-122.1972, 38.3145], [-122.19717, 38.31471], [-122.19693, 38.31471], [-122.19675, 38.3146], [-122.19652, 38.31422], [-122.19619, 38.31412], [-122.19578, 38.31424], [-122.1956, 38.31404], [-122.19513, 38.31383], [-122.19461, 38.31393], [-122.19445, 38.31407], [-122.19414, 38.31428], [-122.19359, 38.31458], [-122.19269, 38.31501], [-122.19303, 38.31447], [-122.19326, 38.31396], [-122.19336, 38.31344], [-122.19309, 38.31321], [-122.19269, 38.31296], [-122.19231, 38.31283], [-122.19215, 38.31267], [-122.19211, 38.3124], [-122.19187, 38.31187], [-122.1914, 38.31131], [-122.19127, 38.31103], [-122.1914, 38.31078], [-122.19168, 38.31061], [-122.19199, 38.3105], [-122.19197, 38.31027], [-122.19184, 38.31022], [-122.19177, 38.31007], [-122.19186, 38.31], [-122.19236, 38.31018], [-122.19278, 38.31036], [-122.1931, 38.31035], [-122.19321, 38.31018], [-122.19304, 38.3098], [-122.19232, 38.3091], [-122.19248, 38.30887], [-122.19247, 38.30854], [-122.19331, 38.30796], [-122.19392, 38.30748], [-122.19467, 38.30713], [-122.19537, 38.30627], [-122.19554, 38.30593], [-122.19592, 38.30586], [-122.19655, 38.30547], [-122.19708, 38.30535], [-122.1975, 38.30511], [-122.19785, 38.30474], [-122.19813, 38.30518]]]} No Public Access 3 16333 Lake Madigan 20951 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 66.97 Lake Madigan   None 830  
9683 9683 9682 {"type": "Polygon", "coordinates": [[[-122.20614, 38.31457], [-122.20607, 38.3157], [-122.1894, 38.31588], [-122.18952, 38.3136], [-122.1897, 38.30526], [-122.18507, 38.30526], [-122.18515, 38.29837], [-122.18065, 38.29829], [-122.18076, 38.28784], [-122.18075, 38.28783], [-122.18022, 38.28841], [-122.1764, 38.27648], [-122.17639, 38.27648], [-122.17466, 38.27733], [-122.17228, 38.27276], [-122.17131, 38.2713], [-122.17033, 38.2697], [-122.1693, 38.26822], [-122.16818, 38.26618], [-122.17132, 38.26615], [-122.17405, 38.2673], [-122.17621, 38.26806], [-122.17787, 38.26825], [-122.18125, 38.25243], [-122.19329, 38.25234], [-122.19314, 38.25272], [-122.19297, 38.25544], [-122.19237, 38.25612], [-122.19237, 38.25613], [-122.19566, 38.2584], [-122.2031, 38.25944], [-122.19399, 38.2709], [-122.19304, 38.27115], [-122.18835, 38.2714], [-122.19035, 38.27574], [-122.19019, 38.2872], [-122.19947, 38.28716], [-122.19952, 38.28719], [-122.19951, 38.2872], [-122.19954, 38.28728], [-122.1995, 38.28756], [-122.19954, 38.28779], [-122.19969, 38.28801], [-122.19987, 38.28812], [-122.20004, 38.28827], [-122.20021, 38.28859], [-122.20032, 38.28872], [-122.20046, 38.28883], [-122.20082, 38.28903], [-122.20122, 38.28939], [-122.20133, 38.28951], [-122.20136, 38.28966], [-122.20138, 38.28991], [-122.20139, 38.2905], [-122.19943, 38.29049], [-122.19965, 38.2982], [-122.18994, 38.29826], [-122.18979, 38.3017], [-122.1898, 38.30171], [-122.19097, 38.3017], [-122.19902, 38.30174], [-122.20022, 38.30208], [-122.20051, 38.30238], [-122.20065, 38.30285], [-122.20072, 38.30294], [-122.20245, 38.30413], [-122.20259, 38.3051], [-122.20185, 38.30668], [-122.20117, 38.30779], [-122.20115, 38.30785], [-122.20116, 38.30817], [-122.20129, 38.30858], [-122.2015, 38.30881], [-122.20164, 38.309], [-122.2019, 38.30924], [-122.2025, 38.30949], [-122.2027, 38.30951], [-122.20289, 38.3096], [-122.20312, 38.30968], [-122.20338, 38.30972], [-122.2036, 38.30986], [-122.204, 38.3102], [-122.20454, 38.31106], [-122.20499, 38.31274], [-122.20614, 38.31457]], [[-122.1976, 38.305], [-122.1975, 38.30511], [-122.19707, 38.30535], [-122.19655, 38.30547], [-122.19592, 38.30586], [-122.19554, 38.30593], [-122.19537, 38.30627], [-122.19467, 38.30713], [-122.19392, 38.30748], [-122.19331, 38.30796], [-122.19247, 38.30854], [-122.19248, 38.30887], [-122.19233, 38.3091], [-122.19304, 38.3098], [-122.19321, 38.31017], [-122.1931, 38.31035], [-122.19278, 38.31036], [-122.19236, 38.31018], [-122.19186, 38.31001], [-122.19178, 38.31008], [-122.19184, 38.31022], [-122.19197, 38.31027], [-122.19199, 38.3105], [-122.19168, 38.31061], [-122.19141, 38.31078], [-122.19127, 38.31103], [-122.1914, 38.31132], [-122.19187, 38.31187], [-122.19211, 38.3124], [-122.19215, 38.31267], [-122.19231, 38.31283], [-122.19269, 38.31296], [-122.19309, 38.31321], [-122.19336, 38.31344], [-122.19326, 38.31395], [-122.19303, 38.31447], [-122.19271, 38.31499], [-122.19271, 38.315], [-122.19359, 38.31458], [-122.19414, 38.31428], [-122.19445, 38.31407], [-122.19461, 38.31393], [-122.19513, 38.31383], [-122.1956, 38.31404], [-122.19578, 38.31424], [-122.19619, 38.31412], [-122.19652, 38.31423], [-122.19675, 38.3146], [-122.19693, 38.31471], [-122.19717, 38.3147], [-122.1972, 38.31449], [-122.19682, 38.31398], [-122.1966, 38.31375], [-122.1966, 38.31346], [-122.19687, 38.3129], [-122.19667, 38.3129], [-122.19627, 38.31316], [-122.19566, 38.31317], [-122.19525, 38.31315], [-122.19472, 38.31293], [-122.19463, 38.31263], [-122.1948, 38.3118], [-122.19566, 38.3109], [-122.19533, 38.31033], [-122.19561, 38.30937], [-122.19629, 38.30861], [-122.19709, 38.30803], [-122.19746, 38.30695], [-122.19811, 38.30572], [-122.19813, 38.30518], [-122.19785, 38.30475], [-122.19784, 38.30475], [-122.1976, 38.305]], [[-122.19187, 38.29525], [-122.19169, 38.29521], [-122.19155, 38.29515], [-122.19135, 38.29495], [-122.19128, 38.29482], [-122.19128, 38.29474], [-122.19142, 38.29462], [-122.19144, 38.29453], [-122.1914, 38.29445], [-122.19133, 38.29438], [-122.19109, 38.29435], [-122.19096, 38.29416], [-122.19093, 38.29384], [-122.19114, 38.29353], [-122.19107, 38.29329], [-122.19094, 38.29299], [-122.1909, 38.29274], [-122.19092, 38.29262], [-122.19104, 38.29246], [-122.19112, 38.29228], [-122.19126, 38.2921], [-122.19131, 38.29193], [-122.19119, 38.2918], [-122.19105, 38.29154], [-122.19089, 38.29128], [-122.19089, 38.29107], [-122.19077, 38.29099], [-122.19072, 38.29101], [-122.19058, 38.29091], [-122.19046, 38.29056], [-122.19039, 38.29045], [-122.19002, 38.29014], [-122.18993, 38.29004], [-122.18985, 38.28979], [-122.1898, 38.28974], [-122.18976, 38.28973], [-122.18966, 38.28974], [-122.18949, 38.28972], [-122.18937, 38.28963], [-122.18932, 38.28951], [-122.18925, 38.28941], [-122.18916, 38.28937], [-122.18908, 38.28918], [-122.18896, 38.2889], [-122.18891, 38.28859], [-122.18881, 38.28836], [-122.18849, 38.28815], [-122.18837, 38.28803], [-122.18833, 38.28793], [-122.18824, 38.28789], [-122.18807, 38.28803], [-122.188, 38.28816], [-122.18804, 38.2883], [-122.18812, 38.28842], [-122.18818, 38.28883], [-122.18818, 38.2892], [-122.18809, 38.28932], [-122.1878, 38.28947], [-122.18768, 38.28946], [-122.18752, 38.28944], [-122.18705, 38.28964], [-122.18655, 38.28976], [-122.18645, 38.28981], [-122.18641, 38.28989], [-122.18648, 38.28997], [-122.18658, 38.29004], [-122.1867, 38.29021], [-122.18678, 38.29053], [-122.18685, 38.29066], [-122.18714, 38.291], [-122.18748, 38.29129], [-122.18782, 38.29186], [-122.18787, 38.292], [-122.18796, 38.29208], [-122.18803, 38.29218], [-122.18811, 38.29231], [-122.18821, 38.29253], [-122.18849, 38.29274], [-122.18853, 38.29294], [-122.18853, 38.29308], [-122.18863, 38.29329], [-122.1887, 38.29338], [-122.18872, 38.29346], [-122.18872, 38.29353], [-122.18849, 38.29365], [-122.18847, 38.29387], [-122.18864, 38.29413], [-122.18888, 38.29431], [-122.18907, 38.2945], [-122.18929, 38.29469], [-122.18948, 38.29491], [-122.18934, 38.29521], [-122.1893, 38.29542], [-122.18933, 38.29555], [-122.1893, 38.2958], [-122.18912, 38.29602], [-122.18903, 38.29625], [-122.18901, 38.29648], [-122.18904, 38.29688], [-122.1893, 38.29748], [-122.18938, 38.29755], [-122.18961, 38.29751], [-122.18971, 38.29735], [-122.18977, 38.29714], [-122.18984, 38.29702], [-122.19006, 38.29702], [-122.19031, 38.29687], [-122.19055, 38.2969], [-122.19094, 38.29711], [-122.19099, 38.2971], [-122.19101, 38.29691], [-122.19096, 38.2967], [-122.19091, 38.29658], [-122.19081, 38.29641], [-122.19076, 38.29637], [-122.19073, 38.29628], [-122.19071, 38.29609], [-122.19087, 38.29605], [-122.19099, 38.29593], [-122.19096, 38.29567], [-122.19105, 38.2956], [-122.19255, 38.29563], [-122.19255, 38.29554], [-122.19248, 38.29542], [-122.19236, 38.29531], [-122.19221, 38.29528], [-122.19208, 38.29529], [-122.19187, 38.29525]]]} No Public Access 3 16322 Vallejo Lakes 26780 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 2325.531 Vallejo Lakes 0 None 834  
10346 10346 10345 {"type": "Polygon", "coordinates": [[[-122.19567, 38.13207], [-122.19607, 38.1323], [-122.19607, 38.1323], [-122.1969, 38.13267], [-122.19794, 38.13308], [-122.19855, 38.13337], [-122.19901, 38.13361], [-122.19996, 38.1342], [-122.20165, 38.13531], [-122.20208, 38.13557], [-122.20272, 38.13596], [-122.20326, 38.13619], [-122.20352, 38.13629], [-122.20489, 38.13665], [-122.20612, 38.13692], [-122.20724, 38.13706], [-122.20547, 38.13799], [-122.20543, 38.13823], [-122.20762, 38.13847], [-122.20991, 38.13874], [-122.20972, 38.13981], [-122.20973, 38.13982], [-122.21088, 38.13993], [-122.21174, 38.14005], [-122.21298, 38.14019], [-122.2131, 38.13937], [-122.21532, 38.13962], [-122.21525, 38.14005], [-122.21545, 38.1406], [-122.21382, 38.14057], [-122.21368, 38.14204], [-122.21291, 38.14191], [-122.21264, 38.14192], [-122.21255, 38.14225], [-122.21271, 38.14272], [-122.2134, 38.14303], [-122.21288, 38.14606], [-122.20837, 38.14896], [-122.20599, 38.14589], [-122.19995, 38.14373], [-122.19935, 38.14304], [-122.19853, 38.14245], [-122.19668, 38.14098], [-122.19475, 38.13958], [-122.19412, 38.13869], [-122.19448, 38.13723], [-122.19423, 38.13573], [-122.19408, 38.13498], [-122.19238, 38.13177], [-122.19208, 38.13161], [-122.19179, 38.13148], [-122.19139, 38.13124], [-122.19095, 38.13094], [-122.19068, 38.13063], [-122.19033, 38.13018], [-122.18977, 38.1297], [-122.18938, 38.12931], [-122.18901, 38.1289], [-122.18861, 38.12857], [-122.18982, 38.12792], [-122.19073, 38.12752], [-122.19077, 38.12764], [-122.19086, 38.12773], [-122.19143, 38.12808], [-122.19189, 38.12829], [-122.192, 38.12829], [-122.19217, 38.12822], [-122.19363, 38.13011], [-122.19405, 38.13058], [-122.19453, 38.13106], [-122.19501, 38.13153], [-122.19554, 38.132], [-122.19567, 38.13207]]]} No Public Access 3 18255 Northgate 22870 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 435.488 Northgate 1999 None 905  

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