units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2, AGNCY_LEV = 5, COUNTY = 6 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, LABEL_NAME

MNG_AG_TYP 1

  • State Agency · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
15573 15573 15572 {"type": "MultiPolygon", "coordinates": [[[[-118.44473, 33.96166], [-118.4447, 33.96171], [-118.44418, 33.96215], [-118.44385, 33.96246], [-118.44342, 33.96289], [-118.44309, 33.96328], [-118.44315, 33.96333], [-118.44053, 33.96656], [-118.44026, 33.96686], [-118.44011, 33.96701], [-118.43981, 33.96728], [-118.43941, 33.9676], [-118.43887, 33.96794], [-118.4384, 33.96819], [-118.43066, 33.97172], [-118.42699, 33.96619], [-118.42668, 33.96586], [-118.42641, 33.96564], [-118.42613, 33.96547], [-118.42645, 33.96527], [-118.42773, 33.96546], [-118.43068, 33.96732], [-118.43234, 33.96689], [-118.43239, 33.9668], [-118.43209, 33.9664], [-118.4321, 33.96632], [-118.43276, 33.9659], [-118.43364, 33.96545], [-118.43415, 33.96523], [-118.43422, 33.96524], [-118.43435, 33.9654], [-118.43446, 33.96535], [-118.43469, 33.96582], [-118.43509, 33.96568], [-118.43604, 33.9651], [-118.43667, 33.96607], [-118.43697, 33.96594], [-118.43706, 33.96604], [-118.43709, 33.96601], [-118.43699, 33.96585], [-118.43699, 33.96579], [-118.43704, 33.96573], [-118.43777, 33.96541], [-118.43791, 33.96542], [-118.43798, 33.96545], [-118.43802, 33.9655], [-118.43814, 33.96549], [-118.43874, 33.96467], [-118.43957, 33.96412], [-118.43945, 33.96398], [-118.44147, 33.96268], [-118.44115, 33.96234], [-118.44009, 33.96295], [-118.44008, 33.96292], [-118.44091, 33.96236], [-118.44307, 33.9621], [-118.44458, 33.96139], [-118.44472, 33.96151], [-118.44473, 33.96166]], [[-118.43824, 33.96817], [-118.43824, 33.96815], [-118.43806, 33.96788], [-118.43778, 33.96801], [-118.43796, 33.96829], [-118.43824, 33.96817]], [[-118.43869, 33.96659], [-118.43869, 33.96658], [-118.43851, 33.9663], [-118.43823, 33.96643], [-118.43841, 33.96672], [-118.43869, 33.96659]], [[-118.44125, 33.96475], [-118.44126, 33.96474], [-118.44108, 33.96446], [-118.44079, 33.96459], [-118.44097, 33.96487], [-118.44125, 33.96475]]], [[[-118.43925, 33.96812], [-118.43793, 33.96975], [-118.43775, 33.96993], [-118.43747, 33.97015], [-118.43728, 33.97027], [-118.43507, 33.97137], [-118.43351, 33.97209], [-118.43335, 33.97219], [-118.43319, 33.97233], [-118.43307, 33.97247], [-118.43296, 33.97271], [-118.43292, 33.97285], [-118.43291, 33.97312], [-118.43293, 33.97324], [-118.43299, 33.9734], [-118.43323, 33.97385], [-118.43335, 33.97414], [-118.43342, 33.9745], [-118.43342, 33.9747], [-118.4334, 33.97487], [-118.43336, 33.97486], [-118.43335, 33.97488], [-118.43263, 33.97528], [-118.4324, 33.97495], [-118.43169, 33.97387], [-118.43174, 33.97384], [-118.4317, 33.97378], [-118.43062, 33.97213], [-118.43065, 33.97204], [-118.4385, 33.96846], [-118.4388, 33.96831], [-118.4392, 33.96808], [-118.43924, 33.96808], [-118.43925, 33.96812]], [[-118.4383, 33.96882], [-118.43821, 33.96868], [-118.43793, 33.96881], [-118.43812, 33.96909], [-118.4384, 33.96897], [-118.4383, 33.96882]]], [[[-118.43334, 33.97494], [-118.43332, 33.97504], [-118.4332, 33.97536], [-118.43311, 33.97551], [-118.43296, 33.9757], [-118.43267, 33.97532], [-118.43334, 33.97494]]], [[[-118.45161, 33.96469], [-118.44452, 33.9687], [-118.44542, 33.96982], [-118.44543, 33.97342], [-118.44494, 33.9741], [-118.43612, 33.97801], [-118.4347, 33.97707], [-118.43468, 33.97708], [-118.4341, 33.9767], [-118.43372, 33.97642], [-118.43344, 33.97618], [-118.43331, 33.97606], [-118.43335, 33.97599], [-118.4332, 33.97591], [-118.43335, 33.97571], [-118.43354, 33.9754], [-118.43368, 33.97507], [-118.43375, 33.97478], [-118.44449, 33.96869], [-118.44446, 33.96865], [-118.44411, 33.96885], [-118.43376, 33.97471], [-118.43378, 33.97456], [-118.43376, 33.97433], [-118.43368, 33.97401], [-118.43361, 33.97384], [-118.43334, 33.97331], [-118.43327, 33.97306], [-118.43327, 33.97283], [-118.43331, 33.97269], [-118.43343, 33.97247], [-118.43353, 33.97236], [-118.43366, 33.97224], [-118.43385, 33.97214], [-118.43519, 33.97153], [-118.43726, 33.97048], [-118.43765, 33.97025], [-118.43787, 33.97008], [-118.43817, 33.96978], [-118.44333, 33.96342], [-118.44359, 33.96312], [-118.44394, 33.96276], [-118.44421, 33.96249], [-118.44451, 33.96222], [-118.44505, 33.96178], [-118.44528, 33.96197], [-118.44816, 33.95963], [-118.4483, 33.95975], [-118.44862, 33.95994], [-118.45035, 33.96271], [-118.45044, 33.96286], [-118.45041, 33.96289], [-118.45041, 33.96291], [-118.45161, 33.96469]], [[-118.44504, 33.97165], [-118.44497, 33.97162], [-118.44481, 33.97186], [-118.44516, 33.97201], [-118.44531, 33.97178], [-118.44504, 33.97165]], [[-118.44334, 33.97151], [-118.44335, 33.97149], [-118.44329, 33.97118], [-118.44297, 33.97123], [-118.44303, 33.97155], [-118.44334, 33.97151]], [[-118.44456, 33.97055], [-118.44454, 33.97053], [-118.44426, 33.97067], [-118.44441, 33.97091], [-118.44445, 33.97095], [-118.44473, 33.97082], [-118.44456, 33.97055]], [[-118.44264, 33.96993], [-118.44258, 33.9699], [-118.44242, 33.97013], [-118.44277, 33.97029], [-118.44292, 33.97006], [-118.44264, 33.96993]], [[-118.44405, 33.9696], [-118.44391, 33.96938], [-118.44362, 33.96951], [-118.44381, 33.9698], [-118.44409, 33.96967], [-118.44405, 33.9696]], [[-118.4425, 33.96731], [-118.44226, 33.96707], [-118.44201, 33.96724], [-118.44225, 33.96749], [-118.4425, 33.96733], [-118.4425, 33.96731]], [[-118.44362, 33.9664], [-118.4435, 33.96623], [-118.44322, 33.96636], [-118.44341, 33.96664], [-118.44369, 33.96652], [-118.44362, 33.9664]], [[-118.44164, 33.96645], [-118.44164, 33.96644], [-118.44145, 33.96616], [-118.44118, 33.96628], [-118.44136, 33.96657], [-118.44164, 33.96645]], [[-118.44294, 33.96604], [-118.44307, 33.9658], [-118.44272, 33.96566], [-118.44259, 33.96591], [-118.44294, 33.96604]], [[-118.44467, 33.96591], [-118.44478, 33.96606], [-118.44506, 33.96592], [-118.44486, 33.96565], [-118.44459, 33.96577], [-118.44467, 33.96591]], [[-118.44438, 33.9652], [-118.44438, 33.96519], [-118.4442, 33.96491], [-118.44392, 33.96504], [-118.4441, 33.96533], [-118.44438, 33.9652]], [[-118.44834, 33.96124], [-118.44834, 33.96123], [-118.44816, 33.96095], [-118.44788, 33.96108], [-118.44806, 33.96136], [-118.44834, 33.96124]], [[-118.44066, 33.96931], [-118.44044, 33.96908], [-118.44019, 33.96924], [-118.44038, 33.96946], [-118.44044, 33.9695], [-118.44068, 33.96934], [-118.44066, 33.96931]]], [[[-118.42859, 33.97776], [-118.42515, 33.98022], [-118.42379, 33.97996], [-118.42537, 33.97911], [-118.42826, 33.97724], [-118.42859, 33.97776]]], [[[-118.43174, 33.97724], [-118.4317, 33.97735], [-118.43144, 33.97766], [-118.42946, 33.98012], [-118.42927, 33.98031], [-118.42887, 33.98057], [-118.42866, 33.98065], [-118.42828, 33.9807], [-118.42783, 33.98073], [-118.42528, 33.98024], [-118.42626, 33.97951], [-118.42754, 33.9786], [-118.42908, 33.97756], [-118.43008, 33.97693], [-118.43083, 33.97698], [-118.43096, 33.97692], [-118.43095, 33.9769], [-118.43022, 33.97685], [-118.43141, 33.97613], [-118.43141, 33.97616], [-118.43134, 33.97622], [-118.43125, 33.97636], [-118.43123, 33.97645], [-118.43125, 33.97664], [-118.43128, 33.97671], [-118.43136, 33.97682], [-118.4315, 33.97693], [-118.43167, 33.97702], [-118.43172, 33.9771], [-118.43174, 33.97717], [-118.43174, 33.97724]]], [[[-118.43032, 33.9812], [-118.43032, 33.9812], [-118.42931, 33.98101], [-118.42992, 33.98025], [-118.42992, 33.9805], [-118.42994, 33.98063], [-118.42999, 33.98077], [-118.43012, 33.98099], [-118.43032, 33.9812]]], [[[-118.43568, 33.97821], [-118.43245, 33.97964], [-118.43209, 33.98154], [-118.43051, 33.98124], [-118.43043, 33.98119], [-118.43027, 33.98105], [-118.43018, 33.98095], [-118.43009, 33.98081], [-118.43002, 33.9806], [-118.43, 33.98053], [-118.43, 33.9803], [-118.43006, 33.98007], [-118.43284, 33.97663], [-118.43284, 33.97661], [-118.43269, 33.97653], [-118.43293, 33.97623], [-118.43309, 33.97632], [-118.43312, 33.9763], [-118.43336, 33.97651], [-118.4337, 33.97677], [-118.43551, 33.978], [-118.43546, 33.97807], [-118.43568, 33.97821]]]]} Restricted Access 2 6315 Ballona Wetlands Ecological Reserve 15789 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Los Angeles 6 576.608 Ballona Wetlands ER 0 State Conservation Area 8 2
15631 15631 15630 {"type": "MultiPolygon", "coordinates": [[[[-118.42515, 33.98022], [-118.42488, 33.98042], [-118.42427, 33.98031], [-118.42454, 33.98011], [-118.42515, 33.98022]]], [[[-118.42921, 33.98035], [-118.42898, 33.98059], [-118.42873, 33.9809], [-118.42783, 33.98073], [-118.42828, 33.9807], [-118.42866, 33.98064], [-118.42887, 33.98056], [-118.42921, 33.98035]]], [[[-118.42901, 33.97746], [-118.42859, 33.97776], [-118.42826, 33.97724], [-118.42875, 33.97693], [-118.42887, 33.97722], [-118.42901, 33.97746]]], [[[-118.43285, 33.97662], [-118.43006, 33.98007], [-118.43, 33.9803], [-118.43002, 33.9806], [-118.4301, 33.98081], [-118.43018, 33.98095], [-118.43027, 33.98105], [-118.43049, 33.98123], [-118.43191, 33.9815], [-118.43208, 33.98162], [-118.43187, 33.98175], [-118.42892, 33.98119], [-118.43269, 33.97653], [-118.43285, 33.97662]], [[-118.43028, 33.98119], [-118.43029, 33.98117], [-118.43018, 33.98107], [-118.43009, 33.98096], [-118.42999, 33.98077], [-118.42993, 33.98058], [-118.42991, 33.98041], [-118.42992, 33.98028], [-118.42991, 33.98027], [-118.42941, 33.98086], [-118.42931, 33.981], [-118.43028, 33.98119]]], [[[-118.4323, 33.97539], [-118.42949, 33.97712], [-118.42928, 33.97727], [-118.42915, 33.97702], [-118.42904, 33.97676], [-118.42915, 33.97666], [-118.43197, 33.97484], [-118.4323, 33.97539]]]]} Restricted Access 2 44627 Ballona Wetlands Ecological Reserve 15789 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Los Angeles 6 11.92 Ballona Wetlands ER 0 State Conservation Area 8 2
16966 16966 16965 {"type": "MultiPolygon", "coordinates": [[[[-118.65894, 34.09067], [-118.6584, 34.09088], [-118.65818, 34.09092], [-118.65805, 34.09092], [-118.65778, 34.09087], [-118.65727, 34.09065], [-118.65706, 34.09061], [-118.65686, 34.09061], [-118.65631, 34.09068], [-118.65619, 34.09069], [-118.65602, 34.09066], [-118.65581, 34.09059], [-118.65522, 34.0903], [-118.65493, 34.09022], [-118.65474, 34.09019], [-118.65398, 34.09017], [-118.65376, 34.09019], [-118.65358, 34.09024], [-118.65348, 34.0903], [-118.65336, 34.09041], [-118.65325, 34.09056], [-118.65313, 34.09096], [-118.65309, 34.09104], [-118.65302, 34.09112], [-118.65289, 34.09121], [-118.65253, 34.09139], [-118.65237, 34.09152], [-118.65231, 34.09163], [-118.65228, 34.09173], [-118.6523, 34.09208], [-118.65228, 34.09218], [-118.6522, 34.09232], [-118.65216, 34.09236], [-118.65194, 34.09254], [-118.65177, 34.09262], [-118.65153, 34.0927], [-118.65116, 34.09274], [-118.651, 34.09278], [-118.65087, 34.09284], [-118.65059, 34.09306], [-118.65049, 34.0931], [-118.65019, 34.09315], [-118.65005, 34.0932], [-118.64986, 34.09335], [-118.6498, 34.09344], [-118.64966, 34.09372], [-118.64958, 34.0938], [-118.64949, 34.09385], [-118.64932, 34.09388], [-118.64917, 34.09385], [-118.6481, 34.0933], [-118.64793, 34.09325], [-118.64769, 34.09324], [-118.64753, 34.09328], [-118.64741, 34.09334], [-118.64725, 34.09346], [-118.64716, 34.09363], [-118.647, 34.09414], [-118.64698, 34.09424], [-118.64699, 34.09442], [-118.64705, 34.0946], [-118.64709, 34.09469], [-118.6472, 34.09482], [-118.64737, 34.09494], [-118.64751, 34.09501], [-118.64769, 34.09506], [-118.64891, 34.09528], [-118.64914, 34.09531], [-118.64954, 34.09531], [-118.64983, 34.09529], [-118.65032, 34.0952], [-118.6507, 34.09509], [-118.6512, 34.09488], [-118.65135, 34.09484], [-118.65157, 34.09483], [-118.65182, 34.09487], [-118.65203, 34.09496], [-118.65221, 34.0951], [-118.6523, 34.09521], [-118.65235, 34.09529], [-118.65242, 34.09551], [-118.65242, 34.09562], [-118.6524, 34.09574], [-118.65233, 34.09591], [-118.65219, 34.09613], [-118.65214, 34.09627], [-118.65017, 34.09629], [-118.6502, 34.09996], [-118.64111, 34.09994], [-118.64112, 34.09636], [-118.64115, 34.09468], [-118.64116, 34.09265], [-118.65012, 34.09267], [-118.65009, 34.08891], [-118.65894, 34.08891], [-118.65894, 34.09067]]], [[[-118.65894, 34.0962], [-118.65234, 34.09626], [-118.65238, 34.09618], [-118.65252, 34.09596], [-118.65257, 34.09584], [-118.65261, 34.09566], [-118.65261, 34.09546], [-118.65252, 34.0952], [-118.65238, 34.09502], [-118.65227, 34.09491], [-118.65214, 34.09483], [-118.65199, 34.09475], [-118.65187, 34.09471], [-118.6517, 34.09468], [-118.65139, 34.09467], [-118.65111, 34.09473], [-118.65049, 34.09497], [-118.65006, 34.09507], [-118.64959, 34.09513], [-118.64924, 34.09513], [-118.64891, 34.09511], [-118.64773, 34.0949], [-118.64752, 34.09482], [-118.64734, 34.0947], [-118.64723, 34.09454], [-118.64718, 34.09439], [-118.64719, 34.09421], [-118.64735, 34.09366], [-118.6474, 34.09357], [-118.64754, 34.09346], [-118.64774, 34.09341], [-118.64789, 34.09341], [-118.64802, 34.09346], [-118.64909, 34.09401], [-118.64925, 34.09404], [-118.6494, 34.09404], [-118.64962, 34.09397], [-118.64979, 34.09385], [-118.64987, 34.09374], [-118.64998, 34.09349], [-118.65001, 34.09345], [-118.65013, 34.09336], [-118.65023, 34.09332], [-118.65051, 34.09327], [-118.65067, 34.09321], [-118.65103, 34.09295], [-118.6511, 34.09292], [-118.65154, 34.09286], [-118.65179, 34.09279], [-118.65206, 34.09266], [-118.6523, 34.09248], [-118.65242, 34.09233], [-118.65248, 34.09218], [-118.65249, 34.09207], [-118.65247, 34.09175], [-118.65252, 34.09164], [-118.65259, 34.09155], [-118.65303, 34.09132], [-118.65319, 34.09121], [-118.65326, 34.09111], [-118.65333, 34.09099], [-118.65344, 34.09062], [-118.65351, 34.09051], [-118.6536, 34.09044], [-118.65375, 34.09037], [-118.65387, 34.09034], [-118.65469, 34.09035], [-118.65484, 34.09037], [-118.65503, 34.09041], [-118.65517, 34.09046], [-118.65573, 34.09074], [-118.65601, 34.09083], [-118.65612, 34.09085], [-118.65639, 34.09085], [-118.65684, 34.09079], [-118.65706, 34.09078], [-118.65719, 34.09081], [-118.65763, 34.091], [-118.65785, 34.09106], [-118.65802, 34.09108], [-118.65815, 34.09108], [-118.65839, 34.09105], [-118.6584, 34.09173], [-118.65894, 34.09173], [-118.65894, 34.0962]]]]} Restricted Access 2 6444 Stunt Ranch Santa Monica Mountains Reserve 25938 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5   Los Angeles 6 319.623 Stunt Ranch Santa Monica Mtns. Reserve 0 State Conservation Area 8 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]);