units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "River Village Park" and MNG_AGENCY = 322
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15239 | 15239 | 15238 | {"type": "Polygon", "coordinates": [[[-118.52635, 34.42033], [-118.52605, 34.42057], [-118.52583, 34.4208], [-118.52529, 34.4212], [-118.52503, 34.42143], [-118.52496, 34.42148], [-118.52486, 34.42153], [-118.52479, 34.42162], [-118.52444, 34.42172], [-118.52436, 34.42183], [-118.52427, 34.42182], [-118.52417, 34.42187], [-118.52414, 34.42185], [-118.52375, 34.42215], [-118.52359, 34.42224], [-118.52334, 34.42235], [-118.52326, 34.42241], [-118.52311, 34.42239], [-118.52308, 34.42243], [-118.52308, 34.42247], [-118.52305, 34.42258], [-118.523, 34.42267], [-118.52287, 34.42276], [-118.52287, 34.42278], [-118.52272, 34.42284], [-118.5227, 34.42286], [-118.52261, 34.42286], [-118.52253, 34.42288], [-118.5225, 34.42291], [-118.5225, 34.42295], [-118.52247, 34.42302], [-118.52242, 34.42307], [-118.52231, 34.4231], [-118.52232, 34.42324], [-118.52229, 34.42331], [-118.52229, 34.42334], [-118.5222, 34.42342], [-118.52216, 34.42349], [-118.52219, 34.42352], [-118.52214, 34.42357], [-118.52213, 34.42365], [-118.52205, 34.4237], [-118.52205, 34.42372], [-118.52191, 34.42378], [-118.52191, 34.42368], [-118.52173, 34.4236], [-118.52169, 34.4236], [-118.52169, 34.42374], [-118.52167, 34.42389], [-118.52173, 34.42395], [-118.52169, 34.42413], [-118.52171, 34.42429], [-118.52173, 34.42431], [-118.52168, 34.42438], [-118.52153, 34.42482], [-118.52155, 34.42499], [-118.52003, 34.42511], [-118.5199, 34.42509], [-118.51966, 34.42512], [-118.51956, 34.42506], [-118.51954, 34.42488], [-118.51955, 34.42467], [-118.51952, 34.4245], [-118.51944, 34.42423], [-118.51943, 34.42372], [-118.51972, 34.42373], [-118.51985, 34.42362], [-118.51995, 34.42359], [-118.52, 34.42354], [-118.52009, 34.42353], [-118.52015, 34.42354], [-118.52021, 34.42346], [-118.52034, 34.42345], [-118.5204, 34.42342], [-118.52043, 34.42331], [-118.52059, 34.42313], [-118.52069, 34.42305], [-118.5208, 34.423], [-118.52083, 34.42296], [-118.52079, 34.42276], [-118.52081, 34.42271], [-118.52087, 34.4227], [-118.52093, 34.42261], [-118.52102, 34.4226], [-118.5211, 34.42256], [-118.5213, 34.42239], [-118.52136, 34.42242], [-118.52143, 34.42242], [-118.52153, 34.42237], [-118.52156, 34.42239], [-118.52165, 34.42238], [-118.5217, 34.42235], [-118.52174, 34.42226], [-118.52183, 34.42216], [-118.52184, 34.42203], [-118.52163, 34.42186], [-118.5216, 34.4218], [-118.52159, 34.42172], [-118.5216, 34.42163], [-118.52189, 34.42161], [-118.52207, 34.42157], [-118.52214, 34.42158], [-118.52234, 34.42165], [-118.52247, 34.42165], [-118.52284, 34.4215], [-118.52288, 34.42146], [-118.5229, 34.42141], [-118.52288, 34.42131], [-118.5229, 34.42117], [-118.52296, 34.42108], [-118.52302, 34.42108], [-118.5231, 34.42104], [-118.5231, 34.421], [-118.52316, 34.42095], [-118.52324, 34.42093], [-118.5233, 34.42086], [-118.52334, 34.42084], [-118.52346, 34.42085], [-118.52349, 34.42076], [-118.52362, 34.42066], [-118.52374, 34.42064], [-118.52379, 34.42061], [-118.52382, 34.42061], [-118.52384, 34.42059], [-118.52398, 34.42055], [-118.52393, 34.42025], [-118.52415, 34.42021], [-118.52434, 34.42014], [-118.52475, 34.41992], [-118.52479, 34.41984], [-118.5248, 34.41977], [-118.52475, 34.41968], [-118.52467, 34.41962], [-118.52517, 34.41908], [-118.52541, 34.41925], [-118.52553, 34.41937], [-118.52564, 34.41949], [-118.52605, 34.42005], [-118.52616, 34.42016], [-118.52635, 34.42033]]]} | Open Access 1 | 46216 | River Village Park | 29510 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/Home/Components/FacilityDirectory/FacilityDirectory/88/1386 | Los Angeles 6 | 29.03 | River Village Park | 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]);