units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 510, MNG_AG_TYP = 2 and SUID_NMA = 33066
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15697 | 15697 | 15696 | {"type": "Polygon", "coordinates": [[[-120.94998, 37.64964], [-120.94987, 37.64947], [-120.94973, 37.64935], [-120.94933, 37.64916], [-120.94892, 37.64904], [-120.94857, 37.64887], [-120.94821, 37.6486], [-120.94808, 37.64857], [-120.94792, 37.64849], [-120.94767, 37.64842], [-120.94752, 37.64832], [-120.94726, 37.64824], [-120.94705, 37.64824], [-120.94689, 37.64827], [-120.94604, 37.64854], [-120.94578, 37.64871], [-120.94549, 37.64892], [-120.94541, 37.649], [-120.94526, 37.6492], [-120.9452, 37.64934], [-120.94519, 37.64946], [-120.94455, 37.6507], [-120.94414, 37.65124], [-120.94359, 37.65155], [-120.9433, 37.65173], [-120.94296, 37.65199], [-120.94286, 37.65209], [-120.94267, 37.65231], [-120.94275, 37.65236], [-120.94262, 37.65253], [-120.94256, 37.65267], [-120.94237, 37.65297], [-120.94211, 37.65331], [-120.94171, 37.65367], [-120.94162, 37.65382], [-120.94154, 37.65391], [-120.94143, 37.654], [-120.94125, 37.65409], [-120.94096, 37.6542], [-120.94082, 37.65422], [-120.94049, 37.65421], [-120.94027, 37.65418], [-120.93922, 37.65415], [-120.9392, 37.65408], [-120.93862, 37.6541], [-120.93813, 37.65394], [-120.93784, 37.65395], [-120.93715, 37.65383], [-120.93698, 37.65383], [-120.93663, 37.65371], [-120.93635, 37.65364], [-120.93558, 37.65356], [-120.93523, 37.65357], [-120.93523, 37.65365], [-120.93405, 37.65329], [-120.9337, 37.65323], [-120.9332, 37.65298], [-120.93291, 37.65275], [-120.9319, 37.65225], [-120.93167, 37.65218], [-120.93136, 37.65204], [-120.93064, 37.65213], [-120.93016, 37.6523], [-120.93014, 37.65079], [-120.93024, 37.65078], [-120.93022, 37.64918], [-120.93024, 37.64915], [-120.93026, 37.64914], [-120.93898, 37.64909], [-120.93901, 37.64911], [-120.93909, 37.64943], [-120.93911, 37.65109], [-120.93918, 37.65109], [-120.93919, 37.65111], [-120.94141, 37.65108], [-120.9414, 37.65094], [-120.93924, 37.65097], [-120.93923, 37.64954], [-120.93916, 37.64929], [-120.93916, 37.6492], [-120.93926, 37.64917], [-120.93926, 37.64923], [-120.93927, 37.64924], [-120.94039, 37.64881], [-120.94039, 37.64872], [-120.94066, 37.64859], [-120.94207, 37.64761], [-120.94226, 37.6475], [-120.94247, 37.64742], [-120.94438, 37.64684], [-120.94459, 37.64676], [-120.94479, 37.64665], [-120.94661, 37.64545], [-120.94678, 37.64537], [-120.94705, 37.6453], [-120.94724, 37.64529], [-120.94804, 37.64529], [-120.94813, 37.64549], [-120.94817, 37.64844], [-120.94821, 37.64848], [-120.9483, 37.64851], [-120.9483, 37.64864], [-120.94908, 37.64902], [-120.94982, 37.64935], [-120.94998, 37.64949], [-120.94998, 37.64964]], [[-120.94255, 37.65248], [-120.94255, 37.65246], [-120.94248, 37.65247], [-120.9424, 37.65264], [-120.94244, 37.65264], [-120.94255, 37.65248]]]} | Restricted Access 2 | 18555 | Creekside Golf Course | 33066 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 181.194 | Creekside GC | 0 | Local Recreation Area 3 | 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]);