units_with_maps

Table actions

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

1 row where AGNCY_WEB = "http://www.slc.ca.gov/", DES_TP = 132 and LAYER = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Historic or Cultural Area · 1 ✖

ACCESS_TYP 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
16517 16517 16516 {"type": "Polygon", "coordinates": [[[-123.25504, 38.50964], [-123.25317, 38.51164], [-123.25311, 38.51157], [-123.25296, 38.51143], [-123.25282, 38.51136], [-123.25266, 38.51139], [-123.25254, 38.51138], [-123.25242, 38.51141], [-123.2523, 38.51142], [-123.25207, 38.5114], [-123.2518, 38.51119], [-123.25167, 38.51101], [-123.25154, 38.51076], [-123.25155, 38.51068], [-123.25162, 38.51061], [-123.25164, 38.51049], [-123.25157, 38.51044], [-123.25143, 38.51042], [-123.25131, 38.51047], [-123.25124, 38.51042], [-123.25122, 38.51032], [-123.25119, 38.51025], [-123.25112, 38.51018], [-123.251, 38.51022], [-123.25098, 38.51028], [-123.25093, 38.51029], [-123.25086, 38.51033], [-123.25073, 38.5103], [-123.25068, 38.51024], [-123.25051, 38.51019], [-123.2503, 38.50998], [-123.25023, 38.50994], [-123.25016, 38.50994], [-123.25007, 38.51], [-123.24994, 38.50994], [-123.24972, 38.5099], [-123.24953, 38.50992], [-123.24948, 38.50996], [-123.24949, 38.51005], [-123.24959, 38.51011], [-123.2496, 38.51017], [-123.24974, 38.51056], [-123.24986, 38.5108], [-123.2498, 38.51104], [-123.24951, 38.51125], [-123.24945, 38.5115], [-123.24949, 38.51175], [-123.24894, 38.51191], [-123.24857, 38.51197], [-123.24852, 38.51192], [-123.24845, 38.51197], [-123.24847, 38.51199], [-123.24827, 38.51203], [-123.24821, 38.51202], [-123.24819, 38.51205], [-123.2482, 38.51208], [-123.24723, 38.51306], [-123.24689, 38.51304], [-123.24679, 38.51309], [-123.24679, 38.51312], [-123.24675, 38.51314], [-123.2467, 38.51316], [-123.24668, 38.51315], [-123.24641, 38.51328], [-123.24579, 38.51292], [-123.24556, 38.51256], [-123.24547, 38.51238], [-123.24537, 38.51205], [-123.24519, 38.51189], [-123.24508, 38.51184], [-123.24495, 38.51182], [-123.24474, 38.51162], [-123.24457, 38.51159], [-123.24433, 38.51157], [-123.24418, 38.51159], [-123.24402, 38.51173], [-123.24392, 38.51189], [-123.24376, 38.51202], [-123.24368, 38.512], [-123.24341, 38.512], [-123.24323, 38.51196], [-123.24295, 38.51183], [-123.24278, 38.51181], [-123.24261, 38.51176], [-123.24241, 38.51159], [-123.24226, 38.51137], [-123.24221, 38.51092], [-123.24231, 38.51062], [-123.24244, 38.51051], [-123.24268, 38.5104], [-123.24265, 38.51026], [-123.24255, 38.51017], [-123.24247, 38.51014], [-123.24235, 38.51006], [-123.24215, 38.51007], [-123.24184, 38.50994], [-123.24173, 38.50988], [-123.24155, 38.50986], [-123.24132, 38.50989], [-123.24115, 38.50994], [-123.24093, 38.50995], [-123.24084, 38.5099], [-123.2407, 38.50974], [-123.24067, 38.50958], [-123.2407, 38.50947], [-123.24079, 38.50943], [-123.24086, 38.50936], [-123.2409, 38.50929], [-123.24083, 38.50927], [-123.24073, 38.50928], [-123.24066, 38.50922], [-123.24056, 38.50904], [-123.24042, 38.50898], [-123.24033, 38.50899], [-123.24026, 38.50915], [-123.24022, 38.5092], [-123.24025, 38.50923], [-123.24027, 38.50928], [-123.24003, 38.50938], [-123.23983, 38.50942], [-123.23964, 38.50951], [-123.23942, 38.50957], [-123.23909, 38.5098], [-123.2389, 38.50989], [-123.23865, 38.50988], [-123.2385, 38.50986], [-123.23835, 38.50989], [-123.23818, 38.50989], [-123.23781, 38.50979], [-123.23759, 38.50969], [-123.23748, 38.50947], [-123.2373, 38.50929], [-123.23692, 38.50926], [-123.23936, 38.50656], [-123.23947, 38.50672], [-123.23963, 38.50704], [-123.23985, 38.50738], [-123.24024, 38.50758], [-123.24058, 38.50768], [-123.2408, 38.50769], [-123.24083, 38.50752], [-123.24069, 38.50732], [-123.24056, 38.5072], [-123.24055, 38.50706], [-123.24072, 38.50699], [-123.24092, 38.50705], [-123.24112, 38.50724], [-123.24138, 38.50793], [-123.24161, 38.50841], [-123.24179, 38.50855], [-123.24208, 38.50865], [-123.24256, 38.50864], [-123.24276, 38.50873], [-123.24305, 38.50896], [-123.24336, 38.5091], [-123.24346, 38.50927], [-123.24341, 38.50953], [-123.24342, 38.50972], [-123.24346, 38.50989], [-123.24362, 38.50997], [-123.24383, 38.50997], [-123.24404, 38.51003], [-123.24428, 38.51011], [-123.2445, 38.51023], [-123.24474, 38.5102], [-123.24499, 38.51009], [-123.24536, 38.51004], [-123.24581, 38.51002], [-123.24616, 38.50996], [-123.24647, 38.50979], [-123.24675, 38.5096], [-123.24706, 38.50941], [-123.24727, 38.5094], [-123.2474, 38.50952], [-123.24734, 38.50962], [-123.24721, 38.50964], [-123.2472, 38.50977], [-123.24722, 38.51007], [-123.24716, 38.51027], [-123.2472, 38.51051], [-123.24721, 38.51069], [-123.24718, 38.51079], [-123.24719, 38.51094], [-123.24734, 38.51109], [-123.24761, 38.51113], [-123.24807, 38.51111], [-123.24834, 38.51106], [-123.24856, 38.51094], [-123.24869, 38.51079], [-123.24894, 38.5107], [-123.24907, 38.51058], [-123.2492, 38.5104], [-123.24919, 38.51008], [-123.24932, 38.50975], [-123.24956, 38.50958], [-123.2498, 38.50944], [-123.25022, 38.50912], [-123.25085, 38.50854], [-123.2512, 38.50844], [-123.25167, 38.50836], [-123.25199, 38.50834], [-123.25215, 38.50847], [-123.25233, 38.50847], [-123.25229, 38.50834], [-123.25213, 38.50824], [-123.25228, 38.50813], [-123.25234, 38.50796], [-123.25233, 38.50772], [-123.25251, 38.50762], [-123.25263, 38.50766], [-123.25271, 38.50781], [-123.25253, 38.50801], [-123.25251, 38.50826], [-123.25265, 38.50848], [-123.25292, 38.50858], [-123.25329, 38.5086], [-123.25353, 38.50867], [-123.25359, 38.50893], [-123.25365, 38.5095], [-123.25381, 38.50962], [-123.25406, 38.50966], [-123.25468, 38.50966], [-123.25504, 38.50964]]]} Open Access 1 45335 Fort Ross State Historic Park 1952 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=449 Sonoma 16 85.526 Fort Ross SHP 1909 State Historic or Cultural Area 132 4

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]);