units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 376, MNG_AG_TYP = 2 and YR_EST = 1960
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4114 | 4114 | 4113 | {"type": "Polygon", "coordinates": [[[-121.95833, 37.55749], [-121.95738, 37.55758], [-121.95719, 37.55717], [-121.95711, 37.55712], [-121.95703, 37.55709], [-121.95693, 37.55709], [-121.95685, 37.55712], [-121.95677, 37.55717], [-121.95673, 37.55724], [-121.95672, 37.55731], [-121.95674, 37.55737], [-121.9568, 37.55744], [-121.95688, 37.55748], [-121.95697, 37.5575], [-121.95708, 37.55749], [-121.95713, 37.55751], [-121.95743, 37.55814], [-121.95587, 37.55859], [-121.95559, 37.55471], [-121.95566, 37.55461], [-121.95552, 37.55247], [-121.95541, 37.55221], [-121.95531, 37.55064], [-121.95513, 37.55065], [-121.95499, 37.54848], [-121.95581, 37.54785], [-121.95674, 37.54713], [-121.95833, 37.55749]]]} | Restricted Access 2 | 47146 | Fremont Park Golf Club | 33120 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 53.791 | Fremont Park Golf Club | 1960 | Local Recreation Area 3 | 4 | |
8402 | 8402 | 8401 | {"type": "Polygon", "coordinates": [[[-121.972, 37.54942], [-121.97136, 37.54931], [-121.97107, 37.54946], [-121.971, 37.54955], [-121.97097, 37.54961], [-121.97093, 37.54977], [-121.97094, 37.54979], [-121.97094, 37.54984], [-121.97093, 37.5499], [-121.97077, 37.55006], [-121.97076, 37.55014], [-121.97083, 37.55028], [-121.97082, 37.55037], [-121.97077, 37.5504], [-121.97068, 37.55044], [-121.97046, 37.55049], [-121.9703, 37.55049], [-121.97025, 37.55042], [-121.97009, 37.55037], [-121.96983, 37.55023], [-121.96929, 37.54991], [-121.96868, 37.55068], [-121.96839, 37.55055], [-121.96807, 37.55094], [-121.96809, 37.55099], [-121.96832, 37.55113], [-121.96849, 37.55131], [-121.9683, 37.55134], [-121.96813, 37.5514], [-121.96804, 37.55148], [-121.96782, 37.5517], [-121.96766, 37.55183], [-121.96768, 37.55131], [-121.96766, 37.55126], [-121.9675, 37.55123], [-121.96659, 37.55124], [-121.96657, 37.55185], [-121.96719, 37.55215], [-121.96743, 37.55221], [-121.96833, 37.55299], [-121.96844, 37.55312], [-121.96875, 37.55359], [-121.96409, 37.55553], [-121.96375, 37.5557], [-121.96344, 37.5559], [-121.9589, 37.5593], [-121.95693, 37.54698], [-121.95619, 37.54193], [-121.9561, 37.54143], [-121.95718, 37.54123], [-121.95785, 37.54113], [-121.95832, 37.54112], [-121.9586, 37.54114], [-121.95943, 37.54126], [-121.95985, 37.54138], [-121.96025, 37.54155], [-121.9605, 37.54169], [-121.96079, 37.54191], [-121.96262, 37.54352], [-121.9631, 37.54383], [-121.96535, 37.54521], [-121.96653, 37.54597], [-121.96692, 37.54625], [-121.96715, 37.54644], [-121.96795, 37.54695], [-121.96898, 37.54754], [-121.96898, 37.54758], [-121.97169, 37.54896], [-121.9718, 37.54904], [-121.9719, 37.54917], [-121.97196, 37.54927], [-121.972, 37.54942]]]} | Open Access 1 | 13006 | Fremont Central Park | 3837 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | https://www.fremont.gov/317/Central-Park | Alameda 17 | 352.046 | Fremont Central Park | 1960 | 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]);