units_with_maps

Table actions

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

1 row where DES_TP = 1104, LAYER = 5, MNG_AG_LEV = 5 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

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
12692 12692 12691 {"type": "Polygon", "coordinates": [[[-123.78914, 39.60032], [-123.78909, 39.60039], [-123.78901, 39.60042], [-123.78893, 39.60038], [-123.78886, 39.60033], [-123.78879, 39.60031], [-123.78866, 39.6003], [-123.78856, 39.60026], [-123.78844, 39.60018], [-123.78834, 39.60018], [-123.78826, 39.60026], [-123.78819, 39.6003], [-123.78799, 39.6003], [-123.78758, 39.6002], [-123.78696, 39.59987], [-123.78686, 39.59984], [-123.78682, 39.59987], [-123.78683, 39.59993], [-123.78687, 39.59998], [-123.78716, 39.6002], [-123.78731, 39.60028], [-123.78765, 39.60043], [-123.78813, 39.60054], [-123.78851, 39.60066], [-123.7887, 39.60078], [-123.78876, 39.60087], [-123.78879, 39.60097], [-123.78877, 39.60106], [-123.78877, 39.60116], [-123.78888, 39.60133], [-123.78885, 39.60144], [-123.78878, 39.60153], [-123.78868, 39.60159], [-123.78853, 39.60172], [-123.78852, 39.60182], [-123.78854, 39.60206], [-123.78855, 39.60213], [-123.78865, 39.60234], [-123.78863, 39.60246], [-123.78868, 39.60267], [-123.78884, 39.60288], [-123.78902, 39.60337], [-123.78899, 39.60359], [-123.78901, 39.60374], [-123.78897, 39.60383], [-123.78887, 39.6039], [-123.78886, 39.60397], [-123.78881, 39.60405], [-123.78875, 39.60409], [-123.78869, 39.60409], [-123.78849, 39.60398], [-123.78823, 39.60398], [-123.78815, 39.60399], [-123.78808, 39.60405], [-123.78808, 39.6041], [-123.78815, 39.60419], [-123.78824, 39.60426], [-123.78841, 39.60428], [-123.78862, 39.60447], [-123.78878, 39.60453], [-123.78885, 39.60457], [-123.78888, 39.60464], [-123.78885, 39.60474], [-123.78887, 39.60482], [-123.78899, 39.60493], [-123.78901, 39.60499], [-123.78899, 39.60502], [-123.78887, 39.60501], [-123.78857, 39.605], [-123.78835, 39.60485], [-123.78823, 39.60468], [-123.78812, 39.60458], [-123.78803, 39.60455], [-123.78794, 39.60454], [-123.7878, 39.60459], [-123.78773, 39.60459], [-123.78764, 39.6045], [-123.78759, 39.60441], [-123.78746, 39.60435], [-123.78738, 39.60437], [-123.78729, 39.60447], [-123.78748, 39.60477], [-123.78754, 39.60484], [-123.78758, 39.60493], [-123.78754, 39.60505], [-123.78748, 39.60512], [-123.7874, 39.60514], [-123.7873, 39.60516], [-123.78706, 39.60515], [-123.78697, 39.6052], [-123.78688, 39.60536], [-123.78692, 39.60542], [-123.78701, 39.60546], [-123.78742, 39.60557], [-123.78753, 39.60563], [-123.78758, 39.60569], [-123.78759, 39.60578], [-123.78756, 39.60583], [-123.7875, 39.60588], [-123.78737, 39.60591], [-123.78725, 39.60588], [-123.78716, 39.60582], [-123.78684, 39.60558], [-123.78672, 39.60557], [-123.78664, 39.6056], [-123.78658, 39.60566], [-123.78655, 39.60582], [-123.78655, 39.606], [-123.78661, 39.6061], [-123.78671, 39.60613], [-123.787, 39.60614], [-123.78732, 39.60624], [-123.78751, 39.60643], [-123.78769, 39.60666], [-123.78773, 39.60677], [-123.78774, 39.60685], [-123.78768, 39.60691], [-123.78757, 39.60693], [-123.78753, 39.60696], [-123.78754, 39.60716], [-123.78752, 39.60724], [-123.78748, 39.60732], [-123.78744, 39.60738], [-123.78735, 39.60742], [-123.78732, 39.60747], [-123.78731, 39.60758], [-123.78741, 39.60785], [-123.78741, 39.60804], [-123.78737, 39.60809], [-123.78732, 39.60808], [-123.78712, 39.60812], [-123.78703, 39.60811], [-123.78696, 39.60808], [-123.78684, 39.60796], [-123.7868, 39.60785], [-123.78669, 39.6077], [-123.78642, 39.60752], [-123.78633, 39.6075], [-123.78615, 39.60742], [-123.78583, 39.60733], [-123.78569, 39.60732], [-123.78556, 39.60736], [-123.78548, 39.60742], [-123.78508, 39.60773], [-123.78479, 39.60798], [-123.78434, 39.60832], [-123.78424, 39.60846], [-123.78418, 39.60861], [-123.78417, 39.60876], [-123.78418, 39.60889], [-123.78421, 39.60895], [-123.78435, 39.60912], [-123.78437, 39.60923], [-123.78436, 39.6093], [-123.78432, 39.60938], [-123.78421, 39.60944], [-123.78408, 39.60946], [-123.78378, 39.60944], [-123.78362, 39.60951], [-123.78357, 39.60958], [-123.78351, 39.60975], [-123.78352, 39.61019], [-123.78342, 39.61072], [-123.78334, 39.61094], [-123.78323, 39.61114], [-123.78319, 39.61127], [-123.78332, 39.61139], [-123.78336, 39.61148], [-123.7833, 39.61155], [-123.78312, 39.61159], [-123.78306, 39.61187], [-123.78305, 39.612], [-123.78308, 39.6122], [-123.78304, 39.61251], [-123.78301, 39.61276], [-123.78294, 39.61297], [-123.78273, 39.61326], [-123.78247, 39.6134], [-123.78232, 39.61346], [-123.78226, 39.6135], [-123.78229, 39.61359], [-123.78279, 39.61404], [-123.78284, 39.61419], [-123.78283, 39.61432], [-123.78272, 39.61469], [-123.78262, 39.6149], [-123.78262, 39.61509], [-123.78267, 39.61527], [-123.78273, 39.61536], [-123.78271, 39.61559], [-123.78277, 39.61572], [-123.78277, 39.61589], [-123.78284, 39.61602], [-123.78286, 39.61619], [-123.78292, 39.61639], [-123.78294, 39.61654], [-123.78305, 39.61676], [-123.78306, 39.61699], [-123.78309, 39.61715], [-123.78316, 39.61734], [-123.78319, 39.61758], [-123.78319, 39.61772], [-123.78317, 39.61782], [-123.78301, 39.61813], [-123.7829, 39.61874], [-123.78288, 39.61922], [-123.78289, 39.62014], [-123.78285, 39.62055], [-123.78281, 39.62072], [-123.78282, 39.6209], [-123.78279, 39.62116], [-123.78269, 39.62162], [-123.78271, 39.62177], [-123.78275, 39.62186], [-123.7828, 39.62195], [-123.78303, 39.62212], [-123.78303, 39.62218], [-123.783, 39.62225], [-123.78295, 39.62229], [-123.78291, 39.62236], [-123.78292, 39.62243], [-123.78296, 39.62254], [-123.78022, 39.62297], [-123.77935, 39.62148], [-123.78008, 39.61855], [-123.7808, 39.61595], [-123.78127, 39.61553], [-123.7816, 39.61501], [-123.7817, 39.61484], [-123.78175, 39.61455], [-123.78174, 39.61444], [-123.78169, 39.61428], [-123.78163, 39.61417], [-123.78151, 39.61404], [-123.78132, 39.61392], [-123.78088, 39.61372], [-123.78054, 39.61359], [-123.78035, 39.61346], [-123.77992, 39.61323], [-123.7796, 39.61312], [-123.77852, 39.61287], [-123.77826, 39.61277], [-123.77812, 39.61269], [-123.77804, 39.61261], [-123.77802, 39.61253], [-123.77807, 39.61242], [-123.77813, 39.61236], [-123.77825, 39.61231], [-123.77841, 39.61229], [-123.77861, 39.61229], [-123.77904, 39.61238], [-123.77934, 39.61249], [-123.77969, 39.61253], [-123.78031, 39.61253], [-123.78113, 39.61271], [-123.78157, 39.61272], [-123.78182, 39.61271], [-123.78197, 39.61267], [-123.78207, 39.61262], [-123.78215, 39.6124], [-123.78214, 39.61205], [-123.78215, 39.61171], [-123.78234, 39.6113], [-123.78241, 39.61112], [-123.78249, 39.6108], [-123.78251, 39.61065], [-123.78252, 39.61052], [-123.78244, 39.60967], [-123.7825, 39.60951], [-123.78262, 39.60928], [-123.78275, 39.60909], [-123.78284, 39.60885], [-123.78283, 39.60865], [-123.78277, 39.60849], [-123.78266, 39.6083], [-123.78259, 39.60812], [-123.78256, 39.60801], [-123.78257, 39.60792], [-123.78265, 39.60772], [-123.78271, 39.60762], [-123.7828, 39.60751], [-123.78293, 39.6074], [-123.78305, 39.60735], [-123.78336, 39.6073], [-123.78353, 39.60725], [-123.78376, 39.60707], [-123.78397, 39.60671], [-123.78415, 39.60631], [-123.7843, 39.60588], [-123.78474, 39.60446], [-123.78512, 39.60358], [-123.78527, 39.60307], [-123.78551, 39.60207], [-123.78562, 39.60142], [-123.7853, 39.60079], [-123.78332, 39.59728], [-123.78196, 39.59512], [-123.78218, 39.59501], [-123.78141, 39.59386], [-123.78407, 39.59295], [-123.78409, 39.59298], [-123.78415, 39.59301], [-123.78433, 39.59307], [-123.7845, 39.59317], [-123.78463, 39.59332], [-123.78477, 39.59353], [-123.78477, 39.59358], [-123.78473, 39.59363], [-123.78465, 39.59364], [-123.78454, 39.59363], [-123.78442, 39.5936], [-123.78422, 39.59343], [-123.78412, 39.59338], [-123.78403, 39.59338], [-123.78392, 39.59341], [-123.78381, 39.5935], [-123.78378, 39.59356], [-123.7838, 39.59363], [-123.78379, 39.5937], [-123.78384, 39.59376], [-123.78398, 39.5938], [-123.78423, 39.59409], [-123.7843, 39.59413], [-123.78454, 39.59431], [-123.78466, 39.59436], [-123.78475, 39.59431], [-123.78481, 39.59424], [-123.7849, 39.59429], [-123.78502, 39.59442], [-123.78503, 39.59446], [-123.78502, 39.59451], [-123.78497, 39.59457], [-123.78497, 39.59463], [-123.78503, 39.59471], [-123.78527, 39.59472], [-123.78558, 39.59483], [-123.78582, 39.59488], [-123.78591, 39.59492], [-123.78594, 39.59499], [-123.78606, 39.59508], [-123.78614, 39.59519], [-123.78645, 39.59554], [-123.78644, 39.59563], [-123.7867, 39.59601], [-123.78683, 39.59614], [-123.78709, 39.59646], [-123.7873, 39.59683], [-123.78749, 39.59709], [-123.78761, 39.59738], [-123.78767, 39.59747], [-123.78765, 39.59757], [-123.78759, 39.59773], [-123.78773, 39.5978], [-123.78824, 39.59798], [-123.78829, 39.59805], [-123.78825, 39.59812], [-123.78819, 39.59814], [-123.788, 39.59812], [-123.78789, 39.59807], [-123.78773, 39.59805], [-123.78762, 39.59813], [-123.78751, 39.59816], [-123.78744, 39.59822], [-123.78745, 39.59829], [-123.78753, 39.59836], [-123.78763, 39.59838], [-123.78772, 39.59844], [-123.78789, 39.59864], [-123.78801, 39.59873], [-123.78813, 39.5988], [-123.78824, 39.59892], [-123.78848, 39.59913], [-123.78858, 39.59919], [-123.78863, 39.59928], [-123.78861, 39.59934], [-123.78853, 39.59938], [-123.78841, 39.59939], [-123.78827, 39.59936], [-123.78808, 39.59928], [-123.7877, 39.59909], [-123.78755, 39.59907], [-123.78753, 39.59912], [-123.78758, 39.59918], [-123.78765, 39.59924], [-123.7879, 39.59938], [-123.7882, 39.59953], [-123.78848, 39.5996], [-123.78863, 39.59966], [-123.78898, 39.59995], [-123.78907, 39.60007], [-123.78913, 39.60022], [-123.78914, 39.60032]]]} Open Access 1 29665 Bruhel Point 16449 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Mendocino 24 197.456 Bruhel Point   None 1104  

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