units_with_maps

Table actions

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

4 rows where DES_TP = 3, MNG_AGENCY = 344 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 4 ✖

MNG_AGENCY 1

  • Benicia, City of · 4 ✖

DES_TP 1

  • Local Recreation Area · 4 ✖

ACCESS_TYP 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
4947 4947 4946 {"type": "Polygon", "coordinates": [[[-122.16884, 38.07871], [-122.16854, 38.07916], [-122.1682, 38.07936], [-122.16783, 38.07951], [-122.16755, 38.07969], [-122.16756, 38.08011], [-122.16751, 38.08034], [-122.16729, 38.08055], [-122.16721, 38.08092], [-122.1669, 38.081], [-122.16654, 38.08118], [-122.16654, 38.08149], [-122.16666, 38.08169], [-122.16696, 38.08185], [-122.16793, 38.082], [-122.16805, 38.08215], [-122.1671, 38.08249], [-122.16632, 38.08239], [-122.16569, 38.08243], [-122.16459, 38.0827], [-122.16413, 38.08274], [-122.16375, 38.08249], [-122.16313, 38.08232], [-122.16256, 38.08227], [-122.16194, 38.08265], [-122.1615, 38.08322], [-122.16133, 38.08356], [-122.1602, 38.08327], [-122.15965, 38.08302], [-122.15923, 38.08311], [-122.15905, 38.08335], [-122.15909, 38.08365], [-122.15944, 38.0839], [-122.16023, 38.08416], [-122.16091, 38.08435], [-122.16162, 38.08442], [-122.16132, 38.08447], [-122.16036, 38.08443], [-122.15955, 38.0843], [-122.1591, 38.08407], [-122.15879, 38.08377], [-122.15838, 38.08295], [-122.15771, 38.08145], [-122.15953, 38.08104], [-122.15989, 38.0808], [-122.15998, 38.08036], [-122.15973, 38.08008], [-122.1594, 38.08002], [-122.15843, 38.08023], [-122.15773, 38.08039], [-122.15737, 38.08059], [-122.15697, 38.08023], [-122.1573, 38.07991], [-122.15721, 38.07952], [-122.1572, 38.07937], [-122.15636, 38.07899], [-122.15572, 38.07886], [-122.15521, 38.07879], [-122.15431, 38.07806], [-122.15439, 38.07758], [-122.15475, 38.07713], [-122.15529, 38.07692], [-122.1555, 38.07735], [-122.15737, 38.07771], [-122.15789, 38.07798], [-122.15838, 38.078], [-122.15877, 38.07787], [-122.15881, 38.07735], [-122.15841, 38.07702], [-122.1578, 38.07674], [-122.15658, 38.07661], [-122.15619, 38.07631], [-122.15681, 38.07606], [-122.15729, 38.07595], [-122.15868, 38.07592], [-122.16034, 38.07582], [-122.16222, 38.07559], [-122.16301, 38.07601], [-122.16423, 38.07647], [-122.16455, 38.07673], [-122.16487, 38.07694], [-122.16538, 38.07704], [-122.16529, 38.07722], [-122.16541, 38.0776], [-122.16625, 38.07763], [-122.16653, 38.07753], [-122.16675, 38.07768], [-122.1684, 38.07835], [-122.16851, 38.07845], [-122.1688, 38.07852], [-122.16884, 38.07871]]]} Open Access 1 1683 Tourtelot Open Space 26481 1027 Benicia, City of 347 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1027 Benicia, City of 344 City 2 City Agency 2   Solano 26 160.466 Tourtelot OS 0 Local Recreation Area 3 4
9116 9116 9115 {"type": "Polygon", "coordinates": [[[-122.15372, 38.04874], [-122.15327, 38.04939], [-122.15218, 38.04892], [-122.15261, 38.04822], [-122.15372, 38.04874]]]} Open Access 1 15108 Little League Field Park 21345 1027 Benicia, City of 347 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1027 Benicia, City of 344 City 2 City Agency 2   Solano 26 2.318 Little League Field Park 0 Local Recreation Area 3 4
16015 16015 16014 {"type": "MultiPolygon", "coordinates": [[[[-122.18915, 38.08111], [-122.18816, 38.08142], [-122.1876, 38.08186], [-122.18707, 38.08256], [-122.18641, 38.08251], [-122.1861, 38.08224], [-122.18578, 38.08227], [-122.18525, 38.08227], [-122.18498, 38.08245], [-122.18491, 38.08277], [-122.18515, 38.08286], [-122.18559, 38.08313], [-122.18531, 38.08345], [-122.18483, 38.08442], [-122.18478, 38.0848], [-122.1846, 38.08522], [-122.18437, 38.08554], [-122.18417, 38.08592], [-122.18386, 38.08611], [-122.18338, 38.08619], [-122.18322, 38.08634], [-122.18326, 38.08673], [-122.18348, 38.087], [-122.18394, 38.08727], [-122.18403, 38.08742], [-122.18363, 38.08795], [-122.18298, 38.08819], [-122.18236, 38.08866], [-122.18132, 38.08925], [-122.18064, 38.0893], [-122.18013, 38.08825], [-122.1792, 38.08617], [-122.17659, 38.07977], [-122.17735, 38.0795], [-122.17753, 38.07921], [-122.17752, 38.07896], [-122.17727, 38.0787], [-122.17747, 38.07845], [-122.17795, 38.07806], [-122.17832, 38.07825], [-122.17973, 38.07916], [-122.17993, 38.07978], [-122.18045, 38.08027], [-122.18114, 38.08053], [-122.18193, 38.08063], [-122.1826, 38.08075], [-122.18322, 38.08108], [-122.18372, 38.08066], [-122.18441, 38.08059], [-122.18483, 38.08024], [-122.18455, 38.0798], [-122.18388, 38.07958], [-122.18252, 38.07975], [-122.18118, 38.07959], [-122.18099, 38.07933], [-122.1813, 38.07936], [-122.18182, 38.07936], [-122.18226, 38.07933], [-122.18284, 38.07934], [-122.18345, 38.07933], [-122.18358, 38.07912], [-122.18476, 38.07946], [-122.1859, 38.07942], [-122.1873, 38.07874], [-122.18801, 38.0788], [-122.18853, 38.07914], [-122.1888, 38.07996], [-122.18905, 38.0806], [-122.18915, 38.08111]]], [[[-122.18868, 38.07605], [-122.18835, 38.0769], [-122.18748, 38.07752], [-122.18798, 38.07842], [-122.187, 38.07861], [-122.18632, 38.07899], [-122.18576, 38.0792], [-122.18505, 38.07926], [-122.18436, 38.07915], [-122.18442, 38.07899], [-122.18503, 38.07903], [-122.18529, 38.07876], [-122.18529, 38.07832], [-122.18486, 38.07801], [-122.18498, 38.07727], [-122.18522, 38.07681], [-122.18497, 38.07637], [-122.18415, 38.076], [-122.18356, 38.07545], [-122.18302, 38.07514], [-122.183, 38.07434], [-122.18248, 38.07396], [-122.18199, 38.07394], [-122.18166, 38.07403], [-122.18159, 38.07436], [-122.18161, 38.07488], [-122.18113, 38.07504], [-122.18088, 38.07517], [-122.18063, 38.07481], [-122.18071, 38.07442], [-122.1809, 38.07441], [-122.18101, 38.07425], [-122.18086, 38.074], [-122.18088, 38.07323], [-122.18102, 38.073], [-122.1809, 38.07262], [-122.18191, 38.07227], [-122.18349, 38.07287], [-122.18434, 38.07286], [-122.18486, 38.07238], [-122.18484, 38.07182], [-122.18531, 38.0716], [-122.18757, 38.07463], [-122.18868, 38.07605]]]]} Open Access 1 2138 Braito Open Space 540 1027 Benicia, City of 347 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1027 Benicia, City of 344 City 2 City Agency 2   Solano 26 226.873 Braito OS 0 Local Recreation Area 3 4
16817 16817 16816 {"type": "Polygon", "coordinates": [[[-122.17156, 38.09068], [-122.16649, 38.10078], [-122.16562, 38.10052], [-122.16535, 38.10047], [-122.16508, 38.10045], [-122.16489, 38.10046], [-122.16467, 38.10048], [-122.1643, 38.10055], [-122.16331, 38.101], [-122.16302, 38.1011], [-122.16279, 38.10116], [-122.16249, 38.10118], [-122.16231, 38.10117], [-122.16209, 38.10112], [-122.16174, 38.10098], [-122.1613, 38.1007], [-122.15939, 38.09942], [-122.15913, 38.09926], [-122.15853, 38.09897], [-122.15787, 38.09874], [-122.15754, 38.09866], [-122.15706, 38.09857], [-122.15675, 38.09854], [-122.1557, 38.09848], [-122.15316, 38.09839], [-122.1528, 38.09836], [-122.15254, 38.09829], [-122.15167, 38.09784], [-122.15103, 38.09757], [-122.15082, 38.09751], [-122.14879, 38.0972], [-122.14715, 38.09659], [-122.14643, 38.09624], [-122.1456, 38.09574], [-122.14421, 38.09498], [-122.14407, 38.09493], [-122.14397, 38.09284], [-122.14199, 38.09147], [-122.14182, 38.09033], [-122.14203, 38.09011], [-122.14324, 38.09017], [-122.14439, 38.09111], [-122.14572, 38.09169], [-122.14613, 38.09103], [-122.14527, 38.09077], [-122.14375, 38.08907], [-122.14378, 38.08884], [-122.14294, 38.08821], [-122.14284, 38.08776], [-122.14308, 38.08765], [-122.14439, 38.08795], [-122.14472, 38.08749], [-122.14515, 38.08679], [-122.14529, 38.08695], [-122.14529, 38.08768], [-122.14516, 38.08792], [-122.14464, 38.08835], [-122.14509, 38.08862], [-122.1456, 38.08878], [-122.14562, 38.08877], [-122.14574, 38.08883], [-122.14629, 38.08901], [-122.14666, 38.08931], [-122.14685, 38.08957], [-122.14699, 38.08971], [-122.14727, 38.08994], [-122.14773, 38.09026], [-122.1482, 38.09007], [-122.14868, 38.08944], [-122.14865, 38.08919], [-122.14889, 38.08918], [-122.14924, 38.08915], [-122.14951, 38.0891], [-122.15025, 38.08877], [-122.15144, 38.08879], [-122.15215, 38.08861], [-122.15244, 38.08846], [-122.15336, 38.08773], [-122.15393, 38.08736], [-122.15397, 38.08736], [-122.15406, 38.0873], [-122.15428, 38.08721], [-122.15449, 38.0872], [-122.15492, 38.08737], [-122.1554, 38.0876], [-122.15617, 38.08794], [-122.15623, 38.08787], [-122.15636, 38.08795], [-122.15659, 38.0884], [-122.15708, 38.08888], [-122.15769, 38.08893], [-122.15817, 38.08892], [-122.15851, 38.08897], [-122.15902, 38.08918], [-122.15994, 38.08931], [-122.16075, 38.08914], [-122.16113, 38.08875], [-122.16142, 38.08812], [-122.16146, 38.08789], [-122.16126, 38.08762], [-122.1611, 38.0872], [-122.16132, 38.08696], [-122.1619, 38.08644], [-122.17084, 38.09032], [-122.17156, 38.09068]]]} Open Access 1 17247 Lake Herman Recreation Area 29223 1027 Benicia, City of 347 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1027 Benicia, City of 344 City 2 City Agency 2 http://solanoopenspace.org/OtherOutdoor.asp Solano 26 633.303 Lake Herman Rec. Area 0 Local Recreation Area 3 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]);