Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 173380 | 173380 | 140446 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1435 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003632.9 | 2112791.8873 | 37.781529093472 | -122.43107633714399 | (37.781529093472, -122.431076337144) | |||
| 7601 | 7601 | 9631 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1439 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002709.6742 | 2111961.3805 | 37.7791963723972 | -122.434210861246 | (37.7791963723972, -122.434210861246) | |||
| 156290 | 156290 | 142471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1439 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010974.128 | 2119867.5279 | 37.8013703629213 | -122.406177738482 | (37.8013703629213, -122.406177738482) | |||
| 162322 | 162322 | 66562 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.783393648613796 | -122.45029037155099 | (37.7833936486138, -122.450290371551) | |
| 29158 | 29158 | 142470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | |||
| 130998 | 130998 | 141652 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1444 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000879.6247 | 2110722.6324 | 37.7756910458411 | -122.440452872246 | (37.7756910458411, -122.440452872246) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 37257 | 37257 | 142458 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000907.3913 | 2110378.0547 | 37.7747465034057 | -122.440332103705 | (37.7747465034057, -122.440332103705) | |||
| 7042 | 7042 | 13093 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005391.575 | 2119956.3245 | 37.8013003370098 | -122.42550219218 | (37.8013003370098, -122.42550219218) | |||
| 110431 | 110431 | 113408 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003890.0 | 2099760.0 | 37.74576122776671 | -122.429257354108 | (37.7457612277667, -122.429257354108) | ||||
| 92442 | 92442 | 37059 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 111616 | 111616 | 37061 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | |
| 139908 | 139908 | 37062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 3362 | 3362 | 114879 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2110394.0 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | ||||
| 165285 | 165285 | 142173 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000881.5899 | 2110372.1418 | 37.77472879899221 | -122.44042093163799 | (37.7747287989922, -122.440420931638) | |||
| 146917 | 146917 | 142466 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010993.6362 | 2119929.285 | 37.8015410239646 | -122.40611458444599 | (37.8015410239646, -122.406114584446) | |||
| 43401 | 43401 | 182246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.759970370515106 | -122.491999577939 | (37.7599703705151, -122.491999577939) | |||
| 55708 | 55708 | 142468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010964.6624 | 2119932.1708 | 37.801547327044894 | -122.40621505084299 | (37.8015473270449, -122.406215050843) | |||
| 74573 | 74573 | 142464 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010990.4041 | 2119956.0656 | 37.8016143761567 | -122.406127656852 | (37.8016143761567, -122.406127656852) | |||
| 30721 | 30721 | 246053 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998746.9386 | 2108335.7426 | 37.7690155895077 | -122.447658470154 | (37.7690155895077, -122.447658470154) | |||
| 136475 | 136475 | 142465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1457 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010961.892000001 | 2119955.2575 | 37.8016105625065 | -122.406226265244 | (37.8016105625065, -122.406226265244) | |||
| 6870 | 6870 | 9637 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002620.3308 | 2112001.9911 | 37.7793028076481 | -122.43452284095801 | (37.7793028076481, -122.434522840958) | |||
| 8774 | 8774 | 9636 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | |||
| 51484 | 51484 | 246055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998722.7122 | 2108332.1087 | 37.7690042271302 | -122.447742005772 | (37.7690042271302, -122.447742005772) | |||
| 38494 | 38494 | 246056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1466 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998693.9435 | 2108329.3832 | 37.7689950993057 | -122.44784131823401 | (37.7689950993057, -122.447841318234) | |||
| 7585 | 7585 | 9638 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1470 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002570.9212 | 2111995.2227 | 37.7792814183991 | -122.434693285009 | (37.7792814183991, -122.434693285009) | |||
| 4206 | 4206 | 13097 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1475 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005336.846 | 2119866.4127 | 37.801050369840205 | -122.42568517574 | (37.8010503698402, -122.42568517574) | |||
| 62946 | 62946 | 141779 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1480 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003870.3983 | 2113222.6267 | 37.7827252513684 | -122.43028544741101 | (37.7827252513684, -122.430285447411) | |||
| 135066 | 135066 | 141781 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003816.5092 | 2113214.7018 | 37.7827004390473 | -122.43047131515301 | (37.7827004390473, -122.430471315153) | |||
| 156591 | 156591 | 141780 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1480 ELLIS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003842.3971 | 2113219.4567 | 37.7827149612606 | -122.430382093414 | (37.7827149612606, -122.430382093414) | |||
| 160330 | 160330 | 246074 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1480 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998681.2247 | 2108328.1719 | 37.7689910464057 | -122.447885224354 | (37.7689910464057, -122.447885224354) | |||
| 1838 | 1838 | 9642 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1482 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002517.4506 | 2111986.4237 | 37.7792542228164 | -122.43487763237101 | (37.7792542228164, -122.434877632371) | |||
| 8320 | 8320 | 9641 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002541.4785 | 2111991.5 | 37.77926952525671 | -122.434794873127 | (37.7792695252567, -122.434794873127) | |||
| 27737 | 27737 | 248360 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998667.1431 | 2108281.3848 | 37.768861776014795 | -122.447930562543 | (37.7688617760148, -122.447930562543) | |||
| 68809 | 68809 | 248358 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998577.0515 | 2108268.5146 | 37.76882128769329 | -122.44824125490601 | (37.7688212876933, -122.448241254906) | |||
| 173043 | 173043 | 248359 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998647.9135 | 2108278.8108 | 37.768853609287206 | -122.44799689076099 | (37.7688536092872, -122.447996890761) | |||
| 22359 | 22359 | 246131 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998602.7919 | 2108317.2701 | 37.768956629428395 | -122.448155732181 | (37.7689566294284, -122.448155732181) | |||
| 39181 | 39181 | 246129 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998642.4625 | 2108323.3267 | 37.768975527056206 | -122.44801895087299 | (37.7689755270562, -122.448018950873) | |||
| 189100 | 189100 | 246130 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998621.8702 | 2108319.087 | 37.768962708792 | -122.448089872703 | (37.768962708792, -122.448089872703) | |||
| 3328 | 3328 | 140422 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.43347055342699 | (37.7802667133087, -122.433470553427) | |||
| 3334 | 3334 | 140424 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | |||
| 3335 | 3335 | 140428 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.43297038187401 | (37.7803281468599, -122.432970381874) | |||
| 3339 | 3339 | 140429 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 15 | Width 0ft | 6003096.7102 | 2112369.578 | 37.7803391401181 | -122.432901115602 | (37.7803391401181, -122.432901115602) | |||
| 3342 | 3342 | 140426 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.43314124413601 | (37.7803076012967, -122.433141244136) | |||
| 3343 | 3343 | 140423 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.43338395792802 | (37.7802799627924, -122.433383957928) | |||
| 3344 | 3344 | 140425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.780300508432795 | -122.43321309578998 | (37.7803005084328, -122.43321309579) | |||
| 3349 | 3349 | 140427 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | |||
| 3337 | 3337 | 140433 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 15 | Width 0ft | 6003251.7396 | 2112391.1099 | 37.7804070531695 | -122.432366335522 | (37.7804070531695, -122.432366335522) | |||
| 3347 | 3347 | 140434 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003279.731000001 | 2112394.6985 | 37.780418493723204 | -122.43226975660299 | (37.7804184937232, -122.432269756603) | |||
| 3351 | 3351 | 140431 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003184.2731 | 2112381.0617 | 37.7803756375453 | -122.432599015585 | (37.7803756375453, -122.432599015585) | |||
| 46678 | 46678 | 142123 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 15 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998622.5379 | 2110844.3781 | 37.7758965505953 | -122.448269431558 | (37.7758965505953, -122.448269431558) | |||
| 71986 | 71986 | 200997 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 150 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6015155.9522 | 2115579.6824 | 37.7898299587744 | -122.39140672399999 | (37.7898299587744, -122.391406724) | |||
| 154375 | 154375 | 244243 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 150 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005806.4217 | 2110019.2116 | 37.774038923730295 | -122.423359820085 | (37.7740389237303, -122.423359820085) | |||
| 168437 | 168437 | 244244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 150 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005791.8047 | 2110016.6014 | 37.7740309317752 | -122.423410197258 | (37.7740309317752, -122.423410197258) | |||
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 38098 | 38098 | 98472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887005 | -122.402121236301 | (37.766182021887, -122.402121236301) | |||
| 46381 | 46381 | 98473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | |||
| 47183 | 47183 | 98470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | |||
| 181203 | 181203 | 98471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.40207202642401 | (37.7661880408824, -122.402072026424) | |||
| 26537 | 26537 | 199734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | |||
| 36681 | 36681 | 199730 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014897.5638 | 2092133.7733 | 37.725438180339 | -122.390661646389 | (37.725438180339, -122.390661646389) | |||
| 67341 | 67341 | 199739 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014497.7489 | 2092432.2899 | 37.7262356573725 | -122.392064648003 | (37.7262356573725, -122.392064648003) | |||
| 69184 | 69184 | 199738 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6014531.8139 | 2092406.2929 | 37.7261661660829 | -122.39194506905001 | (37.7261661660829, -122.39194506905) | |||
| 97930 | 97930 | 199735 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | |||
| 170427 | 170427 | 199732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | |||
| 2173 | 2173 | 21585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | |||
| 7192 | 7192 | 21587 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005314.2609 | 2114809.1294 | 37.787163071612795 | -122.42540322917601 | (37.7871630716128, -122.425403229176) | |||
| 7706 | 7706 | 21589 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | |||
| 8536 | 8536 | 21588 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.42547307647301 | (37.7871523906748, -122.425473076473) | |||
| 8583 | 8583 | 21586 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | |||
| 8894 | 8894 | 21590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.78713281444121 | -122.425600795702 | (37.7871328144412, -122.425600795702) | |||
| 5657 | 5657 | 26166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005131.2215 | 2119837.4845 | 37.8009593191179 | -122.426394664407 | (37.8009593191179, -122.426394664407) | |||
| 27278 | 27278 | 248364 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.768773410658895 | -122.44862143957701 | (37.7687734106589, -122.448621439577) | |||
| 131916 | 131916 | 248363 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1503 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998433.2076 | 2108248.225 | 37.7687573531744 | -122.44873733691401 | (37.7687573531744, -122.448737336914) | |||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 68794 | 68794 | 244242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 151 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005776.1437 | 2110149.7201 | 37.7743955596449 | -122.423473837096 | (37.7743955596449, -122.423473837096) | |||
| 153799 | 153799 | 141611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1511 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000524.2023 | 2110966.5279 | 37.7763404768103 | -122.44169987057501 | (37.7763404768103, -122.441699870575) | |||
| 47829 | 47829 | 245112 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1511 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999762.5828 | 2109470.1939 | 37.7721884999222 | -122.44422696449499 | (37.7721884999222, -122.444226964495) | |||
| 159841 | 159841 | 141610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1515 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000503.7259 | 2110965.3234 | 37.7763360028573 | -122.441770617481 | (37.7763360028573, -122.441770617481) | |||
| 57517 | 57517 | 142945 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 152 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010109.3364 | 2121119.0539 | 37.804758334186296 | -122.40925868229799 | (37.8047583341863, -122.409258682298) | |||
| 70577 | 70577 | 142944 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 152 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010124.6433 | 2121121.924 | 37.8047670723213 | -122.409205913626 | (37.8047670723213, -122.409205913626) | |||
| 52857 | 52857 | 244541 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1520 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999127.722999999 | 2109084.8233 | 37.7710941303807 | -122.44639526179701 | (37.7710941303807, -122.446395261797) | |||
| 1363 | 1363 | 21606 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | |||
| 23704 | 23704 | 138749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1528 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000156.6321 | 2114235.0077 | 37.785293933510104 | -122.443206197892 | (37.7852939335101, -122.443206197892) | |||
| 35357 | 35357 | 59593 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.785250588527205 | -122.44319409038201 | (37.7852505885272, -122.443194090382) | ||
| 46126 | 46126 | 141766 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1529 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003866.9642 | 2113516.1114 | 37.783530892448 | -122.43031827350599 | (37.783530892448, -122.430318273506) | |||
| 162784 | 162784 | 141765 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1529 O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003847.9445 | 2113512.4132 | 37.7835196607686 | -122.43038381035 | (37.7835196607686, -122.43038381035) | |||
| 27469 | 27469 | 143247 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | |||
| 6232 | 6232 | 13105 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | ||
| 6528 | 6528 | 13104 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.801142928088495 | -122.426724227861 | (37.8011429280885, -122.426724227861) | ||
| 1504 | 1504 | 21609 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1531 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005037.9058 | 2114711.086 | 37.7868782513618 | -122.42635237507 | (37.7868782513618, -122.42635237507) | ||
| 8655 | 8655 | 21608 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.786875002060704 | -122.42646540299 | (37.7868750020607, -122.42646540299) | ||
| 129813 | 129813 | 248337 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1539 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998178.2256 | 2108213.3997 | 37.7686471477417 | -122.449616786829 | (37.7686471477417, -122.449616786829) | |||
| 178610 | 178610 | 142946 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010096.4211 | 2121116.6622 | 37.8047510435874 | -122.409303208326 | (37.8047510435874, -122.409303208326) | |||
| 32305 | 32305 | 141109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.44882758656601 | (37.7814254265925, -122.448827586566) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");