units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, DES_TP = 2 and MNG_AGENCY = 289
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Palos Verdes Estates, City of · 1 ✖
DES_TP 1
- Local Park · 1 ✖
ACCESS_TYP 1
- Restricted Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6996 | 6996 | 6995 | {"type": "Polygon", "coordinates": [[[-118.38523, 33.79959], [-118.38522, 33.80151], [-118.38443, 33.80159], [-118.38352, 33.8016], [-118.38261, 33.80165], [-118.38171, 33.80173], [-118.38073, 33.80184], [-118.38, 33.80185], [-118.37929, 33.80181], [-118.37888, 33.80176], [-118.37748, 33.80149], [-118.37709, 33.80147], [-118.37577, 33.80148], [-118.37556, 33.80145], [-118.37535, 33.8014], [-118.37506, 33.80128], [-118.37444, 33.8009], [-118.37413, 33.80077], [-118.37303, 33.80049], [-118.37119, 33.80011], [-118.36992, 33.79979], [-118.36961, 33.79966], [-118.36941, 33.79953], [-118.36931, 33.79944], [-118.36912, 33.7992], [-118.369, 33.79895], [-118.36896, 33.79878], [-118.36893, 33.79857], [-118.36895, 33.7979], [-118.36894, 33.79757], [-118.36869, 33.79637], [-118.36868, 33.79617], [-118.36871, 33.796], [-118.3688, 33.79575], [-118.36887, 33.79561], [-118.36892, 33.79555], [-118.36904, 33.79543], [-118.36932, 33.7952], [-118.36951, 33.79508], [-118.36977, 33.79497], [-118.37001, 33.79492], [-118.37153, 33.7948], [-118.37173, 33.7948], [-118.37201, 33.79483], [-118.37259, 33.79493], [-118.37278, 33.79494], [-118.37624, 33.79506], [-118.37703, 33.79504], [-118.37749, 33.79499], [-118.37774, 33.79501], [-118.37787, 33.79506], [-118.37798, 33.79512], [-118.37919, 33.79616], [-118.37948, 33.79636], [-118.3797, 33.79647], [-118.37997, 33.79657], [-118.38047, 33.79666], [-118.38097, 33.79671], [-118.38202, 33.79672], [-118.38247, 33.79675], [-118.38274, 33.79678], [-118.3829, 33.79682], [-118.38303, 33.79689], [-118.38308, 33.79692], [-118.38306, 33.79708], [-118.38284, 33.79829], [-118.38282, 33.79837], [-118.38275, 33.79841], [-118.38267, 33.79852], [-118.38264, 33.79863], [-118.38265, 33.79871], [-118.3827, 33.79882], [-118.38277, 33.7989], [-118.38287, 33.79895], [-118.38304, 33.79899], [-118.38353, 33.79888], [-118.38369, 33.79888], [-118.38393, 33.79893], [-118.38413, 33.79904], [-118.38452, 33.79939], [-118.38468, 33.79951], [-118.38493, 33.79959], [-118.38514, 33.7996], [-118.38523, 33.79959]], [[-118.37105, 33.79608], [-118.37099, 33.79596], [-118.37086, 33.79601], [-118.37094, 33.79615], [-118.37105, 33.79608]], [[-118.37068, 33.79599], [-118.37087, 33.79592], [-118.37082, 33.79582], [-118.37061, 33.79587], [-118.37068, 33.79599]], [[-118.37741, 33.7953], [-118.37728, 33.79529], [-118.37722, 33.79531], [-118.37715, 33.79535], [-118.3771, 33.7954], [-118.37707, 33.79546], [-118.37706, 33.79554], [-118.37708, 33.79562], [-118.37715, 33.7957], [-118.37721, 33.79573], [-118.37731, 33.79576], [-118.37738, 33.79576], [-118.3775, 33.79572], [-118.3776, 33.79562], [-118.37762, 33.79556], [-118.37761, 33.79543], [-118.37754, 33.79535], [-118.37741, 33.7953]]]} | Restricted Access 2 | 5934 | Palos Verdes Golf Club and City Parkland | 23372 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 211.347 | Palos Verdes Golf Club and City Parkland | 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]);