trees
170 rows where qSpecies_id = 232 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116946 | 59609 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1063 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 5 | Permit Number 19011 | 6015560.85054 | 2104166.3389 | 37.7585139078159 | -122.389208516653 | (37.7585139078159, -122.389208516653) | 10 | 3 | 8 | 28856 | 29 | ||
| 70889 | 191429 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2399 Lane St | 7 | Side Yard : Yard | Tree | Private 2 | 4 | 6013991.75526 | 2092879.90646 | 37.7274366158882 | -122.393845172923 | (37.7274366158882, -122.393845172923) | 10 | 3 | 8 | 58 | 1 | ||||
| 158818 | 66159 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 90 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | 6 | Permit Number 29230 | 6013889.68751 | 2094856.83218 | 37.732859178908 | -122.394336381736 | (37.732859178908, -122.394336381736) | 10 | 3 | 8 | 58 | 1 | |
| 59330 | 191427 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1627 20th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013091.09687 | 2104712.62895 | 37.7598766756903 | -122.397788409621 | (37.7598766756903, -122.397788409621) | 10 | 3 | 8 | 28856 | 29 | |||
| 91779 | 191426 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1700 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 6 | 6012934.52583 | 2103813.36642 | 37.7573987772601 | -122.39826682196 | (37.7573987772601, -122.39826682196) | 10 | 3 | 8 | 28856 | 29 | ||||
| 91613 | 191428 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 22 Robblee Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6012599.81478 | 2095974.63355 | 37.7358566435644 | -122.39887425376 | (37.7358566435644, -122.39887425376) | 10 | 3 | 8 | 58 | 1 | |||
| 138958 | 191424 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 743 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012751.86136 | 2104046.56843 | 37.7580289223265 | -122.398914919298 | (37.7580289223265, -122.398914919298) | 10 | 3 | 8 | 28856 | 29 | |||
| 180341 | 191425 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 798 Wisconsin St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6012697.8338 | 2103815.11788 | 37.7573903991588 | -122.399085525191 | (37.7573903991588, -122.399085525191) | 10 | 3 | 8 | 28856 | 29 | |||
| 159199 | 129557 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 300 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6012628.75569 | 2116888.88104 | 37.7932841227067 | -122.400242632492 | (37.7932841227067, -122.400242632492) | 4 | 1 | 10 | 28854 | 6 | |||
| 146635 | 129558 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 300 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012591.86858 | 2116885.11843 | 37.793271734566 | -122.400370000791 | (37.793271734566, -122.400370000791) | 4 | 1 | 10 | 28854 | 6 | |||
| 15496 | 58940 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1360 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1980 12:00:00 AM | 2 | Permit Number 18218 | 6011963.90217 | 2102042.40825 | 37.7524820001659 | -122.401499182338 | (37.7524820001659, -122.401499182338) | 10 | 3 | 8 | 28856 | 29 | |
| 75793 | 191420 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 785 Rhode Island St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6011880.44844 | 2104704.93056 | 37.759788043893 | -122.401974935396 | (37.759788043893, -122.401974935396) | 10 | 3 | 8 | 28856 | 29 | |||
| 76243 | 191421 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 785 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011879.91992 | 2104709.23521 | 37.7597998340098 | -122.40197706591 | (37.7597998340098, -122.40197706591) | 10 | 3 | 8 | 28856 | 29 | |||
| 193637 | 57852 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1977 12:00:00 AM | 10 | Permit Number 16793 | 6012080.13289 | 2115527.66509 | 37.7895159399674 | -122.402045176939 | (37.7895159399674, -122.402045176939) | 4 | 1 | 10 | 28854 | 6 | ||
| 83143 | 129549 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.7895463001798 | -122.402052980384 | (37.7895463001798, -122.402052980384) | 4 | 1 | 10 | 28854 | 6 | |||
| 140132 | 129550 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6012076.26306 | 2115552.15036 | 37.7895829547447 | -122.40206028827 | (37.7895829547447, -122.40206028827) | 4 | 1 | 10 | 28854 | 6 | |||
| 40212 | 129551 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6012074.07881 | 2115564.48535 | 37.789616701801 | -122.40206871312 | (37.789616701801, -122.40206871312) | 4 | 1 | 10 | 28854 | 6 | |||
| 69781 | 191423 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 872 Rhode Island St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6011836.25776 | 2104328.91927 | 37.7587531337637 | -122.402101335126 | (37.7587531337637, -122.402101335126) | 10 | 3 | 8 | 28856 | 29 | |||
| 87175 | 129552 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6012061.46033 | 2115633.25932 | 37.7898048345693 | -122.402117209065 | (37.7898048345693, -122.402117209065) | 4 | 1 | 10 | 28854 | 6 | |||
| 132604 | 129553 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6012058.5984 | 2115646.10201 | 37.7898399378192 | -122.402128014397 | (37.7898399378192, -122.402128014397) | 4 | 1 | 10 | 28854 | 6 | |||
| 155806 | 129554 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6012057.79655 | 2115657.86651 | 37.7898721955983 | -122.402131616176 | (37.7898721955983, -122.402131616176) | 4 | 1 | 10 | 28854 | 6 | |||
| 31041 | 191422 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 518 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 1ft | 6011739.54492 | 2105950.98951 | 37.7632015790138 | -122.402549877375 | (37.7632015790138, -122.402549877375) | 8 | 3 | 8 | 28856 | 29 | |||
| 99522 | 35353 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1023 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2013 12:00:00 AM | 1 | Permit Number 770231 | 6011656.23225 | 2103580.24733 | 37.7566873964196 | -122.40267130025 | (37.7566873964196, -122.40267130025) | 10 | 3 | 8 | 28856 | 29 | |
| 115948 | 191430 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 12 Augusta St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6011384.73848 | 2095507.87401 | 37.7345072405216 | -122.403042454946 | (37.7345072405216, -122.403042454946) | 10 | 3 | 8 | 58 | 1 | |||
| 55056 | 191419 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 574 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011201.13816 | 2105680.19927 | 37.7624279767963 | -122.404392995652 | (37.7624279767963, -122.404392995652) | 8 | 3 | 8 | 28856 | 29 | |||
| 97823 | 16365 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1306X Montgomery St | 18 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011450.07983 | 2119965.49195 | 37.8016659588815 | -122.404537624619 | (37.8016659588815, -122.404537624619) | 3 | 1 | 10 | 308 | 23 | |||
| 135366 | 129537 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1306x Montgomery St | 22 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6011446.5417 | 2119990.51434 | 37.801734466528 | -122.404551630663 | (37.801734466528, -122.404551630663) | 3 | 1 | 10 | 308 | 23 | |||
| 65138 | 129535 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1420 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011436.62121 | 2120241.6491 | 37.8024234668433 | -122.404603649235 | (37.8024234668433, -122.404603649235) | 3 | 1 | 10 | 308 | 23 | |||
| 89082 | 129536 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1440 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011432.08366 | 2120273.70789 | 37.8025112388511 | -122.404621609616 | (37.8025112388511, -122.404621609616) | 3 | 1 | 10 | 308 | 23 | |||
| 59538 | 249913 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 356 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011242.07072 | 2120420.51237 | 37.8029037065993 | -122.405289496536 | (37.8029037065993, -122.405289496536) | 3 | 1 | 10 | 308 | 23 | |||
| 138546 | 129555 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 216 Post St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6011031.64459 | 2115258.30549 | 37.7887177673445 | -122.405653872146 | (37.7887177673445, -122.405653872146) | 5 | 1 | 10 | 28857 | 6 | |||
| 153511 | 129556 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 216 Post St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6011025.30596 | 2115257.2463 | 37.7887145046082 | -122.405675728365 | (37.7887145046082, -122.405675728365) | 5 | 1 | 10 | 28857 | 6 | |||
| 129510 | 129548 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1 Saroyan Pl | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6011012.0164 | 2118485.67299 | 37.7975782452004 | -122.405949226574 | (37.7975782452004, -122.405949226574) | 3 | 1 | 10 | 308 | 23 | |||
| 144853 | 53852 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 566 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1972 12:00:00 AM | 7 | Permit Number 9560 | 6010756.69045 | 2115915.59968 | 37.7905071610361 | -122.406651517078 | (37.7905071610361, -122.406651517078) | 5 | 1 | 10 | 28857 | 6 | ||
| 73803 | 53853 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 586 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1972 12:00:00 AM | 6 | Permit Number 9561 | 6010726.48535 | 2115910.44799 | 37.7904913257569 | -122.406755662156 | (37.7904913257569, -122.406755662156) | 5 | 1 | 10 | 28857 | 6 | ||
| 89288 | 129538 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 586 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010716.07014 | 2115909.27019 | 37.7904875090489 | -122.406791615267 | (37.7904875090489, -122.406791615267) | 5 | 1 | 10 | 28857 | 6 | |||
| 76037 | 129539 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 586 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010703.94033 | 2115907.66387 | 37.7904824197785 | -122.406833470599 | (37.7904824197785, -122.406833470599) | 5 | 1 | 10 | 28857 | 6 | |||
| 71146 | 129540 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 586 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010689.62141 | 2115905.17591 | 37.7904747872294 | -122.406882837979 | (37.7904747872294, -122.406882837979) | 5 | 1 | 10 | 28857 | 6 | |||
| 85181 | 129541 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 508 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010626.2585 | 2115918.27933 | 37.7905072203931 | -122.407102994728 | (37.7905072203931, -122.407102994728) | 5 | 1 | 10 | 28857 | 6 | |||
| 82974 | 129542 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 508 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010625.70171 | 2115928.16115 | 37.7905343223424 | -122.407105618041 | (37.7905343223424, -122.407105618041) | 5 | 1 | 10 | 28857 | 6 | |||
| 13787 | 129543 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 508 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010622.60945 | 2115940.55933 | 37.7905681917229 | -122.407117191424 | (37.7905681917229, -122.407117191424) | 5 | 1 | 10 | 28857 | 6 | |||
| 65162 | 129544 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 508 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010620.37011 | 2115953.21754 | 37.7906028228134 | -122.407125832085 | (37.7906028228134, -122.407125832085) | 5 | 1 | 10 | 28857 | 6 | |||
| 27116 | 177037 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 125 Goettingen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6009971.552 | 2093934.84647 | 37.7301090233129 | -122.407817447612 | (37.7301090233129, -122.407817447612) | 10 | 3 | 7 | 309 | 28 | |||
| 162698 | 177038 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 649 Hamilton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009808.87936 | 2091375.19794 | 37.7230716583033 | -122.408199372618 | (37.7230716583033, -122.408199372618) | 10 | 3 | 7 | 309 | 28 | |||
| 4624 | 75146 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010085.43601 | 2111100.02376 | 37.7772471547732 | -122.408634170555 | (37.7772471547732, -122.408634170555) | 8 | 2 | 9 | 28853 | 34 | |||
| 58800 | 108938 | Undocumented 4 | Ligustrum japonicum :: Japanese Privet 232 | 431 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010275.9 | 2120590.4 | 37.8033161117204 | -122.408644952554 | (37.8033161117204, -122.408644952554) | 3 | 1 | 10 | 308 | 23 | |||
| 13461 | 75228 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010065.6483 | 2111120.54922 | 37.7773024046157 | -122.408704071262 | (37.7773024046157, -122.408704071262) | 8 | 2 | 9 | 28853 | 34 | |||
| 12598 | 75304 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010043.76488 | 2111144.47071 | 37.7773668617363 | -122.408781461497 | (37.7773668617363, -122.408781461497) | 8 | 2 | 9 | 28853 | 34 | |||
| 14988 | 75390 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010035.62368 | 2111155.67227 | 37.7773971625953 | -122.408810415165 | (37.7773971625953, -122.408810415165) | 8 | 2 | 9 | 28853 | 34 | |||
| 8735 | 129545 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 10 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010092.54789 | 2116944.91924 | 37.7932962437837 | -122.409022077819 | (37.7932962437837, -122.409022077819) | 3 | 1 | 10 | 28857 | 4 | |||
| 75373 | 129547 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 13 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6010075.14286 | 2116919.1763 | 37.7932245849005 | -122.409080483394 | (37.7932245849005, -122.409080483394) | 3 | 1 | 10 | 28857 | 4 | |||
| 123299 | 129546 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 13 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6010072.19276 | 2116933.78445 | 37.7932645300763 | -122.409091722221 | (37.7932645300763, -122.409091722221) | 3 | 1 | 10 | 28857 | 4 | |||
| 31336 | 177035 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 15 Merrill St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 6009505.01631 | 2094936.0613 | 37.7328320166696 | -122.409500962316 | (37.7328320166696, -122.409500962316) | 10 | 3 | 7 | 309 | 28 | |||
| 72877 | 177036 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 15 Merrill St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6009502.62349 | 2094943.72581 | 37.7328529276995 | -122.409509775682 | (37.7328529276995, -122.409509775682) | 10 | 3 | 7 | 309 | 28 | |||
| 185254 | 191431 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 9 Sumner St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009550.82105 | 2110763.25421 | 37.7762925082147 | -122.410459796982 | (37.7762925082147, -122.410459796982) | 8 | 2 | 9 | 28853 | 34 | |||
| 130483 | 129532 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009758.75399 | 2121832.78165 | 37.8066984049805 | -122.410522343935 | (37.8066984049805, -122.410522343935) | 3 | 1 | 10 | 308 | 23 | |||
| 157377 | 177033 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 681 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6008991.36209 | 2090994.19316 | 37.7219796888926 | -122.410998479192 | (37.7219796888926, -122.410998479192) | 9 | 3 | 7 | 309 | 28 | |||
| 67684 | 177034 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 675 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6008984.35993 | 2091023.84247 | 37.7220607070166 | -122.411024777165 | (37.7220607070166, -122.411024777165) | 9 | 3 | 7 | 309 | 28 | |||
| 123906 | 177032 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 663 University St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008682.45825 | 2090982.77812 | 37.7219310184866 | -122.412065479859 | (37.7219310184866, -122.412065479859) | 9 | 3 | 7 | 309 | 28 | |||
| 16162 | 226641 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 953 Treat Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6008623.39527 | 2103036.69536 | 37.7550251300303 | -122.413121556411 | (37.7550251300303, -122.413121556411) | 2 | 4 | 7 | 28859 | 19 | |||
| 107478 | 129531 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 84 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008275.2008 | 2119135.29153 | 37.7992084921309 | -122.415465384822 | (37.7992084921309, -122.415465384822) | 5 | 1 | 10 | 308 | 32 | ||||
| 2479 | 226638 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 201 Coso Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6007716.3532 | 2099510.69761 | 37.7452925742068 | -122.416008689563 | (37.7452925742068, -122.416008689563) | 2 | 7 | 7 | 28859 | 2 | |||
| 175114 | 226639 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 145 Coso Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6007521.18601 | 2099614.94215 | 37.7455678314934 | -122.416690930545 | (37.7455678314934, -122.416690930545) | 2 | 7 | 7 | 28859 | 2 | ||||
| 164023 | 129530 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1040 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6007879.71026 | 2119961.12323 | 37.8014537818135 | -122.416892463243 | (37.8014537818135, -122.416892463243) | 5 | 1 | 10 | 308 | 32 | |||
| 42346 | 226637 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1199 Capp St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6007225.31017 | 2100622.72822 | 37.7483183396245 | -122.417785447755 | (37.7483183396245, -122.417785447755) | 2 | 4 | 7 | 28859 | 19 | |||
| 49078 | 129533 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 580 North Point St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007551.84536 | 2121660.73903 | 37.8061020492334 | -122.418147590337 | (37.8061020492334, -122.418147590337) | 5 | 1 | 10 | 308 | 23 | |||
| 66754 | 129534 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 580 North Point St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6007527.54685 | 2121657.26711 | 37.8060911485403 | -122.418231433231 | (37.8060911485403, -122.418231433231) | 5 | 1 | 10 | 308 | 23 | |||
| 149824 | 40706 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 758 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 6 | Permit Number 41685 | 6006892.85232 | 2094109.94712 | 37.7304169754587 | -122.41847333919 | (37.7304169754587, -122.41847333919) | 9 | 3 | 7 | 309 | 28 | |
| 77216 | 15295 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1625 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/1995 12:00:00 AM | 3 | 3X3 | 6006990.72739 | 2109176.21889 | 37.7717910362903 | -122.41920328508 | (37.7717910362903, -122.41920328508) | 8 | 2 | 9 | 28853 | 19 | ||
| 114668 | 27386 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2222 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6007153.46283 | 2119942.0708 | 37.8013605913839 | -122.419404257997 | (37.8013605913839, -122.419404257997) | 5 | 1 | 1 | 28858 | 32 | |||
| 38509 | 27387 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2222 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6007153.30759 | 2119954.57165 | 37.8013949068162 | -122.419405682544 | (37.8013949068162, -122.419405682544) | 5 | 1 | 1 | 28858 | 32 | |||
| 25836 | 27388 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2238 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6007145.97631 | 2119998.36118 | 37.8015147288815 | -122.419434160451 | (37.8015147288815, -122.419434160451) | 5 | 1 | 1 | 28858 | 32 | |||
| 42690 | 27391 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2250 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007137.43653 | 2120063.48315 | 37.8016930563562 | -122.419468334714 | (37.8016930563562, -122.419468334714) | 5 | 1 | 1 | 28858 | 32 | |||
| 43760 | 27393 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2256 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007130.3947 | 2120101.32531 | 37.8017965647292 | -122.419495389019 | (37.8017965647292, -122.419495389019) | 5 | 1 | 1 | 28858 | 32 | |||
| 156053 | 129529 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006561.35297 | 2120334.19193 | 37.802403889494 | -122.421481088503 | (37.802403889494, -122.421481088503) | 5 | 9 | 1 | 28858 | 32 | |||
| 118057 | 129528 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006558.18826 | 2120353.46017 | 37.802456616741 | -122.4214934092 | (37.802456616741, -122.4214934092) | 5 | 9 | 1 | 28858 | 32 | |||
| 33790 | 129527 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006554.47344 | 2120382.0459 | 37.802534896425 | -122.421508295689 | (37.802534896425, -122.421508295689) | 5 | 9 | 1 | 28858 | 32 | |||
| 127189 | 129526 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006553.85688 | 2120395.35345 | 37.8025714008062 | -122.421511374958 | (37.8025714008062, -122.421511374958) | 5 | 9 | 1 | 28858 | 32 | |||
| 129834 | 129525 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1109 Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006520.95763 | 2120409.72682 | 37.8026090113668 | -122.421626244478 | (37.8026090113668, -122.421626244478) | 5 | 9 | 1 | 28858 | 32 | |||
| 92441 | 129524 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1109 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006507.13928 | 2120407.78108 | 37.8026028896668 | -122.421673924708 | (37.8026028896668, -122.421673924708) | 5 | 9 | 1 | 28858 | 32 | |||
| 22513 | 129523 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1109 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006484.20699 | 2120406.53709 | 37.8025981808314 | -122.42175319366 | (37.8025981808314, -122.42175319366) | 5 | 9 | 1 | 28858 | 32 | |||
| 172472 | 129522 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1240 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006403.02216 | 2120103.20622 | 37.8017607330441 | -122.422012573438 | (37.8017607330441, -122.422012573438) | 5 | 9 | 1 | 28858 | 32 | |||
| 58621 | 10231 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1440 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 2x2 | 6005821.60814 | 2100602.13393 | 37.7481826984823 | -122.422637956596 | (37.7481826984823, -122.422637956596) | 2 | 4 | 5 | 28859 | 19 | |||
| 4951 | 249501 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1765 California St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6006000.97948 | 2115886.86804 | 37.7901610488408 | -122.4231039628 | (37.7901610488408, -122.4231039628) | 13 | 9 | 1 | 28858 | 41 | |||
| 34613 | 249500 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1765 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005972.54693 | 2115883.04317 | 37.7901489421804 | -122.423202065344 | (37.7901489421804, -122.423202065344) | 13 | 9 | 1 | 28858 | 41 | |||
| 140273 | 249499 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1765 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005919.33859 | 2115875.5653 | 37.7901254069127 | -122.423385630445 | (37.7901254069127, -122.423385630445) | 13 | 9 | 1 | 28858 | 41 | |||
| 166841 | 226645 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3626 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 1ft | 6005580.70423 | 2101999.04422 | 37.7520046984762 | -122.423570296333 | (37.7520046984762, -122.423570296333) | 2 | 4 | 5 | 28859 | 19 | |||
| 129923 | 10088 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 680 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X2 | 6005576.87933 | 2105026.12376 | 37.760316137501 | -122.423798743025 | (37.760316137501, -122.423798743025) | 2 | 4 | 5 | 28859 | 19 | |||
| 133526 | 226642 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 14 Cumberland St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6005484.04077 | 2104618.29186 | 37.759191085608 | -122.424090824831 | (37.759191085608, -122.424090824831) | 2 | 4 | 5 | 28859 | 19 | |||
| 69895 | 226640 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 10 Crescent Ave | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6005282.96903 | 2095902.79944 | 37.7352489878562 | -122.424166394858 | (37.7352489878562, -122.424166394858) | 2 | 7 | 7 | 28859 | 2 | |||
| 30551 | 5710 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1609 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6005330.55919 | 2098925.54374 | 37.7435514489374 | -122.4242167677 | (37.7435514489374, -122.4242167677) | 2 | 7 | 5 | 28859 | 22 | |||
| 27680 | 9990 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 33 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005438.43144 | 2108674.6093 | 37.7703261944175 | -122.424537099004 | (37.7703261944175, -122.424537099004) | 8 | 2 | 5 | 28853 | 19 | |||
| 177220 | 9988 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 25 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005434.58987 | 2108720.51419 | 37.7704520212643 | -122.424553652838 | (37.7704520212643, -122.424553652838) | 8 | 2 | 5 | 28853 | 19 | |||
| 48322 | 177031 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 2ft | 6005122.72167 | 2093818.53424 | 37.7295170103902 | -122.424572215729 | (37.7295170103902, -122.424572215729) | 9 | 7 | 6 | 28861 | 5 | |||
| 46651 | 226643 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 48 Cumberland St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6005334.03507 | 2104616.89651 | 37.7591787837883 | -122.424609517811 | (37.7591787837883, -122.424609517811) | 2 | 4 | 5 | 28859 | 19 | |||
| 36948 | 226644 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 48 Cumberland St | 3 | : | Tree | Private 2 | 2 | Width 2ft | 6005321.77679 | 2104616.40188 | 37.7591767333496 | -122.424651877677 | (37.7591767333496, -122.424651877677) | 2 | 4 | 5 | 28859 | 19 | |||
| 161471 | 226648 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1488 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005200.77027 | 2099715.54685 | 37.7457132878504 | -122.424721734337 | (37.7457132878504, -122.424721734337) | 2 | 7 | 5 | 63 | 22 | |||
| 25064 | 9989 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 28 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X2 | 6005374.86669 | 2108638.02007 | 37.7702221392707 | -122.424754366229 | (37.7702221392707, -122.424754366229) | 8 | 2 | 5 | 28853 | 19 | |||
| 86080 | 226646 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 31 Hidalgo Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004999.4002 | 2107477.29528 | 37.767013854632 | -122.425970464583 | (37.767013854632, -122.425970464583) | 8 | 4 | 5 | 28853 | 19 | |||
| 32361 | 112544 | Undocumented 4 | Ligustrum japonicum :: Japanese Privet 232 | 31 HIDALGO TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | 6004997 | 2107458 | 37.7669607387675 | -122.425977392818 | (37.7669607387675, -122.425977392818) | 8 | 4 | 5 | 28853 | 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) );