units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, LABEL_NAME = "Old Mission Trail", MNG_AGENCY = 24 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 1 ✖
MNG_AGENCY 1
- Los Angeles, City of · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15061 | 15061 | 15060 | {"type": "MultiPolygon", "coordinates": [[[[-118.56211, 34.27247], [-118.55858, 34.27199], [-118.55845, 34.272], [-118.5587, 34.27187], [-118.55896, 34.27181], [-118.55997, 34.27177], [-118.56017, 34.27178], [-118.56044, 34.27185], [-118.56149, 34.27227], [-118.56166, 34.27227], [-118.56211, 34.27214], [-118.56211, 34.27247]]], [[[-118.56933, 34.27254], [-118.56701, 34.27238], [-118.56702, 34.27221], [-118.5669, 34.27221], [-118.56694, 34.27181], [-118.56789, 34.27204], [-118.56819, 34.27203], [-118.56844, 34.27197], [-118.56924, 34.27161], [-118.56923, 34.27183], [-118.56924, 34.27204], [-118.56933, 34.27254]]], [[[-118.57125, 34.2726], [-118.57073, 34.27222], [-118.57053, 34.27214], [-118.57033, 34.27211], [-118.56958, 34.27213], [-118.56956, 34.27184], [-118.56959, 34.27154], [-118.56972, 34.27155], [-118.56983, 34.27158], [-118.56994, 34.27163], [-118.57004, 34.2717], [-118.57012, 34.27164], [-118.57036, 34.27193], [-118.57043, 34.27199], [-118.57053, 34.27204], [-118.57081, 34.27214], [-118.57094, 34.27222], [-118.57114, 34.27241], [-118.57125, 34.2726]]], [[[-118.57293, 34.27207], [-118.57243, 34.27258], [-118.5723, 34.27266], [-118.57211, 34.27271], [-118.57152, 34.27272], [-118.57144, 34.2727], [-118.57138, 34.27265], [-118.57123, 34.27241], [-118.57108, 34.27224], [-118.57108, 34.27175], [-118.57293, 34.27207]]], [[[-118.57491, 34.27259], [-118.57489, 34.27299], [-118.57461, 34.27284], [-118.57412, 34.27283], [-118.57336, 34.27306], [-118.57241, 34.27296], [-118.57242, 34.27268], [-118.573, 34.27211], [-118.57387, 34.27232], [-118.5739, 34.27235], [-118.57491, 34.27259]]]]} | Open Access 1 | 45821 | Old Mission Trail | 28840 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 13.604 | Old Mission Trail | 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]);