units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 533 and SUID_NMA = 27535
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2640 | 2640 | 2639 | {"type": "Polygon", "coordinates": [[[-121.33746, 38.80162], [-121.33738, 38.8016], [-121.33727, 38.80178], [-121.33701, 38.80169], [-121.33682, 38.80167], [-121.33667, 38.8017], [-121.33646, 38.80179], [-121.33611, 38.80189], [-121.33569, 38.80158], [-121.33557, 38.80162], [-121.33532, 38.80198], [-121.33521, 38.8022], [-121.33504, 38.80276], [-121.33491, 38.80291], [-121.33476, 38.80304], [-121.3346, 38.80308], [-121.3345, 38.80316], [-121.33439, 38.80316], [-121.33403, 38.80308], [-121.33371, 38.8032], [-121.33356, 38.80327], [-121.3333, 38.8033], [-121.33319, 38.80335], [-121.33319, 38.80336], [-121.33327, 38.8034], [-121.33342, 38.80353], [-121.33327, 38.80373], [-121.33341, 38.80391], [-121.33373, 38.80471], [-121.33429, 38.80553], [-121.33418, 38.80554], [-121.33364, 38.80475], [-121.33336, 38.8042], [-121.33317, 38.80392], [-121.33319, 38.80381], [-121.33317, 38.80369], [-121.333, 38.80339], [-121.333, 38.80329], [-121.33291, 38.80317], [-121.33277, 38.80312], [-121.33252, 38.8032], [-121.3322, 38.8032], [-121.33214, 38.80307], [-121.33211, 38.80285], [-121.33204, 38.80268], [-121.33186, 38.80262], [-121.3318, 38.80252], [-121.33154, 38.80243], [-121.33135, 38.80239], [-121.33112, 38.80246], [-121.3307, 38.80269], [-121.3306, 38.80269], [-121.33038, 38.80264], [-121.33002, 38.80262], [-121.32972, 38.80215], [-121.33008, 38.80202], [-121.33031, 38.80215], [-121.33057, 38.80222], [-121.33078, 38.80224], [-121.33111, 38.8022], [-121.33128, 38.8022], [-121.33193, 38.8023], [-121.33194, 38.80232], [-121.33213, 38.80231], [-121.33239, 38.80227], [-121.33265, 38.80219], [-121.33299, 38.80201], [-121.33313, 38.80191], [-121.33326, 38.80175], [-121.33334, 38.80158], [-121.33336, 38.80138], [-121.33332, 38.80121], [-121.33325, 38.80108], [-121.33315, 38.80096], [-121.33271, 38.80058], [-121.33251, 38.80045], [-121.33298, 38.80021], [-121.3329, 38.79994], [-121.33309, 38.79935], [-121.33297, 38.79919], [-121.33319, 38.79911], [-121.33374, 38.79925], [-121.3338, 38.79908], [-121.33396, 38.79895], [-121.33426, 38.79902], [-121.33435, 38.7988], [-121.33426, 38.79856], [-121.33422, 38.79829], [-121.33428, 38.798], [-121.33453, 38.79801], [-121.33476, 38.79804], [-121.33495, 38.79809], [-121.33516, 38.79817], [-121.33688, 38.79907], [-121.3371, 38.79922], [-121.33729, 38.7994], [-121.33738, 38.79952], [-121.33747, 38.79968], [-121.33754, 38.79988], [-121.33757, 38.80005], [-121.33759, 38.80119], [-121.33755, 38.80141], [-121.33746, 38.80162]]]} | Open Access 1 | 20852 | William "Bill" Hughes Park | 27535 | 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.252 | William "Bill" Hughes 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]);