trees
502 rows where Supervisor Districts = 7 and qSpecies_id = 50 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51890 | 229889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008249.88149 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | 2 | 7 | 7 | 28859 | 2 | |||
52183 | 228548 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009560.01396 | 2101278.1954 | 37.7502492173426 | -122.409758328497 | (37.7502492173426, -122.409758328497) | 2 | 4 | 7 | 28859 | 19 | |||
52380 | 228547 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6009559.03474 | 2101249.47013 | 37.7501702892497 | -122.409759687354 | (37.7501702892497, -122.409759687354) | 2 | 4 | 7 | 28859 | 19 | |||
52561 | 226312 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2180 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008090.95388 | 2105786.60151 | 37.7625458374421 | -122.4151575397 | (37.7625458374421, -122.4151575397) | 8 | 4 | 7 | 28859 | 19 | |||
52726 | 226462 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007188.60102 | 2106179.35089 | 37.7635734837649 | -122.418306305386 | (37.7635734837649, -122.418306305386) | 8 | 4 | 7 | 28859 | 19 | |||
53093 | 226430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.7547990323663 | -122.419878535269 | (37.7547990323663, -122.419878535269) | 2 | 4 | 7 | 28859 | 19 | |||
53104 | 229794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 270 14th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.7683822351787 | -122.419295689168 | (37.7683822351787, -122.419295689168) | 8 | 4 | 7 | 28853 | 19 | |||
53758 | 226353 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3027 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009058.07626 | 2100853.8453 | 37.7490559051208 | -122.41146409149 | (37.7490559051208, -122.41146409149) | 2 | 4 | 7 | 28859 | 19 | |||
55115 | 229835 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2899 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010132.5344 | 2101618.95509 | 37.7512169355291 | -122.407802532369 | (37.7512169355291, -122.407802532369) | 2 | 4 | 7 | 28859 | 19 | |||
55488 | 220057 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.415273710521 | (37.752790875909, -122.415273710521) | 2 | 4 | 7 | 28859 | 19 | |||
56974 | 226417 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008029.19909 | 2101392.11657 | 37.7504761135956 | -122.415060063068 | (37.7504761135956, -122.415060063068) | 2 | 4 | 7 | 28859 | 19 | |||
58760 | 226396 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1483 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008038.28994 | 2099516.86307 | 37.7453275982942 | -122.41489591881 | (37.7453275982942, -122.41489591881) | 2 | 7 | 7 | 28859 | 2 | |||
59072 | 226414 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1174 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009199.3273 | 2102350.17557 | 37.7531724159966 | -122.411081321155 | (37.7531724159966, -122.411081321155) | 2 | 4 | 7 | 28859 | 19 | |||
60589 | 226459 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3242 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007896.86765 | 2105631.29342 | 37.7621084881288 | -122.415817817459 | (37.7621084881288, -122.415817817459) | 8 | 4 | 7 | 28859 | 19 | |||
64607 | 229834 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2899 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010114.09042 | 2101618.66364 | 37.7512151027139 | -122.407866293408 | (37.7512151027139, -122.407866293408) | 2 | 4 | 7 | 28859 | 19 | |||
64720 | 228525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.7639713843042 | -122.411209189472 | (37.7639713843042, -122.411209189472) | 8 | 4 | 7 | 28859 | 19 | |||
68745 | 226432 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006660.51047 | 2103068.53452 | 37.7550021640414 | -122.41991204672 | (37.7550021640414, -122.41991204672) | 2 | 4 | 7 | 28859 | 19 | |||
68852 | 226346 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008464.57897 | 2101524.14473 | 37.7508630900604 | -122.413563818716 | (37.7508630900604, -122.413563818716) | 2 | 4 | 7 | 28859 | 19 | |||
69053 | 226393 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.7459034791769 | -122.414943103567 | (37.7459034791769, -122.414943103567) | 2 | 7 | 7 | 28859 | 2 | |||
69326 | 229892 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008238.53675 | 2099832.54368 | 37.7462056369848 | -122.414225826762 | (37.7462056369848, -122.414225826762) | 2 | 7 | 7 | 28859 | 2 | |||
69822 | 226431 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006664.92393 | 2103021.2685 | 37.7548726310745 | -122.419893429847 | (37.7548726310745, -122.419893429847) | 2 | 4 | 7 | 28859 | 19 | |||
70019 | 229864 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 76 Peralta Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6010511.83754 | 2100376.53881 | 37.7478267603098 | -122.406403320374 | (37.7478267603098, -122.406403320374) | 2 | 7 | 7 | 28859 | 2 | |||
71714 | 229837 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 226 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006672.14762 | 2104765.95957 | 37.759663556138 | -122.419992251863 | (37.759663556138, -122.419992251863) | 2 | 4 | 7 | 28859 | 19 | |||
73046 | 226344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008415.43541 | 2101520.84505 | 37.7508512702694 | -122.413733528893 | (37.7508512702694, -122.413733528893) | 2 | 4 | 7 | 28859 | 19 | |||
73107 | 115506 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
74612 | 256119 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250X Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
74745 | 229818 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 990 Treat Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008585.67153 | 2102788.11843 | 37.7543404761497 | -122.413234439328 | (37.7543404761497, -122.413234439328) | 2 | 4 | 7 | 28859 | 19 | |||
74771 | 226308 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007401.10475 | 2096768.52961 | 37.7377454608683 | -122.416904522239 | (37.7377454608683, -122.416904522239) | 2 | 7 | 7 | 28859 | 2 | |||
75305 | 226455 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008017.57842 | 2104465.14642 | 37.7589133021322 | -122.4153177674 | (37.7589133021322, -122.4153177674) | 2 | 4 | 7 | 28859 | 19 | |||
75930 | 226391 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.7460665100597 | -122.414972850429 | (37.7460665100597, -122.414972850429) | 2 | 7 | 7 | 28859 | 2 | |||
76750 | 226348 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008541.46923 | 2101528.90291 | 37.7508804721644 | -122.41329826061 | (37.7508804721644, -122.41329826061) | 2 | 4 | 7 | 28859 | 19 | |||
76930 | 226311 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2070 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008053.75125 | 2106490.49002 | 37.7644764615472 | -122.415336042545 | (37.7644764615472, -122.415336042545) | 8 | 4 | 7 | 28859 | 19 | |||
77562 | 226327 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007824.63975 | 2105811.28938 | 37.7625986546389 | -122.416080374504 | (37.7625986546389, -122.416080374504) | 8 | 4 | 7 | 28859 | 19 | |||
77571 | 226413 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009277.36888 | 2100886.87778 | 37.7491589026595 | -122.41070810519 | (37.7491589026595, -122.41070810519) | 2 | 4 | 7 | 28859 | 19 | |||
77899 | 229824 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010048.45335 | 2101561.19156 | 37.7510536222315 | -122.408089221836 | (37.7510536222315, -122.408089221836) | 2 | 4 | 7 | 28859 | 19 | |||
78886 | 229832 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1216 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010283.83962 | 2102006.15901 | 37.7522885811545 | -122.407306593143 | (37.7522885811545, -122.407306593143) | 2 | 4 | 7 | 28859 | 19 | |||
79294 | 226434 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006662.06006 | 2103117.82252 | 37.7551375848404 | -122.419910185127 | (37.7551375848404, -122.419910185127) | 2 | 4 | 7 | 28859 | 19 | |||
79540 | 115508 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
79921 | 226465 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2664 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008878.80492 | 2103009.39191 | 37.7549644959368 | -122.412236343845 | (37.7549644959368, -122.412236343845) | 2 | 4 | 7 | 28859 | 19 | |||
80265 | 226446 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3102 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008932.04499 | 2101596.23583 | 37.7510872739702 | -122.411952365814 | (37.7510872739702, -122.411952365814) | 2 | 4 | 7 | 28859 | 19 | |||
80847 | 228546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1423 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6009579.53359 | 2100868.3183 | 37.7491248795152 | -122.409661901393 | (37.7491248795152, -122.409661901393) | 2 | 4 | 7 | 28859 | 19 | |||
83277 | 226415 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009167.57752 | 2102926.63896 | 37.754753474499 | -122.411231837073 | (37.754753474499, -122.411231837073) | 2 | 4 | 7 | 28859 | 19 | |||
83390 | 226322 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008078.2472 | 2101222.93823 | 37.7500143440966 | -122.414878478273 | (37.7500143440966, -122.414878478273) | 2 | 4 | 7 | 28859 | 19 | |||
83587 | 226326 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 739 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007955.30705 | 2103442.08166 | 37.7561007003072 | -122.415460702047 | (37.7561007003072, -122.415460702047) | 2 | 4 | 7 | 28859 | 19 | |||
83706 | 226401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008220.52934 | 2099483.50303 | 37.7452462375173 | -122.414263403134 | (37.7452462375173, -122.414263403134) | 2 | 7 | 7 | 28859 | 2 | |||
84269 | 228528 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | 8 | 4 | 7 | 28859 | 19 | |||
84496 | 226411 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383517 | -122.410548750743 | (37.741313383517, -122.410548750743) | 10 | 7 | 7 | 28859 | 2 | |||
84662 | 226463 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2680 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008883.38252 | 2102935.43228 | 37.7547616763342 | -122.412215286208 | (37.7547616763342, -122.412215286208) | 2 | 4 | 7 | 28859 | 19 | |||
86331 | 229860 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3224 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008991.73751 | 2099895.44974 | 37.7464206424026 | -122.411625786002 | (37.7464206424026, -122.411625786002) | 2 | 7 | 7 | 28859 | 2 | |||
88747 | 228551 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1398 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009530.29917 | 2101073.08548 | 37.7496843657442 | -122.409846607735 | (37.7496843657442, -122.409846607735) | 2 | 4 | 7 | 28859 | 19 | |||
90647 | 229735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1440 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009547.83815 | 2100777.83843 | 37.748874665647 | -122.409765119277 | (37.748874665647, -122.409765119277) | 2 | 4 | 7 | 28859 | 19 | |||
92211 | 226354 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2531 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008912.12857 | 2103526.86687 | 37.7563872351075 | -122.41215767114 | (37.7563872351075, -122.41215767114) | 2 | 4 | 7 | 28859 | 19 | |||
93521 | 226452 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008472.25902 | 2102739.35181 | 37.7542002061943 | -122.413623200976 | (37.7542002061943, -122.413623200976) | 2 | 4 | 7 | 28859 | 19 | |||
94378 | 226314 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1357 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007744.38877 | 2101777.28879 | 37.7515177002814 | -122.416072235664 | (37.7515177002814, -122.416072235664) | 2 | 4 | 7 | 28859 | 19 | |||
94876 | 226416 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1118 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008031.51023 | 2101373.79083 | 37.7504259251155 | -122.415050773974 | (37.7504259251155, -122.415050773974) | 2 | 4 | 7 | 28859 | 19 | |||
97203 | 229807 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2560 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009717.31333 | 2102417.08102 | 37.7533851578176 | -122.409294735183 | (37.7533851578176, -122.409294735183) | 2 | 4 | 7 | 28859 | 19 | |||
97822 | 226404 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.7465441607 | -122.416469871814 | (37.7465441607, -122.416469871814) | 2 | 7 | 7 | 28859 | 2 | |||
97884 | 229831 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1216 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010281.08298 | 2102019.10674 | 37.7523239784704 | -122.407317038764 | (37.7523239784704, -122.407317038764) | 2 | 4 | 7 | 28859 | 19 | |||
98978 | 226350 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3079 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007751.35411 | 2103240.55496 | 37.7555358882803 | -122.416151769888 | (37.7555358882803, -122.416151769888) | 2 | 4 | 7 | 28859 | 19 | |||
99789 | 229862 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1511 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010167.1335 | 2100435.43231 | 37.747969179639 | -122.40759944746 | (37.747969179639, -122.40759944746) | 2 | 7 | 7 | 28859 | 2 | |||
99838 | 228533 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | 8 | 4 | 7 | 28853 | 19 | |||
100542 | 226332 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006554.33185 | 2103938.10379 | 37.757383817915 | -122.420340959477 | (37.757383817915, -122.420340959477) | 2 | 4 | 7 | 28859 | 19 | |||
100627 | 229811 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2753 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6009624.46016 | 2103341.89532 | 37.7559192881552 | -122.409681113601 | (37.7559192881552, -122.409681113601) | 2 | 4 | 7 | 28859 | 19 | |||
100902 | 229833 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1218 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6010282.39024 | 2101977.39745 | 37.7522095271591 | -122.407309577977 | (37.7522095271591, -122.407309577977) | 2 | 4 | 7 | 28859 | 19 | |||
100983 | 226403 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008209.69188 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | 2 | 7 | 7 | 28859 | 2 | |||
102856 | 226389 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | 2 | 7 | 7 | 28859 | 2 | |||
103022 | 226439 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 355 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006776.41109 | 2101737.70398 | 37.751354537191 | -122.419416820631 | (37.751354537191, -122.419416820631) | 2 | 4 | 7 | 28859 | 19 | |||
103336 | 228545 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1449 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009584.1188 | 2100794.69775 | 37.7489229907161 | -122.409640850052 | (37.7489229907161, -122.409640850052) | 2 | 4 | 7 | 28859 | 19 | |||
104424 | 226352 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007311 | 2105534 | 37.7618083895094 | -122.417837216752 | (37.7618083895094, -122.417837216752) | 2 | 4 | 7 | 28859 | 19 | |||
106092 | 117199 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 383 LEXINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006585 | 2103883 | 37.7572342437784 | -122.42023098587 | (37.7572342437784, -122.42023098587) | 2 | 4 | 7 | 28859 | 19 | |||
106174 | 248027 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009988.36995 | 2098561.68629 | 37.7428142746487 | -122.40808548247 | (37.7428142746487, -122.40808548247) | 10 | 7 | 7 | 28859 | 2 | |||
106216 | 226380 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6009262.96454 | 2097691.62969 | 37.7403846464258 | -122.410532314727 | (37.7403846464258, -122.410532314727) | 10 | 7 | 7 | 28859 | 2 | |||
106394 | 226408 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 324 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006517.91503 | 2097301.91264 | 37.739160293208 | -122.419995981327 | (37.739160293208, -122.419995981327) | 2 | 7 | 7 | 28859 | 2 | |||
106771 | 228529 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | 8 | 4 | 7 | 28859 | 19 | |||
107436 | 229859 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 7x7 | 6010147.50391 | 2104457.87286 | 37.7590128085149 | -122.407950942988 | (37.7590128085149, -122.407950942988) | 2 | 4 | 7 | 28859 | 19 | |||
108141 | 226316 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007669.0206 | 2101973.58327 | 37.7520524425716 | -122.416346770813 | (37.7520524425716, -122.416346770813) | 2 | 4 | 7 | 28859 | 19 | |||
108448 | 229836 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 112 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006642.16012 | 2105416.67615 | 37.7614485827148 | -122.420142145449 | (37.7614485827148, -122.420142145449) | 2 | 4 | 7 | 28859 | 19 | |||
108736 | 226399 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.7453608534324 | -122.41501490632 | (37.7453608534324, -122.41501490632) | 2 | 7 | 7 | 28859 | 2 | |||
108890 | 229800 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 230 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006477.6106 | 2104743.99354 | 37.75959228038 | -122.420663500439 | (37.75959228038, -122.420663500439) | 2 | 4 | 7 | 28859 | 19 | |||
108898 | 245473 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009585.3359 | 2102170.0295 | 37.7526994143976 | -122.409733705951 | (37.7526994143976, -122.409733705951) | 2 | 4 | 7 | 28859 | 19 | |||
109114 | 226436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006661.69832 | 2103152.67554 | 37.7552332628263 | -122.419913909217 | (37.7552332628263, -122.419913909217) | 2 | 4 | 7 | 28859 | 19 | |||
110117 | 229822 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 956 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6009932.67033 | 2103635.88774 | 37.7567437920002 | -122.408635955697 | (37.7567437920002, -122.408635955697) | 2 | 4 | 7 | 28859 | 19 | |||
110428 | 229826 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1312 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010048.8848 | 2101524.58992 | 37.750953146384 | -122.408085148809 | (37.750953146384, -122.408085148809) | 2 | 4 | 7 | 28859 | 19 | |||
110578 | 226461 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2080 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008035.4164 | 2106222.97967 | 37.7637409096456 | -122.415380518518 | (37.7637409096456, -122.415380518518) | 8 | 4 | 7 | 28859 | 19 | |||
110808 | 226410 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007045.3382 | 2096649.72314 | 37.7373992263821 | -122.418126161295 | (37.7373992263821, -122.418126161295) | 2 | 7 | 7 | 28859 | 2 | |||
111480 | 226457 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008057.36787 | 2104469.97829 | 37.758928805544 | -122.415180498503 | (37.758928805544, -122.415180498503) | 2 | 4 | 7 | 28859 | 19 | |||
111793 | 229825 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010049.59844 | 2101548.03234 | 37.7510175540398 | -122.408084334038 | (37.7510175540398, -122.408084334038) | 2 | 4 | 7 | 28859 | 19 | |||
112161 | 229887 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008255.99327 | 2099554.30466 | 37.745442635078 | -122.414145782603 | (37.745442635078, -122.414145782603) | 2 | 7 | 7 | 28859 | 2 | |||
112368 | 115507 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
112398 | 226419 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 932 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007979.64844 | 2102295.8954 | 37.7529549014529 | -122.415295385088 | (37.7529549014529, -122.415295385088) | 2 | 4 | 7 | 28859 | 19 | |||
115180 | 226379 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 424 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008895.67252 | 2096317.34788 | 37.7365905694901 | -122.411705190752 | (37.7365905694901, -122.411705190752) | 10 | 7 | 7 | 28859 | 2 | |||
116554 | 232376 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 50 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x9 | 6008171 | 2099926 | 37.746458453366 | -122.414465973024 | (37.746458453366, -122.414465973024) | 2 | 7 | 7 | 28859 | 2 | |||
117450 | 226321 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008080.72157 | 2101209.59973 | 37.7499778586098 | -122.414868977829 | (37.7499778586098, -122.414868977829) | 2 | 4 | 7 | 28859 | 19 | |||
117771 | 226385 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 352 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006123.1231 | 2098057.1404 | 37.7412117286404 | -122.421414615119 | (37.7412117286404, -122.421414615119) | 2 | 7 | 7 | 28859 | 2 | |||
117876 | 228535 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009303.88793 | 2107359.35357 | 37.766932343692 | -122.411073521351 | (37.766932343692, -122.411073521351) | 8 | 4 | 7 | 28853 | 19 | |||
118855 | 229817 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 990 Treat Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008585.08431 | 2102813.4393 | 37.7544099685703 | -122.413238260532 | (37.7544099685703, -122.413238260532) | 2 | 4 | 7 | 28859 | 19 | |||
119587 | 228527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6009241.97976 | 2106321.44557 | 37.7640790151609 | -122.4112143273 | (37.7640790151609, -122.4112143273) | 8 | 4 | 7 | 28859 | 19 | |||
120410 | 229815 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 990 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008578.50757 | 2102937.64163 | 37.75475063086 | -122.413269787184 | (37.75475063086, -122.413269787184) | 2 | 4 | 7 | 28859 | 19 | |||
120676 | 229814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2851 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010203.85183 | 2101034.69033 | 37.7496166656959 | -122.407514719648 | (37.7496166656959, -122.407514719648) | 2 | 4 | 7 | 28859 | 19 | |||
121135 | 228543 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1459 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009587.00796 | 2100726.59956 | 37.7487361700459 | -122.409626053498 | (37.7487361700459, -122.409626053498) | 2 | 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) );