units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where DES_TP = 2, LAYER = 4, MNG_AGENCY = 949 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 10 ✖
MNG_AGENCY 1
- North Highland Recreation and Park District · 10 ✖
DES_TP 1
- Local Park · 10 ✖
ACCESS_TYP 1
- Open Access 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11608 | 11608 | 11607 | {"type": "Polygon", "coordinates": [[[-121.38758, 38.70956], [-121.38611, 38.70912], [-121.38572, 38.70898], [-121.38548, 38.70889], [-121.38519, 38.70874], [-121.38493, 38.7086], [-121.38465, 38.70841], [-121.38489, 38.70825], [-121.38479, 38.70815], [-121.38651, 38.70702], [-121.38654, 38.70742], [-121.38609, 38.70789], [-121.38629, 38.70809], [-121.3864, 38.70834], [-121.38664, 38.7083], [-121.38687, 38.70832], [-121.387, 38.70835], [-121.38742, 38.70857], [-121.38757, 38.70862], [-121.38758, 38.70956]]]} | Open Access 1 | 23886 | Sierra Creek Park | 25453 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.58 | Sierra Creek Park | 0 | Local Park 2 | 4 | |
11611 | 11611 | 11610 | {"type": "Polygon", "coordinates": [[[-121.3739, 38.70349], [-121.37199, 38.70345], [-121.37204, 38.70206], [-121.37221, 38.70198], [-121.37273, 38.70186], [-121.37388, 38.70187], [-121.3739, 38.70349]]]} | Open Access 1 | 23891 | Brock Park | 16412 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.061 | Brock Park | 0 | Local Park 2 | 4 | |
11614 | 11614 | 11613 | {"type": "Polygon", "coordinates": [[[-121.37388, 38.70115], [-121.3725, 38.70116], [-121.37224, 38.70121], [-121.37226, 38.70119], [-121.37223, 38.70115], [-121.37208, 38.70118], [-121.37208, 38.70124], [-121.37203, 38.70125], [-121.37204, 38.69987], [-121.37388, 38.69989], [-121.37388, 38.70115]]]} | Open Access 1 | 23894 | Memorial Park | 22143 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.681 | Memorial Park | 0 | Local Park 2 | 4 | |
11615 | 11615 | 11614 | {"type": "Polygon", "coordinates": [[[-121.34373, 38.70028], [-121.34286, 38.70052], [-121.34276, 38.70044], [-121.34264, 38.70036], [-121.34249, 38.70031], [-121.34222, 38.70025], [-121.34216, 38.7002], [-121.34218, 38.70014], [-121.34247, 38.69986], [-121.34264, 38.69973], [-121.34332, 38.69927], [-121.34338, 38.69925], [-121.34348, 38.69932], [-121.34356, 38.69941], [-121.34364, 38.69954], [-121.34368, 38.69965], [-121.3437, 38.69979], [-121.3437, 38.70014], [-121.34373, 38.70028]]]} | Open Access 1 | 23895 | Chardonnay Park | 17137 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.8 | Chardonnay Park | 0 | Local Park 2 | 4 | |
11623 | 11623 | 11622 | {"type": "Polygon", "coordinates": [[[-121.37962, 38.68643], [-121.37957, 38.68671], [-121.37957, 38.68692], [-121.3796, 38.68713], [-121.37957, 38.68716], [-121.37857, 38.68731], [-121.37852, 38.6873], [-121.37849, 38.68727], [-121.37842, 38.68704], [-121.37826, 38.68674], [-121.37826, 38.6867], [-121.37841, 38.68659], [-121.37856, 38.68647], [-121.37869, 38.68633], [-121.37876, 38.68623], [-121.37879, 38.68621], [-121.37886, 38.68621], [-121.37957, 38.68637], [-121.37961, 38.68639], [-121.37962, 38.68643]]]} | Open Access 1 | 23905 | Larchmont Park | 21024 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.617 | Larchmont Park | 0 | Local Park 2 | 4 | |
11637 | 11637 | 11636 | {"type": "Polygon", "coordinates": [[[-121.37696, 38.67477], [-121.37463, 38.67475], [-121.37293, 38.67472], [-121.37299, 38.67455], [-121.37324, 38.6745], [-121.37328, 38.67456], [-121.37374, 38.67456], [-121.37375, 38.6745], [-121.37412, 38.6745], [-121.37414, 38.67456], [-121.37506, 38.67456], [-121.37507, 38.6745], [-121.37525, 38.6745], [-121.37526, 38.67456], [-121.3762, 38.67456], [-121.37621, 38.67454], [-121.37597, 38.6741], [-121.37647, 38.67391], [-121.37669, 38.67386], [-121.37688, 38.67385], [-121.37693, 38.67387], [-121.37694, 38.67392], [-121.37694, 38.67463], [-121.37696, 38.67477]]]} | Open Access 1 | 23922 | Karl Rosario Park | 20553 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.235 | Karl Rosario Park | 0 | Local Park 2 | 4 | |
11648 | 11648 | 11647 | {"type": "Polygon", "coordinates": [[[-121.38083, 38.66445], [-121.38077, 38.66445], [-121.38076, 38.66411], [-121.37966, 38.6641], [-121.37929, 38.66443], [-121.37922, 38.66443], [-121.38039, 38.66334], [-121.38083, 38.66334], [-121.38083, 38.66445]]]} | Open Access 1 | 23940 | Planehaven Park | 23768 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.651 | Planehaven Park | 0 | Local Park 2 | 4 | |
11649 | 11649 | 11648 | {"type": "MultiPolygon", "coordinates": [[[[-121.38263, 38.66289], [-121.3826, 38.66294], [-121.38256, 38.66296], [-121.38247, 38.66295], [-121.38244, 38.66291], [-121.38244, 38.66239], [-121.38242, 38.66227], [-121.38239, 38.66212], [-121.38232, 38.66196], [-121.38222, 38.66181], [-121.38206, 38.66163], [-121.38193, 38.66152], [-121.38191, 38.66146], [-121.38193, 38.6614], [-121.3824, 38.66096], [-121.38247, 38.66092], [-121.38253, 38.6609], [-121.38258, 38.66092], [-121.3826, 38.66095], [-121.3826, 38.66122], [-121.38243, 38.66132], [-121.38244, 38.66144], [-121.38263, 38.66146], [-121.38263, 38.66289]]], [[[-121.38261, 38.66389], [-121.38263, 38.66434], [-121.38265, 38.66441], [-121.38262, 38.66445], [-121.38257, 38.66447], [-121.38249, 38.66444], [-121.38245, 38.66437], [-121.38244, 38.66325], [-121.38255, 38.66321], [-121.38259, 38.66324], [-121.38262, 38.66329], [-121.3826, 38.66342], [-121.38261, 38.66378], [-121.38259, 38.66379], [-121.38259, 38.66388], [-121.38261, 38.66389]]]]} | Open Access 1 | 23941 | Ruth Inman Park | 24753 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/parks-and-facilities/ruth-inman/ | Sacramento 41 | 2.102 | Ruth Inman Park | 0 | Local Park 2 | 4 |
13643 | 13643 | 13642 | {"type": "Polygon", "coordinates": [[[-121.35818, 38.70102], [-121.35718, 38.70101], [-121.35719, 38.70042], [-121.35676, 38.69988], [-121.35614, 38.69967], [-121.35646, 38.69952], [-121.35742, 38.69916], [-121.35768, 38.69907], [-121.35798, 38.69901], [-121.35812, 38.69949], [-121.35818, 38.69954], [-121.35812, 38.6996], [-121.35811, 38.69966], [-121.35815, 38.69976], [-121.35825, 38.70096], [-121.35823, 38.701], [-121.35818, 38.70102]]]} | Open Access 1 | 36020 | Ridgepoint Park | 24355 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.636 | Ridgepoint Park | 0 | Local Park 2 | 4 | |
14951 | 14951 | 14950 | {"type": "Polygon", "coordinates": [[[-121.39135, 38.67285], [-121.39135, 38.6736], [-121.39045, 38.67423], [-121.39025, 38.67455], [-121.39021, 38.67582], [-121.389, 38.6758], [-121.389, 38.67514], [-121.38893, 38.67507], [-121.38884, 38.67503], [-121.38849, 38.67503], [-121.38849, 38.67414], [-121.38858, 38.67407], [-121.38863, 38.67397], [-121.38866, 38.67288], [-121.38877, 38.67288], [-121.38888, 38.67268], [-121.38907, 38.67251], [-121.38931, 38.6724], [-121.38958, 38.67234], [-121.38958, 38.67227], [-121.39103, 38.67228], [-121.39104, 38.67271], [-121.39115, 38.67284], [-121.39135, 38.67285]]]} | Open Access 1 | 45556 | Freedom Park | 28384 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/parksfacilities/ | Sacramento 41 | 16.727 | Freedom 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]);