units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 864, LAYER = 2, MNG_AGENCY = 56 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10036 | 10036 | 10035 | {"type": "MultiPolygon", "coordinates": [[[[-122.18013, 37.79253], [-122.17981, 37.79282], [-122.17941, 37.79279], [-122.17596, 37.79357], [-122.17505, 37.79408], [-122.17472, 37.7943], [-122.17463, 37.79429], [-122.17444, 37.79448], [-122.17406, 37.79414], [-122.17365, 37.79442], [-122.17228, 37.79476], [-122.17134, 37.79479], [-122.17133, 37.79481], [-122.17097, 37.79478], [-122.1707, 37.79471], [-122.17047, 37.79458], [-122.16974, 37.79398], [-122.16928, 37.79357], [-122.16892, 37.79327], [-122.16822, 37.79263], [-122.16806, 37.79245], [-122.16796, 37.79227], [-122.16789, 37.79209], [-122.16785, 37.79193], [-122.16784, 37.79176], [-122.16788, 37.7915], [-122.1681, 37.79098], [-122.17057, 37.79323], [-122.17175, 37.79353], [-122.17287, 37.79283], [-122.17292, 37.79166], [-122.17197, 37.79052], [-122.1688, 37.789], [-122.16813, 37.78913], [-122.16792, 37.78846], [-122.1679, 37.7883], [-122.16789, 37.78771], [-122.16786, 37.78757], [-122.16779, 37.78745], [-122.16763, 37.78728], [-122.16745, 37.78717], [-122.16661, 37.78691], [-122.16664, 37.78689], [-122.16745, 37.78714], [-122.16765, 37.78725], [-122.16781, 37.78742], [-122.16789, 37.78757], [-122.16793, 37.7877], [-122.16793, 37.78828], [-122.16795, 37.78845], [-122.16815, 37.78906], [-122.16956, 37.78877], [-122.17252, 37.7902], [-122.17358, 37.7915], [-122.17354, 37.79269], [-122.17582, 37.79224], [-122.17829, 37.79228], [-122.17945, 37.7917], [-122.17983, 37.79067], [-122.17986, 37.79081], [-122.17985, 37.79099], [-122.1798, 37.79112], [-122.17962, 37.79149], [-122.17959, 37.79159], [-122.17959, 37.79173], [-122.17963, 37.79187], [-122.17977, 37.7921], [-122.17989, 37.79227], [-122.18013, 37.79253]]], [[[-122.18087, 37.79024], [-122.18056, 37.79112], [-122.18056, 37.79116], [-122.18038, 37.79125], [-122.18018, 37.79137], [-122.18001, 37.79153], [-122.17988, 37.79169], [-122.17983, 37.7917], [-122.17981, 37.79169], [-122.17979, 37.79165], [-122.17981, 37.79154], [-122.18001, 37.79114], [-122.18007, 37.79092], [-122.18007, 37.79081], [-122.18005, 37.79069], [-122.18, 37.79058], [-122.17993, 37.79047], [-122.18087, 37.79024]]], [[[-122.18103, 37.79328], [-122.181, 37.79329], [-122.18025, 37.79236], [-122.18009, 37.79219], [-122.17992, 37.79194], [-122.17993, 37.79188], [-122.18013, 37.79163], [-122.18023, 37.79153], [-122.18043, 37.79138], [-122.18065, 37.79128], [-122.18067, 37.79142], [-122.18056, 37.79157], [-122.18058, 37.79199], [-122.18072, 37.79227], [-122.18082, 37.79273], [-122.18103, 37.79328]]], [[[-122.18276, 37.79282], [-122.18229, 37.79322], [-122.182, 37.79305], [-122.18164, 37.79261], [-122.18123, 37.79228], [-122.18113, 37.79187], [-122.18118, 37.79149], [-122.18115, 37.79094], [-122.18123, 37.79041], [-122.18155, 37.79042], [-122.18156, 37.791], [-122.18163, 37.79162], [-122.18276, 37.79282]]]]} | Open Access 1 | 17341 | Leona Heights | 21171 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 56.739 | Leona Heights | None 864 |
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]);