trees
531 rows where Fire Prevention Districts = 15 and qSpecies_id = 54 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
| 581 | 248465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.7677969745346 | -122.453160476336 | (37.7677969745346, -122.453160476336) | 15 | 5 | 11 | 29492 | 9 | |||
| 766 | 17084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.7720659980909 | -122.445177292475 | (37.7720659980909, -122.445177292475) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |
| 8783 | 7166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.431408122706 | (37.7764540897977, -122.431408122706) | 15 | 9 | 11 | 29492 | 10 | |||
| 10282 | 18081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2967 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999746.4018 | 2114674.089 | 37.7864761362834 | -122.444657035366 | (37.7864761362834, -122.444657035366) | 15 | 6 | 1 | 29490 | 31 | |||
| 11526 | 66368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | 15 | 6 | 1 | 54 | 31 | |
| 11591 | 246388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.7685701345672 | -122.451204446298 | (37.7685701345672, -122.451204446298) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 13248 | 138690 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2838 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999904.6577 | 2114405.5136 | 37.7857477274076 | -122.444090205696 | (37.7857477274076, -122.444090205696) | 15 | 6 | 1 | 29490 | 31 | |||
| 14071 | 4509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.449199642237 | (37.7715600792218, -122.449199642237) | 15 | 5 | 11 | 29492 | 9 | |||
| 15279 | 248611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953 | (37.7667562259025, -122.45125791953) | 15 | 5 | 11 | 29492 | 9 | |||
| 15508 | 244193 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998442.5226 | 2108797.178 | 37.7702651709945 | -122.448744661621 | (37.7702651709945, -122.448744661621) | 15 | 5 | 11 | 29492 | 9 | |||
| 16062 | 247337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003076.0904 | 2109591.4739 | 37.7727099867472 | -122.432773934025 | (37.7727099867472, -122.432773934025) | 15 | 5 | 11 | 29492 | 9 | |||
| 16127 | 246164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.7683928596779 | -122.452566262235 | (37.7683928596779, -122.452566262235) | 15 | 5 | 11 | 29492 | 9 | |||
| 17983 | 107661 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | 15 | 5 | 5 | 28862 | 3 | |||
| 18641 | 59622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | 15 | 5 | 11 | 29492 | 10 | |
| 20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
| 21051 | 141109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.448827586566 | (37.7814254265925, -122.448827586566) | 15 | 6 | 2 | 54 | 16 | |||
| 21641 | 17024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001643.357 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | 15 | 5 | 11 | 29492 | 9 | |||
| 23620 | 141343 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001184.3335 | 2110341.7185 | 37.7746624976237 | -122.439371501085 | (37.7746624976237, -122.439371501085) | 15 | 5 | 11 | 29492 | 10 | |||
| 24027 | 17108 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | 15 | 5 | 11 | 29492 | 9 | |||
| 24624 | 17680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.435234433978 | (37.7795688238035, -122.435234433978) | 15 | 5 | 11 | 29490 | 41 | |||
| 24743 | 66562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.7833936486138 | -122.450290371551 | (37.7833936486138, -122.450290371551) | 15 | 6 | 1 | 54 | 31 | |
| 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 | |||
| 25823 | 140682 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21366 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997596.5061 | 2110261.2804 | 37.7742368042101 | -122.451776648803 | (37.7742368042101, -122.451776648803) | 15 | 5 | 2 | 29492 | 16 | |||
| 26458 | 248312 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999157.272 | 2108349.6728 | 37.7690772810316 | -122.446240160162 | (37.7690772810316, -122.446240160162) | 15 | 5 | 11 | 29492 | 9 | |||
| 26924 | 142123 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 15 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998622.5379 | 2110844.3781 | 37.7758965505953 | -122.448269431558 | (37.7758965505953, -122.448269431558) | 15 | 6 | 2 | 29492 | 16 | |||
| 27540 | 59659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.7778853946604 | -122.433219797973 | (37.7778853946604, -122.433219797973) | 15 | 9 | 11 | 29492 | 41 | ||
| 29602 | 139484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1216 FULTON ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 6001778.449 | 2111192.2794 | 37.7770317168845 | -122.437377258879 | (37.7770317168845, -122.437377258879) | 15 | 5 | 11 | 29492 | 41 | |||
| 30164 | 138611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1711 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6000013.0072 | 2114911.1445 | 37.7871422388637 | -122.443751687038 | (37.7871422388637, -122.443751687038) | 15 | 6 | 1 | 29490 | 31 | |||
| 32113 | 17114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998005.981 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | 15 | 5 | 11 | 29492 | 9 | |||
| 32493 | 244027 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 510 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998001.7833 | 2108800.966 | 37.7702503589654 | -122.45026944288 | (37.7702503589654, -122.45026944288) | 15 | 5 | 11 | 29492 | 9 | |||
| 32823 | 248346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998065.2703 | 2108198.2582 | 37.7685991103156 | -122.45000639696 | (37.7685991103156, -122.45000639696) | 15 | 5 | 11 | 29492 | 9 | |||
| 33663 | 14813 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.7785794305459 | -122.431524477475 | (37.7785794305459, -122.431524477475) | 15 | 9 | 11 | 29492 | 41 | |||
| 35064 | 138707 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2874 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999741.1485 | 2114383.1871 | 37.7856770956012 | -122.444654293951 | (37.7856770956012, -122.444654293951) | 15 | 6 | 1 | 29490 | 31 | |||
| 36660 | 138731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2755 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000355.1143 | 2114408.2991 | 37.7857810625069 | -122.44253195817 | (37.7857810625069, -122.44253195817) | 15 | 6 | 1 | 29490 | 27 | |||
| 36701 | 59351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.443073153769 | (37.7755210539143, -122.443073153769) | 15 | 5 | 11 | 29492 | 16 | |
| 38278 | 32778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.7754918376538 | -122.439679097651 | (37.7754918376538, -122.439679097651) | 15 | 5 | 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 | |||
| 39112 | 14585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918 | (37.7700327707282, -122.44520049918) | 15 | 5 | 11 | 29492 | 9 | |||
| 40875 | 138980 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 712 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003074.6186 | 2110844.4251 | 37.7761501973749 | -122.432868552462 | (37.7761501973749, -122.432868552462) | 15 | 9 | 11 | 29492 | 10 | |||
| 41460 | 248350 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.450322880989 | (37.7685597685915, -122.450322880989) | 15 | 5 | 11 | 29492 | 9 | |||
| 41921 | 141342 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 454 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001185.8232 | 2110322.8485 | 37.7746107701242 | -122.439364995038 | (37.7746107701242, -122.439364995038) | 15 | 5 | 11 | 29492 | 10 | |||
| 45008 | 246387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999191.1888 | 2108399.0339 | 37.7692147510646 | -122.446126395439 | (37.7692147510646, -122.446126395439) | 15 | 5 | 11 | 29492 | 9 | |||
| 45097 | 138716 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999594.5745 | 2114418.8648 | 37.7857666921726 | -122.445163962127 | (37.7857666921726, -122.445163962127) | 15 | 6 | 1 | 29490 | 31 | |||
| 46831 | 140683 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21288 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997608.0859 | 2110262.8359 | 37.7742417384078 | -122.451736704617 | (37.7742417384078, -122.451736704617) | 15 | 5 | 2 | 29492 | 16 | |||
| 47862 | 17675 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.7794417346192 | -122.435215744209 | (37.7794417346192, -122.435215744209) | 15 | 5 | 11 | 29490 | 41 | |||
| 48547 | 142458 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1450 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000907.3913 | 2110378.0547 | 37.7747465034057 | -122.440332103705 | (37.7747465034057, -122.440332103705) | 15 | 5 | 11 | 29492 | 10 | |||
| 48736 | 22785 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1885 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001011.2725 | 2112069.058 | 37.7793954847522 | -122.440094040754 | (37.7793954847522, -122.440094040754) | 15 | 5 | 11 | 29490 | 41 | |||
| 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 | |||
| 50060 | 248364 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.7687734106589 | -122.448621439577 | (37.7687734106589, -122.448621439577) | 15 | 5 | 11 | 29492 | 9 | |||
| 50148 | 247386 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1045 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001982.645 | 2109781.521 | 37.773169733383 | -122.436569880602 | (37.773169733383, -122.436569880602) | 15 | 5 | 11 | 29492 | 9 | |||
| 50167 | 244530 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258947 | (37.7701388371467, -122.44703258947) | 15 | 5 | 11 | 29492 | 9 | |||
| 51977 | 141307 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 61 COOK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5997486.7259 | 2113348.6561 | 37.7827076436193 | -122.452379230189 | (37.7827076436193, -122.452379230189) | 15 | 6 | 1 | 54 | 31 | |||
| 52878 | 247257 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997008.9956 | 2109086.9596 | 37.7709787579671 | -122.453724126699 | (37.7709787579671, -122.453724126699) | 15 | 5 | 11 | 29492 | 9 | |||
| 53133 | 104353 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2594 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999783.3073 | 2113692.3242 | 37.7837825709749 | -122.444458768108 | (37.7837825709749, -122.444458768108) | 15 | 6 | 11 | 29490 | 31 | |||
| 53611 | 138739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999270.4631 | 2114185.9407 | 37.7851086382869 | -122.446268530298 | (37.7851086382869, -122.446268530298) | 15 | 6 | 1 | 29490 | 31 | |||
| 53616 | 137517 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001642.6038 | 2112140.9289 | 37.779628745329 | -122.437915153636 | (37.779628745329, -122.437915153636) | 15 | 5 | 11 | 29490 | 41 | |||
| 53713 | 140510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003410.4306 | 2111922.6668 | 37.7791298221794 | -122.431783892996 | (37.7791298221794, -122.431783892996) | 15 | 9 | 11 | 29490 | 41 | |||
| 54101 | 140403 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1119 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003754.0514 | 2112594.2194 | 37.7809932110185 | -122.430643102161 | (37.7809932110185, -122.430643102161) | 15 | 9 | 11 | 29490 | 41 | |||
| 54142 | 7177 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | 15 | 9 | 11 | 29492 | 10 | |||
| 54837 | 55473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1270 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11425 | 6001761.1754 | 2110839.3962 | 37.7760618062261 | -122.437411738171 | (37.7760618062261, -122.437411738171) | 15 | 5 | 11 | 29492 | 10 | ||
| 55772 | 246074 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998681.2247 | 2108328.1719 | 37.7689910464057 | -122.447885224354 | (37.7689910464057, -122.447885224354) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 57468 | 248363 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1503 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998433.2076 | 2108248.225 | 37.7687573531744 | -122.448737336914 | (37.7687573531744, -122.448737336914) | 15 | 5 | 11 | 29492 | 9 | |||
| 57691 | 137640 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1319 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002813.9379 | 2111632.5778 | 37.7782994795531 | -122.433826662886 | (37.7782994795531, -122.433826662886) | 15 | 5 | 11 | 29492 | 41 | |||
| 58363 | 16974 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 785 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003248.3505 | 2109954.9799 | 37.7737178528926 | -122.432204032613 | (37.7737178528926, -122.432204032613) | 15 | 9 | 11 | 29492 | 10 | |||
| 58558 | 246173 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997888.1153 | 2108243.3798 | 37.768712864196 | -122.450622412179 | (37.768712864196, -122.450622412179) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 59329 | 137638 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 807 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999975.5644 | 2111759.3427 | 37.7784860688888 | -122.443654723767 | (37.7784860688888, -122.443654723767) | 15 | 5 | 11 | 29490 | 16 | |||
| 60700 | 244192 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 529 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998441.2408 | 2108808.2865 | 37.7702955988047 | -122.448749895574 | (37.7702955988047, -122.448749895574) | 15 | 5 | 11 | 29492 | 9 | |||
| 61039 | 137688 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1836 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000295.9538 | 2111331.2873 | 37.7773290058158 | -122.442515637928 | (37.7773290058158, -122.442515637928) | 15 | 5 | 11 | 29490 | 16 | |||
| 61706 | 138607 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 512 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999174.9019 | 2114851.0194 | 37.7869293124952 | -122.446647009525 | (37.7869293124952, -122.446647009525) | 15 | 6 | 1 | 29490 | 31 | |||
| 62544 | 248469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | 15 | 5 | 11 | 29492 | 9 | |||
| 63273 | 16989 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 880 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002806.5013 | 2109946.7063 | 37.7736700736517 | -122.433731865097 | (37.7736700736517, -122.433731865097) | 15 | 5 | 11 | 29492 | 10 | |||
| 63639 | 17679 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | 15 | 5 | 11 | 29490 | 41 | |||
| 63983 | 62369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.7739117964536 | -122.449478321628 | (37.7739117964536, -122.449478321628) | 15 | 5 | 11 | 29492 | 16 | |
| 64717 | 16976 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003075.3996 | 2109932.9295 | 37.7736475004085 | -122.432800720802 | (37.7736475004085, -122.432800720802) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 65301 | 9636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | 15 | 5 | 11 | 29490 | 41 | |||
| 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 | |||
| 66771 | 17128 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 67896 | 59593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.7852505885272 | -122.443194090382 | (37.7852505885272, -122.443194090382) | 15 | 6 | 1 | 29490 | 27 | ||
| 67956 | 9638 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1470 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002570.9212 | 2111995.2227 | 37.7792814183991 | -122.434693285009 | (37.7792814183991, -122.434693285009) | 15 | 5 | 11 | 29490 | 41 | |||
| 69199 | 141383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6001170.9258 | 2110090.9457 | 37.7739731755059 | -122.439399901379 | (37.7739731755059, -122.439399901379) | 15 | 5 | 11 | 29492 | 10 | |||
| 71079 | 17113 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1875 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5998056.3964 | 2109231.5833 | 37.7714358490518 | -122.450111579711 | (37.7714358490518, -122.450111579711) | 15 | 5 | 11 | 29492 | 9 | |||
| 71148 | 137659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1334 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002765.4317 | 2111672.0138 | 37.7784050083088 | -122.433997283271 | (37.7784050083088, -122.433997283271) | 15 | 5 | 11 | 29490 | 41 | |||
| 71607 | 61078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.444377837774 | (37.7837992291467, -122.444377837774) | 15 | 6 | 11 | 29490 | 31 | ||
| 71673 | 248411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1737 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997411.4623 | 2108107.5609 | 37.7683126457867 | -122.452261308397 | (37.7683126457867, -122.452261308397) | 15 | 5 | 11 | 29492 | 9 | |||
| 72679 | 246053 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1456 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998746.9386 | 2108335.7426 | 37.7690155895077 | -122.447658470154 | (37.7690155895077, -122.447658470154) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 73929 | 246153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1720 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997461.1263 | 2108156.7707 | 37.7684506082583 | -122.452093077181 | (37.7684506082583, -122.452093077181) | 15 | 5 | 11 | 29492 | 9 | |||
| 74602 | 17126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1971 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997587.7043 | 2109167.9232 | 37.7712342233691 | -122.451728208046 | (37.7712342233691, -122.451728208046) | 15 | 5 | 11 | 29492 | 9 | |||
| 74673 | 141682 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998677.6671 | 2111822.1113 | 37.7785843052603 | -122.448149143618 | (37.7785843052603, -122.448149143618) | 15 | 6 | 2 | 54 | 16 | |||
| 74774 | 28785 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | 15 | 5 | 11 | 29492 | 9 | |||
| 75606 | 140724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002188.642 | 2110237.6916 | 37.7744339682233 | -122.435889957062 | (37.7744339682233, -122.435889957062) | 15 | 5 | 11 | 29492 | 10 | |||
| 77368 | 247387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001955.5092 | 2109778.1291 | 37.7731588780046 | -122.43666350389 | (37.7731588780046, -122.43666350389) | 15 | 5 | 11 | 29492 | 9 | |||
| 78074 | 246129 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998642.4625 | 2108323.3267 | 37.7689755270562 | -122.448018950873 | (37.7689755270562, -122.448018950873) | 15 | 5 | 11 | 29492 | 9 |
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) );