superunits_with_maps

Table actions

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

5 rows where MNG_AGENCY = 551 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Non Profit - Land Trust · 5 ✖

MNG_AGENCY 1

  • Tuleyome · 5 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
3625 3625 3624 {"type": "Polygon", "coordinates": [[[-122.11064, 38.47867], [-122.11067, 38.47899], [-122.11052, 38.47933], [-122.11022, 38.47988], [-122.11006, 38.48009], [-122.10985, 38.48044], [-122.10987, 38.48056], [-122.10992, 38.48061], [-122.10989, 38.48075], [-122.10971, 38.48093], [-122.10952, 38.4811], [-122.10933, 38.48132], [-122.10919, 38.48154], [-122.10907, 38.48178], [-122.10901, 38.48214], [-122.10153, 38.48206], [-122.10152, 38.47858], [-122.11064, 38.47867]]]} Open Access 1 Cold Canyon Headwaters Property http://tuleyome.org/properties/ 33330 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 69.857 Cold Canyon Headwaters Property 2010
5362 5362 5361 {"type": "Polygon", "coordinates": [[[-122.12586, 38.58699], [-122.12577, 38.59445], [-122.12573, 38.59949], [-122.12569, 38.60202], [-122.12568, 38.60461], [-122.11735, 38.60523], [-122.11752, 38.59863], [-122.10463, 38.59864], [-122.10398, 38.58416], [-122.1085, 38.58412], [-122.10875, 38.59126], [-122.11773, 38.59115], [-122.11766, 38.59465], [-122.12183, 38.59434], [-122.12203, 38.58727], [-122.12586, 38.58699]]]} Restricted Access 2 Ireland Ranch   20229 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 582.655 Ireland Ranch  
12010 12010 12009 {"type": "Polygon", "coordinates": [[[-122.11574, 38.47849], [-122.1108, 38.47847], [-122.11074, 38.47867], [-122.09694, 38.47855], [-122.09695, 38.47505], [-122.113, 38.47524], [-122.11293, 38.47538], [-122.11294, 38.47539], [-122.1131, 38.47522], [-122.11313, 38.47502], [-122.11317, 38.47487], [-122.1155, 38.47489], [-122.11574, 38.47849]], [[-122.11094, 38.47779], [-122.11096, 38.47779], [-122.111, 38.47767], [-122.11099, 38.47768], [-122.11094, 38.47779]]]} Open Access 1 Huber Ranch http://tuleyome.org/properties/ 33327 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 154.759 Huber Ranch 2018
12033 12033 12032 {"type": "Polygon", "coordinates": [[[-122.5547, 39.07288], [-122.54077, 39.07244], [-122.52192, 39.07296], [-122.51717, 39.07356], [-122.51634, 39.05553], [-122.52099, 39.05524], [-122.52083, 39.05168], [-122.53935, 39.05086], [-122.54017, 39.06525], [-122.54047, 39.06884], [-122.55439, 39.06917], [-122.5547, 39.07288]]]} Open Access 1 Silver Spur Ranch http://tuleyome.org/properties/ 33328 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 1270.942 Silver Spur Ranch 2016
15508 15508 15507 {"type": "MultiPolygon", "coordinates": [[[[-122.72176, 39.22676], [-122.71712, 39.22651], [-122.71709, 39.23006], [-122.72173, 39.23039], [-122.72174, 39.23412], [-122.71241, 39.23361], [-122.71239, 39.22984], [-122.71238, 39.22983], [-122.70762, 39.22992], [-122.70761, 39.23359], [-122.70258, 39.23362], [-122.69033, 39.23329], [-122.6873, 39.23318], [-122.68712, 39.22951], [-122.68979, 39.22966], [-122.70275, 39.23006], [-122.70762, 39.22992], [-122.70772, 39.22628], [-122.71247, 39.22624], [-122.71253, 39.21919], [-122.72176, 39.21953], [-122.72176, 39.22676]]], [[[-122.7125, 39.2489], [-122.7031, 39.2481], [-122.70289, 39.24409], [-122.70288, 39.24064], [-122.71237, 39.24126], [-122.71233, 39.24508], [-122.7125, 39.2489]]]]} Open Access 1 Goat Mountain Property http://tuleyome.org/properties/ 33329 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 663.35 Goat Mtn. Property 2011

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);