superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "Creek Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 2
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3292 | 3292 | 3291 | {"type": "Polygon", "coordinates": [[[-118.00252, 33.9204], [-118.00176, 33.92042], [-118.0013, 33.92086], [-118.00129, 33.92095], [-118.0011, 33.92094], [-118.00067, 33.92095], [-118.00055, 33.92097], [-118.00054, 33.92099], [-117.99937, 33.92118], [-117.99564, 33.9216], [-117.99534, 33.92172], [-117.99465, 33.92215], [-117.99459, 33.92217], [-117.99455, 33.92225], [-117.99452, 33.92225], [-117.99451, 33.92105], [-117.99447, 33.92103], [-117.99447, 33.92091], [-117.99651, 33.92069], [-117.99652, 33.92001], [-117.99657, 33.92002], [-117.99666, 33.91998], [-117.99666, 33.92065], [-117.99671, 33.92067], [-117.99893, 33.92043], [-118.00039, 33.92042], [-118.00094, 33.92026], [-118.00122, 33.92015], [-118.00178, 33.91989], [-118.00206, 33.91978], [-118.0024, 33.91969], [-118.00249, 33.91999], [-118.00245, 33.92002], [-118.00241, 33.92009], [-118.00241, 33.92018], [-118.00251, 33.92035], [-118.00252, 33.9204]]]} | Open Access 1 | Creek Park | 17763 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 15.959 | Creek Park | ||
3293 | 3293 | 3292 | {"type": "MultiPolygon", "coordinates": [[[[-122.56273, 37.97622], [-122.56273, 37.97628], [-122.5624, 37.97617], [-122.56203, 37.97613], [-122.56191, 37.97598], [-122.56199, 37.97433], [-122.56205, 37.97432], [-122.56207, 37.97474], [-122.56208, 37.97536], [-122.56213, 37.97555], [-122.56223, 37.97578], [-122.56211, 37.97582], [-122.56211, 37.97583], [-122.56273, 37.97622]]], [[[-122.56263, 37.97593], [-122.56256, 37.97602], [-122.5624, 37.9759], [-122.56255, 37.97585], [-122.56263, 37.97593]]], [[[-122.56314, 37.97651], [-122.56288, 37.97636], [-122.56282, 37.97635], [-122.56281, 37.97625], [-122.56304, 37.97641], [-122.56305, 37.97643], [-122.56314, 37.97651]]], [[[-122.56356, 37.97674], [-122.56356, 37.97675], [-122.56332, 37.97661], [-122.56333, 37.9766], [-122.56356, 37.97674]]]]} | Open Access 1 | Creek Park | 17764 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 0.974 | Creek Park | ||
3294 | 3294 | 3293 | {"type": "MultiPolygon", "coordinates": [[[[-121.54538, 37.7804], [-121.54522, 37.78077], [-121.54524, 37.78079], [-121.54511, 37.78096], [-121.54496, 37.78111], [-121.54445, 37.78147], [-121.5442, 37.78172], [-121.54399, 37.78174], [-121.54378, 37.78179], [-121.54358, 37.78186], [-121.54335, 37.782], [-121.54319, 37.78214], [-121.54268, 37.78271], [-121.54248, 37.78288], [-121.54232, 37.783], [-121.54207, 37.78313], [-121.54189, 37.78321], [-121.54162, 37.7833], [-121.54142, 37.78335], [-121.54117, 37.78339], [-121.54092, 37.78341], [-121.54045, 37.7834], [-121.54044, 37.78309], [-121.54045, 37.78287], [-121.54053, 37.78244], [-121.5406, 37.78223], [-121.54071, 37.78197], [-121.54095, 37.78158], [-121.54121, 37.78126], [-121.54147, 37.78101], [-121.54267, 37.78008], [-121.54287, 37.7799], [-121.54308, 37.77969], [-121.54322, 37.77977], [-121.54332, 37.77966], [-121.54384, 37.77993], [-121.54424, 37.7801], [-121.54466, 37.78023], [-121.54525, 37.78035], [-121.54526, 37.78038], [-121.54538, 37.7804]]], [[[-121.55082, 37.77568], [-121.5508, 37.77572], [-121.55043, 37.77588], [-121.54959, 37.7761], [-121.54925, 37.77623], [-121.54795, 37.77699], [-121.54712, 37.77733], [-121.54663, 37.7776], [-121.54659, 37.77765], [-121.54656, 37.77771], [-121.54652, 37.77772], [-121.54635, 37.77802], [-121.54566, 37.77907], [-121.54558, 37.77922], [-121.54553, 37.77934], [-121.54551, 37.77948], [-121.54545, 37.78007], [-121.54505, 37.78001], [-121.54465, 37.77991], [-121.54427, 37.77978], [-121.54387, 37.77959], [-121.54418, 37.77927], [-121.54454, 37.77906], [-121.54477, 37.77879], [-121.54512, 37.77825], [-121.54541, 37.77784], [-121.54584, 37.77709], [-121.54597, 37.77694], [-121.54606, 37.77685], [-121.54623, 37.77674], [-121.54624, 37.77671], [-121.54636, 37.7767], [-121.54646, 37.77666], [-121.54677, 37.77658], [-121.54739, 37.77635], [-121.5476, 37.77623], [-121.54827, 37.77579], [-121.54842, 37.77571], [-121.54848, 37.77564], [-121.54852, 37.77564], [-121.54912, 37.77537], [-121.54914, 37.77534], [-121.54924, 37.77533], [-121.5494, 37.77527], [-121.54989, 37.77516], [-121.55013, 37.77506], [-121.55016, 37.77506], [-121.55049, 37.77533], [-121.55071, 37.77555], [-121.55082, 37.77568]]], [[[-121.55684, 37.77112], [-121.55681, 37.77206], [-121.55634, 37.77206], [-121.55638, 37.77199], [-121.55637, 37.77193], [-121.55633, 37.77189], [-121.55628, 37.77186], [-121.55622, 37.77185], [-121.55615, 37.77185], [-121.55609, 37.77188], [-121.55606, 37.77191], [-121.55604, 37.77197], [-121.55608, 37.77211], [-121.55606, 37.77224], [-121.55606, 37.77268], [-121.55603, 37.77272], [-121.55599, 37.77273], [-121.55505, 37.77275], [-121.55425, 37.77283], [-121.55372, 37.77293], [-121.55325, 37.77304], [-121.55291, 37.77318], [-121.5527, 37.77332], [-121.55248, 37.77355], [-121.5518, 37.7748], [-121.5516, 37.77509], [-121.5514, 37.7753], [-121.55106, 37.77557], [-121.55102, 37.77557], [-121.55099, 37.77556], [-121.55072, 37.77528], [-121.55031, 37.77493], [-121.55057, 37.77464], [-121.5509, 37.77422], [-121.55104, 37.774], [-121.55135, 37.7734], [-121.55156, 37.77314], [-121.55179, 37.77294], [-121.55312, 37.77197], [-121.55328, 37.77189], [-121.55344, 37.77184], [-121.55364, 37.77182], [-121.55416, 37.77181], [-121.5544, 37.77177], [-121.55461, 37.77171], [-121.55481, 37.77163], [-121.55499, 37.77154], [-121.55535, 37.77128], [-121.55551, 37.77118], [-121.55584, 37.77102], [-121.55598, 37.77098], [-121.55621, 37.77094], [-121.55681, 37.77096], [-121.55681, 37.77111], [-121.55684, 37.77112]]]]} | Open Access 1 | Creek Park | 17765 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | http://www.mhcsd.com/ | Special District 4 | 59.435 | Creek Park |
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]);