units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, AGNCY_NAME = 540 and DES_TP = 4

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

MNG_AGENCY 1

DES_TP 1

  • Local Conservation Area · 2 ✖

ACCESS_TYP 1

  • Open Access · 2 ✖
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
3634 3634 3633 {"type": "Polygon", "coordinates": [[[-121.22558, 38.7212], [-121.22557, 38.7219], [-121.22553, 38.72195], [-121.22548, 38.72198], [-121.22526, 38.72199], [-121.22513, 38.72187], [-121.22478, 38.72139], [-121.22457, 38.72123], [-121.22431, 38.72121], [-121.22422, 38.72114], [-121.22423, 38.72105], [-121.22416, 38.72097], [-121.22398, 38.72088], [-121.2239, 38.72082], [-121.22374, 38.72084], [-121.22354, 38.72096], [-121.22332, 38.72098], [-121.22298, 38.72116], [-121.22292, 38.72124], [-121.22288, 38.72142], [-121.22282, 38.72152], [-121.22271, 38.72153], [-121.22255, 38.72147], [-121.22237, 38.72146], [-121.22219, 38.72152], [-121.22204, 38.72162], [-121.22177, 38.7216], [-121.2216, 38.72165], [-121.22148, 38.72164], [-121.22137, 38.7217], [-121.22125, 38.72169], [-121.2211, 38.72161], [-121.22101, 38.72163], [-121.22093, 38.72169], [-121.22074, 38.72166], [-121.22053, 38.72148], [-121.22003, 38.72149], [-121.21996, 38.72158], [-121.21974, 38.72164], [-121.21954, 38.72159], [-121.21951, 38.72151], [-121.21914, 38.72146], [-121.21894, 38.72145], [-121.21868, 38.72137], [-121.21833, 38.72157], [-121.21802, 38.72159], [-121.21762, 38.72151], [-121.21739, 38.7215], [-121.2174, 38.7216], [-121.21726, 38.72169], [-121.21709, 38.72167], [-121.21694, 38.72156], [-121.21655, 38.72139], [-121.21655, 38.72104], [-121.21688, 38.72108], [-121.21712, 38.72103], [-121.21734, 38.72088], [-121.21758, 38.7208], [-121.2179, 38.72074], [-121.21812, 38.72076], [-121.21845, 38.72069], [-121.21894, 38.72064], [-121.21924, 38.72057], [-121.21953, 38.72046], [-121.21968, 38.72042], [-121.21984, 38.72049], [-121.21999, 38.72059], [-121.22014, 38.72063], [-121.22027, 38.72061], [-121.22046, 38.72065], [-121.22072, 38.72076], [-121.22085, 38.72077], [-121.22142, 38.72073], [-121.22148, 38.72067], [-121.22156, 38.72054], [-121.22169, 38.7205], [-121.22184, 38.72055], [-121.22202, 38.72072], [-121.22213, 38.72076], [-121.2223, 38.72068], [-121.2225, 38.72054], [-121.22275, 38.72043], [-121.22297, 38.72037], [-121.22298, 38.72028], [-121.22489, 38.72032], [-121.22489, 38.72043], [-121.22501, 38.72055], [-121.22501, 38.72071], [-121.22511, 38.72086], [-121.22548, 38.72116], [-121.22558, 38.7212]]]} Open Access 1 29448 Wetlands 27445 1285 Roseville, City of 540 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 1285 Roseville, City of 533 City 2 City Agency 2   Placer 35 18.178 Wetlands 0 Local Conservation Area 4 2
12639 12639 12638 {"type": "Polygon", "coordinates": [[[-121.30026, 38.79227], [-121.30023, 38.79305], [-121.29371, 38.78839], [-121.29355, 38.7888], [-121.29311, 38.78954], [-121.29308, 38.78965], [-121.29301, 38.79074], [-121.29284, 38.79061], [-121.29194, 38.7901], [-121.29214, 38.78992], [-121.29216, 38.78884], [-121.29193, 38.78862], [-121.29199, 38.78839], [-121.29221, 38.78817], [-121.29201, 38.78784], [-121.29298, 38.78674], [-121.29257, 38.78589], [-121.29243, 38.78543], [-121.29201, 38.78533], [-121.29208, 38.78461], [-121.29138, 38.78388], [-121.2904, 38.78326], [-121.29028, 38.78266], [-121.29035, 38.78211], [-121.29021, 38.78146], [-121.2901, 38.78134], [-121.28912, 38.78136], [-121.2884, 38.78154], [-121.28729, 38.78154], [-121.28732, 38.78083], [-121.28738, 38.78036], [-121.28745, 38.78003], [-121.28755, 38.77972], [-121.28865, 38.77989], [-121.28946, 38.77918], [-121.28969, 38.7793], [-121.29091, 38.78004], [-121.29051, 38.78043], [-121.2908, 38.78103], [-121.29073, 38.78109], [-121.2908, 38.78127], [-121.29081, 38.78144], [-121.29069, 38.78285], [-121.29072, 38.783], [-121.29076, 38.78306], [-121.29113, 38.78323], [-121.29119, 38.78326], [-121.29135, 38.78326], [-121.29152, 38.7833], [-121.29174, 38.78342], [-121.29181, 38.78349], [-121.29244, 38.78452], [-121.29279, 38.78471], [-121.29336, 38.78479], [-121.29425, 38.78549], [-121.29444, 38.78608], [-121.29373, 38.78639], [-121.29385, 38.78769], [-121.30026, 38.79227]]]} Open Access 1 29463 Wetlands 27445 1285 Roseville, City of 540 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 1285 Roseville, City of 533 City 2 City Agency 2   Placer 35 50.045 Wetlands 0 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]);