units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, COUNTY = 23 and DES_TP = 16

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

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
6751 6751 6750 {"type": "Polygon", "coordinates": [[[-122.49667, 37.96721], [-122.49568, 37.97019], [-122.49389, 37.96873], [-122.49305, 37.96873], [-122.49385, 37.96635], [-122.49592, 37.96699], [-122.49667, 37.96721]]]} Open Access 1 5187 San Rafael Tidelands 30323 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 18.615 San Rafael Tidelands 1978 Private Conservation 16 2
9640 9640 9639 {"type": "Polygon", "coordinates": [[[-122.4913, 37.96048], [-122.49049, 37.9606], [-122.48972, 37.96061], [-122.48972, 37.96425], [-122.48836, 37.96425], [-122.48826, 37.9606], [-122.48723, 37.96061], [-122.48721, 37.95839], [-122.49058, 37.95832], [-122.4913, 37.96048]]]} Open Access 1 16223 Marin Audubon Society 30324 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 32.569 Marin Audubon Society 0 Private Conservation 16 2
12734 12734 12733 {"type": "Polygon", "coordinates": [[[-122.47026, 38.03457], [-122.47026, 38.03457], [-122.46444, 38.03432], [-122.46746, 38.02948], [-122.47021, 38.02945], [-122.47026, 38.03457]]]} Open Access 1 29764 Water Lots 27295 3130 Marin Conservation League 1035 Non Profit 6 Non Profit - Conservation 12 http://www.marinconservationleague.org/ Non Governmental Organization 10 3130 Marin Conservation League 997 Non Profit 6 Non Profit - Conservation 12   Marin 23 51.863 Water Lots 0 Private Conservation 16 2
14822 14822 14821 {"type": "Polygon", "coordinates": [[[-122.69118, 37.9329], [-122.68888, 37.93441], [-122.67482, 37.94751], [-122.66036, 37.93681], [-122.66163, 37.93601], [-122.66163, 37.93599], [-122.65724, 37.93353], [-122.65725, 37.9335], [-122.6572, 37.93347], [-122.65775, 37.93261], [-122.65787, 37.93201], [-122.66228, 37.92912], [-122.66557, 37.92719], [-122.66568, 37.92715], [-122.66657, 37.92673], [-122.66708, 37.92652], [-122.66955, 37.92521], [-122.67289, 37.92396], [-122.67443, 37.92344], [-122.67464, 37.92389], [-122.67503, 37.92435], [-122.67516, 37.9246], [-122.67551, 37.92494], [-122.67583, 37.92515], [-122.67596, 37.92522], [-122.67608, 37.92525], [-122.67657, 37.92529], [-122.677, 37.92529], [-122.67779, 37.9252], [-122.67879, 37.92521], [-122.67907, 37.92527], [-122.67913, 37.92531], [-122.67927, 37.92537], [-122.67975, 37.92569], [-122.6799, 37.92577], [-122.68007, 37.92582], [-122.6803, 37.92595], [-122.68035, 37.926], [-122.6804, 37.92609], [-122.68043, 37.92618], [-122.68043, 37.92635], [-122.68049, 37.92644], [-122.68101, 37.927], [-122.68148, 37.92737], [-122.68185, 37.92762], [-122.68199, 37.92778], [-122.68205, 37.92791], [-122.68208, 37.92809], [-122.68207, 37.92836], [-122.68203, 37.92864], [-122.682, 37.92902], [-122.68201, 37.92914], [-122.68206, 37.92934], [-122.68211, 37.92948], [-122.68223, 37.92966], [-122.68246, 37.92987], [-122.68274, 37.93004], [-122.68314, 37.93023], [-122.68387, 37.93053], [-122.68406, 37.93058], [-122.68427, 37.9306], [-122.68457, 37.93059], [-122.68522, 37.93045], [-122.68529, 37.93085], [-122.68565, 37.93107], [-122.68592, 37.93102], [-122.68642, 37.93039], [-122.68675, 37.93041], [-122.68792, 37.93056], [-122.68821, 37.93071], [-122.68836, 37.93086], [-122.68845, 37.931], [-122.68849, 37.93113], [-122.68851, 37.93133], [-122.68849, 37.93148], [-122.68841, 37.93167], [-122.68843, 37.93199], [-122.68855, 37.93222], [-122.68876, 37.93235], [-122.68919, 37.93253], [-122.68963, 37.93266], [-122.68999, 37.9327], [-122.69036, 37.93269], [-122.69081, 37.93262], [-122.69093, 37.93264], [-122.69104, 37.93271], [-122.69118, 37.9329]]]} Open Access 1 45281 Martin Griffin Preserve 21904 3005 Audubon Canyon Ranch 837 Non Profit 6 Non Profit - Conservation 12 http://www.egret.org Non Governmental Organization 10 3005 Audubon Canyon Ranch 814 Non Profit 6 Non Profit - Conservation 12   Marin 23 1010.785 Martin Griffin 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]);