Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79713 | 79713 | 3575 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 84280 | 84280 | 3576 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 95791 | 95791 | 3567 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 103648 | 103648 | 3574 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 113278 | 113278 | 3568 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 138764 | 138764 | 3571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 13811 | 13811 | 3566 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.740229404572396 | -122.377152086609 | (37.7402294045724, -122.377152086609) | ||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 16144 | 16144 | 3565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.37721484129601 | (37.740264715549, -122.377214841296) | ||
| 14754 | 14754 | 3564 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.740299071447794 | -122.377276992562 | (37.7402990714478, -122.377276992562) | ||
| 13816 | 13816 | 3563 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.37733612657401 | (37.7403324731777, -122.377336126574) | ||
| 14102 | 14102 | 3562 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.37739405370701 | (37.7403663524293, -122.377394053707) | ||
| 116499 | 116499 | 3555 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018831.8 | 2097475.1 | 37.7403219094469 | -122.377431668566 | (37.7403219094469, -122.377431668566) | ||
| 14314 | 14314 | 3560 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | ||
| 59414 | 59414 | 83045 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | ||
| 16143 | 16143 | 3559 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | ||
| 173934 | 173934 | 83044 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 2 | 6018777.54715 | 2097643.31156 | 37.740780796002895 | -122.377630926146 | (37.7407807960029, -122.377630926146) | ||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 13656 | 13656 | 3557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.221530001 | 2097553.75967 | 37.740533839473294 | -122.377691534151 | (37.7405338394733, -122.377691534151) | ||
| 4990 | 4990 | 3550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | ||
| 89486 | 89486 | 41526 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | |||
| 99125 | 99125 | 1984 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 106 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 3 | 3X4 | 6017854.9793307 | 2094779.8205714 | 37.732867343787 | -122.38062186171699 | (37.732867343787, -122.380621861717) | ||
| 140155 | 140155 | 121343 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 399X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017829.0 | 2098352.0 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | |||
| 146110 | 146110 | 121354 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 399X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017829.0 | 2098352.0 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | |||
| 119429 | 119429 | 1980 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 96 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017818.374320901 | 2094812.8777716998 | 37.7329560922326 | -122.38075071303601 | (37.7329560922326, -122.380750713036) | ||
| 90950 | 90950 | 1967 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 55 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017714.6010769 | 2094983.7665226 | 37.7334195913803 | -122.381121365124 | (37.7334195913803, -122.381121365124) | ||
| 110194 | 110194 | 1964 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 45 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017685.4326556 | 2095014.8991764 | 37.7335034653707 | -122.38122437355301 | (37.7335034653707, -122.381224373553) | ||
| 140205 | 140205 | 1958 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 31 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017652.9680682 | 2095074.2258741 | 37.7336645725809 | -122.381340737954 | (37.7336645725809, -122.381340737954) | ||
| 81392 | 81392 | 1962 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 36 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017618.4307655 | 2095033.1830576 | 37.733549970373105 | -122.38145729159599 | (37.7335499703731, -122.381457291596) | ||
| 138548 | 138548 | 1957 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 28 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017599.7808961 | 2095067.264352 | 37.7336425212053 | -122.381524139501 | (37.7336425212053, -122.381524139501) | ||
| 115850 | 115850 | 1951 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 22 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | ||
| 13814 | 13814 | 10604 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.864569999 | 2095475.59177 | 37.73473117440221 | -122.383588632512 | (37.7347311744022, -122.383588632512) | ||
| 16403 | 16403 | 3726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016987.22702 | 2098921.28419 | 37.744191044988 | -122.38391020401899 | (37.744191044988, -122.383910204019) | |||
| 42792 | 42792 | 194229 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 7 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016979.331809999 | 2095396.8970400002 | 37.734513351414705 | -122.38369217597601 | (37.7345133514147, -122.383692175976) | |||
| 106019 | 106019 | 51293 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1211 Shafter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47665 | 6016968.484021 | 2092614.87789536 | 37.726873876443 | -122.38353606910401 | (37.726873876443, -122.383536069104) | |||
| 169950 | 169950 | 194228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016962.87933 | 2095412.7362900001 | 37.7345559334103 | -122.38375016066001 | (37.7345559334103, -122.38375016066) | |||
| 158349 | 158349 | 199980 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1211 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6016959.5373 | 2092619.407 | 37.726885817981895 | -122.38356731318501 | (37.7268858179819, -122.383567313185) | |||
| 135586 | 135586 | 102732 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1217 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6016939.1559 | 2092633.1782 | 37.7269225044661 | -122.383638730259 | (37.7269225044661, -122.383638730259) | |||
| 125678 | 125678 | 51294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1217 Shafter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47666 | 6016937.80385774 | 2092637.74842389 | 37.726934978673796 | -122.383643722332 | (37.7269349786738, -122.383643722332) | |||
| 61673 | 61673 | 194226 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6016841.98922 | 2095417.85433 | 37.734563303344295 | -122.38416847851101 | (37.7345633033443, -122.384168478511) | |||
| 56125 | 56125 | 194230 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 58 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6016826.40406 | 2095640.34928 | 37.7351733683505 | -122.38423785221902 | (37.7351733683505, -122.384237852219) | |||
| 152408 | 152408 | 194227 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 8 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6016817.60054 | 2095485.74545 | 37.7347483703482 | -122.384257525772 | (37.7347483703482, -122.384257525772) | |||
| 65635 | 65635 | 194231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6016795.73668 | 2095634.4055 | 37.7351553522317 | -122.384343467669 | (37.7351553522317, -122.384343467669) | |||
| 29804 | 29804 | 194225 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6016755.26705 | 2095536.04747 | 37.734883042913395 | -122.384476538576 | (37.7348830429134, -122.384476538576) | |||
| 35401 | 35401 | 194224 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 11 Jakey Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6016749.98334 | 2095555.73275 | 37.7349368025769 | -122.384496177064 | (37.7349368025769, -122.384496177064) | |||
| 179901 | 179901 | 194232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 70 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016747.54449 | 2095620.76311 | 37.7351152280806 | -122.38450913719 | (37.7351152280806, -122.38450913719) | |||
| 183369 | 183369 | 194238 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 6 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6016710.45664 | 2095786.72783 | 37.735568882989796 | -122.384648921526 | (37.7355688829898, -122.384648921526) | |||
| 26262 | 26262 | 194237 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 11 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6016697.0495 | 2095760.45578 | 37.735496003732 | -122.38469344603901 | (37.735496003732, -122.384693446039) | |||
| 170909 | 170909 | 194233 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6016686.67059 | 2095602.00775 | 37.735060363144605 | -122.38471829610701 | (37.7350603631446, -122.384718296107) | |||
| 63902 | 63902 | 194236 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6016647.59382 | 2095743.55851 | 37.7354468719595 | -122.384863257848 | (37.7354468719595, -122.384863257848) | |||
| 89905 | 89905 | 3554 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 50639 | 50639 | 194235 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6016602.67648 | 2095728.9552900002 | 37.7354042899791 | -122.385017538329 | (37.7354042899791, -122.385017538329) | |||
| 44540 | 44540 | 194234 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 21 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6016584.85791 | 2095721.5603900002 | 37.7353829994301 | -122.385078629298 | (37.7353829994301, -122.385078629298) | |||
| 15044 | 15044 | 3707 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016577.539609999 | 2099225.88923 | 37.7450047713688 | -122.385348049088 | (37.7450047713688, -122.385348049088) | ||
| 103074 | 103074 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.743261569489704 | -122.38540219642401 | (37.7432615694897, -122.385402196424) | |||
| 168379 | 168379 | 194241 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4 Mabrey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6016531.12407 | 2095935.7497 | 37.735968147815704 | -122.385279329202 | (37.7359681478157, -122.385279329202) | |||
| 16268 | 16268 | 13318 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 11 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/09/1992 12:00:00 AM | 12 | 3X3 | 6016491.98013 | 2095896.26802 | 37.735857573458794 | -122.38541191625099 | (37.7358575734588, -122.385411916251) | ||
| 74426 | 74426 | 194240 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Mabrey Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6016449.3803900005 | 2095875.6026700002 | 37.735798473604795 | -122.385557761994 | (37.7357984736048, -122.385557761994) | |||
| 14969 | 14969 | 13320 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 16 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/09/1992 12:00:00 AM | 6 | 3X3 | 6016446.48412 | 2095922.18028 | 37.7359262061134 | -122.385571020705 | (37.7359262061134, -122.385571020705) | ||
| 61547 | 61547 | 194239 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Mabrey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016431.077330001 | 2095866.9452 | 37.7357736892058 | -122.385620440254 | (37.7357736892058, -122.385620440254) | |||
| 13525 | 13525 | 3697 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016390.489709999 | 2099364.7540700003 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | |||
| 98513 | 98513 | 12193 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1465 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016272.6778818 | 2095480.4561363999 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | |||
| 72457 | 72457 | 194194 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1888 Illinois St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6016264.99223 | 2100427.37243 | 37.7482865000228 | -122.38651255153499 | (37.7482865000228, -122.386512551535) | |||
| 133572 | 133572 | 200525 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016241.3617 | 2095551.4547 | 37.7348969165843 | -122.386254379093 | (37.7348969165843, -122.386254379093) | |||
| 42250 | 42250 | 194138 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 Illinois St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6015994.24024 | 2105456.78042 | 37.7620812009176 | -122.387799686412 | (37.7620812009176, -122.387799686412) | ||||
| 73476 | 73476 | 194140 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 Illinois St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6015990.70284 | 2105517.86766 | 37.762248737420705 | -122.38781618356701 | (37.7622487374207, -122.387816183567) | ||||
| 39449 | 39449 | 194139 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6015990.605380001 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | ||||
| 159573 | 159573 | 74272 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1998 12:00:00 AM | 13 | 6015960.78285 | 2105386.23771 | 37.761885652315705 | -122.387910481099 | (37.7618856523157, -122.387910481099) | ||
| 14191 | 14191 | 12216 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1523 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1992 12:00:00 AM | 15 | 3X3 | 6015935.5625 | 2095820.8342 | 37.735619647499 | -122.387330428498 | (37.735619647499, -122.387330428498) | ||
| 66374 | 66374 | 74059 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1998 12:00:00 AM | 9 | 6015912.53475 | 2105383.55959 | 37.7618756257676 | -122.38807716683701 | (37.7618756257676, -122.388077166837) | ||
| 137487 | 137487 | 72834 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1998 12:00:00 AM | 8 | 6015894.43243 | 2105382.09889 | 37.76187061204679 | -122.388139674229 | (37.7618706120468, -122.388139674229) | ||
| 16013 | 16013 | 22114 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3650X 03rd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5X5 | 6015872.240569999 | 2098764.87252 | 37.7436998694469 | -122.38775470773999 | (37.7436998694469, -122.38775470774) | |||
| 104535 | 104535 | 64528 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1450 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1988 12:00:00 AM | Permit Number 25410 | 6015863.28704 | 2094893.11504234 | 37.7330683144881 | -122.387515613747 | (37.7330683144881, -122.387515613747) | ||
| 14876 | 14876 | 96731 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1504 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015860.59929 | 2096653.48415 | 37.7379017837359 | -122.38764768211 | (37.7379017837359, -122.38764768211) | |||
| 16532 | 16532 | 22198 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4049 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6015622.4674 | 2097608.2349 | 37.740510141063204 | -122.38853765218501 | (37.7405101410632, -122.388537652185) | |||
| 15185 | 15185 | 71390 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1530 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1988 12:00:00 AM | 1 | 3x3 | 6015584.85469 | 2096508.0059099998 | 37.7374870523836 | -122.38859092252599 | (37.7374870523836, -122.388590922526) | ||
| 143291 | 143291 | 55069 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1410 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10963 | 6015495.8002 | 2094978.5728 | 37.7332826032428 | -122.388792087955 | (37.7332826032428, -122.388792087955) | ||
| 153941 | 153941 | 194136 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 51 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015363.679269999 | 2102425.5673 | 37.753723186885296 | -122.389768841963 | (37.7537231868853, -122.389768841963) | ||||
| 178109 | 178109 | 194137 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 52 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.68251 | 2102417.32718 | 37.7537005059858 | -122.389771713504 | (37.7537005059858, -122.389771713504) | ||||
| 57533 | 57533 | 194133 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015360.93697 | 2102437.8741900004 | 37.7537568269303 | -122.38977918508199 | (37.7537568269303, -122.389779185082) | ||||
| 65224 | 65224 | 194135 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015359.62578 | 2102424.0826 | 37.753718885432704 | -122.38978275627 | (37.7537188854327, -122.38978275627) | ||||
| 55984 | 55984 | 194132 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 46 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015356.8182 | 2102444.39788 | 37.7537745112003 | -122.389793884481 | (37.7537745112003, -122.389793884481) | ||||
| 37321 | 37321 | 194134 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015354.20873 | 2102436.4215599997 | 37.753752465207704 | -122.389802351607 | (37.7537524652077, -122.389802351607) | ||||
| 166194 | 166194 | 38631 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1575 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40565 | 6015036.874 | 2094048.9037 | 37.730704473021 | -122.390313804197 | (37.730704473021, -122.390313804197) | |
| 71693 | 71693 | 194130 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1278 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015031.011390001 | 2102620.78867 | 37.7542407701151 | -122.39093293521002 | (37.7542407701151, -122.39093293521) | |||
| 75041 | 75041 | 194131 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1310 Indiana St | 4 | : Yard 23 | Tree 1 | Private 1 | 37 | 6014985.85621 | 2102536.5970099997 | 37.754007092062004 | -122.391083210127 | (37.754007092062, -122.391083210127) | ||||
| 96949 | 96949 | 109968 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
| 140856 | 140856 | 109967 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
| 79010 | 79010 | 50355 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 85538 | 85538 | 50358 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774276 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |
| 88281 | 88281 | 50353 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 107383 | 107383 | 50354 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 115678 | 115678 | 50356 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 143576 | 143576 | 50357 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 36139 | 36139 | 194201 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 662 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014609.108519999 | 2111624.9876200003 | 37.778940904643996 | -122.393021952422 | (37.778940904644, -122.393021952422) | |||
| 177108 | 177108 | 194200 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 662 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014600.86316 | 2111636.1866 | 37.7789711964939 | -122.39305126042801 | (37.7789711964939, -122.393051260428) | |||
| 28976 | 28976 | 194199 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 662 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014592.769180001 | 2111644.13802 | 37.7789925796789 | -122.39307981747801 | (37.7789925796789, -122.393079817478) | |||
| 15839 | 15839 | 18557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1700X Quesada Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014589.42489 | 2095117.7447900001 | 37.733614463738604 | -122.391935430178 | (37.7336144637386, -122.391935430178) | |||
| 33684 | 33684 | 194198 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 662 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014579.53841 | 2111655.87054 | 37.779024059548 | -122.39312640955099 | (37.779024059548, -122.393126409551) | |||
| 162470 | 162470 | 194197 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 662 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014568.0664 | 2111668.64931 | 37.779058509868996 | -122.393166990581 | (37.779058509869, -122.393166990581) |
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");