units_with_maps

Table actions

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

3 rows where COUNTY = 12, DES_TP = 4 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 3 ✖

DES_TP 1

  • Local Conservation Area · 3 ✖

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
6840 6840 6839 {"type": "MultiPolygon", "coordinates": [[[[-122.30443, 37.92294], [-122.30401, 37.92313], [-122.30408, 37.92332], [-122.30401, 37.92354], [-122.30422, 37.92384], [-122.30247, 37.92464], [-122.30208, 37.92435], [-122.29973, 37.92584], [-122.30015, 37.92458], [-122.29997, 37.92377], [-122.30023, 37.92358], [-122.30107, 37.92361], [-122.30108, 37.92359], [-122.30011, 37.92288], [-122.29998, 37.92276], [-122.29934, 37.92321], [-122.29848, 37.92338], [-122.29801, 37.92345], [-122.29781, 37.92284], [-122.29933, 37.92216], [-122.29933, 37.92215], [-122.29867, 37.92156], [-122.298, 37.92088], [-122.29768, 37.92058], [-122.29676, 37.91987], [-122.29594, 37.91938], [-122.29536, 37.91863], [-122.29542, 37.91858], [-122.29552, 37.91835], [-122.29563, 37.91824], [-122.29574, 37.91818], [-122.29619, 37.91812], [-122.29638, 37.91811], [-122.29639, 37.9181], [-122.29634, 37.91803], [-122.29795, 37.91777], [-122.29863, 37.91746], [-122.29868, 37.91752], [-122.29902, 37.91746], [-122.29963, 37.91832], [-122.29917, 37.91854], [-122.29951, 37.91904], [-122.30079, 37.91847], [-122.30149, 37.91962], [-122.30235, 37.92081], [-122.30159, 37.92116], [-122.30263, 37.92258], [-122.30271, 37.92319], [-122.30339, 37.92374], [-122.30374, 37.92358], [-122.30372, 37.92316], [-122.3039, 37.92289], [-122.30419, 37.92257], [-122.30429, 37.92269], [-122.30428, 37.92273], [-122.30443, 37.92294]]], [[[-122.29972, 37.92585], [-122.3003, 37.92643], [-122.30156, 37.92608], [-122.30179, 37.9265], [-122.30186, 37.92649], [-122.30193, 37.92651], [-122.30197, 37.92655], [-122.30199, 37.92659], [-122.30194, 37.92675], [-122.30195, 37.92719], [-122.30192, 37.92725], [-122.30201, 37.92728], [-122.30199, 37.92735], [-122.30192, 37.92734], [-122.302, 37.92757], [-122.3016, 37.92767], [-122.30092, 37.9272], [-122.2999, 37.92708], [-122.29989, 37.92711], [-122.29946, 37.92729], [-122.2987, 37.9265], [-122.29972, 37.92585]]], [[[-122.30876, 37.92785], [-122.30587, 37.9279], [-122.30563, 37.92705], [-122.30492, 37.92648], [-122.30388, 37.92684], [-122.30325, 37.92733], [-122.30314, 37.92723], [-122.30278, 37.92747], [-122.30275, 37.92743], [-122.3031, 37.9272], [-122.30305, 37.92694], [-122.30313, 37.92679], [-122.30358, 37.92614], [-122.30399, 37.92576], [-122.30447, 37.9261], [-122.30716, 37.9249], [-122.30745, 37.92531], [-122.30777, 37.92516], [-122.30746, 37.92476], [-122.30747, 37.92476], [-122.30779, 37.92516], [-122.30781, 37.92572], [-122.30837, 37.92574], [-122.30839, 37.9258], [-122.3081, 37.92596], [-122.30809, 37.92597], [-122.30829, 37.92621], [-122.30868, 37.92621], [-122.30876, 37.92785]]]]} Open Access 1 47537 Hillside Natural Area 31244 1094 El Cerrito, City of 385 City 2 City Agency 2 http://www.el-cerrito.org/ City 2 1094 El Cerrito, City of 381 City 2 City Agency 2 http://www.el-cerrito.org/index.aspx?NID=812 Contra Costa 12 98.951 Hillside Natural Area 0 Local Conservation Area 4 2
8947 8947 8946 {"type": "Polygon", "coordinates": [[[-122.15409, 37.85875], [-122.15382, 37.85912], [-122.15332, 37.8589], [-122.15259, 37.85923], [-122.15174, 37.85981], [-122.15113, 37.86013], [-122.15036, 37.86072], [-122.15004, 37.86052], [-122.14988, 37.86078], [-122.14943, 37.86126], [-122.14924, 37.86109], [-122.14906, 37.86095], [-122.14886, 37.86083], [-122.14741, 37.86019], [-122.147, 37.85999], [-122.14641, 37.85974], [-122.14369, 37.85838], [-122.14335, 37.85825], [-122.14317, 37.85821], [-122.14295, 37.85818], [-122.14268, 37.85816], [-122.1426, 37.85264], [-122.14422, 37.85365], [-122.14541, 37.85435], [-122.14541, 37.85462], [-122.14521, 37.85491], [-122.14526, 37.85503], [-122.14528, 37.85512], [-122.14538, 37.85516], [-122.14542, 37.85521], [-122.14572, 37.85545], [-122.14665, 37.85597], [-122.14686, 37.8567], [-122.14772, 37.85662], [-122.14768, 37.85637], [-122.14785, 37.85571], [-122.14886, 37.85549], [-122.1493, 37.85542], [-122.15037, 37.85557], [-122.15096, 37.85579], [-122.15188, 37.85642], [-122.15363, 37.85749], [-122.15347, 37.85824], [-122.15354, 37.85835], [-122.15365, 37.85847], [-122.15409, 37.85875]]]} Open Access 1 44957 Mulholland Open Space Preserve 22595 1235 Orinda, City of 392 City 2 City Agency 2 http://www.cityoforinda.org/index.asp?Type=B_BASIC&SEC={DF30AA31-A638-4650-A63E-8E4033089DBE} City 2 1235 Orinda, City of 386 City 2 City Agency 2   Contra Costa 12 113.073 Mulholland OSP 1991 Local Conservation Area 4 2
15949 15949 15948 {"type": "Polygon", "coordinates": [[[-122.14268, 37.85816], [-122.14235, 37.85815], [-122.14204, 37.85809], [-122.14178, 37.85803], [-122.14081, 37.85772], [-122.13915, 37.85695], [-122.13895, 37.85687], [-122.1385, 37.85675], [-122.13797, 37.85644], [-122.13789, 37.85641], [-122.13737, 37.85627], [-122.13684, 37.85603], [-122.13597, 37.85559], [-122.13559, 37.85538], [-122.13499, 37.85501], [-122.1347, 37.85482], [-122.13427, 37.85445], [-122.13341, 37.85359], [-122.13318, 37.85341], [-122.13276, 37.85316], [-122.13262, 37.85304], [-122.13226, 37.8527], [-122.13148, 37.85184], [-122.13125, 37.85145], [-122.13077, 37.8505], [-122.13068, 37.85042], [-122.13059, 37.85038], [-122.13043, 37.85037], [-122.13031, 37.85041], [-122.13023, 37.85047], [-122.12693, 37.84989], [-122.12656, 37.84953], [-122.12664, 37.84925], [-122.12664, 37.84898], [-122.1267, 37.84885], [-122.12668, 37.84843], [-122.12852, 37.84839], [-122.12881, 37.84814], [-122.12743, 37.84726], [-122.12754, 37.84707], [-122.12862, 37.84718], [-122.12969, 37.84772], [-122.1304, 37.84876], [-122.13019, 37.84901], [-122.13064, 37.84986], [-122.13107, 37.85023], [-122.13172, 37.85002], [-122.13187, 37.84988], [-122.13228, 37.85019], [-122.13235, 37.85041], [-122.13229, 37.85079], [-122.1325, 37.85138], [-122.13265, 37.85212], [-122.13301, 37.85271], [-122.13421, 37.85275], [-122.13436, 37.85203], [-122.13483, 37.85169], [-122.13519, 37.85167], [-122.13524, 37.85145], [-122.13544, 37.85143], [-122.13582, 37.85128], [-122.13606, 37.85101], [-122.1382, 37.853], [-122.139, 37.85303], [-122.13957, 37.85319], [-122.13971, 37.85326], [-122.13974, 37.85323], [-122.14011, 37.85336], [-122.14028, 37.85321], [-122.14042, 37.85312], [-122.14058, 37.85297], [-122.14043, 37.85206], [-122.14032, 37.85195], [-122.1407, 37.85102], [-122.14152, 37.8514], [-122.14169, 37.8513], [-122.14178, 37.85127], [-122.14206, 37.85231], [-122.1426, 37.85264], [-122.14268, 37.85816]], [[-122.13781, 37.85395], [-122.13781, 37.85397], [-122.13851, 37.85438], [-122.13875, 37.85413], [-122.13867, 37.85394], [-122.13807, 37.85365], [-122.13781, 37.85395]]]} Open Access 1 44956 Mulholland Open Space Preserve 22594 1215 Moraga, Town of 731 City 2 City Agency 2 http://www.ci.moraga.ca.us/dept/park-rec/home City 2 1215 Moraga, Town of 715 City 2 City Agency 2   Contra Costa 12 122.086 Mulholland OSP 0 Local Conservation Area 4 2

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