units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2 and SUID_NMA = 9451
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10708 | 10708 | 10707 | {"type": "MultiPolygon", "coordinates": [[[[-117.37087, 33.994], [-117.37078, 33.99435], [-117.37031, 33.99412], [-117.36972, 33.99353], [-117.36958, 33.99334], [-117.36949, 33.99316], [-117.36942, 33.99296], [-117.36938, 33.99277], [-117.36938, 33.99257], [-117.3694, 33.99237], [-117.36946, 33.99218], [-117.36955, 33.99197], [-117.36982, 33.99158], [-117.37012, 33.99184], [-117.36983, 33.99208], [-117.36977, 33.99312], [-117.36986, 33.9934], [-117.37009, 33.99365], [-117.37087, 33.994]]], [[[-117.37086, 33.99581], [-117.37063, 33.99558], [-117.37069, 33.99542], [-117.37072, 33.99526], [-117.37073, 33.99505], [-117.37071, 33.99487], [-117.37066, 33.99469], [-117.3706, 33.99454], [-117.37052, 33.99438], [-117.37041, 33.99424], [-117.37078, 33.99442], [-117.37117, 33.99516], [-117.37118, 33.99526], [-117.37115, 33.99537], [-117.37086, 33.99581]]], [[[-117.39089, 33.99042], [-117.39043, 33.99084], [-117.38686, 33.99507], [-117.3868, 33.99555], [-117.38653, 33.99587], [-117.38657, 33.9959], [-117.38427, 33.99864], [-117.38249, 33.99753], [-117.38234, 33.99761], [-117.38223, 33.99748], [-117.38215, 33.99752], [-117.38192, 33.99732], [-117.3817, 33.99744], [-117.38134, 33.99699], [-117.38069, 33.99734], [-117.38051, 33.99749], [-117.38034, 33.99766], [-117.37982, 33.99846], [-117.37976, 33.99852], [-117.37777, 33.99728], [-117.37773, 33.99731], [-117.37699, 33.9973], [-117.37656, 33.99716], [-117.37477, 33.99998], [-117.37442, 33.99975], [-117.37329, 33.99888], [-117.37358, 33.99866], [-117.37363, 33.99866], [-117.37368, 33.99873], [-117.37379, 33.99867], [-117.37356, 33.99832], [-117.37344, 33.99837], [-117.37299, 33.99865], [-117.37265, 33.99841], [-117.37237, 33.99824], [-117.37197, 33.99803], [-117.37138, 33.99775], [-117.37116, 33.9976], [-117.37098, 33.99745], [-117.37082, 33.99726], [-117.37074, 33.99714], [-117.37064, 33.99692], [-117.37056, 33.99658], [-117.37179, 33.99475], [-117.37179, 33.99474], [-117.37172, 33.9947], [-117.37218, 33.99403], [-117.37276, 33.99431], [-117.37305, 33.99439], [-117.37325, 33.99441], [-117.37344, 33.99439], [-117.37359, 33.99437], [-117.37379, 33.99429], [-117.37395, 33.99422], [-117.37409, 33.9941], [-117.37421, 33.99398], [-117.37506, 33.99271], [-117.37512, 33.99268], [-117.37519, 33.99268], [-117.37549, 33.99282], [-117.37529, 33.99313], [-117.37651, 33.99369], [-117.37669, 33.99393], [-117.3769, 33.99408], [-117.37684, 33.9942], [-117.37732, 33.99442], [-117.37717, 33.99452], [-117.37707, 33.99455], [-117.37701, 33.99458], [-117.37698, 33.99466], [-117.37699, 33.9947], [-117.37703, 33.99474], [-117.37712, 33.99477], [-117.37721, 33.99475], [-117.37724, 33.99472], [-117.37731, 33.99461], [-117.3775, 33.99448], [-117.37753, 33.99443], [-117.37783, 33.99466], [-117.37789, 33.9946], [-117.37801, 33.99467], [-117.37783, 33.99488], [-117.37766, 33.99533], [-117.37764, 33.99544], [-117.3778, 33.99547], [-117.3779, 33.99516], [-117.37801, 33.99493], [-117.37812, 33.99479], [-117.37869, 33.99428], [-117.37876, 33.99418], [-117.3789, 33.99383], [-117.37904, 33.99362], [-117.37944, 33.9938], [-117.37962, 33.99385], [-117.38049, 33.99381], [-117.3807, 33.99384], [-117.38084, 33.99389], [-117.38092, 33.99378], [-117.3809, 33.99376], [-117.38078, 33.99371], [-117.38057, 33.99367], [-117.38026, 33.99367], [-117.3797, 33.99372], [-117.3796, 33.99371], [-117.37951, 33.99368], [-117.37912, 33.9935], [-117.37937, 33.99312], [-117.38044, 33.99363], [-117.38108, 33.9936], [-117.38137, 33.99371], [-117.38161, 33.99374], [-117.38197, 33.9937], [-117.38215, 33.99358], [-117.38205, 33.9935], [-117.38324, 33.99227], [-117.38375, 33.99209], [-117.38449, 33.99162], [-117.3851, 33.9919], [-117.38617, 33.9913], [-117.38799, 33.98968], [-117.38909, 33.99004], [-117.38943, 33.9901], [-117.39011, 33.99028], [-117.39089, 33.99042]], [[-117.37157, 33.99781], [-117.37158, 33.99783], [-117.37171, 33.99777], [-117.37168, 33.99774], [-117.37157, 33.99781]]]]} | Open Access 1 | 19864 | Fairmount Park | 9451 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/facilities.asp | Riverside 10 | 213.051 | Fairmount 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]);