units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 43 and YR_EST = 1986

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 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
15866 15866 15865 {"type": "Polygon", "coordinates": [[[-122.56426, 38.11867], [-122.56314, 38.11914], [-122.56283, 38.11934], [-122.5624, 38.11973], [-122.5619, 38.12009], [-122.56146, 38.12059], [-122.56117, 38.12076], [-122.56075, 38.12092], [-122.56043, 38.1212], [-122.56016, 38.12134], [-122.55997, 38.12147], [-122.55968, 38.12173], [-122.55946, 38.12189], [-122.55916, 38.12206], [-122.55883, 38.12217], [-122.55698, 38.12336], [-122.55627, 38.12376], [-122.55494, 38.12443], [-122.55479, 38.12463], [-122.55471, 38.12543], [-122.55461, 38.12583], [-122.55451, 38.12599], [-122.55407, 38.12627], [-122.55373, 38.12644], [-122.55363, 38.12652], [-122.55353, 38.12664], [-122.55342, 38.1268], [-122.55333, 38.12702], [-122.55331, 38.12717], [-122.55338, 38.12749], [-122.5534, 38.12778], [-122.55337, 38.12806], [-122.5533, 38.12833], [-122.55319, 38.1286], [-122.55303, 38.12886], [-122.5528, 38.12908], [-122.55253, 38.12927], [-122.55223, 38.12943], [-122.55143, 38.12967], [-122.55096, 38.1297], [-122.55078, 38.12973], [-122.5503, 38.12992], [-122.54981, 38.13005], [-122.54935, 38.13007], [-122.54928, 38.13019], [-122.55047, 38.13066], [-122.5504, 38.13089], [-122.55002, 38.13086], [-122.5495, 38.1309], [-122.54921, 38.13099], [-122.54902, 38.13111], [-122.54884, 38.13126], [-122.54877, 38.13153], [-122.5487, 38.13201], [-122.54863, 38.13236], [-122.54851, 38.13265], [-122.54827, 38.13289], [-122.54743, 38.13363], [-122.54686, 38.13444], [-122.54673, 38.1345], [-122.54609, 38.13407], [-122.54517, 38.13326], [-122.54513, 38.13236], [-122.5441, 38.13187], [-122.54362, 38.13132], [-122.54335, 38.13137], [-122.54291, 38.13111], [-122.54275, 38.13031], [-122.5422, 38.13015], [-122.54185, 38.13049], [-122.54104, 38.13065], [-122.54049, 38.13109], [-122.53973, 38.13088], [-122.54032, 38.12927], [-122.53981, 38.1292], [-122.5393, 38.12958], [-122.53873, 38.12945], [-122.53879, 38.12859], [-122.5385, 38.12842], [-122.53742, 38.12933], [-122.5373, 38.12998], [-122.53646, 38.12992], [-122.53567, 38.12921], [-122.53627, 38.128], [-122.53585, 38.12769], [-122.53505, 38.12788], [-122.5334, 38.12854], [-122.53313, 38.12884], [-122.53282, 38.12892], [-122.53141, 38.12872], [-122.53068, 38.12816], [-122.5306, 38.12771], [-122.53123, 38.12743], [-122.53128, 38.12672], [-122.53174, 38.12628], [-122.5316, 38.12597], [-122.53105, 38.1257], [-122.53028, 38.12608], [-122.52946, 38.1261], [-122.52921, 38.1265], [-122.52774, 38.12624], [-122.52769, 38.12612], [-122.52811, 38.12602], [-122.52817, 38.12604], [-122.5282, 38.12609], [-122.52839, 38.12605], [-122.52839, 38.126], [-122.52843, 38.12597], [-122.52959, 38.12571], [-122.52995, 38.12558], [-122.53021, 38.12542], [-122.53043, 38.12524], [-122.53112, 38.12446], [-122.53137, 38.12425], [-122.53163, 38.12411], [-122.53262, 38.12368], [-122.53441, 38.12323], [-122.53474, 38.12317], [-122.53496, 38.12317], [-122.53723, 38.1233], [-122.53762, 38.12329], [-122.53799, 38.12322], [-122.53827, 38.12313], [-122.53861, 38.12298], [-122.53884, 38.12283], [-122.53928, 38.12244], [-122.53962, 38.12221], [-122.53999, 38.122], [-122.54053, 38.12175], [-122.54066, 38.12196], [-122.54096, 38.12226], [-122.54108, 38.12227], [-122.54136, 38.12234], [-122.54174, 38.12234], [-122.54205, 38.12455], [-122.54072, 38.12551], [-122.54003, 38.12656], [-122.54091, 38.12676], [-122.54137, 38.1259], [-122.54214, 38.12595], [-122.54324, 38.12758], [-122.54377, 38.12621], [-122.5444, 38.12597], [-122.54441, 38.12587], [-122.54509, 38.126], [-122.54568, 38.1259], [-122.54572, 38.1253], [-122.54594, 38.12499], [-122.54605, 38.12439], [-122.54622, 38.12407], [-122.54625, 38.12373], [-122.54621, 38.12294], [-122.54713, 38.12221], [-122.54701, 38.122], [-122.54712, 38.12195], [-122.54737, 38.12225], [-122.54772, 38.1224], [-122.54831, 38.12184], [-122.54831, 38.12182], [-122.54783, 38.12136], [-122.54797, 38.1212], [-122.55038, 38.12199], [-122.5508, 38.12068], [-122.55091, 38.12045], [-122.55091, 38.12041], [-122.55155, 38.12072], [-122.55226, 38.12038], [-122.55289, 38.12], [-122.55381, 38.12032], [-122.55415, 38.12014], [-122.55478, 38.12019], [-122.55524, 38.12011], [-122.55533, 38.11963], [-122.55549, 38.1196], [-122.55569, 38.11969], [-122.55842, 38.11911], [-122.55843, 38.1191], [-122.55817, 38.11854], [-122.55787, 38.11854], [-122.55786, 38.11848], [-122.55844, 38.11821], [-122.55919, 38.11802], [-122.55882, 38.11707], [-122.56054, 38.11662], [-122.56077, 38.11678], [-122.56136, 38.11676], [-122.5624, 38.11702], [-122.56264, 38.11754], [-122.56341, 38.1178], [-122.56376, 38.11784], [-122.56408, 38.11811], [-122.56426, 38.11867]]]} Open Access 1 299 Rush Creek Open Space Preserve 31486 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/depts/pk/divisions/open-space/rush-creek Marin 23 488.5 Rush Creek OSP 1986 Local Conservation Area 4 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]);