units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, MNG_AG_TYP = 2 and UNIT_NAME = "False Ravine Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12641 | 12641 | 12640 | {"type": "Polygon", "coordinates": [[[-121.24502, 38.75872], [-121.24496, 38.75878], [-121.2447, 38.75881], [-121.24447, 38.75887], [-121.24429, 38.75896], [-121.24399, 38.75914], [-121.24374, 38.75926], [-121.24348, 38.75936], [-121.24299, 38.75949], [-121.24279, 38.75957], [-121.24235, 38.75977], [-121.24169, 38.76015], [-121.2414, 38.75979], [-121.23915, 38.76145], [-121.23854, 38.76172], [-121.23809, 38.76199], [-121.2378, 38.76218], [-121.23758, 38.76239], [-121.23708, 38.76296], [-121.23585, 38.76411], [-121.23562, 38.76444], [-121.23528, 38.76514], [-121.23459, 38.76562], [-121.23434, 38.76586], [-121.23412, 38.76621], [-121.23406, 38.76646], [-121.23405, 38.76658], [-121.23342, 38.76651], [-121.23314, 38.76645], [-121.23281, 38.76636], [-121.23285, 38.76629], [-121.23304, 38.76626], [-121.23321, 38.76619], [-121.23348, 38.76597], [-121.23359, 38.76581], [-121.2336, 38.76527], [-121.23419, 38.76527], [-121.23425, 38.7652], [-121.23426, 38.76478], [-121.2342, 38.76472], [-121.23425, 38.76469], [-121.23428, 38.76465], [-121.23427, 38.76455], [-121.23466, 38.76454], [-121.23499, 38.7643], [-121.23516, 38.76398], [-121.23519, 38.76378], [-121.23459, 38.76336], [-121.23428, 38.76336], [-121.23428, 38.76303], [-121.23423, 38.76289], [-121.23417, 38.76276], [-121.23504, 38.76264], [-121.23563, 38.76224], [-121.23612, 38.76226], [-121.23651, 38.76192], [-121.23653, 38.76148], [-121.2359, 38.76106], [-121.236, 38.76095], [-121.23612, 38.76087], [-121.23637, 38.76076], [-121.2367, 38.76068], [-121.23694, 38.76109], [-121.23753, 38.76086], [-121.23781, 38.76068], [-121.23951, 38.75949], [-121.24003, 38.75919], [-121.24031, 38.75908], [-121.24147, 38.75881], [-121.24147, 38.7588], [-121.24104, 38.75821], [-121.24112, 38.75808], [-121.24117, 38.75805], [-121.24161, 38.75813], [-121.24167, 38.75838], [-121.24187, 38.75871], [-121.24237, 38.7586], [-121.24282, 38.75826], [-121.24306, 38.75811], [-121.24391, 38.75776], [-121.24418, 38.75768], [-121.24484, 38.75755], [-121.24492, 38.75779], [-121.24499, 38.75811], [-121.24502, 38.75872]]]} | Open Access 1 | 29468 | False Ravine Park | 18840 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 44.406 | False Ravine Park | 0 | Local Park 2 | 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]);