units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_LEV = 3, DES_TP = 2, MNG_AGENCY = 497 and PARK_URL = "http://www.stancounty.com/ER/PARKS/off-road-park.shtm"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16365 | 16365 | 16364 | {"type": "MultiPolygon", "coordinates": [[[[-121.35295, 37.41858], [-121.35294, 37.42008], [-121.35266, 37.42028], [-121.35202, 37.42062], [-121.35141, 37.42092], [-121.35068, 37.42102], [-121.34998, 37.42079], [-121.34931, 37.42045], [-121.34846, 37.42026], [-121.34755, 37.42025], [-121.34663, 37.42035], [-121.34571, 37.42036], [-121.34476, 37.4204], [-121.34395, 37.42068], [-121.34337, 37.42116], [-121.34311, 37.42184], [-121.34282, 37.42255], [-121.34269, 37.42331], [-121.34252, 37.42402], [-121.34173, 37.42534], [-121.3414, 37.42593], [-121.34078, 37.4264], [-121.34017, 37.42705], [-121.33905, 37.42811], [-121.33755, 37.42629], [-121.33567, 37.42727], [-121.33567, 37.42729], [-121.33701, 37.42888], [-121.33661, 37.42903], [-121.33628, 37.42959], [-121.33636, 37.43021], [-121.3367, 37.4307], [-121.33678, 37.43121], [-121.33668, 37.43182], [-121.33679, 37.43242], [-121.33679, 37.43286], [-121.33661, 37.43301], [-121.3366, 37.43076], [-121.33355, 37.4311], [-121.33356, 37.4208], [-121.35254, 37.41859], [-121.35295, 37.41858]]], [[[-121.33605, 37.43487], [-121.33588, 37.43511], [-121.3357, 37.43571], [-121.33563, 37.43631], [-121.33569, 37.43755], [-121.33596, 37.43804], [-121.33588, 37.43839], [-121.33551, 37.43878], [-121.33519, 37.43893], [-121.33452, 37.43898], [-121.33397, 37.43912], [-121.33345, 37.43908], [-121.3331, 37.43901], [-121.33302, 37.43867], [-121.33286, 37.43821], [-121.33227, 37.43783], [-121.33167, 37.43765], [-121.33356, 37.43515], [-121.33605, 37.43487]]], [[[-121.35293, 37.42038], [-121.35281, 37.433], [-121.34756, 37.44017], [-121.32798, 37.44253], [-121.3315, 37.4379], [-121.33162, 37.43787], [-121.33212, 37.43803], [-121.33262, 37.43833], [-121.33274, 37.43872], [-121.33286, 37.43919], [-121.33341, 37.43929], [-121.334, 37.43934], [-121.33456, 37.43921], [-121.33527, 37.43914], [-121.3357, 37.43894], [-121.33614, 37.43849], [-121.33624, 37.438], [-121.33596, 37.4375], [-121.3359, 37.43632], [-121.33596, 37.43574], [-121.33614, 37.43519], [-121.3364, 37.43483], [-121.33662, 37.43479], [-121.33662, 37.43333], [-121.33705, 37.43295], [-121.33707, 37.43241], [-121.33696, 37.43182], [-121.33706, 37.43121], [-121.33697, 37.43063], [-121.33664, 37.43014], [-121.33655, 37.42964], [-121.33681, 37.4292], [-121.33716, 37.42907], [-121.33812, 37.43019], [-121.33994, 37.42919], [-121.33921, 37.42829], [-121.34039, 37.42719], [-121.34099, 37.42655], [-121.34163, 37.42606], [-121.34198, 37.42544], [-121.34279, 37.42408], [-121.34296, 37.42334], [-121.34308, 37.4226], [-121.34338, 37.4219], [-121.34361, 37.42127], [-121.34411, 37.42086], [-121.34483, 37.42062], [-121.34572, 37.42057], [-121.34665, 37.42056], [-121.34756, 37.42046], [-121.34842, 37.42048], [-121.34919, 37.42065], [-121.34985, 37.42098], [-121.35065, 37.42124], [-121.35151, 37.42113], [-121.35218, 37.4208], [-121.35285, 37.42046], [-121.35293, 37.42038]]], [[[-121.37111, 37.41544], [-121.37168, 37.41593], [-121.37204, 37.41651], [-121.37309, 37.41669], [-121.37361, 37.4173], [-121.37416, 37.41761], [-121.37451, 37.4179], [-121.37483, 37.41844], [-121.38892, 37.41835], [-121.39212, 37.41822], [-121.39202, 37.41827], [-121.39199, 37.41834], [-121.39245, 37.41885], [-121.39341, 37.41905], [-121.39335, 37.42518], [-121.39336, 37.42889], [-121.39334, 37.43151], [-121.39457, 37.43248], [-121.39786, 37.43251], [-121.39797, 37.43605], [-121.40693, 37.43597], [-121.40707, 37.44857], [-121.40202, 37.4486], [-121.40178, 37.44821], [-121.40106, 37.44767], [-121.40093, 37.44754], [-121.40079, 37.44744], [-121.40026, 37.44725], [-121.39987, 37.44718], [-121.39954, 37.44705], [-121.3992, 37.44694], [-121.39763, 37.44691], [-121.39697, 37.44681], [-121.39657, 37.44671], [-121.39597, 37.44638], [-121.39537, 37.44616], [-121.3948, 37.44604], [-121.39389, 37.44591], [-121.39254, 37.4459], [-121.39162, 37.44554], [-121.38969, 37.44484], [-121.38911, 37.44427], [-121.38811, 37.444], [-121.38783, 37.44381], [-121.3875, 37.44319], [-121.38731, 37.44286], [-121.38708, 37.4426], [-121.38671, 37.44235], [-121.38639, 37.44224], [-121.38606, 37.4423], [-121.38531, 37.44272], [-121.38505, 37.44275], [-121.38481, 37.44268], [-121.38415, 37.44228], [-121.38386, 37.44209], [-121.38378, 37.44207], [-121.38357, 37.44197], [-121.3834, 37.44176], [-121.38322, 37.44147], [-121.3826, 37.44089], [-121.38228, 37.44056], [-121.38213, 37.44033], [-121.38193, 37.44015], [-121.37475, 37.44064], [-121.37532, 37.43979], [-121.37531, 37.43977], [-121.36599, 37.4404], [-121.37108, 37.43261], [-121.37099, 37.41847], [-121.36185, 37.41852], [-121.36199, 37.41135], [-121.35292, 37.41137], [-121.35311, 37.40421], [-121.36204, 37.40411], [-121.36285, 37.40837], [-121.36397, 37.40841], [-121.36501, 37.40828], [-121.36528, 37.4086], [-121.36541, 37.40932], [-121.36545, 37.41012], [-121.36654, 37.41208], [-121.36643, 37.41237], [-121.36659, 37.41303], [-121.36721, 37.41417], [-121.36746, 37.41426], [-121.36788, 37.41449], [-121.36882, 37.41512], [-121.37026, 37.41518], [-121.37089, 37.41527], [-121.37111, 37.41544]]]]} | Open Access 1 | 18163 | Frank Raines Regional Park | 12793 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/ER/PARKS/off-road-park.shtm | Stanislaus 2 | 2981.626 | Frank Raines RP | 0 | Local Park 2 | 4 |
16369 | 16369 | 16368 | {"type": "MultiPolygon", "coordinates": [[[[-120.46168, 37.66621], [-120.46152, 37.66673], [-120.45807, 37.66672], [-120.45809, 37.66563], [-120.4582, 37.66566], [-120.45838, 37.66567], [-120.45862, 37.66579], [-120.45884, 37.66586], [-120.45939, 37.66592], [-120.45971, 37.66599], [-120.46014, 37.66601], [-120.46053, 37.66614], [-120.46063, 37.66614], [-120.46082, 37.66618], [-120.46118, 37.66619], [-120.46128, 37.66617], [-120.46154, 37.66618], [-120.46168, 37.66621]]], [[[-120.46208, 37.66442], [-120.46207, 37.6648], [-120.46203, 37.66502], [-120.46193, 37.6653], [-120.46184, 37.66564], [-120.46147, 37.66561], [-120.46127, 37.66562], [-120.46069, 37.66551], [-120.45996, 37.6655], [-120.45962, 37.66552], [-120.45912, 37.66548], [-120.45864, 37.66536], [-120.45856, 37.66532], [-120.45822, 37.66525], [-120.45808, 37.66525], [-120.4581, 37.66305], [-120.46031, 37.66307], [-120.46049, 37.66318], [-120.46053, 37.66361], [-120.45954, 37.66364], [-120.45961, 37.66425], [-120.4599, 37.66425], [-120.45994, 37.66449], [-120.4605, 37.66447], [-120.46041, 37.66382], [-120.46071, 37.66381], [-120.46081, 37.66446], [-120.46208, 37.66442]]], [[[-120.4713, 37.66349], [-120.47127, 37.66436], [-120.47115, 37.66436], [-120.47114, 37.66437], [-120.47135, 37.66699], [-120.47123, 37.66867], [-120.47112, 37.66904], [-120.47086, 37.66955], [-120.47031, 37.67041], [-120.47008, 37.67067], [-120.47, 37.67073], [-120.46898, 37.67032], [-120.4681, 37.6702], [-120.46729, 37.67023], [-120.46725, 37.6686], [-120.46608, 37.66859], [-120.46599, 37.66851], [-120.46575, 37.66847], [-120.46564, 37.66854], [-120.4655, 37.66845], [-120.4653, 37.66866], [-120.46492, 37.66834], [-120.4649, 37.66747], [-120.46265, 37.66674], [-120.46169, 37.66672], [-120.46184, 37.66625], [-120.46218, 37.66633], [-120.46233, 37.66638], [-120.46326, 37.66659], [-120.46377, 37.66673], [-120.46319, 37.66673], [-120.46319, 37.66675], [-120.4638, 37.66675], [-120.46379, 37.666], [-120.46377, 37.66601], [-120.46377, 37.66615], [-120.46364, 37.66615], [-120.46327, 37.66608], [-120.46281, 37.6659], [-120.46201, 37.66568], [-120.46219, 37.66505], [-120.46269, 37.66507], [-120.46378, 37.66505], [-120.46378, 37.66546], [-120.46808, 37.66545], [-120.46808, 37.66358], [-120.46987, 37.66361], [-120.47068, 37.66354], [-120.4707, 37.66359], [-120.4713, 37.66349]]], [[[-120.4644, 37.66195], [-120.46436, 37.66271], [-120.46356, 37.66267], [-120.46233, 37.66216], [-120.46181, 37.66207], [-120.46172, 37.66199], [-120.46176, 37.66179], [-120.46307, 37.66183], [-120.46308, 37.66189], [-120.4644, 37.66195]]], [[[-120.48166, 37.66175], [-120.48149, 37.66362], [-120.47992, 37.66363], [-120.47948, 37.66345], [-120.47894, 37.66466], [-120.47895, 37.66468], [-120.47911, 37.66468], [-120.47918, 37.66486], [-120.47902, 37.66497], [-120.47976, 37.66627], [-120.47936, 37.66638], [-120.47898, 37.66644], [-120.47867, 37.66647], [-120.47743, 37.66673], [-120.47696, 37.66675], [-120.47673, 37.66686], [-120.47646, 37.66685], [-120.47618, 37.66693], [-120.47512, 37.66692], [-120.47497, 37.66695], [-120.4745, 37.6669], [-120.47375, 37.66688], [-120.47346, 37.66683], [-120.47309, 37.6668], [-120.47304, 37.66677], [-120.47221, 37.66668], [-120.47203, 37.66441], [-120.47192, 37.6644], [-120.47199, 37.66332], [-120.47301, 37.66306], [-120.47305, 37.66289], [-120.47597, 37.66218], [-120.47764, 37.66183], [-120.47911, 37.66175], [-120.48076, 37.662], [-120.48166, 37.66175]]], [[[-120.48583, 37.65913], [-120.48495, 37.66053], [-120.48461, 37.66078], [-120.48471, 37.66064], [-120.4858, 37.65842], [-120.48583, 37.65913]]], [[[-120.50093, 37.63795], [-120.50046, 37.63827], [-120.50011, 37.63854], [-120.49947, 37.63915], [-120.49619, 37.64287], [-120.49451, 37.64468], [-120.49329, 37.64588], [-120.49214, 37.64738], [-120.49193, 37.64779], [-120.49184, 37.64812], [-120.49205, 37.64838], [-120.49167, 37.64883], [-120.49087, 37.64999], [-120.49028, 37.65089], [-120.49029, 37.64868], [-120.48691, 37.64869], [-120.48695, 37.64509], [-120.49149, 37.6451], [-120.49253, 37.64154], [-120.49313, 37.64155], [-120.49301, 37.64026], [-120.49329, 37.63872], [-120.49317, 37.63794], [-120.49266, 37.63644], [-120.49199, 37.63533], [-120.49183, 37.63491], [-120.49178, 37.63441], [-120.49146, 37.63409], [-120.4911, 37.63356], [-120.49069, 37.63333], [-120.4906, 37.63346], [-120.49033, 37.63363], [-120.49033, 37.63319], [-120.49128, 37.63214], [-120.49114, 37.63203], [-120.49136, 37.63177], [-120.49308, 37.62991], [-120.49385, 37.62931], [-120.49505, 37.62842], [-120.49594, 37.62843], [-120.49595, 37.62722], [-120.49662, 37.62686], [-120.49938, 37.62687], [-120.49936, 37.63795], [-120.50093, 37.63795]]], [[[-120.4949, 37.64735], [-120.49476, 37.64753], [-120.49464, 37.64764], [-120.4944, 37.64779], [-120.49439, 37.64788], [-120.49436, 37.64794], [-120.49425, 37.64802], [-120.49416, 37.64813], [-120.49413, 37.64823], [-120.49414, 37.64842], [-120.49415, 37.64843], [-120.49441, 37.64816], [-120.49449, 37.64812], [-120.49459, 37.64811], [-120.49467, 37.64814], [-120.49469, 37.64823], [-120.49469, 37.64844], [-120.49459, 37.64861], [-120.49447, 37.64894], [-120.4944, 37.64962], [-120.49439, 37.64988], [-120.49431, 37.65007], [-120.4943, 37.65028], [-120.49424, 37.65048], [-120.49418, 37.65053], [-120.49414, 37.65061], [-120.49404, 37.65096], [-120.4939, 37.65124], [-120.4938, 37.65134], [-120.49367, 37.65145], [-120.49357, 37.6515], [-120.49343, 37.65168], [-120.49331, 37.6518], [-120.4932, 37.65188], [-120.49283, 37.65202], [-120.49262, 37.65214], [-120.49224, 37.65226], [-120.49215, 37.65234], [-120.49028, 37.65234], [-120.49027, 37.65119], [-120.49062, 37.65106], [-120.49238, 37.64871], [-120.49266, 37.64844], [-120.49319, 37.64808], [-120.4935, 37.64792], [-120.49383, 37.64778], [-120.4949, 37.64735]]], [[[-120.4958, 37.64538], [-120.49568, 37.64558], [-120.49549, 37.6458], [-120.49535, 37.64607], [-120.49513, 37.64632], [-120.49498, 37.64658], [-120.49496, 37.64669], [-120.49498, 37.64676], [-120.49364, 37.64728], [-120.49351, 37.64731], [-120.49297, 37.64753], [-120.49261, 37.64772], [-120.49248, 37.64782], [-120.4924, 37.64785], [-120.49217, 37.64803], [-120.49205, 37.64797], [-120.49209, 37.64785], [-120.49231, 37.64743], [-120.49344, 37.64595], [-120.49417, 37.64523], [-120.49447, 37.6451], [-120.49459, 37.64508], [-120.49494, 37.64508], [-120.4951, 37.64512], [-120.4958, 37.64538]]]]} | Open Access 1 | 18171 | La Grange Regional Park | 12795 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/ER/PARKS/off-road-park.shtm | Stanislaus 2 | 556.421 | La Grange RP | 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]);