units_with_maps

Table actions

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

1 row where COUNTY = 12, DES_TP = 132 and MNG_AGENCY = 47

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 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
16497 16497 16496 {"type": "MultiPolygon", "coordinates": [[[[-121.76916, 37.88188], [-121.76914, 37.89612], [-121.75097, 37.89593], [-121.75098, 37.90484], [-121.75026, 37.9055], [-121.75025, 37.90582], [-121.74955, 37.90609], [-121.74904, 37.9068], [-121.74904, 37.90696], [-121.74851, 37.90791], [-121.74749, 37.90823], [-121.74165, 37.90856], [-121.74111, 37.90882], [-121.73821, 37.91059], [-121.73742, 37.91062], [-121.73719, 37.91056], [-121.73588, 37.91054], [-121.73459, 37.91001], [-121.7338, 37.91041], [-121.73378, 37.91021], [-121.7324, 37.90814], [-121.733, 37.90708], [-121.73281, 37.90639], [-121.73169, 37.90549], [-121.73062, 37.90418], [-121.73149, 37.90344], [-121.73281, 37.90386], [-121.73417, 37.90511], [-121.73587, 37.90539], [-121.73671, 37.90545], [-121.7377, 37.90457], [-121.73927, 37.90374], [-121.73926, 37.90372], [-121.73658, 37.90228], [-121.73512, 37.90208], [-121.73464, 37.9019], [-121.73453, 37.90191], [-121.734, 37.9014], [-121.73294, 37.90128], [-121.7327, 37.90074], [-121.73293, 37.89974], [-121.73569, 37.90006], [-121.73639, 37.89945], [-121.73639, 37.89943], [-121.73641, 37.89943], [-121.73691, 37.899], [-121.73785, 37.89861], [-121.73873, 37.89784], [-121.73884, 37.89759], [-121.73888, 37.89722], [-121.73879, 37.89696], [-121.73859, 37.89674], [-121.73841, 37.89664], [-121.73798, 37.89652], [-121.73778, 37.89654], [-121.73733, 37.89666], [-121.73709, 37.89686], [-121.73695, 37.89711], [-121.73696, 37.89746], [-121.73722, 37.89786], [-121.73758, 37.89805], [-121.73761, 37.89812], [-121.73753, 37.89825], [-121.73675, 37.89866], [-121.73626, 37.89844], [-121.73538, 37.89833], [-121.73487, 37.89846], [-121.73296, 37.89796], [-121.73332, 37.8975], [-121.73268, 37.89685], [-121.73187, 37.8969], [-121.73178, 37.89652], [-121.73092, 37.89651], [-121.73023, 37.89588], [-121.72966, 37.89552], [-121.72947, 37.89506], [-121.72949, 37.89439], [-121.7296, 37.8941], [-121.73043, 37.8937], [-121.73029, 37.89364], [-121.73023, 37.89269], [-121.72971, 37.89225], [-121.72822, 37.89173], [-121.72737, 37.89176], [-121.7261, 37.89228], [-121.72578, 37.89261], [-121.72485, 37.89302], [-121.7241, 37.89318], [-121.72353, 37.89316], [-121.72294, 37.89317], [-121.72241, 37.89338], [-121.72167, 37.89396], [-121.7206, 37.89424], [-121.71992, 37.89431], [-121.71888, 37.89541], [-121.71816, 37.89604], [-121.72036, 37.90067], [-121.72015, 37.9008], [-121.71889, 37.89825], [-121.71772, 37.89563], [-121.7179, 37.89537], [-121.71818, 37.89508], [-121.71805, 37.89499], [-121.71905, 37.89394], [-121.7193, 37.89364], [-121.71955, 37.89325], [-121.71981, 37.89273], [-121.71979, 37.89273], [-121.71927, 37.89333], [-121.71878, 37.89385], [-121.71853, 37.894], [-121.71789, 37.89236], [-121.71772, 37.89124], [-121.71754, 37.89045], [-121.71512, 37.88958], [-121.71493, 37.88961], [-121.71412, 37.88949], [-121.71364, 37.88967], [-121.71285, 37.89042], [-121.71181, 37.89162], [-121.71265, 37.89219], [-121.71354, 37.89221], [-121.71228, 37.89226], [-121.71216, 37.89218], [-121.7118, 37.89217], [-121.71026, 37.89233], [-121.7101, 37.89263], [-121.70931, 37.8916], [-121.70734, 37.88984], [-121.70475, 37.88812], [-121.70435, 37.88793], [-121.70133, 37.887], [-121.69927, 37.88643], [-121.6965, 37.88605], [-121.69644, 37.87992], [-121.69648, 37.87984], [-121.6965, 37.87984], [-121.69664, 37.87954], [-121.69731, 37.87767], [-121.69804, 37.87629], [-121.69805, 37.87557], [-121.69781, 37.87532], [-121.69865, 37.87416], [-121.69922, 37.87383], [-121.69932, 37.87341], [-121.70562, 37.87326], [-121.71085, 37.87599], [-121.71241, 37.87628], [-121.71495, 37.87522], [-121.71621, 37.87378], [-121.71734, 37.87308], [-121.71779, 37.87247], [-121.71678, 37.87066], [-121.71726, 37.87076], [-121.71727, 37.87075], [-121.71714, 37.87064], [-121.72156, 37.87042], [-121.72241, 37.86908], [-121.72661, 37.86869], [-121.72767, 37.86754], [-121.72849, 37.86755], [-121.72839, 37.86855], [-121.72464, 37.87106], [-121.72453, 37.87169], [-121.72368, 37.8715], [-121.72358, 37.87352], [-121.72227, 37.87379], [-121.72191, 37.87499], [-121.72354, 37.87434], [-121.73263, 37.87057], [-121.73273, 37.87056], [-121.73274, 37.87068], [-121.73275, 37.87069], [-121.73522, 37.87042], [-121.73551, 37.87044], [-121.73602, 37.87055], [-121.7368, 37.87085], [-121.73746, 37.87094], [-121.74193, 37.87086], [-121.74216, 37.87071], [-121.74206, 37.86786], [-121.74278, 37.86784], [-121.75124, 37.86778], [-121.75129, 37.87035], [-121.7509, 37.88191], [-121.76916, 37.88188]], [[-121.72989, 37.87795], [-121.72888, 37.87389], [-121.72791, 37.87413], [-121.72768, 37.87376], [-121.72762, 37.87292], [-121.7249, 37.87396], [-121.72074, 37.87604], [-121.72065, 37.87755], [-121.72071, 37.88032], [-121.71994, 37.88119], [-121.721, 37.8834], [-121.7212, 37.88442], [-121.72195, 37.88702], [-121.7216, 37.88753], [-121.72105, 37.88781], [-121.72105, 37.88859], [-121.72069, 37.88896], [-121.72071, 37.88961], [-121.72053, 37.88984], [-121.72031, 37.89033], [-121.72023, 37.89086], [-121.72039, 37.89119], [-121.72026, 37.89166], [-121.71998, 37.89209], [-121.71985, 37.89266], [-121.72, 37.89271], [-121.72037, 37.89221], [-121.72062, 37.89228], [-121.7206, 37.8922], [-121.72108, 37.89108], [-121.72081, 37.8909], [-121.72106, 37.88966], [-121.72131, 37.88917], [-121.72243, 37.88963], [-121.72449, 37.89061], [-121.7245, 37.89061], [-121.72517, 37.89091], [-121.72504, 37.89143], [-121.7251, 37.89199], [-121.72569, 37.89226], [-121.72603, 37.89214], [-121.7272, 37.8911], [-121.72906, 37.88867], [-121.72917, 37.88626], [-121.72919, 37.88624], [-121.72918, 37.88615], [-121.7292, 37.88564], [-121.72869, 37.88512], [-121.72821, 37.88069], [-121.72934, 37.88096], [-121.73016, 37.88045], [-121.73029, 37.87953], [-121.73013, 37.8789], [-121.73025, 37.8782], [-121.72989, 37.87795]]], [[[-121.70864, 37.89362], [-121.70821, 37.89378], [-121.70596, 37.89347], [-121.70465, 37.89347], [-121.70353, 37.89261], [-121.70236, 37.89271], [-121.70206, 37.89352], [-121.70138, 37.89329], [-121.69963, 37.89334], [-121.69885, 37.89303], [-121.69826, 37.8933], [-121.69657, 37.89287], [-121.6966, 37.8896], [-121.69673, 37.88959], [-121.6969, 37.88776], [-121.69926, 37.88747], [-121.70132, 37.88772], [-121.70236, 37.88812], [-121.70347, 37.88869], [-121.7044, 37.88921], [-121.70526, 37.88983], [-121.70508, 37.89036], [-121.70526, 37.89082], [-121.70624, 37.89158], [-121.70661, 37.89161], [-121.70864, 37.89362]]], [[[-121.7189, 37.90153], [-121.71846, 37.90179], [-121.71729, 37.90067], [-121.71669, 37.89892], [-121.71677, 37.89873], [-121.71685, 37.8988], [-121.71712, 37.89885], [-121.71726, 37.89892], [-121.71778, 37.89951], [-121.71828, 37.9002], [-121.7189, 37.90153]]], [[[-121.7199, 37.90094], [-121.71974, 37.90104], [-121.71916, 37.89999], [-121.71891, 37.89962], [-121.71795, 37.89834], [-121.71728, 37.89751], [-121.71775, 37.89638], [-121.71859, 37.89827], [-121.7199, 37.90094]]]]} No Public Access 3 5358 Marsh Creek State Historic Park 30633 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   Contra Costa 12 3679.382 Marsh Creek SHP 1981 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]);