units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1 and AGNCY_NAME = 500

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 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
2240 2240 2239 {"type": "Polygon", "coordinates": [[[-123.69334, 38.89646], [-123.69092, 38.89742], [-123.68781, 38.89884], [-123.68619, 38.8973], [-123.6853, 38.89648], [-123.68339, 38.89464], [-123.68665, 38.89209], [-123.68674, 38.89243], [-123.687, 38.89272], [-123.68732, 38.89305], [-123.6881, 38.8935], [-123.68935, 38.89412], [-123.68975, 38.89423], [-123.69062, 38.89436], [-123.69119, 38.89451], [-123.69155, 38.89485], [-123.69225, 38.89544], [-123.69266, 38.89574], [-123.69321, 38.89625], [-123.69334, 38.89646]]]} Open Access 1 47883 Pelican Bluffs Reserve 31827 3128 Mendocino Land Trust 500 Non Profit 6 Non Profit - Land Trust 10 http://mendocinolandtrust.org/ Non Governmental Organization 10 3128 Mendocino Land Trust 492 Non Profit 6 Non Profit - Land Trust 10 https://www.mendocinolandtrust.org/explore/explore-our-lands/pelican-bluffs/ Mendocino 24 76.551 Pelican Bluffs Reserve 2013 Private Conservation 16 2
5887 5887 5886 {"type": "Polygon", "coordinates": [[[-123.76772, 39.55769], [-123.76768, 39.55797], [-123.76746, 39.55836], [-123.76737, 39.55841], [-123.76706, 39.55853], [-123.76689, 39.55864], [-123.76691, 39.55873], [-123.76701, 39.55888], [-123.76702, 39.55897], [-123.76695, 39.55912], [-123.7669, 39.55915], [-123.76663, 39.55918], [-123.76648, 39.55917], [-123.76612, 39.55899], [-123.76591, 39.55893], [-123.76587, 39.55894], [-123.76581, 39.55891], [-123.76541, 39.55901], [-123.76476, 39.55906], [-123.7634, 39.55846], [-123.76336, 39.55736], [-123.76358, 39.55752], [-123.76379, 39.55765], [-123.76399, 39.55772], [-123.76451, 39.55785], [-123.76453, 39.55769], [-123.76568, 39.55772], [-123.76569, 39.5577], [-123.76614, 39.55772], [-123.76645, 39.55776], [-123.76694, 39.55771], [-123.76772, 39.55769]]]} Open Access 1 46782 Seaside Beach 30236 3128 Mendocino Land Trust 500 Non Profit 6 Non Profit - Land Trust 10 http://mendocinolandtrust.org/ Non Governmental Organization 10 3128 Mendocino Land Trust 492 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 11.569 Seaside Beach 0 Private Conservation 16 2
5888 5888 5887 {"type": "Polygon", "coordinates": [[[-123.81194, 39.41802], [-123.81192, 39.41832], [-123.81151, 39.41794], [-123.81066, 39.41825], [-123.80979, 39.41781], [-123.8096, 39.41781], [-123.80926, 39.41831], [-123.80924, 39.41858], [-123.8092, 39.41858], [-123.80811, 39.41948], [-123.80819, 39.41855], [-123.80851, 39.4185], [-123.80906, 39.41793], [-123.80955, 39.41729], [-123.81153, 39.41745], [-123.81173, 39.41784], [-123.81194, 39.41802]]]} Open Access 1 46784 Hare Creek Beach 30238 3128 Mendocino Land Trust 500 Non Profit 6 Non Profit - Land Trust 10 http://mendocinolandtrust.org/ Non Governmental Organization 10 3128 Mendocino Land Trust 492 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 5.825 Hare Creek Beach 0 Private Conservation 16 2
12689 12689 12688 {"type": "Polygon", "coordinates": [[[-123.77319, 39.19854], [-123.77315, 39.19856], [-123.77313, 39.19859], [-123.77318, 39.19869], [-123.7731, 39.19881], [-123.77295, 39.19886], [-123.77288, 39.19886], [-123.77285, 39.19891], [-123.77267, 39.19894], [-123.77259, 39.19893], [-123.77246, 39.19886], [-123.77217, 39.19865], [-123.7721, 39.19858], [-123.77207, 39.19853], [-123.77206, 39.19845], [-123.77192, 39.19842], [-123.77169, 39.19843], [-123.77154, 39.19849], [-123.7715, 39.19853], [-123.77131, 39.19859], [-123.7713, 39.19863], [-123.77134, 39.19871], [-123.77132, 39.19875], [-123.77116, 39.19882], [-123.77099, 39.19883], [-123.77066, 39.19902], [-123.77055, 39.19906], [-123.77038, 39.19915], [-123.7703, 39.19921], [-123.77022, 39.19938], [-123.77021, 39.19951], [-123.77023, 39.19957], [-123.77057, 39.1998], [-123.7706, 39.19987], [-123.77059, 39.19997], [-123.77056, 39.20001], [-123.77056, 39.20005], [-123.77067, 39.20013], [-123.77065, 39.20018], [-123.77059, 39.20022], [-123.77032, 39.20016], [-123.7703, 39.20021], [-123.77034, 39.20026], [-123.7706, 39.20034], [-123.77093, 39.20048], [-123.77104, 39.20063], [-123.77104, 39.2007], [-123.77097, 39.20091], [-123.77097, 39.20098], [-123.771, 39.20105], [-123.77112, 39.20119], [-123.77115, 39.20125], [-123.77114, 39.20139], [-123.77107, 39.20142], [-123.77102, 39.2014], [-123.77098, 39.20136], [-123.77092, 39.20123], [-123.77075, 39.2012], [-123.77056, 39.20126], [-123.77046, 39.20134], [-123.77045, 39.20141], [-123.77036, 39.20145], [-123.77024, 39.2014], [-123.77007, 39.2014], [-123.76996, 39.20136], [-123.7699, 39.20138], [-123.7699, 39.20144], [-123.76998, 39.20155], [-123.76994, 39.20157], [-123.76976, 39.20157], [-123.7697, 39.2016], [-123.76967, 39.20165], [-123.76967, 39.20176], [-123.76965, 39.20182], [-123.76966, 39.20191], [-123.76972, 39.20199], [-123.76983, 39.20207], [-123.76989, 39.20217], [-123.76993, 39.20221], [-123.77003, 39.20222], [-123.77009, 39.20227], [-123.77012, 39.20232], [-123.77009, 39.20244], [-123.7701, 39.20249], [-123.76897, 39.20249], [-123.7688, 39.20209], [-123.76846, 39.20161], [-123.76795, 39.20091], [-123.76759, 39.20046], [-123.76722, 39.20004], [-123.76712, 39.19924], [-123.76704, 39.19901], [-123.76691, 39.19883], [-123.76685, 39.19856], [-123.76682, 39.19828], [-123.76685, 39.19804], [-123.76729, 39.19757], [-123.76746, 39.19727], [-123.76748, 39.19691], [-123.76721, 39.19615], [-123.76708, 39.19595], [-123.76689, 39.19576], [-123.76663, 39.19554], [-123.76622, 39.19532], [-123.76579, 39.19518], [-123.7717, 39.19503], [-123.77175, 39.19513], [-123.77173, 39.19522], [-123.7717, 39.19529], [-123.77154, 39.1953], [-123.77125, 39.19538], [-123.77115, 39.19537], [-123.771, 39.19531], [-123.77092, 39.1953], [-123.77084, 39.19533], [-123.77081, 39.19536], [-123.7708, 39.19541], [-123.77082, 39.19545], [-123.77088, 39.19555], [-123.77093, 39.1956], [-123.77112, 39.19573], [-123.77117, 39.19579], [-123.77118, 39.19597], [-123.77116, 39.19607], [-123.7711, 39.1962], [-123.77107, 39.19633], [-123.77098, 39.19642], [-123.77086, 39.19659], [-123.77081, 39.19671], [-123.77076, 39.19685], [-123.77078, 39.19702], [-123.7709, 39.19719], [-123.77098, 39.19727], [-123.7713, 39.19744], [-123.77192, 39.19764], [-123.77203, 39.19775], [-123.77222, 39.19784], [-123.77225, 39.19794], [-123.77232, 39.19795], [-123.77234, 39.1979], [-123.77237, 39.1979], [-123.77249, 39.19799], [-123.77259, 39.198], [-123.77273, 39.19797], [-123.77288, 39.19805], [-123.77288, 39.19809], [-123.77284, 39.19811], [-123.77284, 39.19813], [-123.77307, 39.19823], [-123.77305, 39.19829], [-123.77317, 39.19833], [-123.77321, 39.19844], [-123.77319, 39.19854]]]} Open Access 1 29684 Navarro Point Preserve 22677 3128 Mendocino Land Trust 500 Non Profit 6 Non Profit - Land Trust 10 http://mendocinolandtrust.org/ Non Governmental Organization 10 3128 Mendocino Land Trust 492 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 62.511 Navarro Point Preserve 0 Private Conservation 16 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]);