trees
334 rows where qSpecies_id = 59 sorted by YCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36058 | 6095 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2015 12:00:00 AM | 12 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | ||
| 129436 | 6094 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 145827 | 6098 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 100061 | 195998 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6016075.49067 | 2110714.30849 | 37.7765217283366 | -122.387885542896 | (37.7765217283366, -122.387885542896) | 14 | 3 | 9 | 310 | 20 | ||||
| 175828 | 195997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | 14 | 3 | 9 | 310 | 20 | ||||
| 10408 | 195999 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6016051.5903 | 2110711.60548 | 37.7765129824099 | -122.387968033214 | (37.7765129824099, -122.387968033214) | 14 | 3 | 9 | 310 | 20 | ||||
| 32582 | 196000 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6016029.90141 | 2110710.35403 | 37.7765083446095 | -122.38804297462 | (37.7765083446095, -122.38804297462) | 14 | 3 | 9 | 310 | 20 | ||||
| 137112 | 196001 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6016008.12939 | 2110708.52586 | 37.7765021186104 | -122.388118163334 | (37.7765021186104, -122.388118163334) | 14 | 3 | 9 | 310 | 20 | ||||
| 185058 | 196002 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015985.51722 | 2110706.09628 | 37.7764941946745 | -122.388196216398 | (37.7764941946745, -122.388196216398) | 14 | 3 | 9 | 310 | 20 | ||||
| 121735 | 196003 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015962.95079 | 2110705.93329 | 37.7764924967751 | -122.388274269443 | (37.7764924967751, -122.388274269443) | 14 | 3 | 9 | 310 | 20 | ||||
| 191532 | 196004 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015940.35109 | 2110704.12187 | 37.7764862707572 | -122.388352322497 | (37.7764862707572, -122.388352322497) | 14 | 3 | 9 | 310 | 20 | ||||
| 87935 | 196005 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015919.22066 | 2110703.31156 | 37.7764828749315 | -122.38842536276 | (37.7764828749315, -122.38842536276) | 14 | 3 | 9 | 310 | 20 | ||||
| 80958 | 196006 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6015895.59891 | 2110702.13918 | 37.7764783468376 | -122.388506996001 | (37.7764783468376, -122.388506996001) | 14 | 3 | 9 | 310 | 20 | ||||
| 81978 | 196007 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015874.48096 | 2110701.94702 | 37.7764766489106 | -122.388580036236 | (37.7764766489106, -122.388580036236) | 14 | 3 | 9 | 310 | 20 | ||||
| 145197 | 196008 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015854.16157 | 2110700.296 | 37.7764709894889 | -122.388650212137 | (37.7764709894889, -122.388650212137) | 14 | 3 | 9 | 310 | 20 | ||||
| 126204 | 196009 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | 14 | 3 | 9 | 310 | 20 | ||||
| 37957 | 196010 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015807.5178 | 2110696.90854 | 37.7764591031505 | -122.38881133109 | (37.7764591031505, -122.38881133109) | 14 | 3 | 9 | 310 | 20 | ||||
| 84576 | 196011 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015786.39152 | 2110696.30426 | 37.7764562729832 | -122.388884371337 | (37.7764562729832, -122.388884371337) | 14 | 3 | 9 | 310 | 20 | ||||
| 23490 | 196012 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015764.41678 | 2110694.68671 | 37.7764506135265 | -122.388960275907 | (37.7764506135265, -122.388960275907) | 14 | 3 | 9 | 310 | 20 | ||||
| 49343 | 196013 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015743.28218 | 2110693.67028 | 37.7764466511333 | -122.389033316139 | (37.7764466511333, -122.389033316139) | 14 | 3 | 9 | 310 | 20 | ||||
| 30255 | 196014 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015720.48392 | 2110692.27541 | 37.7764415573597 | -122.389112085054 | (37.7764415573597, -122.389112085054) | 14 | 3 | 9 | 310 | 20 | ||||
| 184380 | 196015 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015698.09519 | 2110690.66596 | 37.7764358970472 | -122.389189422279 | (37.7764358970472, -122.389189422279) | 14 | 3 | 9 | 310 | 20 | ||||
| 155750 | 196017 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015653.37625 | 2110690.3321 | 37.776432501193 | -122.389344095768 | (37.776432501193, -122.389344095768) | 14 | 3 | 9 | 310 | 20 | ||||
| 169789 | 196016 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015678.42156 | 2110690.23877 | 37.7764336334278 | -122.389257449686 | (37.7764336334278, -122.389257449686) | 14 | 3 | 9 | 310 | 20 | ||||
| 6092 | 196018 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015632.04702 | 2110689.93838 | 37.7764302375944 | -122.389417852744 | (37.7764302375944, -122.389417852744) | 14 | 3 | 9 | 310 | 20 | ||||
| 158107 | 196020 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015589.15281 | 2110687.71234 | 37.7764217471115 | -122.38956608172 | (37.7764217471115, -122.38956608172) | 14 | 3 | 9 | 310 | 20 | ||||
| 138177 | 196019 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015611.09455 | 2110687.68162 | 37.7764228793455 | -122.389490176245 | (37.7764228793455, -122.389490176245) | 14 | 3 | 9 | 310 | 20 | ||||
| 39747 | 196021 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6015567.39764 | 2110686.7089 | 37.7764177856004 | -122.389641269543 | (37.7764177856004, -122.389641269543) | 14 | 3 | 9 | 310 | 20 | ||||
| 68586 | 196022 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6015549.75144 | 2110684.1794 | 37.7764098616684 | -122.389702136539 | (37.7764098616684, -122.389702136539) | 14 | 3 | 9 | 310 | 20 | ||||
| 187951 | 244409 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6005580.6462 | 2110260.99 | 37.7746900436181 | -122.424158015373 | (37.7746900436181, -122.424158015373) | 7 | 9 | 11 | 28852 | 10 | |||
| 116865 | 244408 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005581.41 | 2110245.7143 | 37.7746481433715 | -122.424154286626 | (37.7746481433715, -122.424154286626) | 7 | 9 | 11 | 28852 | 10 | |||
| 61977 | 244407 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | 7 | 9 | 11 | 28852 | 10 | |||
| 101044 | 244406 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005586.7565 | 2110217.4543 | 37.7745708501281 | -122.424133781799 | (37.7745708501281, -122.424133781799) | 7 | 9 | 11 | 28852 | 10 | |||
| 136053 | 244405 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005589.0478 | 2110200.651 | 37.7745248417047 | -122.424124660487 | (37.7745248417047, -122.424124660487) | 7 | 9 | 11 | 28852 | 10 | |||
| 98854 | 244404 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005594.3943 | 2110164.7531 | 37.7744265766299 | -122.424103612435 | (37.7744265766299, -122.424103612435) | 7 | 9 | 11 | 28852 | 10 | |||
| 77096 | 244403 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005596.6857 | 2110150.2412 | 37.7743868598384 | -122.424094653801 | (37.7743868598384, -122.424094653801) | 7 | 9 | 11 | 28852 | 10 | |||
| 124424 | 244402 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005599.7408 | 2110138.7844 | 37.7743555747298 | -122.424083270702 | (37.7743555747298, -122.424083270702) | 7 | 9 | 11 | 28852 | 10 | |||
| 85065 | 244266 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005600.5046 | 2110125.0362 | 37.7743178686238 | -122.424079650665 | (37.7743178686238, -122.424079650665) | 7 | 9 | 11 | 28852 | 10 | |||
| 112727 | 244265 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005602.0322 | 2110112.8157 | 37.7742844003359 | -122.42407349717 | (37.7742844003359, -122.42407349717) | 7 | 9 | 11 | 28852 | 10 | |||
| 127892 | 244264 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005607.3787 | 2110087.6108 | 37.7742154956389 | -122.424053209833 | (37.7742154956389, -122.424053209833) | 7 | 9 | 11 | 28852 | 10 | |||
| 44966 | 244263 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005610.4338 | 2110073.0988 | 37.7741758216851 | -122.424041609468 | (37.7741758216851, -122.424041609468) | 7 | 9 | 11 | 28852 | 10 | |||
| 147228 | 244262 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.7252 | 2110055.5318 | 37.7741277163216 | -122.424032433594 | (37.7741277163216, -122.424032433594) | 7 | 9 | 11 | 28852 | 10 | |||
| 100001 | 244261 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005613.489 | 2110034.9096 | 37.7740711358709 | -122.424028324662 | (37.7740711358709, -122.424028324662) | 7 | 9 | 11 | 28852 | 10 | |||
| 148940 | 244260 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.2528 | 2110021.9252 | 37.7740355269714 | -122.424024758994 | (37.7740355269714, -122.424024758994) | 7 | 9 | 11 | 28852 | 10 | |||
| 92490 | 244339 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 16 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005625.7255 | 2109918.6883 | 37.7737527111209 | -122.423977730108 | (37.7737527111209, -122.423977730108) | 7 | 9 | 11 | 28852 | 10 | |||
| 168738 | 244338 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005626.4106 | 2109908.4113 | 37.7737245316409 | -122.42397462928 | (37.7737245316409, -122.42397462928) | 7 | 9 | 11 | 28852 | 10 | |||
| 121894 | 244337 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005627.7809 | 2109896.0788 | 37.7736907469384 | -122.423969012041 | (37.7736907469384, -122.423969012041) | 7 | 9 | 11 | 28852 | 10 | |||
| 46467 | 244336 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | 7 | 9 | 11 | 28852 | 10 | |||
| 59524 | 244335 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | 7 | 9 | 11 | 28852 | 10 | |||
| 122485 | 244334 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005631.2066 | 2109866.6178 | 37.7736100475528 | -122.423955066597 | (37.7736100475528, -122.423955066597) | 7 | 9 | 11 | 28852 | 10 | |||
| 178442 | 244333 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005640.1134 | 2109813.177 | 37.773463814863 | -122.423920455707 | (37.773463814863, -122.423920455707) | 7 | 9 | 11 | 28852 | 10 | |||
| 153224 | 244332 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005642.1688 | 2109804.2702 | 37.7734394749788 | -122.423912712296 | (37.7734394749788, -122.423912712296) | 7 | 9 | 11 | 28852 | 10 | |||
| 131182 | 244434 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005644.2243 | 2109791.2526 | 37.7734038478353 | -122.423904676174 | (37.7734038478353, -122.423904676174) | 7 | 9 | 11 | 28852 | 10 | |||
| 117263 | 244433 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.423891754495 | (37.7733626541324, -122.423891754495) | 7 | 9 | 11 | 28852 | 10 | |||
| 150696 | 244432 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005649.0202 | 2109761.1065 | 37.7733213446724 | -122.423885942412 | (37.7733213446724, -122.423885942412) | 7 | 9 | 11 | 28852 | 10 | |||
| 83892 | 244431 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.7732013716398 | -122.423856754026 | (37.7732013716398, -122.423856754026) | 7 | 9 | 11 | 28852 | 10 | |||
| 39892 | 244430 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.423851185605 | (37.7731694680478, -122.423851185605) | 7 | 9 | 11 | 28852 | 10 | |||
| 34981 | 244429 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005659.2973 | 2109696.7034 | 37.7731450894818 | -122.4238458121 | (37.7731450894818, -122.4238458121) | 7 | 9 | 11 | 28852 | 10 | |||
| 125575 | 244428 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005659.9824 | 2109685.0561 | 37.7731131474821 | -122.423842613892 | (37.7731131474821, -122.423842613892) | 7 | 9 | 11 | 28852 | 10 | |||
| 184838 | 244427 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005661.3527 | 2109672.0384 | 37.7730774813758 | -122.423836948028 | (37.7730774813758, -122.423836948028) | 7 | 9 | 11 | 28852 | 10 | |||
| 80487 | 246571 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 15 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | 7 | 9 | 11 | 28852 | 10 | |||
| 165695 | 246570 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 14 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005693.82305 | 2109545.39115 | 37.7727315715478 | -122.423715622299 | (37.7727315715478, -122.423715622299) | 7 | 9 | 11 | 28852 | 10 | |||
| 100151 | 246569 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 13 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005694.60842 | 2109539.50826 | 37.772715462883 | -122.423712487254 | (37.772715462883, -122.423712487254) | 7 | 9 | 11 | 28852 | 10 | |||
| 115890 | 246568 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005695.27816 | 2109533.51475 | 37.7726990439551 | -122.423709744321 | (37.7726990439551, -122.423709744321) | 7 | 9 | 11 | 28852 | 10 | |||
| 32481 | 246567 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | 7 | 9 | 11 | 28852 | 10 | |||
| 142683 | 246566 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 10 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005705.41603 | 2109475.54193 | 37.772540436826 | -122.423670553651 | (37.772540436826, -122.423670553651) | 7 | 9 | 11 | 28852 | 10 | |||
| 37967 | 246565 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.7725208666788 | -122.423667646169 | (37.7725208666788, -122.423667646169) | 7 | 9 | 11 | 28852 | 10 | |||
| 26372 | 246564 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | 7 | 9 | 11 | 28852 | 10 | |||
| 148891 | 246563 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 14 | Width 7ft | 6005707.64026 | 2109451.46523 | 37.7724744535597 | -122.423661147645 | (37.7724744535597, -122.423661147645) | 7 | 9 | 11 | 28852 | 10 | |||
| 24737 | 246562 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | 7 | 9 | 11 | 28852 | 10 | |||
| 84264 | 246561 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.423619884948 | (37.7722999149342, -122.423619884948) | 7 | 9 | 11 | 28852 | 10 | |||
| 67742 | 246560 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | 7 | 9 | 11 | 28852 | 10 | |||
| 19788 | 246559 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.423601653893 | (37.7722588698898, -122.423601653893) | 7 | 9 | 11 | 28852 | 10 | |||
| 81955 | 246558 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 2 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.7722394013476 | -122.423593061791 | (37.7722394013476, -122.423593061791) | 7 | 9 | 11 | 28852 | 10 | |||
| 178785 | 246557 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 1 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005728.07536 | 2109359.17359 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | 7 | 9 | 11 | 28852 | 10 | |||
| 16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
| 111973 | 247225 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002109.57301 | 2108309.81574 | 37.7691360073432 | -122.4360254903 | (37.7691360073432, -122.4360254903) | 15 | 5 | 5 | 29492 | 9 | ||||
| 96656 | 248613 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | 15 | 5 | 11 | 29492 | 9 | |||
| 145764 | 246917 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5997637.48509 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | 15 | 5 | 11 | 29492 | 9 | |||
| 74379 | 246918 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 5997638.10514 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | 15 | 5 | 11 | 29492 | 9 | |||
| 102733 | 248614 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | 15 | 5 | 11 | 29492 | 9 | |||
| 100049 | 196024 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6013848.21751 | 2107498.56576 | 37.7675683801977 | -122.395365047877 | (37.7675683801977, -122.395365047877) | 14 | 3 | 9 | 310 | 20 | |||
| 108842 | 196023 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6013858.29957 | 2107482.27299 | 37.7675242045935 | -122.395329033601 | (37.7675242045935, -122.395329033601) | 14 | 3 | 9 | 310 | 20 | |||
| 88473 | 85294 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2255 Mariposa St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752 | 2105977 | 37.7632178155038 | -122.405967315915 | (37.7632178155038, -122.405967315915) | 8 | 4 | 8 | 28859 | 19 | |||
| 99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
| 150253 | 234896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 10ft | 6007240.7393 | 2101963.94083 | 37.7520018736867 | -122.417827151095 | (37.7520018736867, -122.417827151095) | 2 | 4 | 7 | 28859 | 19 | |||
| 165442 | 234871 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010740.98958 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | 10 | 4 | 7 | 28859 | 19 | ||||
| 24893 | 234872 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | 10 | 4 | 7 | 28859 | 19 | ||||
| 21087 | 234873 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6010726.23893 | 2100862.83367 | 37.7491740112676 | -122.405696174457 | (37.7491740112676, -122.405696174457) | 10 | 4 | 7 | 28859 | 19 | ||||
| 111134 | 234874 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356 | (37.7491536092595, -122.40577509356) | 10 | 4 | 7 | 28859 | 19 | ||||
| 66581 | 234875 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | 10 | 4 | 7 | 28859 | 19 | ||||
| 146008 | 234876 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | 6010649.76891 | 2100846.09542 | 37.7491237751432 | -122.405959431208 | (37.7491237751432, -122.405959431208) | 10 | 4 | 7 | 28859 | 19 | ||||
| 182229 | 234877 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | 10 | 4 | 7 | 28859 | 19 | ||||
| 117375 | 234878 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6010615.53478 | 2100839.32379 | 37.7491032670092 | -122.406077336824 | (37.7491032670092, -122.406077336824) | 10 | 4 | 7 | 28859 | 19 | ||||
| 121304 | 234879 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6010587.10266 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | 10 | 4 | 7 | 28859 | 19 | ||||
| 114900 | 234880 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.406208290698 | (37.7490776534227, -122.406208290698) | 10 | 4 | 7 | 28859 | 19 | ||||
| 115793 | 234881 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.406244130469 | (37.749070568567, -122.406244130469) | 10 | 4 | 7 | 28859 | 19 | ||||
| 78172 | 234882 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6010551.46993 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | 10 | 4 | 7 | 28859 | 19 | ||||
| 131745 | 234883 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6010542.26084 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | 10 | 4 | 7 | 28859 | 19 | ||||
| 34861 | 234884 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6010535.25533 | 2100821.90556 | 37.7490509498578 | -122.406353718268 | (37.7490509498578, -122.406353718268) | 10 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );