superunits_with_maps

Table actions

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

4 rows where ACCESS_TYP = 3, LAYER = 2 and MNG_AGENCY = 197

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Marcos, City of · 4 ✖

ACCESS_TYP 1

  • No Public Access · 4 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
13825 13825 13824 {"type": "Polygon", "coordinates": [[[-117.15123, 33.13075], [-117.14933, 33.13076], [-117.14897, 33.13166], [-117.14916, 33.13197], [-117.15033, 33.13376], [-117.14836, 33.13491], [-117.14827, 33.13106], [-117.14832, 33.12938], [-117.14827, 33.12783], [-117.14921, 33.12832], [-117.14932, 33.12837], [-117.14963, 33.12845], [-117.15012, 33.12851], [-117.15039, 33.12859], [-117.15064, 33.12873], [-117.15083, 33.12889], [-117.15099, 33.12911], [-117.15109, 33.12937], [-117.15123, 33.13075]]]} No Public Access 3 La Moree Park   31359 1308 San Marcos, City of 197 City 2 City Agency 2 http://www.ci.san-marcos.ca.us/index.aspx?page=42 City 2 28.896 La Moree Park  
14183 14183 14182 {"type": "Polygon", "coordinates": [[[-117.17097, 33.11374], [-117.17037, 33.11403], [-117.16936, 33.1144], [-117.16869, 33.11525], [-117.16869, 33.11589], [-117.1677, 33.11649], [-117.16752, 33.11688], [-117.16683, 33.11688], [-117.16714, 33.11619], [-117.16679, 33.11598], [-117.16556, 33.11598], [-117.16559, 33.11623], [-117.16539, 33.11626], [-117.16532, 33.11598], [-117.16473, 33.11597], [-117.16472, 33.11458], [-117.16443, 33.11428], [-117.16415, 33.11412], [-117.16436, 33.11387], [-117.16443, 33.1135], [-117.16443, 33.11338], [-117.16416, 33.11309], [-117.16432, 33.11292], [-117.16492, 33.11313], [-117.165, 33.11327], [-117.16616, 33.11328], [-117.16617, 33.11297], [-117.16669, 33.11245], [-117.16671, 33.11223], [-117.16609, 33.1121], [-117.16543, 33.11143], [-117.16572, 33.11127], [-117.16596, 33.11142], [-117.16637, 33.11155], [-117.16696, 33.1115], [-117.16709, 33.11132], [-117.16748, 33.11138], [-117.16788, 33.11159], [-117.16805, 33.11267], [-117.168, 33.11329], [-117.16876, 33.11329], [-117.16878, 33.11319], [-117.16924, 33.11279], [-117.17009, 33.11237], [-117.16996, 33.11267], [-117.16958, 33.1131], [-117.16954, 33.11329], [-117.16947, 33.11331], [-117.16943, 33.11355], [-117.16966, 33.11366], [-117.17097, 33.11374]], [[-117.16912, 33.11452], [-117.16939, 33.11424], [-117.16972, 33.11405], [-117.16971, 33.11394], [-117.16945, 33.11372], [-117.16928, 33.11338], [-117.16906, 33.11345], [-117.16868, 33.11397], [-117.1683, 33.11424], [-117.16779, 33.11418], [-117.16765, 33.11374], [-117.16768, 33.11329], [-117.16666, 33.11328], [-117.16658, 33.11343], [-117.16583, 33.11369], [-117.1652, 33.11353], [-117.1649, 33.11361], [-117.16488, 33.11398], [-117.16536, 33.11481], [-117.16555, 33.11498], [-117.16594, 33.11491], [-117.16683, 33.11496], [-117.16743, 33.1153], [-117.16849, 33.11523], [-117.16906, 33.11473], [-117.16912, 33.11452]]]} No Public Access 3 South Lake Park   31662 1308 San Marcos, City of 197 City 2 City Agency 2 http://www.ci.san-marcos.ca.us/index.aspx?page=42 City 2 29.969 South Lake Park  
14187 14187 14186 {"type": "MultiPolygon", "coordinates": [[[[-117.15598, 33.10707], [-117.15561, 33.10724], [-117.15541, 33.10729], [-117.15513, 33.10743], [-117.15484, 33.1075], [-117.15451, 33.10766], [-117.15398, 33.10779], [-117.15383, 33.10784], [-117.15357, 33.10796], [-117.15345, 33.10804], [-117.1534, 33.10809], [-117.15337, 33.10819], [-117.1534, 33.10835], [-117.15356, 33.10863], [-117.15377, 33.10915], [-117.15402, 33.10997], [-117.15394, 33.10991], [-117.15386, 33.10987], [-117.15326, 33.10975], [-117.15297, 33.10964], [-117.15283, 33.11018], [-117.15297, 33.11064], [-117.15345, 33.11053], [-117.15394, 33.11036], [-117.15385, 33.11066], [-117.1538, 33.11078], [-117.15369, 33.11096], [-117.15363, 33.111], [-117.15356, 33.11101], [-117.15301, 33.11098], [-117.15136, 33.11131], [-117.15112, 33.11093], [-117.15102, 33.11072], [-117.151, 33.11064], [-117.151, 33.11047], [-117.15098, 33.11037], [-117.15081, 33.11], [-117.1507, 33.10967], [-117.1507, 33.10956], [-117.15072, 33.10945], [-117.15071, 33.10937], [-117.15038, 33.10894], [-117.15017, 33.10859], [-117.15012, 33.10852], [-117.15003, 33.10847], [-117.14962, 33.10829], [-117.14952, 33.10827], [-117.14942, 33.10828], [-117.14875, 33.10845], [-117.14855, 33.10847], [-117.14838, 33.10846], [-117.14822, 33.10849], [-117.14822, 33.1055], [-117.14954, 33.10548], [-117.1506, 33.10609], [-117.15282, 33.10654], [-117.15402, 33.10642], [-117.15598, 33.10707]]], [[[-117.16972, 33.11406], [-117.16939, 33.11425], [-117.16912, 33.11452], [-117.16906, 33.11473], [-117.16849, 33.11523], [-117.16743, 33.1153], [-117.16683, 33.11496], [-117.16594, 33.11491], [-117.16555, 33.11498], [-117.16536, 33.11482], [-117.16487, 33.11397], [-117.1649, 33.1136], [-117.1652, 33.11353], [-117.16583, 33.11369], [-117.16657, 33.11343], [-117.16665, 33.11328], [-117.1677, 33.11329], [-117.16765, 33.11374], [-117.16779, 33.11418], [-117.16831, 33.11424], [-117.16868, 33.11397], [-117.16907, 33.11344], [-117.16928, 33.11337], [-117.16945, 33.11372], [-117.16972, 33.11395], [-117.16972, 33.11406]]]]} No Public Access 3 South Lake Mitigation   31663 1308 San Marcos, City of 197 City 2 City Agency 2 http://www.ci.san-marcos.ca.us/index.aspx?page=42 City 2 72.147 South Lake Mitigation  
14931 14931 14930 {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15824, 33.14041], [-117.15823, 33.1404], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13856], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} No Public Access 3 San Marcos City Open Space   24944 1308 San Marcos, City of 197 City 2 City Agency 2 http://www.ci.san-marcos.ca.us/index.aspx?page=42 City 2 10.998 San Marcos City OS  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);