Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49437 | 49437 | 227622 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221001 | (37.748648223551, -122.43700910221) | |||
| 148811 | 148811 | 247957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6010434.9927199995 | 2098878.7541 | 37.743709870826 | -122.40656351750602 | (37.743709870826, -122.406563517506) | ||||
| 143200 | 143200 | 109857 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 CLIPPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x6 | 6001683.3 | 2100835.6 | 37.748589397757 | -122.436964779583 | (37.748589397757, -122.436964779583) | |||
| 168581 | 168581 | 227609 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6006260.1728300005 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | ||||
| 168888 | 168888 | 176927 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 6000575.21017 | 2087869.90013 | 37.7129255429455 | -122.43986703794201 | (37.7129255429455, -122.439867037942) | |||
| 16799 | 16799 | 57069 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | |
| 62886 | 62886 | 227610 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6006250.04952 | 2097648.9456700003 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | ||||
| 156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
| 171630 | 171630 | 227590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 33 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6005514.0143099995 | 2098729.37498 | 37.743023170990604 | -122.423568480604 | (37.7430231709906, -122.423568480604) | |||
| 16227 | 16227 | 7404 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1060 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 24 | 3X3 | 6010543.2443 | 2111181.3457 | 37.777496075538004 | -122.407056190657 | (37.777496075538, -122.407056190657) | ||
| 144085 | 144085 | 4551 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1991 12:00:00 AM | 24 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | ||
| 174716 | 174716 | 227591 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 27 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6005552.79952 | 2098729.9467700003 | 37.743026930158294 | -122.423434412384 | (37.7430269301583, -122.423434412384) | |||
| 37340 | 37340 | 227600 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 308 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6006510.89149 | 2104242.1298 | 37.7582161548565 | -122.420512774045 | (37.7582161548565, -122.420512774045) | |||
| 160010 | 160010 | 176926 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000586.22066 | 2087873.8924099999 | 37.712937131606395 | -122.439829268227 | (37.7129371316064, -122.439829268227) | |||
| 162169 | 162169 | 101345 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.803736447762795 | -122.413855954453 | (37.8037364477628, -122.413855954453) | ||
| 7985 | 7985 | 1718 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 9x6 | 6012538.2564900005 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | |||
| 163137 | 163137 | 227627 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1455 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6003318.42561 | 2099759.38462 | 37.7457271634958 | -122.43123373066003 | (37.7457271634958, -122.43123373066) | |||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 69112 | 69112 | 187585 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 748 University St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6008708.47344 | 2090752.4419999998 | 37.7213000235466 | -122.411959282496 | (37.7213000235466, -122.411959282496) | ||||
| 159237 | 159237 | 139750 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004722.5099 | 2113632.2289 | 37.78389814561189 | -122.427366689538 | (37.7838981456119, -122.427366689538) | |||
| 7798 | 7798 | 1716 | Landmark tree 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x15 | 6012528.51285 | 2117974.4106400004 | 37.796259138493205 | -122.400665775228 | (37.7962591384932, -122.400665775228) | |||
| 9151 | 9151 | 4530 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | |||
| 9465 | 9465 | 4553 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004771.4236 | 2113636.9625 | 37.7839139091534 | -122.427197803426 | (37.7839139091534, -122.427197803426) | |||
| 18345 | 18345 | 16909 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 457 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2009 12:00:00 AM | 18 | 3X3 | 6004854.34153 | 2110178.37501 | 37.7744221674765 | -122.42666456674101 | (37.7744221674765, -122.426664566741) | ||
| 24380 | 24380 | 129424 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6003346.86179 | 2117886.37825 | 37.7955010594853 | -122.43242986946699 | (37.7955010594853, -122.432429869467) | |||
| 96001 | 96001 | 7147 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003730.753719999 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | |||
| 154095 | 154095 | 248214 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | |||
| 177184 | 177184 | 191261 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) | |||
| 60646 | 60646 | 191259 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 900x Carolina St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.39984551077299 | (37.7562963136528, -122.399845510773) | ||||
| 70657 | 70657 | 129393 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997126.155040001 | 2115061.06795 | 37.7873888086001 | -122.45375034092 | (37.7873888086001, -122.45375034092) | |||
| 133441 | 133441 | 227626 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1455 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6003318.57968 | 2099748.35087 | 37.7456968761174 | -122.43123241046601 | (37.7456968761174, -122.431232410466) | |||
| 176903 | 176903 | 129458 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.40206584156401 | (37.7972074996935, -122.402065841564) | |||
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 129683 | 129683 | 227642 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002972.163319999 | 2103558.74094 | 37.756139670625295 | -122.432702408096 | (37.7561396706253, -122.432702408096) | |||
| 28660 | 28660 | 142575 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2251 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.803978459247205 | -122.41333149055401 | (37.8039784592472, -122.413331490554) | |||
| 48721 | 48721 | 33958 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | ||
| 52761 | 52761 | 129417 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003236.15275 | 2117871.33798 | 37.795453484440706 | -122.432811866398 | (37.7954534844407, -122.432811866398) | |||
| 56287 | 56287 | 227611 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6008811.16325 | 2101739.4503099998 | 37.751473726132005 | -122.412380510571 | (37.751473726132, -122.412380510571) | |||
| 56561 | 56561 | 191262 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012676.19431 | 2104276.36771 | 37.7586556841436 | -122.399192740559 | (37.7586556841436, -122.399192740559) | |||
| 70158 | 70158 | 98192 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1020 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008091.62981 | 2118948.72517 | 37.7986859077751 | -122.41608738562799 | (37.7986859077751, -122.416087385628) | |||
| 152638 | 152638 | 129450 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1257 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 6ft | 6006338.43207 | 2120038.90392 | 37.8015805322681 | -122.42223151426799 | (37.8015805322681, -122.422231514268) | |||
| 187273 | 187273 | 176963 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 83 Badger St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.43391881851299 | (37.7306734890866, -122.433918818513) | |||
| 37486 | 37486 | 227656 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 148 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001371.492269999 | 2107387.94373 | 37.7665628167523 | -122.43851240444799 | (37.7665628167523, -122.438512404448) | |||
| 55800 | 55800 | 227661 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003680.16981 | 2096890.8857099998 | 37.7378714190205 | -122.42977831104099 | (37.7378714190205, -122.429778311041) | |||
| 74170 | 74170 | 129446 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | |||
| 136118 | 136118 | 250773 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 259 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | |||
| 171953 | 171953 | 207069 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.752349572298606 | -122.46451448116999 | (37.7523495722986, -122.46451448117) | |||
| 178008 | 178008 | 129422 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003322.87221 | 2117886.8736900003 | 37.7955010594859 | -122.432512912861 | (37.7955010594859, -122.432512912861) | |||
| 178509 | 178509 | 106106 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | ||||
| 182098 | 182098 | 227599 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3542 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005268.27661 | 2106072.0060799997 | 37.7631704570704 | -122.424940469222 | (37.7631704570704, -122.424940469222) | |||
| 184446 | 184446 | 142580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | |||
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 47633 | 47633 | 129418 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003255.2303 | 2117874.11084 | 37.795462179980895 | -122.432746053085 | (37.7954621799809, -122.432746053085) | |||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 59034 | 59034 | 129459 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 458 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011895.81451 | 2118092.21584 | 37.7965472956624 | -122.402863344166 | (37.7965472956624, -122.402863344166) | |||
| 131733 | 131733 | 191263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 728 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012693.0382199995 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | |||
| 150955 | 150955 | 142587 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2320 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008491.26 | 2120799.1265 | 37.8037891087643 | -122.414835562646 | (37.8037891087643, -122.414835562646) | |||
| 161451 | 161451 | 227601 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | ||||
| 69 | 69 | 19206 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.40169859442699 | (37.7962500076802, -122.401698594427) | |||
| 9146 | 9146 | 4532 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005027.0371 | 2113673.2533 | 37.784028006637996 | -122.42631605911998 | (37.784028006638, -122.42631605912) | |||
| 9193 | 9193 | 4549 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004652.295 | 2113623.5507 | 37.7838703460943 | -122.427608988739 | (37.7838703460943, -122.427608988739) | |||
| 9249 | 9249 | 4552 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.42727974188101 | (37.7839147367985, -122.427279741881) | |||
| 9257 | 9257 | 4531 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | |||
| 29861 | 29861 | 227623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001957.40527 | 2101134.69618 | 37.7494262207603 | -122.43603832812599 | (37.7494262207603, -122.436038328126) | |||
| 56261 | 56261 | 227645 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003027.84051 | 2103561.52563 | 37.7561504741859 | -122.432510056589 | (37.7561504741859, -122.432510056589) | |||
| 74636 | 74636 | 227650 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000006.33119 | 2104908.8667200003 | 37.759678136855996 | -122.443056184107 | (37.759678136856, -122.443056184107) | |||
| 97837 | 97837 | 4519 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2015 11:31:00 AM | 12 | 3x3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | ||
| 118583 | 118583 | 26205 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 750 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/20/2007 12:00:00 AM | 12 | 3X3 | 6005640.0872799 | 2098758.1364942 | 37.743109258996206 | -122.423134597972 | (37.7431092589962, -122.423134597972) | ||
| 119172 | 119172 | 4547 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 121552 | 121552 | 4543 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 122987 | 122987 | 4550 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | |||
| 136784 | 136784 | 129423 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003338.49011 | 2117887.74598 | 37.795504340202896 | -122.432458934629 | (37.7955043402029, -122.432458934629) | |||
| 159965 | 159965 | 176962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 121 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 5992069.06615 | 2087619.0428799998 | 37.71174887986621 | -122.46924855110301 | (37.7117488798662, -122.469248551103) | |||
| 162970 | 162970 | 246778 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 392 Franconia St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6009934.469769999 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | ||||
| 162971 | 162971 | 227657 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 117 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001570.048769999 | 2106180.8326 | 37.7632596788053 | -122.437739171852 | (37.7632596788053, -122.437739171852) | |||
| 176194 | 176194 | 187582 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 747 University St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6008739.08909 | 2090759.6184900003 | 37.7213214463175 | -122.41185395930799 | (37.7213214463175, -122.411853959308) | ||||
| 183006 | 183006 | 129410 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003271.2174 | 2116075.89812 | 37.7905256555748 | -122.43256222807301 | (37.7905256555748, -122.432562228073) | |||
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
| 38881 | 38881 | 129421 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447998999 | (37.795493917972, -122.43256447999) | |||
| 44629 | 44629 | 129403 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | |||
| 54469 | 54469 | 57397 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.41518604372601 | (37.7903739066804, -122.415186043726) | ||
| 55145 | 55145 | 129409 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003265.25593 | 2116107.39334 | 37.7906117953446 | -122.43258510502399 | (37.7906117953446, -122.432585105024) | |||
| 58140 | 58140 | 141665 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 MASONIC AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998794.5569 | 2112395.1526 | 37.7801644097761 | -122.44778604353901 | (37.7801644097761, -122.447786043539) | |||
| 76313 | 76313 | 227649 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.44308034798901 | (37.7597108865789, -122.443080347989) | |||
| 136250 | 136250 | 250532 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.787997784513294 | -122.486444423174 | (37.7879977845133, -122.486444423174) | |||
| 148228 | 148228 | 129462 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 584 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011873.80865 | 2117764.68671 | 37.7956467505394 | -122.402916441935 | (37.7956467505394, -122.402916441935) | |||
| 157086 | 157086 | 129399 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5996788.91292 | 2115340.40834 | 37.788136462672604 | -122.454937313809 | (37.7881364626726, -122.454937313809) | |||
| 161158 | 161158 | 129394 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5997109.1846199995 | 2115060.1871599997 | 37.7873854172521 | -122.45380899111099 | (37.7873854172521, -122.453808991111) | |||
| 171489 | 171489 | 176938 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 10 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012264.960419999 | 2087928.82829 | 37.7137458424772 | -122.39946729997101 | (37.7137458424772, -122.399467299971) | |||
| 172429 | 172429 | 176940 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 15 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012273.467119999 | 2087900.15525 | 37.7136675861685 | -122.399435885762 | (37.7136675861685, -122.399435885762) | |||
| 183467 | 183467 | 207095 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1565 Plymouth Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995634.15192 | 2094407.3594099998 | 37.730593351393296 | -122.457417521726 | (37.7305933513933, -122.457417521726) | |||
| 30187 | 30187 | 97675 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000810.80569 | 2117928.4487099997 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | ||||
| 33222 | 33222 | 207070 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.752311011160295 | -122.464510933358 | (37.7523110111603, -122.464510933358) | |||
| 37113 | 37113 | 176939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012245.82216 | 2087941.3179099998 | 37.7137790697309 | -122.399534325569 | (37.7137790697309, -122.399534325569) | |||
| 38136 | 38136 | 46819 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 366 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 10 | Permit Number 44897 | 6004049.020819999 | 2091179.47735 | 37.7222100502291 | -122.428096112963 | (37.7222100502291, -122.428096112963) | |
| 38876 | 38876 | 142250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | |||
| 42869 | 42869 | 129448 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008230.449580001 | 2115909.44994 | 37.79034861235171 | -122.415391745646 | (37.7903486123517, -122.415391745646) | |||
| 44196 | 44196 | 129400 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5996779.47393 | 2115339.45033 | 37.7881332907605 | -122.454969901653 | (37.7881332907605, -122.454969901653) | |||
| 69654 | 69654 | 227617 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) |
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");