units_with_maps

Table actions

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

2 rows where COUNTY = 34 and DES_TP = 132

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Historic or Cultural Area · 2 ✖

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
16507 16507 16506 {"type": "Polygon", "coordinates": [[[-120.88466, 38.80613], [-120.88389, 38.8064], [-120.88376, 38.80648], [-120.88403, 38.80676], [-120.88401, 38.80717], [-120.88417, 38.80751], [-120.8842, 38.80767], [-120.8835, 38.80852], [-120.88327, 38.80922], [-120.88281, 38.80961], [-120.88245, 38.81024], [-120.88229, 38.81027], [-120.88208, 38.80991], [-120.88208, 38.80967], [-120.88179, 38.80972], [-120.88164, 38.81056], [-120.88155, 38.81067], [-120.88135, 38.811], [-120.88161, 38.81133], [-120.88155, 38.81153], [-120.88154, 38.81163], [-120.87937, 38.81146], [-120.87948, 38.80775], [-120.8772, 38.80763], [-120.87708, 38.81127], [-120.87401, 38.81112], [-120.87186, 38.81095], [-120.87183, 38.8106], [-120.8717, 38.81026], [-120.87165, 38.80961], [-120.87168, 38.8094], [-120.87211, 38.80908], [-120.87179, 38.80855], [-120.87222, 38.80834], [-120.87239, 38.80802], [-120.87231, 38.80746], [-120.87188, 38.80716], [-120.87149, 38.8071], [-120.87136, 38.80687], [-120.87121, 38.80651], [-120.87096, 38.80632], [-120.87109, 38.80601], [-120.87112, 38.80574], [-120.87132, 38.80528], [-120.87168, 38.80496], [-120.87174, 38.80459], [-120.87243, 38.8042], [-120.87287, 38.80388], [-120.87296, 38.80367], [-120.87319, 38.80353], [-120.87381, 38.8033], [-120.87401, 38.80316], [-120.87436, 38.80289], [-120.87461, 38.80258], [-120.87488, 38.80229], [-120.87533, 38.80206], [-120.87557, 38.80203], [-120.87598, 38.80177], [-120.87643, 38.80144], [-120.87742, 38.80116], [-120.87889, 38.80033], [-120.88059, 38.79966], [-120.88126, 38.79967], [-120.88149, 38.79981], [-120.88196, 38.79991], [-120.88206, 38.79991], [-120.88202, 38.80143], [-120.883, 38.80291], [-120.88298, 38.80309], [-120.88322, 38.80353], [-120.88347, 38.80389], [-120.88365, 38.80404], [-120.88372, 38.80426], [-120.8836, 38.80465], [-120.88343, 38.80494], [-120.88339, 38.80507], [-120.88355, 38.80513], [-120.88421, 38.80509], [-120.88429, 38.80524], [-120.8843, 38.80566], [-120.88459, 38.80583], [-120.88466, 38.80613]]]} Open Access 1 25795 Marshall Gold Discovery State Historic Park 1624 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=484 El Dorado 34 246.831 Marshall Gold Discovery SHP 1889 State Historic or Cultural Area 132 4
16512 16512 16511 {"type": "MultiPolygon", "coordinates": [[[[-120.89139, 38.80075], [-120.89075, 38.80132], [-120.88998, 38.8008], [-120.88994, 38.80071], [-120.88952, 38.80054], [-120.88893, 38.80026], [-120.88822, 38.80082], [-120.88761, 38.80067], [-120.88822, 38.79962], [-120.88818, 38.79958], [-120.88861, 38.79888], [-120.88864, 38.79893], [-120.88903, 38.79917], [-120.89003, 38.7999], [-120.88982, 38.80009], [-120.88915, 38.79964], [-120.8891, 38.79966], [-120.88911, 38.79968], [-120.88938, 38.79989], [-120.88936, 38.79991], [-120.88936, 38.79992], [-120.8898, 38.8002], [-120.8901, 38.79995], [-120.89105, 38.80052], [-120.89139, 38.80075]]], [[[-120.89559, 38.80731], [-120.89558, 38.80843], [-120.89478, 38.80842], [-120.89478, 38.80808], [-120.89466, 38.80797], [-120.89451, 38.80796], [-120.89445, 38.80783], [-120.89443, 38.80768], [-120.89445, 38.80751], [-120.89445, 38.8073], [-120.89451, 38.80709], [-120.89447, 38.80689], [-120.89444, 38.80682], [-120.89455, 38.80668], [-120.89447, 38.80663], [-120.89277, 38.80739], [-120.89208, 38.80653], [-120.89205, 38.80591], [-120.89198, 38.8058], [-120.89178, 38.80566], [-120.89113, 38.80561], [-120.89024, 38.80521], [-120.88953, 38.80484], [-120.889, 38.80477], [-120.8889, 38.80428], [-120.88877, 38.80415], [-120.88847, 38.80401], [-120.88831, 38.8038], [-120.88818, 38.80356], [-120.8878, 38.80321], [-120.8879, 38.80314], [-120.88814, 38.80285], [-120.88891, 38.80258], [-120.88914, 38.80265], [-120.89048, 38.80185], [-120.89071, 38.80201], [-120.89086, 38.80222], [-120.89129, 38.80265], [-120.89152, 38.80293], [-120.89156, 38.8031], [-120.8915, 38.80363], [-120.89157, 38.80399], [-120.89175, 38.80419], [-120.89192, 38.80434], [-120.89217, 38.80478], [-120.89233, 38.80496], [-120.89253, 38.80512], [-120.89275, 38.80522], [-120.89309, 38.80545], [-120.89345, 38.80563], [-120.89371, 38.80582], [-120.89408, 38.80624], [-120.89447, 38.80662], [-120.89468, 38.80653], [-120.89559, 38.80731]]], [[[-120.88963, 38.79564], [-120.88881, 38.79535], [-120.88867, 38.79521], [-120.88851, 38.79498], [-120.88878, 38.79449], [-120.88911, 38.79433], [-120.88947, 38.7943], [-120.88949, 38.79446], [-120.88968, 38.79492], [-120.88971, 38.79506], [-120.88972, 38.79534], [-120.88969, 38.7955], [-120.88963, 38.79564]]], [[[-120.89064, 38.79948], [-120.89028, 38.79979], [-120.88888, 38.79883], [-120.88909, 38.7982], [-120.88981, 38.79833], [-120.89008, 38.79835], [-120.89009, 38.79838], [-120.89021, 38.79838], [-120.89002, 38.79863], [-120.89028, 38.79877], [-120.89009, 38.79898], [-120.89027, 38.7991], [-120.89021, 38.79915], [-120.89021, 38.79917], [-120.89064, 38.79948]]], [[[-120.89017, 38.79755], [-120.88993, 38.79793], [-120.88922, 38.79781], [-120.88929, 38.79729], [-120.88937, 38.79739], [-120.89017, 38.79755]]], [[[-120.90416, 38.80323], [-120.90387, 38.80373], [-120.90367, 38.80416], [-120.90334, 38.80446], [-120.90262, 38.80481], [-120.90241, 38.80503], [-120.89977, 38.80491], [-120.89979, 38.80439], [-120.89976, 38.80438], [-120.8997, 38.80448], [-120.89842, 38.80581], [-120.89761, 38.80647], [-120.89718, 38.80729], [-120.89666, 38.80747], [-120.89647, 38.80746], [-120.89629, 38.80717], [-120.89614, 38.80682], [-120.89626, 38.8068], [-120.89626, 38.80678], [-120.89569, 38.80547], [-120.89525, 38.80452], [-120.89513, 38.80453], [-120.89461, 38.80354], [-120.89476, 38.8035], [-120.89477, 38.80349], [-120.89375, 38.80246], [-120.89327, 38.80191], [-120.8927, 38.80138], [-120.89163, 38.80063], [-120.892, 38.80026], [-120.8904, 38.79914], [-120.89156, 38.79812], [-120.89197, 38.79845], [-120.89203, 38.7984], [-120.89203, 38.79838], [-120.89163, 38.79806], [-120.89214, 38.79764], [-120.89178, 38.7974], [-120.89283, 38.79595], [-120.89297, 38.79587], [-120.89348, 38.7958], [-120.89383, 38.79546], [-120.89307, 38.79552], [-120.8927, 38.79567], [-120.89185, 38.79585], [-120.89143, 38.79573], [-120.89014, 38.79554], [-120.89007, 38.79552], [-120.89005, 38.79542], [-120.88979, 38.79549], [-120.88981, 38.7953], [-120.88978, 38.79503], [-120.88994, 38.7951], [-120.89112, 38.79527], [-120.89102, 38.79447], [-120.89084, 38.79424], [-120.89077, 38.79409], [-120.89089, 38.79384], [-120.89177, 38.79384], [-120.89177, 38.79386], [-120.89178, 38.79386], [-120.89176, 38.79428], [-120.89135, 38.79504], [-120.89129, 38.79529], [-120.89196, 38.79538], [-120.89209, 38.79538], [-120.89221, 38.79535], [-120.89252, 38.79521], [-120.89273, 38.79514], [-120.89306, 38.79508], [-120.89229, 38.79385], [-120.89574, 38.79385], [-120.90024, 38.794], [-120.89997, 38.79985], [-120.9027, 38.79998], [-120.90349, 38.80296], [-120.90416, 38.80323]]], [[[-120.891, 38.79676], [-120.89082, 38.79702], [-120.89007, 38.79687], [-120.89017, 38.7964], [-120.89025, 38.79633], [-120.89093, 38.79646], [-120.89081, 38.79674], [-120.891, 38.79676]]], [[[-120.89183, 38.80031], [-120.89146, 38.80062], [-120.89079, 38.80017], [-120.89046, 38.79991], [-120.89035, 38.79985], [-120.89073, 38.79953], [-120.89183, 38.80031]]], [[[-120.89626, 38.80745], [-120.89561, 38.80691], [-120.8956, 38.80692], [-120.89559, 38.80714], [-120.89502, 38.8066], [-120.89439, 38.80573], [-120.89407, 38.80542], [-120.89328, 38.80492], [-120.89303, 38.8047], [-120.89277, 38.80429], [-120.89255, 38.80409], [-120.89243, 38.80376], [-120.89229, 38.80352], [-120.8922, 38.80322], [-120.89211, 38.80301], [-120.89194, 38.80272], [-120.89184, 38.80238], [-120.89162, 38.8022], [-120.8912, 38.80182], [-120.89184, 38.80117], [-120.89297, 38.80184], [-120.8933, 38.80208], [-120.89436, 38.80328], [-120.89474, 38.80397], [-120.89492, 38.80457], [-120.89509, 38.80496], [-120.89508, 38.8052], [-120.8952, 38.80556], [-120.89559, 38.80632], [-120.89573, 38.80638], [-120.89626, 38.80745]]]]} Open Access 1 20500 Marshall Gold Discovery State Historic Park 1624 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=484 El Dorado 34 321.673 Marshall Gold Discovery SHP 1889 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]);