units_with_maps

Table actions

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

1 row where COUNTY = 10 and DES_TP = 132

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
16504 16504 16503 {"type": "MultiPolygon", "coordinates": [[[[-117.41584, 33.89039], [-117.41541, 33.89094], [-117.41511, 33.89107], [-117.41508, 33.89095], [-117.41518, 33.89085], [-117.41511, 33.8908], [-117.4151, 33.89068], [-117.41509, 33.89068], [-117.415, 33.89084], [-117.41493, 33.89086], [-117.41483, 33.89098], [-117.41473, 33.89083], [-117.41472, 33.89067], [-117.41463, 33.89057], [-117.41449, 33.89053], [-117.41431, 33.89018], [-117.41429, 33.89018], [-117.41437, 33.89054], [-117.41453, 33.89069], [-117.41447, 33.89082], [-117.41431, 33.89083], [-117.41431, 33.89089], [-117.41443, 33.89103], [-117.41441, 33.89119], [-117.41446, 33.89129], [-117.41441, 33.89148], [-117.41442, 33.89158], [-117.41432, 33.8916], [-117.41451, 33.89196], [-117.4144, 33.89203], [-117.41404, 33.89198], [-117.41377, 33.89199], [-117.4135, 33.89186], [-117.41354, 33.89164], [-117.4134, 33.89163], [-117.4133, 33.89157], [-117.41336, 33.89147], [-117.41333, 33.89099], [-117.41341, 33.89088], [-117.4133, 33.8907], [-117.41332, 33.89056], [-117.41309, 33.89036], [-117.413, 33.89022], [-117.41287, 33.89013], [-117.41285, 33.88996], [-117.41272, 33.89], [-117.41254, 33.89021], [-117.41235, 33.89029], [-117.41194, 33.89031], [-117.41195, 33.88993], [-117.41184, 33.88988], [-117.41186, 33.88968], [-117.41174, 33.88961], [-117.41173, 33.88952], [-117.41159, 33.88956], [-117.41158, 33.88938], [-117.41133, 33.88943], [-117.41144, 33.88925], [-117.4112, 33.88913], [-117.41128, 33.88888], [-117.41085, 33.88867], [-117.41085, 33.88845], [-117.4106, 33.88852], [-117.41048, 33.88846], [-117.41045, 33.88823], [-117.41044, 33.88823], [-117.41021, 33.88855], [-117.40998, 33.88863], [-117.40985, 33.88821], [-117.40949, 33.88808], [-117.40925, 33.88786], [-117.4093, 33.88773], [-117.40977, 33.88755], [-117.40989, 33.88734], [-117.4097, 33.88701], [-117.40964, 33.88694], [-117.41085, 33.88738], [-117.41231, 33.88798], [-117.41291, 33.88834], [-117.41352, 33.88872], [-117.41408, 33.88914], [-117.41462, 33.88949], [-117.41584, 33.89039]]], [[[-117.42825, 33.89828], [-117.42551, 33.89984], [-117.42507, 33.89982], [-117.42447, 33.89968], [-117.42413, 33.89972], [-117.42387, 33.89991], [-117.42313, 33.90089], [-117.42295, 33.9013], [-117.42102, 33.9024], [-117.41746, 33.90445], [-117.41221, 33.89813], [-117.41103, 33.89667], [-117.41409, 33.89496], [-117.41445, 33.89493], [-117.41478, 33.89496], [-117.41517, 33.89544], [-117.41526, 33.89538], [-117.41851, 33.89932], [-117.42036, 33.89826], [-117.41811, 33.89551], [-117.41837, 33.89535], [-117.4186, 33.89529], [-117.41899, 33.89581], [-117.42006, 33.89559], [-117.42029, 33.89534], [-117.42021, 33.89448], [-117.42012, 33.89439], [-117.41995, 33.89439], [-117.42013, 33.89428], [-117.42019, 33.89428], [-117.42026, 33.89429], [-117.4205, 33.8944], [-117.42072, 33.89443], [-117.42092, 33.89442], [-117.42108, 33.89436], [-117.42117, 33.8943], [-117.42124, 33.89421], [-117.42129, 33.89411], [-117.42141, 33.89401], [-117.42153, 33.89405], [-117.42195, 33.89414], [-117.42262, 33.89437], [-117.42282, 33.89463], [-117.42312, 33.89445], [-117.42341, 33.8946], [-117.42361, 33.89468], [-117.42387, 33.89474], [-117.4243, 33.89469], [-117.42455, 33.89476], [-117.42507, 33.89494], [-117.42563, 33.89526], [-117.426, 33.89556], [-117.4265, 33.89614], [-117.42825, 33.89828]]], [[[-117.4211, 33.89413], [-117.42104, 33.89421], [-117.42094, 33.89427], [-117.42079, 33.8943], [-117.42061, 33.89428], [-117.4203, 33.89417], [-117.42015, 33.89415], [-117.42014, 33.8941], [-117.41976, 33.89373], [-117.4193, 33.89373], [-117.41907, 33.89345], [-117.41869, 33.89345], [-117.41845, 33.89311], [-117.41809, 33.8932], [-117.41755, 33.89264], [-117.41759, 33.89239], [-117.418, 33.89201], [-117.41868, 33.89265], [-117.41885, 33.89297], [-117.4192, 33.8931], [-117.41938, 33.89329], [-117.41972, 33.89351], [-117.41991, 33.89358], [-117.42044, 33.89369], [-117.42069, 33.89379], [-117.42107, 33.89392], [-117.4211, 33.89413]]]]} Open Access 1 13493 California Citrus State Historic Park 1455 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=649 Riverside 10 252.338 California Citrus SHP 1984 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]);