units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, COUNTY = 12 and DES_TP = 132
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- State Historic or Cultural Area · 1 ✖
ACCESS_TYP 1
- No Public Access · 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
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]);