units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 304 and SUID_NMA = 25867
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12288 | 12288 | 12287 | {"type": "Polygon", "coordinates": [[[-121.27946, 38.56943], [-121.27965, 38.57223], [-121.27964, 38.57254], [-121.2796, 38.5728], [-121.27953, 38.57311], [-121.27937, 38.57356], [-121.27924, 38.57381], [-121.27911, 38.57404], [-121.27879, 38.57446], [-121.27841, 38.57486], [-121.27808, 38.57513], [-121.27759, 38.57548], [-121.27753, 38.57543], [-121.27753, 38.57538], [-121.27811, 38.57495], [-121.27853, 38.57456], [-121.27876, 38.5743], [-121.27887, 38.57416], [-121.27892, 38.57406], [-121.27893, 38.57391], [-121.27884, 38.57376], [-121.27877, 38.5737], [-121.27853, 38.5736], [-121.27834, 38.57347], [-121.2782, 38.57336], [-121.27803, 38.57319], [-121.27777, 38.57299], [-121.27764, 38.57284], [-121.27755, 38.57271], [-121.27748, 38.57253], [-121.27735, 38.57233], [-121.27725, 38.57224], [-121.27684, 38.57206], [-121.2766, 38.57191], [-121.27636, 38.57171], [-121.27627, 38.57158], [-121.27624, 38.57148], [-121.27624, 38.57138], [-121.2764, 38.57113], [-121.27681, 38.57088], [-121.27771, 38.57061], [-121.27837, 38.57058], [-121.27886, 38.57065], [-121.27918, 38.57078], [-121.27922, 38.57078], [-121.27933, 38.57076], [-121.27941, 38.57071], [-121.27945, 38.57062], [-121.27938, 38.56947], [-121.27946, 38.56943]]]} | Open Access 1 | 25940 | Stone Creek Community Park | 25867 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 18.334 | Stone Creek Community 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]);