units_with_maps

Table actions

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

8 rows where DES_TP = 2, MNG_AGENCY = 431 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 8 ✖

MNG_AGENCY 1

  • San Anselmo, City of · 8 ✖

DES_TP 1

  • Local Park · 8 ✖

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
1863 1863 1862 {"type": "MultiPolygon", "coordinates": [[[[-122.58022, 37.98301], [-122.58014, 37.98311], [-122.57993, 37.98309], [-122.57917, 37.98294], [-122.57907, 37.98292], [-122.57872, 37.98261], [-122.57838, 37.98254], [-122.57833, 37.98259], [-122.57821, 37.98251], [-122.5781, 37.98251], [-122.57801, 37.9826], [-122.57779, 37.98246], [-122.57791, 37.98233], [-122.57834, 37.98228], [-122.57848, 37.98228], [-122.57864, 37.98235], [-122.57887, 37.98237], [-122.57877, 37.98255], [-122.57895, 37.98269], [-122.57906, 37.98272], [-122.57908, 37.98268], [-122.5792, 37.98277], [-122.57919, 37.98281], [-122.57933, 37.98285], [-122.57947, 37.98287], [-122.57953, 37.98292], [-122.58022, 37.98301]]], [[[-122.57817, 37.98218], [-122.57799, 37.9822], [-122.5779, 37.98195], [-122.57804, 37.98182], [-122.57817, 37.98218]]]]} Open Access 1 14215 Lansdale Park 21015 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 1.158 Lansdale Park 0 Local Park 2 4
4251 4251 4250 {"type": "Polygon", "coordinates": [[[-122.56804, 37.97383], [-122.56784, 37.97429], [-122.56769, 37.97449], [-122.56722, 37.97489], [-122.56704, 37.97479], [-122.56688, 37.97474], [-122.56674, 37.97443], [-122.56663, 37.97445], [-122.56646, 37.97411], [-122.56717, 37.97388], [-122.56754, 37.97362], [-122.56804, 37.97383]]]} Open Access 1 14221 Robson-Harrington Park 24506 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 2.61 Robson-Harrington Park 0 Local Park 2 4
7427 7427 7426 {"type": "Polygon", "coordinates": [[[-122.56596, 37.99241], [-122.56243, 37.99431], [-122.56075, 37.99224], [-122.55765, 37.99387], [-122.55737, 37.99356], [-122.55831, 37.98957], [-122.55979, 37.9893], [-122.56022, 37.989], [-122.56046, 37.9892], [-122.56082, 37.98895], [-122.56122, 37.98959], [-122.56139, 37.98953], [-122.56142, 37.98967], [-122.56139, 37.9898], [-122.56131, 37.98991], [-122.56112, 37.99005], [-122.56105, 37.99012], [-122.561, 37.99021], [-122.56098, 37.9903], [-122.561, 37.99039], [-122.56104, 37.99048], [-122.56134, 37.99075], [-122.56166, 37.99052], [-122.56152, 37.99039], [-122.56264, 37.98956], [-122.56264, 37.98951], [-122.5626, 37.98948], [-122.56243, 37.9895], [-122.56232, 37.98949], [-122.56197, 37.98931], [-122.56214, 37.98925], [-122.56232, 37.98938], [-122.56242, 37.98929], [-122.56296, 37.98957], [-122.56319, 37.9901], [-122.56316, 37.99012], [-122.56334, 37.9907], [-122.56359, 37.99066], [-122.56374, 37.99052], [-122.56406, 37.98877], [-122.56426, 37.98866], [-122.56409, 37.98975], [-122.56401, 37.99037], [-122.56416, 37.99074], [-122.56596, 37.99241]]]} Open Access 1 6869 Sorich Ranch Park 25627 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 61.381 Sorich Ranch Park 0 Local Park 2 4
8750 8750 8749 {"type": "MultiPolygon", "coordinates": [[[[-122.56273, 37.97622], [-122.56273, 37.97628], [-122.5624, 37.97617], [-122.56203, 37.97613], [-122.56191, 37.97598], [-122.56199, 37.97433], [-122.56205, 37.97432], [-122.56207, 37.97474], [-122.56208, 37.97536], [-122.56213, 37.97555], [-122.56223, 37.97578], [-122.56211, 37.97582], [-122.5621, 37.97583], [-122.56273, 37.97622]]], [[[-122.56263, 37.97593], [-122.56256, 37.97602], [-122.5624, 37.9759], [-122.56255, 37.97585], [-122.56263, 37.97593]]], [[[-122.56314, 37.97651], [-122.56288, 37.97636], [-122.56282, 37.97635], [-122.56281, 37.97625], [-122.56304, 37.97641], [-122.56304, 37.97643], [-122.56314, 37.97651]]], [[[-122.56356, 37.97674], [-122.56356, 37.97675], [-122.56332, 37.97661], [-122.56333, 37.9766], [-122.56356, 37.97674]]]]} Open Access 1 14218 Creek Park 17764 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 0.973 Creek Park 0 Local Park 2 4
8751 8751 8750 {"type": "MultiPolygon", "coordinates": [[[[-122.56578, 37.98282], [-122.56573, 37.98336], [-122.56561, 37.98361], [-122.5654, 37.98349], [-122.56509, 37.98379], [-122.56509, 37.9838], [-122.56525, 37.9839], [-122.56491, 37.98426], [-122.56455, 37.98405], [-122.56455, 37.98372], [-122.56383, 37.98375], [-122.56303, 37.98382], [-122.56403, 37.98314], [-122.5649, 37.98298], [-122.56534, 37.98279], [-122.56578, 37.98282]]], [[[-122.5661, 37.98446], [-122.56571, 37.98423], [-122.56589, 37.98406], [-122.5659, 37.98416], [-122.56596, 37.9843], [-122.5661, 37.98446]]], [[[-122.56682, 37.98284], [-122.566, 37.98369], [-122.56578, 37.98356], [-122.56589, 37.98336], [-122.56596, 37.98255], [-122.5661, 37.98241], [-122.56645, 37.98262], [-122.56612, 37.98298], [-122.56612, 37.983], [-122.56648, 37.98263], [-122.56682, 37.98284]]], [[[-122.56738, 37.98316], [-122.56621, 37.98435], [-122.56621, 37.98435], [-122.5661, 37.98416], [-122.56606, 37.98403], [-122.56606, 37.9839], [-122.56699, 37.98293], [-122.56738, 37.98316]]], [[[-122.56799, 37.98253], [-122.56746, 37.98306], [-122.56608, 37.98228], [-122.56663, 37.98173], [-122.5674, 37.98218], [-122.56742, 37.98218], [-122.56799, 37.98253]]]]} Open Access 1 14223 Memorial Park 22131 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 10.371 Memorial Park 0 Local Park 2 4
8752 8752 8751 {"type": "Polygon", "coordinates": [[[-122.57021, 37.98794], [-122.56988, 37.98813], [-122.57007, 37.98828], [-122.56999, 37.98847], [-122.56932, 37.98842], [-122.56913, 37.9886], [-122.56897, 37.98863], [-122.56879, 37.98881], [-122.56871, 37.98882], [-122.56866, 37.98872], [-122.56861, 37.98867], [-122.56872, 37.98824], [-122.56881, 37.98812], [-122.56889, 37.9881], [-122.56893, 37.98807], [-122.56898, 37.98798], [-122.56886, 37.98766], [-122.56878, 37.98755], [-122.56872, 37.9873], [-122.56833, 37.987], [-122.56824, 37.98663], [-122.56791, 37.98643], [-122.56786, 37.98628], [-122.56788, 37.98614], [-122.56774, 37.98598], [-122.56749, 37.98584], [-122.56721, 37.98574], [-122.56712, 37.98563], [-122.56706, 37.98543], [-122.56741, 37.98534], [-122.56768, 37.98499], [-122.56777, 37.98469], [-122.56785, 37.98463], [-122.56858, 37.98456], [-122.5687, 37.98446], [-122.56906, 37.98471], [-122.56934, 37.98494], [-122.5696, 37.98523], [-122.56987, 37.9856], [-122.57001, 37.98563], [-122.56947, 37.9872], [-122.56962, 37.98781], [-122.56991, 37.98768], [-122.57004, 37.98786], [-122.57018, 37.98784], [-122.57021, 37.98794]]]} Open Access 1 14225 Faude Park 18852 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 15.056 Faude Park 0 Local Park 2 4
9553 9553 9552 {"type": "MultiPolygon", "coordinates": [[[[-122.57174, 37.9877], [-122.57157, 37.98793], [-122.5715, 37.98795], [-122.57136, 37.98792], [-122.57122, 37.98785], [-122.57112, 37.98781], [-122.57091, 37.98781], [-122.57063, 37.98785], [-122.57061, 37.98783], [-122.57079, 37.98761], [-122.57139, 37.98731], [-122.57174, 37.9877]]], [[[-122.57181, 37.98811], [-122.57174, 37.98818], [-122.5716, 37.98804], [-122.57162, 37.98803], [-122.57181, 37.98811]]]]} Open Access 1 16127 Oak Park 23000 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 0.94 Oak Park 0 Local Park 2 4
14056 14056 14055 {"type": "Polygon", "coordinates": [[[-122.56401, 37.98004], [-122.564, 37.98004], [-122.56078, 37.9797], [-122.56089, 37.97926], [-122.56361, 37.97889], [-122.56389, 37.9793], [-122.56396, 37.97945], [-122.56393, 37.97965], [-122.56385, 37.9797], [-122.56394, 37.97981], [-122.5639, 37.97984], [-122.56401, 37.98004]]]} Open Access 1 38058 Red Hill Community Park 24224 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 5.852 Red Hill Community Park 0 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]);