superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, LABEL_NAME = "SDG&E, Norton, 2.164 acres" and MNG_AG_TYP = 13
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9427 | 9427 | 9426 | {"type": "Polygon", "coordinates": [[[-114.73212, 33.43458], [-114.7324, 33.43611], [-114.73141, 33.44813], [-114.73042, 33.45173], [-114.73028, 33.4553], [-114.72649, 33.45538], [-114.72627, 33.4629], [-114.71681, 33.46294], [-114.71678, 33.47024], [-114.70007, 33.47022], [-114.69999, 33.47644], [-114.70015, 33.47912], [-114.69985, 33.48542], [-114.69515, 33.48542], [-114.69522, 33.484], [-114.69093, 33.48404], [-114.69081, 33.47792], [-114.69437, 33.47284], [-114.69918, 33.47028], [-114.69919, 33.463], [-114.68225, 33.46298], [-114.68188, 33.43882], [-114.68407, 33.43876], [-114.68505, 33.43817], [-114.68671, 33.43603], [-114.68901, 33.43558], [-114.69107, 33.43362], [-114.70443, 33.43361], [-114.71809, 33.43367], [-114.72428, 33.42651], [-114.72643, 33.42661], [-114.72679, 33.43361], [-114.7269, 33.4337], [-114.73004, 33.43371], [-114.72547, 33.43649], [-114.72549, 33.43895], [-114.72778, 33.43891], [-114.73107, 33.4362], [-114.73212, 33.43458]]]} | No Public Access 3 | SDG&E, Norton, 2.164 acres | 25226 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 4175.228 | SDG&E, Norton, 2.164 acres |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);