Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221 | 221 | 138361 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002830.8674 | 2114461.7028 | 37.78606850519029 | -122.433970377911 | (37.7860685051903, -122.433970377911) | |||
| 325 | 325 | 21670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6004121.8146 | 2114641.2436 | 37.786634655728605 | -122.429516856277 | (37.7866346557286, -122.429516856277) | |||
| 593 | 593 | 140072 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
| 1448 | 1448 | 138093 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1890 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6003632.0 | 2114586.0 | 37.7864552256154 | -122.43120755079399 | (37.7864552256154, -122.431207550794) | |||
| 2908 | 2908 | 140145 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.45065770078699 | (37.7732838718856, -122.450657700787) | |||
| 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) | |||
| 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) | |||
| 5652 | 5652 | 6235 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | ||
| 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) | |||
| 5722 | 5722 | 21711 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x6 | 6003392.8992 | 2114541.4083 | 37.7863192355998 | -122.43203159373999 | (37.7863192355998, -122.43203159374) | |||
| 5781 | 5781 | 7252 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003031.0875 | 2114271.6252 | 37.78555796067371 | -122.433264083866 | (37.7855579606737, -122.433264083866) | |||
| 5946 | 5946 | 18013 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000963.2953 | 2114846.642 | 37.7870192873225 | -122.440459278057 | (37.7870192873225, -122.440459278057) | |||
| 6233 | 6233 | 4722 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.804065344872704 | -122.415444338519 | (37.8040653448727, -122.415444338519) | |||
| 6362 | 6362 | 21629 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1615 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004674.0893 | 2114666.9174 | 37.786736403473704 | -122.427607948661 | (37.7867364034737, -122.427607948661) | ||
| 6459 | 6459 | 13183 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 12 | 3x3 | 6002759.5454 | 2119509.3192 | 37.7999239124366 | -122.43457818463301 | (37.7999239124366, -122.434578184633) | ||
| 6546 | 6546 | 13195 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6002408.3176 | 2119538.5881 | 37.7999843325384 | -122.435795658785 | (37.7999843325384, -122.435795658785) | |||
| 6739 | 6739 | 99228 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | |||
| 6749 | 6749 | 13206 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6002065.1856 | 2119491.2596 | 37.799834883876 | -122.436979633615 | (37.799834883876, -122.436979633615) | |||
| 6753 | 6753 | 14817 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1234 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003267.0451 | 2111739.9368 | 37.7786199621548 | -122.43226686795799 | (37.7786199621548, -122.432266867958) | |||
| 6970 | 6970 | 6245 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | ||
| 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) | |||
| 7263 | 7263 | 4725 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | |||
| 7470 | 7470 | 13111 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1994 12:00:00 AM | 24 | 3X3 | 6004886.5048 | 2119803.0834 | 37.8008510262732 | -122.4272390368 | (37.8008510262732, -122.4272390368) | ||
| 7525 | 7525 | 7159 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 719 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003516.9027 | 2110817.5612 | 37.7761015111675 | -122.431336655161 | (37.7761015111675, -122.431336655161) | |||
| 7868 | 7868 | 4605 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 270 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010895.3992 | 2118554.4574 | 37.7977605876582 | -122.40635760441799 | (37.7977605876582, -122.406357604418) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 8428 | 8428 | 21739 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002859.7063 | 2114412.7642 | 37.785935768772 | -122.433867103908 | (37.785935768772, -122.433867103908) | |||
| 14749 | 14749 | 7388 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | |||
| 15892 | 15892 | 97244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.38629180873501 | (37.7329489559822, -122.386291808735) | |||
| 17676 | 17676 | 25267 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5994656.4814 | 2092369.8948 | 37.7249427634406 | -122.46064985933901 | (37.7249427634406, -122.460649859339) | |||
| 17957 | 17957 | 15626 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.42330974756901 | (37.7404679423018, -122.423309747569) | |||
| 18957 | 18957 | 15300 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006966.3695 | 2109250.29 | 37.7719930461457 | -122.41929279621 | (37.7719930461457, -122.41929279621) | |||
| 19445 | 19445 | 16994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002602.5998 | 2109922.2867 | 37.7735914513761 | -122.434435444699 | (37.7735914513761, -122.434435444699) | |||
| 20229 | 20229 | 493 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010421.2461 | 2102217.9187 | 37.752877715813796 | -122.406846340514 | (37.7528777158138, -122.406846340514) | |||
| 20516 | 20516 | 19219 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002112.0403 | 2110145.6145 | 37.774176795696995 | -122.436148345951 | (37.774176795697, -122.436148345951) | |||
| 22235 | 22235 | 17057 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6000879.2146 | 2109627.576 | 37.772684273376 | -122.440375738629 | (37.772684273376, -122.440375738629) | |||
| 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) | |||
| 22888 | 22888 | 245220 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.774191391909596 | -122.425893994936 | (37.7741913919096, -122.425893994936) | |||
| 24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
| 27146 | 27146 | 140419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.43365863076201 | (37.780048730384, -122.433658630762) | |||
| 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) | |||
| 28034 | 28034 | 140161 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998791.141 | 2109784.5074 | 37.7729960548875 | -122.44760988046998 | (37.7729960548875, -122.44760988047) | |||
| 30246 | 30246 | 140690 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003362.1468 | 2112293.1578 | 37.7801443609542 | -122.431977389111 | (37.7801443609542, -122.431977389111) | |||
| 31925 | 31925 | 139285 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 855 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003448.7737 | 2111306.0955 | 37.7774390440386 | -122.431607217597 | (37.7774390440386, -122.431607217597) | |||
| 33367 | 33367 | 141080 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 192 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996588.0468 | 2113019.8793 | 37.7817533832417 | -122.45546448989799 | (37.7817533832417, -122.455464489898) | |||
| 34800 | 34800 | 140777 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.44309803536699 | (37.7813935692054, -122.443098035367) | |||
| 35662 | 35662 | 142960 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 180 Pfeiffer St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009952.201 | 2121096.8109999998 | 37.804688455991396 | -122.409800896711 | (37.8046884559914, -122.409800896711) | |||
| 36777 | 36777 | 142949 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 BELLAIR PL | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010058.1538 | 2121167.8448 | 37.8048894342531 | -122.40943925119 | (37.8048894342531, -122.40943925119) | |||
| 37168 | 37168 | 140723 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 555 PIERCE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002602.535 | 2110423.8561 | 37.7749686327575 | -122.434471537714 | (37.7749686327575, -122.434471537714) | |||
| 37976 | 37976 | 140209 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 704 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003553.8988 | 2110879.8473 | 37.7762746300025 | -122.431213122749 | (37.7762746300025, -122.431213122749) | |||
| 40023 | 40023 | 141792 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1280 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003805.1483 | 2112935.1558 | 37.7819322319873 | -122.43049066646499 | (37.7819322319873, -122.430490666465) | |||
| 43832 | 43832 | 138987 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.43152453742701 | (37.7757340330654, -122.431524537427) | |||
| 44977 | 44977 | 143125 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2095 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002486.7834 | 2119470.7090000003 | 37.799802411097296 | -122.435519279075 | (37.7998024110973, -122.435519279075) | |||
| 46666 | 46666 | 140592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 950 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002968.2418 | 2111603.9288 | 37.778229571438295 | -122.433290821469 | (37.7782295714383, -122.433290821469) | |||
| 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) | |||
| 50778 | 50778 | 140610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 860 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003498.0852 | 2111306.0629 | 37.7774417494141 | -122.431436630621 | (37.7774417494141, -122.431436630621) | |||
| 54759 | 54759 | 139432 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | |||
| 56825 | 56825 | 108010 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6005279.8436 | 2111122.0196 | 37.777037232737705 | -122.42525983588001 | (37.7770372327377, -122.42525983588) | ||||
| 58026 | 58026 | 199854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | |||
| 58031 | 58031 | 143187 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010390.2098 | 2121342.6183 | 37.8053879184635 | -122.408302464879 | (37.8053879184635, -122.408302464879) | |||
| 58347 | 58347 | 143363 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1892 UNION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003957.9860000005 | 2118713.6123 | 37.7978070663315 | -122.43037432608801 | (37.7978070663315, -122.430374326088) | |||
| 58484 | 58484 | 138743 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999307.6319 | 2114263.2516 | 37.7853230365302 | -122.446145501349 | (37.7853230365302, -122.446145501349) | |||
| 58650 | 58650 | 138132 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2131 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003095.0366 | 2114792.1671 | 37.786990864454296 | -122.433080043725 | (37.7869908644543, -122.433080043725) | |||
| 59283 | 59283 | 140706 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002658.7155 | 2110338.0026 | 37.774736089286606 | -122.434271058386 | (37.7747360892866, -122.434271058386) | |||
| 59370 | 59370 | 141680 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998758.0111 | 2111834.2387 | 37.7786221965848 | -122.447872077437 | (37.7786221965848, -122.447872077437) | |||
| 59660 | 59660 | 117031 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002487.092999999 | 2114413.0027 | 37.78591527192879 | -122.435156258966 | (37.7859152719288, -122.435156258966) | |||
| 61363 | 61363 | 138465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1870 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001534.446 | 2114897.4717 | 37.7871913575616 | -122.43848687191401 | (37.7871913575616, -122.438486871914) | |||
| 63167 | 63167 | 142150 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 Stanyan Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996389.5624 | 2112799.0591 | 37.7811356783284 | -122.456135178495 | (37.7811356783284, -122.456135178495) | |||
| 63234 | 63234 | 142593 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008314.0969 | 2120822.0003 | 37.8038419583694 | -122.415450267897 | (37.8038419583694, -122.415450267897) | |||
| 64636 | 64636 | 246098 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.45329942957198 | (37.7684784553517, -122.453299429572) | |||
| 64988 | 64988 | 138503 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002537.1515 | 2114272.2749 | 37.7855317115931 | -122.43497300238899 | (37.7855317115931, -122.434973002389) | |||
| 66204 | 66204 | 143212 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010402.9445 | 2121293.4361 | 37.8052535894305 | -122.408254923564 | (37.8052535894305, -122.408254923564) | |||
| 68465 | 68465 | 108005 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | |||
| 68579 | 68579 | 138831 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 745 BUCHANAN ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6004451.1778 | 2111098.9724 | 37.7769271009021 | -122.428124806353 | (37.7769271009021, -122.428124806353) | |||
| 70659 | 70659 | 139446 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005466.7779 | 2111071.8783 | 37.7769101159246 | -122.424609603708 | (37.7769101159246, -122.424609603708) | |||
| 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) | |||
| 72177 | 72177 | 143349 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1651 UNION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005080.6941 | 2118822.0519999997 | 37.798168345125205 | -122.426497166568 | (37.7981683451252, -122.426497166568) | |||
| 72866 | 72866 | 142989 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1851 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010373.868 | 2120901.8959999997 | 37.8041768891146 | -122.408327913174 | (37.8041768891146, -122.408327913174) | |||
| 73003 | 73003 | 117049 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | |||
| 73100 | 73100 | 141695 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998748.3741 | 2112341.6402 | 37.78001483889879 | -122.44794195643499 | (37.7800148388988, -122.447941956435) | |||
| 73309 | 73309 | 110467 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | ||
| 73921 | 73921 | 142633 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009714.0145 | 2121546.0367 | 37.805908566732896 | -122.41065691150699 | (37.8059085667329, -122.410656911507) | |||
| 76808 | 76808 | 138539 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1700 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003089.8085 | 2114203.6138 | 37.785374549591204 | -122.433056065597 | (37.7853745495912, -122.433056065597) | |||
| 120867 | 120867 | 143169 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 185 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009906.0036 | 2121573.3589 | 37.80599434882029 | -122.40999443049999 | (37.8059943488203, -122.4099944305) | |||
| 129779 | 129779 | 141586 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1301 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6001472.6683 | 2111100.3675 | 37.776761961586 | -122.438428460489 | (37.776761961586, -122.438428460489) | |||
| 130403 | 130403 | 143498 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.723999999 | 2117930.0991 | 37.796064276257205 | -122.40519827705499 | (37.7960642762572, -122.405198277055) | |||
| 130476 | 130476 | 142490 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009644.6785 | 2119609.6491 | 37.8005878398576 | -122.41076002073 | (37.8005878398576, -122.41076002073) | |||
| 130725 | 130725 | 245471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010463.1133 | 2102261.5065 | 37.7529997408326 | -122.406704626743 | (37.7529997408326, -122.406704626743) | |||
| 131662 | 131662 | 247451 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 915 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002618.2019 | 2109871.0089 | 37.773451540866496 | -122.434377807884 | (37.7734515408665, -122.434377807884) | |||
| 131793 | 131793 | 138473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1749 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003016.4418 | 2114370.4842 | 37.7858285716099 | -122.433321820329 | (37.7858285716099, -122.433321820329) | |||
| 131804 | 131804 | 138123 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1850 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003035.9259 | 2114580.1998 | 37.786405502849604 | -122.433269401448 | (37.7864055028496, -122.433269401448) | |||
| 132458 | 132458 | 97936 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.41032100357701 | (37.8057498158932, -122.410321003577) | |||
| 132858 | 132858 | 138866 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003084.5886 | 2110775.7422 | 37.7759621766443 | -122.43282915583401 | (37.7759621766443, -122.432829155834) | |||
| 134331 | 134331 | 139436 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | |||
| 134866 | 134866 | 244278 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 589 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004214.5249 | 2110092.3934 | 37.774149889764 | -122.42887168253701 | (37.774149889764, -122.428871682537) | |||
| 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) | |||
| 135750 | 135750 | 247391 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 215 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002287.9227 | 2109197.4231 | 37.7715832884679 | -122.435472094457 | (37.7715832884679, -122.435472094457) | |||
| 147110 | 147110 | 248373 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997837.6943 | 2108167.0669 | 37.768500442306106 | -122.45079131066002 | (37.7685004423061, -122.45079131066) | |||
| 148433 | 148433 | 244501 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 607 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004030.4942 | 2110064.8827 | 37.7740639341827 | -122.42950631481199 | (37.7740639341827, -122.429506314812) |
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");