units_with_maps

Table actions

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

11 rows where ACCESS_TYP = 2, COUNTY = 5, MNG_AGENCY = 571 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 11 ✖

MNG_AGENCY 1

  • Sempervirens Fund · 11 ✖

DES_TP 1

ACCESS_TYP 1

  • Restricted Access · 11 ✖
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
3075 3075 3074 {"type": "Polygon", "coordinates": [[[-122.14367, 37.21657], [-122.14354, 37.21652], [-122.14303, 37.21586], [-122.14234, 37.21568], [-122.14172, 37.21539], [-122.14133, 37.21517], [-122.14115, 37.21505], [-122.14088, 37.21485], [-122.14062, 37.21462], [-122.14067, 37.21449], [-122.14068, 37.2144], [-122.14075, 37.21431], [-122.14105, 37.21399], [-122.14107, 37.21389], [-122.14322, 37.2139], [-122.14323, 37.21392], [-122.14268, 37.21489], [-122.14292, 37.21504], [-122.14326, 37.21515], [-122.14366, 37.21515], [-122.14367, 37.21657]]]} Restricted Access 2 24955 Ahlgren 15297 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 9.806 Ahlgren 0 Private Conservation 16 2
3409 3409 3408 {"type": "Polygon", "coordinates": [[[-122.14677, 37.21609], [-122.14492, 37.21731], [-122.14513, 37.21749], [-122.14534, 37.21764], [-122.14562, 37.21778], [-122.14593, 37.21799], [-122.14589, 37.21808], [-122.1437, 37.2181], [-122.14367, 37.21611], [-122.14677, 37.21609]]]} Restricted Access 2 24954 Butler 16547 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 9.721 Butler 0 Private Conservation 16 2
3450 3450 3449 {"type": "Polygon", "coordinates": [[[-122.19466, 37.15793], [-122.19268, 37.15833], [-122.19133, 37.15817], [-122.1914, 37.15754], [-122.19169, 37.15748], [-122.19213, 37.15729], [-122.19248, 37.15727], [-122.19291, 37.15713], [-122.19325, 37.15713], [-122.19388, 37.15727], [-122.19424, 37.15748], [-122.19448, 37.15752], [-122.19466, 37.15793]]]} Restricted Access 2 25308 Griffith 19515 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 6.861 Griffith 0 Private Conservation 16 2
3451 3451 3450 {"type": "Polygon", "coordinates": [[[-122.05152, 37.12104], [-122.0515, 37.1215], [-122.05057, 37.12154], [-122.05058, 37.1218], [-122.0491, 37.12186], [-122.04919, 37.12379], [-122.04898, 37.12381], [-122.04901, 37.1246], [-122.04883, 37.12461], [-122.04884, 37.12487], [-122.04845, 37.12489], [-122.04848, 37.12545], [-122.04984, 37.12541], [-122.04985, 37.12539], [-122.04982, 37.12537], [-122.05014, 37.12515], [-122.05031, 37.1248], [-122.05052, 37.12456], [-122.05067, 37.12436], [-122.05102, 37.12436], [-122.05097, 37.12503], [-122.0507, 37.12554], [-122.05058, 37.12595], [-122.05079, 37.12617], [-122.05061, 37.12666], [-122.05069, 37.12687], [-122.04892, 37.12795], [-122.04839, 37.12795], [-122.04716, 37.12854], [-122.0472, 37.13152], [-122.04443, 37.13154], [-122.04443, 37.13491], [-122.03037, 37.13484], [-122.03039, 37.12776], [-122.04031, 37.12786], [-122.04035, 37.12388], [-122.04487, 37.12392], [-122.04468, 37.11638], [-122.04681, 37.11647], [-122.0468, 37.11741], [-122.04673, 37.12022], [-122.05113, 37.12033], [-122.05127, 37.12076], [-122.05152, 37.12098], [-122.05152, 37.12104]]]} Restricted Access 2 25311 Lompico 21417 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 425.126 Lompico 0 Private Conservation 16 2
3452 3452 3451 {"type": "MultiPolygon", "coordinates": [[[[-122.10049, 37.07295], [-122.09985, 37.0722], [-122.09934, 37.07207], [-122.09895, 37.07175], [-122.09865, 37.0716], [-122.09803, 37.07107], [-122.09755, 37.0709], [-122.09716, 37.07068], [-122.09696, 37.07041], [-122.09697, 37.07011], [-122.09653, 37.06891], [-122.10038, 37.06883], [-122.10049, 37.07295]]], [[[-122.10529, 37.0809], [-122.10419, 37.08125], [-122.10419, 37.07993], [-122.10379, 37.07917], [-122.1036, 37.07849], [-122.1032, 37.0781], [-122.10321, 37.07642], [-122.10523, 37.07636], [-122.10529, 37.0809]]]]} Restricted Access 2 25312 Fall Creek 18831 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 42.071 Fall Creek 0 Private Conservation 16 2
3602 3602 3601 {"type": "Polygon", "coordinates": [[[-122.29256, 37.17984], [-122.28811, 37.17993], [-122.28801, 37.17277], [-122.29232, 37.17259], [-122.29256, 37.17984]]]} Restricted Access 2 38037 Lachenbruch 20818 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 76.858 Lachenbruch 0 Private Conservation 16 2
5435 5435 5434 {"type": "Polygon", "coordinates": [[[-122.20851, 37.20799], [-122.19951, 37.20811], [-122.19945, 37.20114], [-122.20078, 37.20112], [-122.20302, 37.20112], [-122.20315, 37.20121], [-122.20326, 37.20133], [-122.20386, 37.20156], [-122.20393, 37.20167], [-122.20396, 37.20179], [-122.20389, 37.20192], [-122.20365, 37.2021], [-122.20327, 37.20232], [-122.20324, 37.2024], [-122.20328, 37.20246], [-122.20342, 37.2025], [-122.20429, 37.2026], [-122.2047, 37.20269], [-122.20484, 37.20279], [-122.20485, 37.20287], [-122.20482, 37.20295], [-122.20458, 37.20319], [-122.20444, 37.20343], [-122.20457, 37.20383], [-122.20451, 37.20394], [-122.2044, 37.20408], [-122.20434, 37.20426], [-122.20434, 37.20436], [-122.20446, 37.20474], [-122.20473, 37.20519], [-122.20481, 37.20526], [-122.2049, 37.2053], [-122.20533, 37.20541], [-122.20539, 37.20553], [-122.20543, 37.2057], [-122.20549, 37.20585], [-122.20569, 37.20598], [-122.20589, 37.20616], [-122.20594, 37.20623], [-122.20601, 37.2064], [-122.20612, 37.20652], [-122.2062, 37.20674], [-122.20625, 37.2068], [-122.20642, 37.20685], [-122.20662, 37.20686], [-122.20684, 37.20692], [-122.20695, 37.20697], [-122.20705, 37.20705], [-122.20713, 37.20711], [-122.20727, 37.20727], [-122.20735, 37.20733], [-122.20758, 37.20741], [-122.20789, 37.20746], [-122.20809, 37.20755], [-122.20844, 37.20777], [-122.2085, 37.20786], [-122.20851, 37.20799]]]} Restricted Access 2 24952 Minton 22271 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 95.844 Minton 0 Private Conservation 16 2
5436 5436 5435 {"type": "Polygon", "coordinates": [[[-122.09864, 37.21348], [-122.09844, 37.21693], [-122.09369, 37.21684], [-122.09402, 37.21338], [-122.09864, 37.21348]]]} Restricted Access 2 24956 Isacson 20276 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 39.497 Isacson 0 Private Conservation 16 2
5450 5450 5449 {"type": "Polygon", "coordinates": [[[-122.26016, 37.12434], [-122.26015, 37.1277], [-122.25555, 37.12715], [-122.25541, 37.12386], [-122.26016, 37.12434]]]} Restricted Access 2 24961 Katz 20559 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 37.897 Katz 0 Private Conservation 16 2
7545 7545 7544 {"type": "Polygon", "coordinates": [[[-122.15782, 37.20232], [-122.15696, 37.20481], [-122.15628, 37.20537], [-122.15672, 37.2066], [-122.15636, 37.20702], [-122.15531, 37.20745], [-122.15528, 37.20797], [-122.15568, 37.20821], [-122.15581, 37.20913], [-122.15637, 37.21034], [-122.15575, 37.2113], [-122.15528, 37.21157], [-122.15523, 37.21152], [-122.15489, 37.21163], [-122.15445, 37.21168], [-122.15414, 37.21169], [-122.1535, 37.21161], [-122.1531, 37.21163], [-122.1529, 37.2116], [-122.15234, 37.21147], [-122.15211, 37.20816], [-122.15233, 37.20055], [-122.14389, 37.20053], [-122.15304, 37.20054], [-122.15694, 37.20066], [-122.15653, 37.2011], [-122.15782, 37.20232]]]} Restricted Access 2 47615 Sempervirens 236 31349 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 115.28 Sempervirens 236 0 Private Conservation 16 2
12735 12735 12734 {"type": "Polygon", "coordinates": [[[-122.14589, 37.21808], [-122.14582, 37.21821], [-122.14578, 37.21847], [-122.14559, 37.21887], [-122.14558, 37.21907], [-122.14553, 37.21919], [-122.14372, 37.2192], [-122.1437, 37.2181], [-122.14589, 37.21808]]]} Restricted Access 2 29766 Gee 19247 3110 Sempervirens Fund 579 Non Profit 6 Non Profit - Land Trust 10 http://www.sempervirens.org/ Non Governmental Organization 10 3110 Sempervirens Fund 571 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 5.342 Gee 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]);