units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, AGNCY_NAME = 279 and DES_TP = 3
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11863 | 11863 | 11862 | {"type": "MultiPolygon", "coordinates": [[[[-122.9546, 38.94653], [-122.95306, 38.94643], [-122.95002, 38.94634], [-122.94994, 38.94325], [-122.95117, 38.94382], [-122.95151, 38.94392], [-122.95178, 38.94404], [-122.95195, 38.94473], [-122.95231, 38.94518], [-122.95246, 38.94561], [-122.95267, 38.94569], [-122.95308, 38.94565], [-122.95356, 38.94572], [-122.954, 38.94569], [-122.95446, 38.94583], [-122.95479, 38.94577], [-122.95491, 38.94577], [-122.95488, 38.94585], [-122.95443, 38.94623], [-122.95442, 38.94636], [-122.95448, 38.94647], [-122.9546, 38.94653], [-122.95486, 38.94645], [-122.95501, 38.94649], [-122.95515, 38.9465], [-122.95528, 38.94648], [-122.95557, 38.94638], [-122.95626, 38.94647], [-122.95671, 38.94657], [-122.95695, 38.9467], [-122.9551, 38.94653], [-122.9546, 38.94653]]], [[[-122.90255, 38.94905], [-122.90246, 38.94915], [-122.90245, 38.94663], [-122.90226, 38.94607], [-122.90242, 38.94631], [-122.90269, 38.94661], [-122.90284, 38.94686], [-122.9029, 38.94713], [-122.90288, 38.94729], [-122.90282, 38.94745], [-122.90258, 38.94783], [-122.90255, 38.94802], [-122.90255, 38.94905]]], [[[-122.9594, 38.94295], [-122.95921, 38.94666], [-122.95716, 38.94669], [-122.95708, 38.94659], [-122.95675, 38.94644], [-122.9563, 38.94635], [-122.95558, 38.94624], [-122.9552, 38.94636], [-122.9551, 38.94636], [-122.95492, 38.94631], [-122.95471, 38.94633], [-122.95459, 38.94637], [-122.95459, 38.94629], [-122.95507, 38.94588], [-122.95509, 38.94573], [-122.95497, 38.94563], [-122.95483, 38.94563], [-122.95448, 38.9457], [-122.95402, 38.94555], [-122.95357, 38.94558], [-122.95308, 38.94551], [-122.95265, 38.94553], [-122.95251, 38.94518], [-122.95211, 38.94466], [-122.95197, 38.94404], [-122.95183, 38.94388], [-122.95123, 38.9437], [-122.94994, 38.9431], [-122.94993, 38.94274], [-122.94805, 38.94276], [-122.94813, 38.94235], [-122.94814, 38.94202], [-122.94795, 38.94159], [-122.94775, 38.94105], [-122.94758, 38.94065], [-122.94732, 38.94043], [-122.94703, 38.9403], [-122.94663, 38.94009], [-122.94605, 38.93984], [-122.945, 38.93923], [-122.9444, 38.93895], [-122.94366, 38.93876], [-122.94334, 38.93874], [-122.94304, 38.9387], [-122.9423, 38.93845], [-122.94189, 38.9383], [-122.94163, 38.93814], [-122.94133, 38.93809], [-122.94112, 38.93799], [-122.94093, 38.93783], [-122.94059, 38.93763], [-122.93991, 38.93751], [-122.93925, 38.93729], [-122.93907, 38.93727], [-122.93874, 38.93733], [-122.93835, 38.93736], [-122.938, 38.93733], [-122.93776, 38.93727], [-122.93757, 38.93712], [-122.93745, 38.93695], [-122.9373, 38.9368], [-122.93717, 38.93676], [-122.93696, 38.93669], [-122.93668, 38.9367], [-122.9364, 38.93674], [-122.93599, 38.93668], [-122.93582, 38.93659], [-122.93564, 38.9363], [-122.93527, 38.93594], [-122.93486, 38.9352], [-122.93481, 38.93473], [-122.93436, 38.93394], [-122.93405, 38.93356], [-122.93385, 38.93339], [-122.93358, 38.93321], [-122.93324, 38.93304], [-122.93278, 38.93286], [-122.93227, 38.93268], [-122.93198, 38.93252], [-122.93117, 38.932], [-122.9308, 38.93191], [-122.93013, 38.93192], [-122.92995, 38.93189], [-122.92978, 38.93181], [-122.92927, 38.9315], [-122.92866, 38.93099], [-122.92827, 38.9307], [-122.92713, 38.92996], [-122.92691, 38.92988], [-122.92663, 38.92996], [-122.92619, 38.93022], [-122.92593, 38.93026], [-122.92567, 38.93033], [-122.92512, 38.9306], [-122.92497, 38.93073], [-122.92484, 38.93098], [-122.92471, 38.93109], [-122.92454, 38.93114], [-122.9244, 38.93112], [-122.92424, 38.93104], [-122.92412, 38.93096], [-122.9234, 38.93039], [-122.92292, 38.9302], [-122.92201, 38.92995], [-122.92166, 38.92994], [-122.92092, 38.93004], [-122.92018, 38.93037], [-122.91993, 38.9304], [-122.91935, 38.93033], [-122.91879, 38.93048], [-122.91848, 38.93069], [-122.91831, 38.93093], [-122.91806, 38.9314], [-122.91752, 38.93254], [-122.91724, 38.93289], [-122.91695, 38.93306], [-122.91668, 38.9331], [-122.91638, 38.93303], [-122.91575, 38.93281], [-122.91536, 38.93274], [-122.91494, 38.93279], [-122.91365, 38.93329], [-122.91336, 38.93351], [-122.91318, 38.93372], [-122.9125, 38.93478], [-122.9122, 38.93514], [-122.91179, 38.93545], [-122.91057, 38.93581], [-122.91011, 38.93607], [-122.90977, 38.93641], [-122.90959, 38.93672], [-122.90941, 38.9373], [-122.90912, 38.93786], [-122.90904, 38.93819], [-122.90904, 38.93851], [-122.9092, 38.93921], [-122.90917, 38.9395], [-122.90892, 38.94012], [-122.90895, 38.94047], [-122.90906, 38.94076], [-122.9093, 38.94101], [-122.90965, 38.94122], [-122.90999, 38.94138], [-122.9103, 38.94162], [-122.91048, 38.94188], [-122.91052, 38.94229], [-122.91044, 38.94273], [-122.91022, 38.94305], [-122.91004, 38.94323], [-122.90976, 38.94339], [-122.90947, 38.94348], [-122.90882, 38.94363], [-122.90854, 38.94377], [-122.90823, 38.944], [-122.90797, 38.94438], [-122.90788, 38.94474], [-122.90791, 38.94501], [-122.90798, 38.94524], [-122.90824, 38.94569], [-122.90842, 38.94607], [-122.90854, 38.94645], [-122.9086, 38.94691], [-122.90857, 38.94868], [-122.90852, 38.94892], [-122.90844, 38.94906], [-122.90829, 38.94919], [-122.90811, 38.94927], [-122.90796, 38.94932], [-122.9078, 38.94933], [-122.9076, 38.94932], [-122.90666, 38.94902], [-122.90608, 38.94891], [-122.90409, 38.94867], [-122.90373, 38.94866], [-122.90315, 38.94875], [-122.90286, 38.94885], [-122.90265, 38.94899], [-122.90265, 38.94802], [-122.90269, 38.94786], [-122.90292, 38.94747], [-122.90299, 38.94729], [-122.903, 38.94712], [-122.90295, 38.94683], [-122.90278, 38.94657], [-122.90252, 38.94628], [-122.90234, 38.94601], [-122.90226, 38.94575], [-122.90211, 38.94458], [-122.90196, 38.94418], [-122.90127, 38.94315], [-122.90068, 38.94258], [-122.90056, 38.94231], [-122.90049, 38.942], [-122.90032, 38.94156], [-122.90012, 38.94113], [-122.90005, 38.94071], [-122.90014, 38.9399], [-122.9002, 38.93945], [-122.90032, 38.93921], [-122.90046, 38.93905], [-122.90082, 38.93888], [-122.90117, 38.93876], [-122.90149, 38.9386], [-122.9027, 38.93764], [-122.90292, 38.93752], [-122.90354, 38.93703], [-122.90354, 38.93701], [-122.90348, 38.93696], [-122.90286, 38.93745], [-122.90264, 38.93758], [-122.90169, 38.93835], [-122.90115, 38.93867], [-122.9008, 38.93879], [-122.90042, 38.93897], [-122.90023, 38.93918], [-122.9001, 38.93946], [-122.90003, 38.9399], [-122.89995, 38.9407], [-122.90002, 38.94114], [-122.90038, 38.94199], [-122.90044, 38.94234], [-122.90059, 38.94263], [-122.90103, 38.94304], [-122.90007, 38.94305], [-122.90006, 38.94271], [-122.89548, 38.94267], [-122.89546, 38.94302], [-122.89319, 38.943], [-122.89275, 38.94505], [-122.8919, 38.94504], [-122.8912, 38.94309], [-122.89075, 38.94307], [-122.88949, 38.94335], [-122.88845, 38.94301], [-122.88809, 38.94301], [-122.888, 38.94292], [-122.88852, 38.9429], [-122.889, 38.94283], [-122.88828, 38.94156], [-122.88816, 38.94083], [-122.88798, 38.93923], [-122.88713, 38.93861], [-122.88654, 38.93848], [-122.8861, 38.93791], [-122.88609, 38.93709], [-122.88611, 38.93568], [-122.88184, 38.93563], [-122.88168, 38.9354], [-122.88167, 38.93198], [-122.89541, 38.93213], [-122.89537, 38.92485], [-122.91357, 38.92503], [-122.93287, 38.92501], [-122.93232, 38.93223], [-122.93699, 38.93224], [-122.93663, 38.93583], [-122.94593, 38.93578], [-122.94546, 38.9393], [-122.95017, 38.93923], [-122.95487, 38.93922], [-122.95461, 38.94298], [-122.9594, 38.94295]]], [[[-122.94788, 38.94277], [-122.94053, 38.94286], [-122.94039, 38.93937], [-122.93177, 38.93946], [-122.91358, 38.93953], [-122.91353, 38.94309], [-122.91804, 38.9431], [-122.91784, 38.95396], [-122.91758, 38.95761], [-122.91327, 38.95741], [-122.91335, 38.95377], [-122.90483, 38.95379], [-122.90484, 38.95033], [-122.90191, 38.95024], [-122.9021, 38.94997], [-122.9022, 38.94967], [-122.90261, 38.9492], [-122.90293, 38.94899], [-122.90317, 38.94889], [-122.90362, 38.94881], [-122.90372, 38.9488], [-122.90409, 38.9488], [-122.90606, 38.94905], [-122.90659, 38.94915], [-122.90686, 38.94922], [-122.90754, 38.94945], [-122.90779, 38.94947], [-122.90798, 38.94945], [-122.90819, 38.9494], [-122.90838, 38.9493], [-122.90857, 38.94914], [-122.90868, 38.94898], [-122.90874, 38.94867], [-122.90878, 38.94689], [-122.90871, 38.94641], [-122.90859, 38.94605], [-122.90841, 38.94566], [-122.90815, 38.94521], [-122.90807, 38.94498], [-122.90806, 38.94475], [-122.90814, 38.94441], [-122.90839, 38.94406], [-122.90863, 38.94388], [-122.90889, 38.94376], [-122.90952, 38.94361], [-122.90987, 38.9435], [-122.91017, 38.94331], [-122.91041, 38.94308], [-122.9106, 38.94276], [-122.91072, 38.94228], [-122.91064, 38.94184], [-122.91043, 38.94152], [-122.91006, 38.94125], [-122.90975, 38.94111], [-122.90939, 38.94088], [-122.90921, 38.94068], [-122.90912, 38.94043], [-122.9091, 38.94014], [-122.90923, 38.93977], [-122.90937, 38.93951], [-122.90939, 38.93921], [-122.90921, 38.93847], [-122.90922, 38.93824], [-122.90927, 38.93795], [-122.90958, 38.93732], [-122.90974, 38.93675], [-122.90991, 38.93648], [-122.91025, 38.93616], [-122.91065, 38.93594], [-122.91186, 38.93559], [-122.91234, 38.93524], [-122.91264, 38.93484], [-122.91334, 38.93377], [-122.91347, 38.93361], [-122.91375, 38.93339], [-122.915, 38.93291], [-122.91535, 38.93287], [-122.91573, 38.93295], [-122.91633, 38.93316], [-122.91667, 38.93324], [-122.917, 38.93319], [-122.91737, 38.93299], [-122.91768, 38.93262], [-122.91822, 38.93146], [-122.91846, 38.931], [-122.91863, 38.93077], [-122.9189, 38.93059], [-122.91934, 38.93047], [-122.91994, 38.93054], [-122.92025, 38.9305], [-122.92098, 38.93017], [-122.92167, 38.93007], [-122.9219, 38.93008], [-122.92212, 38.93012], [-122.92287, 38.93033], [-122.92328, 38.9305], [-122.92349, 38.93064], [-122.92412, 38.93115], [-122.92427, 38.93123], [-122.92458, 38.93128], [-122.9248, 38.93122], [-122.92494, 38.93113], [-122.92512, 38.9308], [-122.92523, 38.93071], [-122.92574, 38.93046], [-122.92595, 38.93039], [-122.92624, 38.93035], [-122.92648, 38.93024], [-122.9267, 38.93009], [-122.92691, 38.93002], [-122.92701, 38.93007], [-122.92776, 38.93053], [-122.92856, 38.93111], [-122.92915, 38.93161], [-122.9297, 38.93193], [-122.92991, 38.93203], [-122.93017, 38.93207], [-122.93079, 38.93206], [-122.9311, 38.93212], [-122.93191, 38.93265], [-122.93227, 38.93283], [-122.93284, 38.93303], [-122.93322, 38.93318], [-122.93349, 38.93333], [-122.93374, 38.9335], [-122.93392, 38.93367], [-122.93421, 38.93402], [-122.93462, 38.93472], [-122.93469, 38.93523], [-122.93513, 38.936], [-122.93549, 38.93638], [-122.9357, 38.93669], [-122.93592, 38.93681], [-122.93639, 38.93688], [-122.93672, 38.93683], [-122.93696, 38.93683], [-122.93718, 38.93691], [-122.93734, 38.93705], [-122.93745, 38.93722], [-122.93768, 38.9374], [-122.93796, 38.93746], [-122.93836, 38.93749], [-122.93876, 38.93747], [-122.93906, 38.9374], [-122.93942, 38.93749], [-122.9398, 38.93763], [-122.94052, 38.93775], [-122.94081, 38.93794], [-122.94106, 38.93813], [-122.94128, 38.93822], [-122.94157, 38.93828], [-122.94181, 38.93842], [-122.94224, 38.93858], [-122.94295, 38.93882], [-122.94329, 38.93888], [-122.94362, 38.93889], [-122.9443, 38.93908], [-122.94483, 38.93931], [-122.94594, 38.93994], [-122.94651, 38.94019], [-122.94694, 38.94043], [-122.94723, 38.94055], [-122.94744, 38.94074], [-122.94779, 38.94165], [-122.94796, 38.94203], [-122.94795, 38.94233], [-122.94788, 38.94277]]]]} | Open Access 1 | 25233 | Highland Springs Recreation Area | 5079 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://www.co.lake.ca.us/Government/Directory/Parks_and_Recreation/Parks_Search/Highland_Springs_Recreation_Area.htm | Lake 40 | 2434.453 | Highland Springs Rec. Area | 0 | Local Recreation Area 3 | 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]);