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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78900 | 78900 | 9577 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | |||
| 78901 | 78901 | 23814 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 78920 | 78920 | 23703 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
| 78930 | 78930 | 57108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.752087986316106 | -122.42645196024401 | (37.7520879863161, -122.426451960244) | |
| 78939 | 78939 | 8182 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | |||
| 78954 | 78954 | 113001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 78965 | 78965 | 11046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007462.427490001 | 2117742.7343900003 | 37.795339161156605 | -122.41817908492399 | (37.7953391611566, -122.418179084924) | |||
| 79022 | 79022 | 61158 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) |
| 79031 | 79031 | 4709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.6629099995 | 2120633.4675 | 37.8033402849031 | -122.41445215852801 | (37.8033402849031, -122.414452158528) | ||
| 79034 | 79034 | 16939 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 79069 | 79069 | 44125 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.40233912369301 | (37.796490448112, -122.402339123693) | ||||
| 79104 | 79104 | 116602 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x9 | 6005124.0 | 2106632.0 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | |||
| 79132 | 79132 | 109603 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.41588590510901 | (37.758675396701, -122.415885905109) | ||||
| 79144 | 79144 | 16393 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.785180307755105 | -122.42217541209699 | (37.7851803077551, -122.422175412097) | |||
| 79174 | 79174 | 108979 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3298 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6001385.1 | 2119659.6 | 37.800258423921 | -122.43934505130699 | (37.800258423921, -122.439345051307) | |||
| 79278 | 79278 | 7198 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003395.6816300005 | 2111577.87165 | 37.778182264409295 | -122.431810290332 | (37.7781822644093, -122.431810290332) | |||
| 79284 | 79284 | 97611 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 349 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009106.7 | 2109348.6 | 37.7723832922197 | -122.41189615048799 | (37.7723832922197, -122.411896150488) | ||||
| 79378 | 79378 | 20244 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | |||
| 79382 | 79382 | 22281 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
| 79385 | 79385 | 110987 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 79478 | 79478 | 22719 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 79481 | 79481 | 49286 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 79496 | 79496 | 96947 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6x6 | 6007389.0 | 2101516.0 | 37.750780272338 | -122.41728270280899 | (37.750780272338, -122.417282702809) | |||
| 79524 | 79524 | 112827 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 79549 | 79549 | 18364 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.40728647423201 | (37.7619322307219, -122.407286474232) | |||
| 79552 | 79552 | 14994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 79580 | 79580 | 19375 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011348.292859999 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | |||
| 79589 | 79589 | 11091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.41884176477899 | (37.7984523847496, -122.418841764779) | |||
| 79596 | 79596 | 117399 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 79646 | 79646 | 117205 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | |||||
| 79647 | 79647 | 107630 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001495.0 | 2119755.0 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | |||
| 79776 | 79776 | 94218 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | ||
| 79798 | 79798 | 115056 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 79832 | 79832 | 665 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 79837 | 79837 | 21956 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015841.2226599995 | 2104083.6923599998 | 37.758302516993105 | -122.38823308755899 | (37.7583025169931, -122.388233087559) | |||
| 79860 | 79860 | 101758 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 79863 | 79863 | 7185 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.43157522738599 | (37.7773563593355, -122.431575227386) | |||
| 79876 | 79876 | 120964 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 79879 | 79879 | 110363 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1899x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011823.0 | 2106021.0 | 37.7633984709679 | -122.40226615501801 | (37.7633984709679, -122.402266155018) | ||||
| 79945 | 79945 | 113775 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6000121.0 | 2114885.0 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | |||
| 79990 | 79990 | 111430 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999200.0 | 2114887.0 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | ||||
| 80014 | 80014 | 13200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.43658729566201 | (37.7999076905723, -122.436587295662) | |||
| 80115 | 80115 | 7156 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | |||
| 80118 | 80118 | 15251 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007694.41094 | 2110207.30516 | 37.774661758829104 | -122.416842252889 | (37.7746617588291, -122.416842252889) | |||
| 80162 | 80162 | 110730 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
| 80196 | 80196 | 120531 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 80256 | 80256 | 668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 80323 | 80323 | 4626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010254.831619999 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | |||
| 80353 | 80353 | 18304 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.768310067349894 | -122.407895847634 | (37.7683100673499, -122.407895847634) | |||
| 80364 | 80364 | 573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 776380 | 6009007.8652800005 | 2102243.7741799997 | 37.752869522851704 | -122.411735919997 | (37.7528695228517, -122.411735919997) | ||
| 80416 | 80416 | 17013 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | |||
| 80453 | 80453 | 96734 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 520 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3.5 | 6007401.6 | 2106571.6 | 37.764662495901106 | -122.41759740995501 | (37.7646624959011, -122.417597409955) | |||
| 80462 | 80462 | 13254 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | ||
| 80486 | 80486 | 4599 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 80490 | 80490 | 11446 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2191X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005072.64937 | 2117089.8596099997 | 37.7934117301419 | -122.42640160486499 | (37.7934117301419, -122.426401604865) | |||
| 80499 | 80499 | 108103 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 80508 | 80508 | 17044 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Oak St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6001235.1914802 | 2109729.1714048 | 37.772983491104604 | -122.439151661694 | (37.7729834911046, -122.439151661694) | |||
| 80569 | 80569 | 113510 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008411.0 | 2113171.0 | 37.7828396386737 | -122.41457318656299 | (37.7828396386737, -122.414573186563) | ||||
| 80579 | 80579 | 20167 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | |||
| 80581 | 80581 | 96337 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1851 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.766145462943605 | -122.42523686393 | (37.7661454629436, -122.42523686393) | |||
| 80590 | 80590 | 15250 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007716.1596800005 | 2110227.0605599997 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | |||
| 80661 | 80661 | 107839 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008256.0 | 2115925.0 | 37.790392745036 | -122.41530444395501 | (37.790392745036, -122.415304443955) | ||||
| 80711 | 80711 | 120139 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 80730 | 80730 | 117185 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 80900 | 80900 | 6378 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006136.3622127995 | 2112667.0618884997 | 37.781327894236796 | -122.422406674363 | (37.7813278942368, -122.422406674363) | |||
| 80976 | 80976 | 41195 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1996 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 80990 | 80990 | 17830 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.42804619277099 | (37.7885920838825, -122.428046192771) | |||
| 81060 | 81060 | 17309 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 70 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | |||
| 81089 | 81089 | 100262 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 81143 | 81143 | 4596 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 81170 | 81170 | 60715 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 30 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1983 12:00:00 AM | 24 | 3x3 | Permit Number 20368 | 6005215.9296478 | 2105282.4178358 | 37.7609994776864 | -122.425065336381 | (37.7609994776864, -122.425065336381) | |
| 81245 | 81245 | 111817 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 80 ORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6000817.0 | 2105938.0 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | |||
| 81353 | 81353 | 112404 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011264.0 | 2107649.0 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | ||||
| 81359 | 81359 | 112751 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | Private 3 | 3x3 | 6009947.0 | 2118097.0 | 37.796451422722605 | -122.409607037418 | (37.7964514227226, -122.409607037418) | |||
| 81456 | 81456 | 17320 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 81530 | 81530 | 25702 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 550 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.40167438060301 | (37.7752602760543, -122.401674380603) | |||
| 81572 | 81572 | 110995 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 81573 | 81573 | 110967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003043.0 | 2116458.0 | 37.7915618650441 | -122.43337916182101 | (37.7915618650441, -122.433379161821) | ||||
| 81585 | 81585 | 52592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 327CALIFORNIA 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48686 | 5988048.64326864 | 2113784.56845539 | 37.7833593060301 | -122.48506257055 | (37.7833593060301, -122.48506257055) | ||||
| 81633 | 81633 | 11103 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | |||
| 81656 | 81656 | 15164 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 81682 | 81682 | 44064 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 81832 | 81832 | 99266 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008042.0 | 2117018.0 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | ||||
| 81839 | 81839 | 15324 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1698X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 81870 | 81870 | 25701 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 550 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6012066.8540199995 | 2110350.0849099997 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | |||
| 81958 | 81958 | 18383 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | |||
| 82000 | 82000 | 23820 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 82122 | 82122 | 100107 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 82132 | 82132 | 121039 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | ||||
| 82140 | 82140 | 18940 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2770 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001564.88968 | 2115697.48907 | 37.7893897308811 | -122.438438883241 | (37.7893897308811, -122.438438883241) | |||
| 82173 | 82173 | 94931 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1771 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004522.0 | 2118744.0 | 37.7979224352085 | -122.428424847305 | (37.7979224352085, -122.428424847305) | |||||
| 82184 | 82184 | 121122 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 82261 | 82261 | 10710 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.783111376296795 | -122.430189039187 | (37.7831113762968, -122.430189039187) | |||
| 82278 | 82278 | 11175 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 82448 | 82448 | 20124 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 924X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002999.41967 | 2110319.2516799998 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | |||
| 82477 | 82477 | 20090 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2075X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.45345917871401 | (37.7709958615587, -122.453459178714) | |||
| 82490 | 82490 | 21634 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1629 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004806.293908 | 2114684.9896753 | 37.786793502462004 | -122.42715183963301 | (37.786793502462, -122.427151839633) | |||
| 82491 | 82491 | 49240 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) |
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");