units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 10 and MNG_AG_TYP = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency · 32 ✖
MNG_AGENCY 1
- Patterson, City of · 32 ✖
ACCESS_TYP 1
- Open Access 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5797 | 5797 | 5796 | {"type": "Polygon", "coordinates": [[[-121.1509, 37.46277], [-121.1508, 37.46292], [-121.14988, 37.46396], [-121.14979, 37.46412], [-121.14974, 37.46424], [-121.14971, 37.46426], [-121.14957, 37.46426], [-121.14958, 37.46277], [-121.1509, 37.46277]]]} | Open Access 1 | 55 | Amaryllis Park | 15440 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.566 | Amaryllis Park | 0 | Local Park 2 | 4 | |
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | 66 | Ambercot Park | 15443 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 4.088 | Ambercot Park | 0 | Local Park 2 | 4 | |
5802 | 5802 | 5801 | {"type": "Polygon", "coordinates": [[[-121.15135, 37.46576], [-121.15132, 37.46714], [-121.15127, 37.46718], [-121.15088, 37.46718], [-121.15078, 37.46715], [-121.15072, 37.46715], [-121.15063, 37.46719], [-121.1506, 37.46725], [-121.15028, 37.46725], [-121.15029, 37.46575], [-121.15059, 37.46575], [-121.15063, 37.46573], [-121.15072, 37.46575], [-121.15088, 37.46571], [-121.1513, 37.46572], [-121.15135, 37.46576]]]} | Open Access 1 | 71 | Aprigold Park | 15545 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.755 | Aprigold Park | 0 | Local Park 2 | 4 | |
21 | 21 | 20 | {"type": "Polygon", "coordinates": [[[-121.14743, 37.47816], [-121.14709, 37.47823], [-121.14693, 37.47771], [-121.14719, 37.47764], [-121.14726, 37.47767], [-121.14743, 37.47816]]]} | Open Access 1 | 77 | Aurora Park | 15710 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.447 | Aurora Park | 0 | Local Park 2 | 4 | |
32 | 32 | 31 | {"type": "Polygon", "coordinates": [[[-121.1459, 37.47051], [-121.14458, 37.47106], [-121.14385, 37.46995], [-121.14391, 37.4699], [-121.1459, 37.47051]]]} | Open Access 1 | 81 | Autumn Royal Park | 15718 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.417 | Autumn Royal Park | 0 | Local Park 2 | 4 | |
33 | 33 | 32 | {"type": "Polygon", "coordinates": [[[-121.14984, 37.4662], [-121.14978, 37.46625], [-121.14941, 37.46624], [-121.14942, 37.46456], [-121.1496, 37.46457], [-121.14966, 37.46461], [-121.14965, 37.46506], [-121.14967, 37.46526], [-121.1497, 37.46547], [-121.14981, 37.46593], [-121.14984, 37.4662]]]} | Open Access 1 | 87 | Blenheim Park | 16159 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.244 | Blenheim Park | 0 | Local Park 2 | 4 | |
43 | 43 | 42 | {"type": "Polygon", "coordinates": [[[-121.15669, 37.46915], [-121.15657, 37.46931], [-121.15657, 37.46937], [-121.15661, 37.46943], [-121.15668, 37.46948], [-121.15648, 37.46951], [-121.15606, 37.46951], [-121.15586, 37.46948], [-121.15657, 37.46901], [-121.15669, 37.46906], [-121.15669, 37.46915]]]} | Open Access 1 | 98 | Castlebrite Park | 16958 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.519 | Castlebrite Park | 0 | Local Park 2 | 4 | |
48 | 48 | 47 | {"type": "Polygon", "coordinates": [[[-121.13139, 37.46901], [-121.13089, 37.46894], [-121.13099, 37.46845], [-121.13139, 37.46901], [-121.13139, 37.46901]]]} | Open Access 1 | 106 | Del Puerto Park | 18048 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.306 | Del Puerto Park | 0 | Local Park 2 | 4 | |
5780 | 5780 | 5779 | {"type": "Polygon", "coordinates": [[[-121.15626, 37.46621], [-121.15624, 37.46686], [-121.1555, 37.46686], [-121.15551, 37.4662], [-121.15626, 37.46621]]]} | Open Access 1 | 115 | Early Gold Park | 18356 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.191 | Early Gold Park | 0 | Local Park 2 | 4 | |
38 | 38 | 37 | {"type": "Polygon", "coordinates": [[[-121.12982, 37.47991], [-121.12928, 37.48015], [-121.12914, 37.47996], [-121.12969, 37.4797], [-121.12982, 37.47991]]]} | Open Access 1 | 121 | El Pescadero Park | 18527 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.352 | El Pescadero Park | 0 | Local Park 2 | 4 | |
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-121.12622, 37.47895], [-121.12464, 37.47968], [-121.12384, 37.47861], [-121.12544, 37.47788], [-121.12622, 37.47895]]]} | Open Access 1 | 128 | Felipe Garza Park | 18867 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 5.539 | Felipe Garza Park | 0 | Local Park 2 | 4 | |
5163 | 5163 | 5162 | {"type": "Polygon", "coordinates": [[[-121.15166, 37.46918], [-121.15088, 37.47082], [-121.15013, 37.4706], [-121.15013, 37.47015], [-121.15025, 37.47014], [-121.15026, 37.4691], [-121.15141, 37.46911], [-121.15166, 37.46918]]]} | Open Access 1 | 135 | Floragold Park | 18957 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 4.275 | Floragold Park | 0 | Local Park 2 | 4 | |
59 | 59 | 58 | {"type": "Polygon", "coordinates": [[[-121.1527, 37.47726], [-121.15269, 37.47821], [-121.15093, 37.47821], [-121.15093, 37.47775], [-121.15095, 37.47748], [-121.15165, 37.47732], [-121.15206, 37.47726], [-121.1527, 37.47726]]]} | Open Access 1 | 143 | Goldbar Park | 19357 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.779 | Goldbar Park | 0 | Local Park 2 | 4 | |
60 | 60 | 59 | {"type": "Polygon", "coordinates": [[[-121.14269, 37.47264], [-121.14187, 37.47299], [-121.14169, 37.47269], [-121.14164, 37.47256], [-121.1416, 37.47241], [-121.14166, 37.47235], [-121.14203, 37.47228], [-121.14236, 37.47215], [-121.14269, 37.47264]]]} | Open Access 1 | 148 | Golden Amber Park | 19358 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.295 | Golden Amber Park | 0 | Local Park 2 | 4 | |
5833 | 5833 | 5832 | {"type": "Polygon", "coordinates": [[[-121.14493, 37.46191], [-121.14464, 37.46191], [-121.14412, 37.46212], [-121.144, 37.46199], [-121.14368, 37.46171], [-121.14316, 37.46139], [-121.14344, 37.46118], [-121.14351, 37.4612], [-121.14357, 37.4612], [-121.14365, 37.46116], [-121.1449, 37.46116], [-121.14493, 37.46191]]]} | Open Access 1 | 160 | Meadow Rue Park | 22078 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.784 | Meadow Rue Park | 0 | Local Park 2 | 4 | |
5836 | 5836 | 5835 | {"type": "Polygon", "coordinates": [[[-121.149, 37.4605], [-121.149, 37.4608], [-121.14896, 37.46084], [-121.14742, 37.46083], [-121.14725, 37.46078], [-121.14714, 37.46081], [-121.1471, 37.46088], [-121.14639, 37.46087], [-121.14636, 37.46073], [-121.14638, 37.46068], [-121.14671, 37.46044], [-121.1471, 37.46005], [-121.14716, 37.46004], [-121.14729, 37.46008], [-121.14771, 37.46025], [-121.148, 37.46034], [-121.14847, 37.46043], [-121.14895, 37.46046], [-121.149, 37.4605]]]} | Open Access 1 | 168 | Mustang Clover Park | 22616 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.252 | Mustang Clover Park | 0 | Local Park 2 | 4 | |
73 | 73 | 72 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.1445, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | 172 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.056 | Newcastle Park | 0 | Local Park 2 | 4 | |
5841 | 5841 | 5840 | {"type": "Polygon", "coordinates": [[[-121.13122, 37.47881], [-121.13121, 37.47884], [-121.13118, 37.47888], [-121.13095, 37.47898], [-121.13089, 37.47899], [-121.13066, 37.47909], [-121.1306, 37.47915], [-121.12982, 37.47951], [-121.12975, 37.4795], [-121.1297, 37.47945], [-121.1297, 37.47941], [-121.12972, 37.47938], [-121.13004, 37.47924], [-121.13012, 37.47922], [-121.13034, 37.47912], [-121.13039, 37.47907], [-121.13109, 37.47875], [-121.13117, 37.47875], [-121.13122, 37.47881]]]} | Open Access 1 | 175 | Noble Park | 22779 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.565 | Noble Park | 0 | Local Park 2 | 4 | |
12329 | 12329 | 12328 | {"type": "Polygon", "coordinates": [[[-121.14932, 37.45758], [-121.14932, 37.45788], [-121.14927, 37.45789], [-121.14921, 37.45785], [-121.14914, 37.45783], [-121.14898, 37.45788], [-121.14862, 37.45787], [-121.14863, 37.45757], [-121.14932, 37.45758]]]} | Open Access 1 | 25996 | Patterson Gardens Parks | 23518 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.496 | Patterson Gardens Parks | None 1075 | |||
13776 | 13776 | 13775 | {"type": "Polygon", "coordinates": [[[-121.15526, 37.46194], [-121.15507, 37.46228], [-121.15456, 37.46207], [-121.15465, 37.46189], [-121.15464, 37.46185], [-121.15461, 37.46182], [-121.15454, 37.46182], [-121.15434, 37.46192], [-121.15427, 37.46191], [-121.15422, 37.46189], [-121.15457, 37.46164], [-121.1549, 37.4618], [-121.15526, 37.46194]]]} | Open Access 1 | 36322 | Patterson holding 1 | 23519 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.674 | Patterson holding 1 | 0 | Local Other or Unknown 14 | 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]);