units_with_maps

Table actions

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

4 rows where MNG_AGENCY = 25, MNG_AG_TYP = 5 and YR_EST = 1975

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER

ACCESS_TYP 2

MNG_AG_TYP 1

  • State Agency · 4 ✖

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 4 ✖
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
10196 10196 10195 {"type": "MultiPolygon", "coordinates": [[[[-116.46032, 33.7287], [-116.46028, 33.74292], [-116.44297, 33.743], [-116.43995, 33.74321], [-116.42563, 33.74329], [-116.4241, 33.74327], [-116.42427, 33.74193], [-116.42383, 33.74191], [-116.4229, 33.74094], [-116.42501, 33.73847], [-116.42654, 33.73484], [-116.42872, 33.73227], [-116.42891, 33.73198], [-116.42988, 33.73198], [-116.43084, 33.73168], [-116.43184, 33.73181], [-116.43249, 33.73202], [-116.43276, 33.73225], [-116.43359, 33.7331], [-116.43381, 33.73356], [-116.43383, 33.73356], [-116.4342, 33.73331], [-116.43334, 33.73203], [-116.43307, 33.7314], [-116.43361, 33.7307], [-116.4341, 33.73065], [-116.43443, 33.73028], [-116.43442, 33.72982], [-116.43399, 33.72938], [-116.43378, 33.72938], [-116.4338, 33.72967], [-116.43299, 33.73036], [-116.43235, 33.73077], [-116.42894, 33.73039], [-116.42731, 33.73002], [-116.42605, 33.72913], [-116.4256, 33.73088], [-116.42552, 33.72869], [-116.41815, 33.72859], [-116.41815, 33.72842], [-116.41814, 33.72841], [-116.41749, 33.72872], [-116.40815, 33.72868], [-116.40812, 33.72153], [-116.40827, 33.72152], [-116.40812, 33.7142], [-116.42344, 33.71414], [-116.42507, 33.71407], [-116.42557, 33.71407], [-116.44277, 33.71408], [-116.44289, 33.72866], [-116.46032, 33.7287]]], [[[-116.46031, 33.69965], [-116.46031, 33.7141], [-116.44293, 33.71408], [-116.44293, 33.69956], [-116.42555, 33.69961], [-116.42556, 33.69234], [-116.42634, 33.69178], [-116.42641, 33.69156], [-116.42666, 33.69135], [-116.42699, 33.6913], [-116.42765, 33.69136], [-116.42782, 33.69117], [-116.42755, 33.69106], [-116.42658, 33.69021], [-116.42647, 33.6895], [-116.42556, 33.68961], [-116.42555, 33.68505], [-116.4429, 33.68507], [-116.44293, 33.69956], [-116.46031, 33.69965]]]]} Open Access 1 12829 Magnesia Spring Ecological Reserve 32213 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 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Magnesia-Spring-ER Riverside 10 3791.767 Magnesia Spring ER 1975 State Conservation Area 8 2
15579 15579 15578 {"type": "MultiPolygon", "coordinates": [[[[-117.82139, 36.70181], [-117.82134, 36.70914], [-117.81229, 36.70918], [-117.81232, 36.70187], [-117.80326, 36.70192], [-117.80316, 36.69463], [-117.82138, 36.69449], [-117.82139, 36.70181]]], [[[-117.8305, 36.6981], [-117.826, 36.6981], [-117.82598, 36.69448], [-117.83048, 36.69447], [-117.8305, 36.6981]]]]} Open Access 1 7985 Saline Valley Ecological Reserve 32286 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 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Saline-Valley-ER Inyo 43 528.226 Saline Valley ER 1975 State Conservation Area 8 2
15593 15593 15592 {"type": "MultiPolygon", "coordinates": [[[[-117.89222, 33.64467], [-117.89145, 33.6457], [-117.89113, 33.64628], [-117.89089, 33.64677], [-117.89083, 33.64719], [-117.89084, 33.64753], [-117.89089, 33.64759], [-117.89093, 33.64785], [-117.89083, 33.64873], [-117.89054, 33.64966], [-117.89017, 33.65045], [-117.8898, 33.65087], [-117.88872, 33.65156], [-117.88812, 33.65187], [-117.88788, 33.65189], [-117.88622, 33.65225], [-117.88611, 33.652], [-117.88486, 33.65232], [-117.8843, 33.65248], [-117.87916, 33.65141], [-117.87837, 33.65117], [-117.87713, 33.65074], [-117.87657, 33.6506], [-117.87613, 33.65052], [-117.87553, 33.65046], [-117.87501, 33.65045], [-117.87457, 33.65048], [-117.87406, 33.65056], [-117.87356, 33.65068], [-117.87325, 33.65078], [-117.87276, 33.65097], [-117.8725, 33.6511], [-117.8725, 33.65114], [-117.87218, 33.65124], [-117.87103, 33.65164], [-117.87, 33.65204], [-117.8698, 33.65216], [-117.86922, 33.65227], [-117.8687, 33.65232], [-117.86833, 33.65235], [-117.86765, 33.65235], [-117.86706, 33.65231], [-117.86708, 33.65218], [-117.86709, 33.65196], [-117.86707, 33.65156], [-117.86682, 33.64989], [-117.86679, 33.64957], [-117.86679, 33.64906], [-117.86683, 33.64857], [-117.86703, 33.64726], [-117.86707, 33.6472], [-117.86711, 33.64718], [-117.86734, 33.64712], [-117.8676, 33.64704], [-117.86792, 33.64689], [-117.86808, 33.6468], [-117.86834, 33.64662], [-117.86852, 33.64646], [-117.86899, 33.64595], [-117.8692, 33.64576], [-117.86944, 33.64558], [-117.86976, 33.64542], [-117.87016, 33.64527], [-117.87085, 33.64509], [-117.87095, 33.64511], [-117.87106, 33.64518], [-117.87142, 33.64535], [-117.87172, 33.64545], [-117.87183, 33.64547], [-117.87223, 33.64549], [-117.87236, 33.64548], [-117.87265, 33.64543], [-117.87291, 33.64542], [-117.87372, 33.64556], [-117.87421, 33.64568], [-117.87447, 33.6457], [-117.87515, 33.6457], [-117.8759, 33.64575], [-117.87634, 33.64582], [-117.87713, 33.64612], [-117.87762, 33.64626], [-117.87788, 33.64635], [-117.87808, 33.64647], [-117.87867, 33.6469], [-117.87881, 33.64695], [-117.87897, 33.64698], [-117.87915, 33.64697], [-117.87951, 33.64689], [-117.8799, 33.64678], [-117.88059, 33.64662], [-117.88113, 33.64644], [-117.88173, 33.64615], [-117.88198, 33.64597], [-117.88219, 33.64575], [-117.88233, 33.64554], [-117.88237, 33.64543], [-117.88239, 33.64532], [-117.8824, 33.64522], [-117.88237, 33.64482], [-117.88232, 33.64439], [-117.88232, 33.64391], [-117.88236, 33.64373], [-117.88249, 33.64346], [-117.88289, 33.64303], [-117.8835, 33.64256], [-117.88413, 33.64202], [-117.88488, 33.64141], [-117.88531, 33.64104], [-117.88556, 33.6409], [-117.88609, 33.64083], [-117.88629, 33.64071], [-117.88769, 33.63761], [-117.8869, 33.63605], [-117.88594, 33.63516], [-117.88561, 33.63453], [-117.88549, 33.6344], [-117.88509, 33.63403], [-117.88483, 33.63395], [-117.88467, 33.63377], [-117.8846, 33.63364], [-117.88329, 33.63301], [-117.88322, 33.63295], [-117.88312, 33.63284], [-117.88308, 33.63273], [-117.88302, 33.63212], [-117.883, 33.63202], [-117.88295, 33.63192], [-117.88289, 33.63186], [-117.88279, 33.63178], [-117.88204, 33.63138], [-117.88241, 33.63125], [-117.88249, 33.6312], [-117.88264, 33.63117], [-117.88405, 33.63114], [-117.88432, 33.63107], [-117.88449, 33.63099], [-117.88488, 33.63066], [-117.88499, 33.63025], [-117.88548, 33.6302], [-117.88591, 33.63007], [-117.88626, 33.6299], [-117.88612, 33.63039], [-117.88587, 33.63218], [-117.88586, 33.63288], [-117.88575, 33.63374], [-117.88578, 33.63407], [-117.88581, 33.63411], [-117.88628, 33.63495], [-117.88729, 33.63596], [-117.88751, 33.63628], [-117.88803, 33.63756], [-117.88726, 33.63909], [-117.88745, 33.63942], [-117.88748, 33.64008], [-117.88734, 33.64041], [-117.88712, 33.64036], [-117.88699, 33.63984], [-117.8868, 33.63992], [-117.88676, 33.64059], [-117.88657, 33.64098], [-117.88545, 33.64139], [-117.88378, 33.64272], [-117.88277, 33.64381], [-117.88279, 33.64569], [-117.88389, 33.64613], [-117.88438, 33.6465], [-117.8855, 33.64753], [-117.88816, 33.64607], [-117.88984, 33.63866], [-117.89034, 33.63939], [-117.89056, 33.64126], [-117.89124, 33.64184], [-117.89123, 33.64185], [-117.89199, 33.64287], [-117.892, 33.64455], [-117.89222, 33.64467]]], [[[-117.89314, 33.62071], [-117.89283, 33.62081], [-117.89246, 33.62119], [-117.89175, 33.62246], [-117.89121, 33.62441], [-117.89083, 33.62549], [-117.88925, 33.62635], [-117.88846, 33.62665], [-117.88746, 33.62641], [-117.88643, 33.62681], [-117.886, 33.62694], [-117.88567, 33.62718], [-117.88584, 33.62689], [-117.88589, 33.62528], [-117.88691, 33.62397], [-117.88723, 33.62373], [-117.88767, 33.62364], [-117.88885, 33.62448], [-117.88954, 33.6235], [-117.88998, 33.62271], [-117.89091, 33.62176], [-117.89113, 33.62077], [-117.89086, 33.62079], [-117.89175, 33.61959], [-117.89246, 33.61966], [-117.8925, 33.61989], [-117.89314, 33.62071]]], [[[-117.88963, 33.63535], [-117.88929, 33.6359], [-117.88875, 33.63601], [-117.88836, 33.63604], [-117.88836, 33.63606], [-117.88847, 33.63615], [-117.88844, 33.63635], [-117.88819, 33.6364], [-117.88797, 33.63633], [-117.88781, 33.63615], [-117.88787, 33.63609], [-117.88787, 33.63607], [-117.88765, 33.63609], [-117.88672, 33.63532], [-117.88638, 33.63492], [-117.88625, 33.63433], [-117.88639, 33.63337], [-117.88651, 33.63282], [-117.88916, 33.63443], [-117.88963, 33.63535]]], [[[-117.89083, 33.6312], [-117.89067, 33.63158], [-117.8901, 33.6319], [-117.88925, 33.63267], [-117.88746, 33.63221], [-117.88696, 33.63051], [-117.88668, 33.62896], [-117.88673, 33.62858], [-117.88728, 33.62827], [-117.8878, 33.62814], [-117.88859, 33.62791], [-117.88964, 33.6274], [-117.88979, 33.62763], [-117.88942, 33.6286], [-117.88976, 33.62886], [-117.89017, 33.62957], [-117.89074, 33.63065], [-117.89083, 33.6312]]]]} Open Access 1 14907 Upper Newport Bay Ecological Reserve 32343 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 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Upper-Newport-Bay-ER Orange 3 505.532 Upper Newport Bay ER 1975 State Conservation Area 8 2
15848 15848 15847 {"type": "MultiPolygon", "coordinates": [[[[-121.83914, 36.92249], [-121.83802, 36.92338], [-121.8365, 36.92336], [-121.83613, 36.92327], [-121.83482, 36.92319], [-121.83425, 36.92341], [-121.83363, 36.92355], [-121.83293, 36.92157], [-121.83662, 36.92077], [-121.83687, 36.92111], [-121.83719, 36.92149], [-121.83759, 36.92182], [-121.83806, 36.92209], [-121.83857, 36.9223], [-121.83914, 36.92249]]], [[[-121.84473, 36.92755], [-121.84387, 36.92867], [-121.84352, 36.9288], [-121.84282, 36.92891], [-121.84224, 36.92906], [-121.84078, 36.92927], [-121.84076, 36.92981], [-121.83859, 36.93], [-121.83579, 36.92663], [-121.83391, 36.92704], [-121.83378, 36.92637], [-121.8335, 36.92598], [-121.83539, 36.92512], [-121.83539, 36.92511], [-121.83506, 36.92497], [-121.83461, 36.92465], [-121.83785, 36.92388], [-121.83996, 36.92589], [-121.84045, 36.92543], [-121.8404, 36.92537], [-121.84042, 36.92535], [-121.8405, 36.9254], [-121.84073, 36.92517], [-121.84473, 36.92755]]]]} Restricted Access 2 27035 Ellicott Slough National Wildlife Refuge 18589 106 United States Fish and Wildlife Service 45 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Santa Cruz 5 111.035 Ellicott Slough NWR 1975 National Wildlife Refuge 105 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]);