trees
255 rows where Neighborhoods (old) = 10 and qSpecies_id = 54 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132386 | 113054 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003823 | 2108493 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | 15 | 9 | 5 | 29492 | 10 | ||||
| 138159 | 114879 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000868 | 2110394 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | 15 | 5 | 11 | 29492 | 10 | ||||
| 150634 | 254387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001170.9258 | 2110090.9457 | 37.7739731755059 | -122.439399901379 | (37.7739731755059, -122.439399901379) | 15 | 5 | 11 | 29492 | 10 | ||||
| 10837 | 70252 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.439451594404 | (37.7750685309709, -122.439451594404) | 15 | 5 | 11 | 29492 | 10 | |||
| 106060 | 139286 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 847 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003452.0971 | 2111280.6163 | 37.7773692728473 | -122.431593901382 | (37.7773692728473, -122.431593901382) | 15 | 9 | 11 | 29492 | 10 | |||
| 123680 | 140224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003614.5841 | 2110462.3343 | 37.7751316811611 | -122.430973390858 | (37.7751316811611, -122.430973390858) | 7 | 9 | 11 | 29492 | 10 | |||
| 124018 | 141586 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1301 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001472.6683 | 2111100.3675 | 37.776761961586 | -122.438428460489 | (37.776761961586, -122.438428460489) | 15 | 5 | 11 | 29492 | 10 | |||
| 128250 | 111732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.7772931610788 | -122.423339818124 | (37.7772931610788, -122.423339818124) | 7 | 9 | 11 | 28852 | 10 | |||
| 140575 | 7160 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 722 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6003546.1461 | 2110964.158 | 37.7765056869903 | -122.431245960959 | (37.7765056869903, -122.431245960959) | 7 | 9 | 11 | 29492 | 10 | |||
| 145097 | 247439 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 430 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002222.1913 | 2110011.395 | 37.7738145198575 | -122.435757709689 | (37.7738145198575, -122.435757709689) | 15 | 5 | 11 | 29492 | 10 | |||
| 158884 | 111730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005810.6231 | 2111200.9612 | 37.7772839590018 | -122.423429315645 | (37.7772839590018, -122.423429315645) | 7 | 9 | 11 | 28852 | 10 | |||
| 166303 | 33642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005737 | (37.776111096903, -122.42556005737) | 7 | 9 | 11 | 28852 | 10 | |
| 177129 | 247502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002054.0619 | 2110138.0012 | 37.7741525973198 | -122.436348358239 | (37.7741525973198, -122.436348358239) | 15 | 5 | 11 | 29492 | 10 | |||
| 3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
| 40947 | 111735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | 7 | 9 | 11 | 28852 | 10 | |||
| 77520 | 33692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123 | (37.7770838353758, -122.42497676123) | 7 | 9 | 11 | 28852 | 10 | ||
| 97052 | 244473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 859 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003334.8057 | 2110313.6958 | 37.774707699746 | -122.431930590036 | (37.774707699746, -122.431930590036) | 15 | 9 | 11 | 29492 | 10 | |||
| 99064 | 244499 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 605 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004067.3081 | 2110070.8068 | 37.7740822846104 | -122.429379391728 | (37.7740822846104, -122.429379391728) | 7 | 9 | 11 | 29492 | 10 | |||
| 109783 | 64843 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 618 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 11 | Permit Number 29500 | 6003607.7064 | 2110511.4611 | 37.7752661815317 | -122.431000689329 | (37.7752661815317, -122.431000689329) | 7 | 9 | 11 | 29492 | 10 | |
| 114929 | 139283 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 855 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003446.5582 | 2111336.5596 | 37.7775225653231 | -122.431617057223 | (37.7775225653231, -122.431617057223) | 15 | 9 | 11 | 29492 | 10 | |||
| 117117 | 141366 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001152.0558 | 2110273.1905 | 37.7744725000369 | -122.439478242448 | (37.7744725000369, -122.439478242448) | 15 | 5 | 11 | 29492 | 10 | |||
| 122397 | 140223 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003617.0405 | 2110448.5788 | 37.7750940511339 | -122.43096391169 | (37.7750940511339, -122.43096391169) | 7 | 9 | 11 | 29492 | 10 | |||
| 149114 | 247438 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002224.5888 | 2109990.6164 | 37.7737576031752 | -122.435747929432 | (37.7737576031752, -122.435747929432) | 15 | 5 | 11 | 29492 | 10 | |||
| 152841 | 140214 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 668 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003589.5295 | 2110658.3502 | 37.7756684727789 | -122.43107405366 | (37.7756684727789, -122.43107405366) | 7 | 9 | 11 | 29492 | 10 | |||
| 181093 | 139436 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | 7 | 9 | 11 | 28852 | 10 | |||
| 3486 | 12249 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.426235730542 | (37.7758762780635, -122.426235730542) | 7 | 9 | 11 | 28852 | 10 | |||
| 7894 | 7178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2020 11:28:00 AM | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.7772449397217 | -122.431567664925 | (37.7772449397217, -122.431567664925) | 15 | 9 | 11 | 29492 | 10 | ||
| 12978 | 7162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.431375949555 | (37.7762857300682, -122.431375949555) | 15 | 9 | 11 | 29492 | 10 | |||
| 17314 | 71305 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001154.5387 | 2110263.7555 | 37.7744467352044 | -122.439468977163 | (37.7744467352044, -122.439468977163) | 15 | 5 | 11 | 29492 | 10 | |||
| 24303 | 139447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005464.5232 | 2111090.4798 | 37.7769610637771 | -122.424618726949 | (37.7769610637771, -122.424618726949) | 7 | 9 | 11 | 28852 | 10 | |||
| 30158 | 244277 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6004143 | 2110087 | 37.7741310322057 | -122.429118715156 | (37.7741310322057, -122.429118715156) | 7 | 9 | 11 | 28852 | 10 | |||
| 35369 | 140725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002187.9434 | 2110254.4569 | 37.7744799618741 | -122.435893573485 | (37.7744799618741, -122.435893573485) | 15 | 5 | 11 | 29492 | 10 | |||
| 43203 | 30704 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 369 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34615 | 6005232.8948 | 2110236.794 | 37.7746039663436 | -122.42535923638 | (37.7746039663436, -122.42535923638) | 7 | 9 | 11 | 28852 | 10 | |
| 43620 | 12248 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004985.728 | 2110723.6115 | 37.7759266811529 | -122.426248902156 | (37.7759266811529, -122.426248902156) | 7 | 9 | 11 | 28852 | 10 | |||
| 59151 | 247376 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 455 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002168.4135 | 2110052.1941 | 37.7739234891683 | -122.435946655381 | (37.7739234891683, -122.435946655381) | 15 | 5 | 11 | 29492 | 10 | |||
| 60844 | 7158 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003514.1332 | 2110837.5014 | 37.7761561050706 | -122.431347659332 | (37.7761561050706, -122.431347659332) | 15 | 9 | 11 | 29492 | 10 | |||
| 66541 | 6994 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003272.598 | 2110360.763 | 37.7748334078832 | -122.432149140862 | (37.7748334078832, -122.432149140862) | 15 | 9 | 11 | 29492 | 10 | |||
| 67143 | 7179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.7771965235218 | -122.431551070298 | (37.7771965235218, -122.431551070298) | 15 | 9 | 11 | 29492 | 10 | |||
| 72884 | 8204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1369 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001211.3032 | 2111062.2036 | 37.7766423030153 | -122.439329862063 | (37.7766423030153, -122.439329862063) | 15 | 5 | 11 | 29492 | 10 | |||
| 73394 | 10639 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003685.3267 | 2110714.3548 | 37.7758276754833 | -122.430746665053 | (37.7758276754833, -122.430746665053) | 7 | 9 | 11 | 29492 | 10 | |||
| 75673 | 12271 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004951.5507 | 2111300.9055 | 37.7775098574182 | -122.426408243779 | (37.7775098574182, -122.426408243779) | 7 | 9 | 11 | 28852 | 10 | |||
| 76159 | 110471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.7776654283212 | -122.423859872139 | (37.7776654283212, -122.423859872139) | 7 | 9 | 11 | 28852 | 10 | ||
| 81768 | 16876 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 274 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005679.4463 | 2110349.1101 | 37.7749375780539 | -122.423822512667 | (37.7749375780539, -122.423822512667) | 7 | 9 | 11 | 28852 | 10 | |||
| 86733 | 7180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003455.9744 | 2111255.1372 | 37.7772995333232 | -122.431578669082 | (37.7772995333232, -122.431578669082) | 15 | 9 | 11 | 29492 | 10 | |||
| 98121 | 16873 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 262 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005733.6702 | 2110353.6763 | 37.7749531766501 | -122.423635265131 | (37.7749531766501, -122.423635265131) | 7 | 9 | 11 | 28852 | 10 | |||
| 100171 | 7154 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 709 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003520.226 | 2110798.7288 | 37.776049990393 | -122.431323814363 | (37.776049990393, -122.431323814363) | 15 | 9 | 11 | 29492 | 10 | |||
| 108929 | 12264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004966.4829 | 2111191.3303 | 37.7772098348265 | -122.426348784703 | (37.7772098348265, -122.426348784703) | 7 | 9 | 11 | 28852 | 10 | |||
| 111984 | 16994 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002602.5998 | 2109922.2867 | 37.7735914513761 | -122.434435444699 | (37.7735914513761, -122.434435444699) | 15 | 5 | 11 | 29492 | 10 | |||
| 119689 | 12265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 646 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004962.1321 | 2111217.4355 | 37.7772812673791 | -122.426365694654 | (37.7772812673791, -122.426365694654) | 7 | 9 | 11 | 28852 | 10 | |||
| 120999 | 244926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005428.5225 | 2110104.1516 | 37.774250812984 | -122.424673083057 | (37.774250812984, -122.424673083057) | 7 | 9 | 11 | 28852 | 10 | |||
| 126179 | 7171 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | 15 | 9 | 11 | 29492 | 10 | ||
| 140176 | 140213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 658 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003592.9683 | 2110633.2956 | 37.7755998738913 | -122.431060369379 | (37.7755998738913, -122.431060369379) | 7 | 9 | 11 | 29492 | 10 | |||
| 144651 | 7159 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003516.9027 | 2110817.5612 | 37.7761015111675 | -122.431336655161 | (37.7761015111675, -122.431336655161) | 15 | 9 | 11 | 29492 | 10 | |||
| 149806 | 7172 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003478.684 | 2111101.7087 | 37.7768795438362 | -122.431489153471 | (37.7768795438362, -122.431489153471) | 15 | 9 | 11 | 29492 | 10 | ||
| 155347 | 10637 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.430277327931 | (37.7758893402664, -122.430277327931) | 7 | 9 | 11 | 29492 | 10 | ||
| 157841 | 12247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.426224546997 | (37.7757881731565, -122.426224546997) | 7 | 9 | 11 | 28852 | 10 | |||
| 167293 | 7023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.436413017138 | (37.7741451002744, -122.436413017138) | 15 | 5 | 11 | 29492 | 10 | |||
| 170228 | 7164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.431390816474 | (37.7763782981407, -122.431390816474) | 15 | 9 | 11 | 29492 | 10 | |||
| 170449 | 10636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | 7 | 9 | 11 | 29492 | 10 | ||
| 177642 | 142107 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1223 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001862.2998 | 2111151.4099 | 37.7769242660631 | -122.437084266624 | (37.7769242660631, -122.437084266624) | 15 | 5 | 11 | 29492 | 10 | |||
| 181278 | 7170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.7769887313283 | -122.43151116193 | (37.7769887313283, -122.43151116193) | 15 | 9 | 11 | 29492 | 10 | ||
| 181995 | 16963 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.431485538257 | (37.7737958222062, -122.431485538257) | 15 | 9 | 11 | 29492 | 10 | |||
| 186831 | 16865 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005838.6934 | 2110371.3705 | 37.7750076883115 | -122.423273225017 | (37.7750076883115, -122.423273225017) | 7 | 9 | 11 | 28852 | 10 | |||
| 187565 | 33694 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.7770914710207 | -122.424910846803 | (37.7770914710207, -122.424910846803) | 7 | 9 | 11 | 28852 | 10 | ||
| 188166 | 7161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 726 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003541.3006 | 2110998.0762 | 37.7765985433792 | -122.431265144599 | (37.7765985433792, -122.431265144599) | 7 | 9 | 11 | 29492 | 10 | |||
| 189104 | 7169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.7770418043343 | -122.431522126808 | (37.7770418043343, -122.431522126808) | 15 | 9 | 11 | 29492 | 10 | ||
| 190509 | 27413 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.7741328457417 | -122.436473498525 | (37.7741328457417, -122.436473498525) | 15 | 5 | 11 | 29492 | 10 | |||
| 192358 | 10629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.7759254847018 | -122.429965440473 | (37.7759254847018, -122.429965440473) | 7 | 9 | 11 | 29492 | 10 | ||
| 4913 | 64501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | 15 | 5 | 11 | 29492 | 10 | |
| 12129 | 57526 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.425022615137 | (37.7775297860553, -122.425022615137) | 7 | 9 | 11 | 28852 | 10 | |
| 50053 | 140726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 507 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002621.396 | 2110304.4034 | 37.774641715946 | -122.434397751258 | (37.774641715946, -122.434397751258) | 15 | 5 | 11 | 29492 | 10 | |||
| 57452 | 247501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002172.3516 | 2110026.2024 | 37.7738523461458 | -122.435931172698 | (37.7738523461458, -122.435931172698) | 15 | 5 | 11 | 29492 | 10 | |||
| 65242 | 56926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 13 | Permit Number 14169 | 6001161.4908 | 2110173.8745 | 37.7742003402164 | -122.439438484322 | (37.7742003402164, -122.439438484322) | 15 | 5 | 11 | 29492 | 10 | ||
| 73112 | 141364 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 451 BRODERICK ST | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 6001150.566 | 2110292.0606 | 37.7745242278003 | -122.439484748915 | (37.7745242278003, -122.439484748915) | 15 | 5 | 11 | 29492 | 10 | |||
| 74257 | 244278 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6004143 | 2110087 | 37.7741310322057 | -122.429118715156 | (37.7741310322057, -122.429118715156) | 7 | 9 | 11 | 28852 | 10 | |||
| 79160 | 138864 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003093.4509 | 2110708.1672 | 37.7757771350892 | -122.432793670379 | (37.7757771350892, -122.432793670379) | 15 | 9 | 11 | 29492 | 10 | |||
| 92546 | 244501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 607 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004030.4942 | 2110064.8827 | 37.7740639341827 | -122.429506314812 | (37.7740639341827, -122.429506314812) | 7 | 9 | 11 | 29492 | 10 | |||
| 94305 | 141377 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 425 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001159.5045 | 2110196.2206 | 37.774261583951 | -122.439446957438 | (37.774261583951, -122.439446957438) | 15 | 5 | 11 | 29492 | 10 | |||
| 99019 | 140702 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 710 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003550.9915 | 2110923.9408 | 37.776395535095 | -122.43122632799 | (37.776395535095, -122.43122632799) | 7 | 9 | 11 | 29492 | 10 | |||
| 106385 | 139439 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 495 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005453.4757 | 2111308.2848 | 37.7775584792902 | -122.424672441445 | (37.7775584792902, -122.424672441445) | 7 | 9 | 11 | 28852 | 10 | |||
| 117346 | 65955 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | 15 | 5 | 11 | 29492 | 10 | ||
| 129362 | 142178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 400 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000706.3548 | 2110383.9675 | 37.7747512900532 | -122.441027952483 | (37.7747512900532, -122.441027952483) | 15 | 5 | 11 | 29492 | 10 | |||
| 132720 | 244480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 436 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004459.1128 | 2109828.0982 | 37.7734380404188 | -122.428006772012 | (37.7734380404188, -122.428006772012) | 7 | 9 | 11 | 28852 | 10 | |||
| 154408 | 67469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | 15 | 5 | 11 | 29492 | 10 | |
| 156129 | 140711 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002645.4844 | 2110432.6051 | 37.7749950932562 | -122.434323592325 | (37.7749950932562, -122.434323592325) | 15 | 5 | 11 | 29492 | 10 | |||
| 165292 | 66381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524 | -122.431045702786 | (37.775493505524, -122.431045702786) | 7 | 9 | 11 | 29492 | 10 | |
| 173051 | 140068 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005004.7286 | 2111303.2254 | 37.7775192332012 | -122.426224448803 | (37.7775192332012, -122.426224448803) | 7 | 9 | 11 | 28852 | 10 | |||
| 175312 | 142179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 400 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000700.9795 | 2110406.5438 | 37.7748129727095 | -122.441048166714 | (37.7748129727095, -122.441048166714) | 15 | 5 | 11 | 29492 | 10 | |||
| 182947 | 33693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.424853261184 | (37.7771015944949, -122.424853261184) | 7 | 9 | 11 | 28852 | 10 | ||
| 185720 | 139434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 406 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005390.0639 | 2111164.7368 | 37.7771607499747 | -122.424881589077 | (37.7771607499747, -122.424881589077) | 7 | 9 | 11 | 28852 | 10 | |||
| 189603 | 244508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 470 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003685.2048 | 2109943.0159 | 37.7737097618778 | -122.430692031876 | (37.7737097618778, -122.430692031876) | 7 | 9 | 11 | 29492 | 10 | |||
| 190495 | 55481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | 15 | 5 | 11 | 29492 | 10 | ||
| 6485 | 71703 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6005189.8095 | 2111320.4314 | 37.7775769362179 | -122.425585416633 | (37.7775769362179, -122.425585416633) | 7 | 9 | 11 | 28852 | 10 | |||
| 25184 | 244323 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003563.5505 | 2110000.7658 | 37.7738614359578 | -122.431116975625 | (37.7738614359578, -122.431116975625) | 15 | 9 | 11 | 29492 | 10 | |||
| 32828 | 140712 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002642.8382 | 2110450.467 | 37.7750439873946 | -122.434334023387 | (37.7750439873946, -122.434334023387) | 15 | 5 | 11 | 29492 | 10 | |||
| 36792 | 244324 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 717 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003593.9138 | 2110004.6215 | 37.7738737432923 | -122.431012219304 | (37.7738737432923, -122.431012219304) | 15 | 9 | 11 | 29492 | 10 | |||
| 38929 | 138927 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003523.5494 | 2110764.9413 | 37.7759574066142 | -122.431309905462 | (37.7759574066142, -122.431309905462) | 15 | 9 | 11 | 29492 | 10 | |||
| 50205 | 244507 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 480 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003680.127 | 2109976.8678 | 37.7738024231986 | -122.430712012932 | (37.7738024231986, -122.430712012932) | 7 | 9 | 11 | 29492 | 10 | |||
| 76970 | 244502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 607 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003992.8339 | 2110059.3818 | 37.7740466976962 | -122.429636195865 | (37.7740466976962, -122.429636195865) | 7 | 9 | 11 | 29492 | 10 | |||
| 81484 | 140709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002649.4537 | 2110396.2195 | 37.7748954127382 | -122.434307259794 | (37.7748954127382, -122.434307259794) | 15 | 5 | 11 | 29492 | 10 |
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) );