units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where UNIT_NAME = "Parkway Greens"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11140 | 11140 | 11139 | {"type": "Polygon", "coordinates": [[[-121.33145, 38.71873], [-121.33142, 38.71879], [-121.33142, 38.71883], [-121.33145, 38.71887], [-121.33142, 38.7189], [-121.3314, 38.71911], [-121.33136, 38.71934], [-121.33134, 38.71943], [-121.33129, 38.71946], [-121.33127, 38.71951], [-121.33129, 38.71958], [-121.33118, 38.71982], [-121.33113, 38.7199], [-121.3311, 38.71991], [-121.33097, 38.72016], [-121.33083, 38.72055], [-121.33067, 38.72078], [-121.33057, 38.72077], [-121.33048, 38.72082], [-121.33047, 38.72085], [-121.33047, 38.7209], [-121.33043, 38.72091], [-121.33017, 38.72138], [-121.33011, 38.72139], [-121.33005, 38.72143], [-121.33003, 38.72148], [-121.33005, 38.72154], [-121.32969, 38.72203], [-121.32962, 38.72204], [-121.32956, 38.72209], [-121.32955, 38.72216], [-121.3296, 38.72223], [-121.32938, 38.72244], [-121.32905, 38.72285], [-121.32891, 38.7229], [-121.32899, 38.72315], [-121.32859, 38.72322], [-121.3282, 38.72325], [-121.32775, 38.72325], [-121.32767, 38.72323], [-121.32765, 38.72319], [-121.32765, 38.72284], [-121.32812, 38.72284], [-121.32841, 38.72278], [-121.32864, 38.72258], [-121.32892, 38.72215], [-121.32891, 38.72212], [-121.32897, 38.72207], [-121.32899, 38.72201], [-121.32902, 38.72201], [-121.32939, 38.72153], [-121.32938, 38.7215], [-121.32945, 38.72145], [-121.32946, 38.72138], [-121.3295, 38.72137], [-121.32985, 38.72089], [-121.32984, 38.72086], [-121.32991, 38.72081], [-121.32992, 38.72074], [-121.32996, 38.72073], [-121.33032, 38.72021], [-121.33064, 38.7198], [-121.3308, 38.71951], [-121.33089, 38.7192], [-121.33091, 38.71901], [-121.33091, 38.71878], [-121.33095, 38.71869], [-121.33093, 38.71864], [-121.3309, 38.71859], [-121.33094, 38.71855], [-121.33094, 38.71809], [-121.33142, 38.71808], [-121.33142, 38.7187], [-121.33145, 38.71873]]]} | Open Access 1 | 21442 | Parkway Greens | 23460 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 8.032 | Parkway Greens | 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]);