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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 15308 | 15308 | 3663 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 99 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/12/1990 12:00:00 AM | 3 | 3X3 | 6017184.0839 | 2098879.2573700002 | 37.744086528482 | -122.383226584333 | (37.744086528482, -122.383226584333) | ||
| 22316 | 22316 | 3655 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 91 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017319.27606 | 2098771.24223 | 37.743797410827796 | -122.382751600221 | (37.7437974108278, -122.382751600221) | |||
| 22331 | 22331 | 3651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6017363.3819699995 | 2098733.24342 | 37.7436955104472 | -122.38259644736601 | (37.7436955104472, -122.382596447366) | ||
| 16783 | 16783 | 3649 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 85 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017394.85513 | 2098704.5539599997 | 37.7436184736271 | -122.382485623916 | (37.7436184736271, -122.382485623916) | ||
| 22350 | 22350 | 3645 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.38226603915399 | (37.7434680683118, -122.382266039154) | ||
| 22327 | 22327 | 3638 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | |||
| 5011 | 5011 | 3549 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:34:00 AM | 3 | 3X3 | 6018691.67406 | 2097603.0587400002 | 37.740665537995895 | -122.377925053006 | (37.7406655379959, -122.377925053006) | ||
| 22346 | 22346 | 3622 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017832.2114699995 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | |||
| 29263 | 29263 | 208368 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 58 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991246.556369999 | 2092406.78265 | 37.7248472743708 | -122.472440157794 | (37.7248472743708, -122.472440157794) | |||
| 73153 | 73153 | 208367 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 56 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991247.57131 | 2092431.18566 | 37.724914337716 | -122.472438427518 | (37.724914337716, -122.472438427518) | |||
| 4988 | 4988 | 3545 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:40:00 AM | 3 | 3X3 | 6018602.9683 | 2097669.9697 | 37.740844373569004 | -122.37823641090799 | (37.740844373569, -122.378236410908) | ||
| 189101 | 189101 | 208366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 54 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991248.72719 | 2092445.9094099998 | 37.7249548323756 | -122.472435504713 | (37.7249548323756, -122.472435504713) | |||
| 5030 | 5030 | 3541 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:57:00 AM | 3 | 3X3 | 6018523.03476 | 2097728.36014 | 37.7410002962211 | -122.378516847395 | (37.7410002962211, -122.378516847395) | ||
| 5066 | 5066 | 3614 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.742354807434396 | -122.380409304248 | (37.7423548074344, -122.380409304248) | |||
| 59430 | 59430 | 201075 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900x Carolina St | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012500.47255 | 2103002.7121099997 | 37.755148710357396 | -122.39971104145599 | (37.7551487103574, -122.399711041456) | ||||
| 4974 | 4974 | 3537 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 10:33:00 AM | 3 | 3X3 | 6018452.88971 | 2097781.22053 | 37.7411415734369 | -122.37876305568899 | (37.7411415734369, -122.378763055689) | ||
| 163890 | 163890 | 191591 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 47 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6015033.44151 | 2097696.15122 | 37.7407188812811 | -122.390580433358 | (37.7407188812811, -122.390580433358) | |||
| 35026 | 35026 | 191590 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 45 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6015086.460390001 | 2097766.6801 | 37.7409154802589 | -122.39040203933 | (37.7409154802589, -122.39040203933) | |||
| 22330 | 22330 | 3607 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6018106.23722 | 2098142.91565 | 37.742115598557895 | -122.37998679465001 | (37.7421155985579, -122.37998679465) | |||
| 56300 | 56300 | 202486 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6015605.55295 | 2114216.90424 | 37.7861130240416 | -122.389755908832 | (37.7861130240416, -122.389755908832) | |||
| 5031 | 5031 | 3531 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018350.91064 | 2097856.90864 | 37.741343775188 | -122.379120922001 | (37.741343775188, -122.379120922001) | ||
| 29990 | 29990 | 202485 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6015591.97779 | 2114203.68942 | 37.7860759863606 | -122.389801952302 | (37.7860759863606, -122.389801952302) | |||
| 137440 | 137440 | 202484 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015612.96577 | 2114183.86007 | 37.7860227033174 | -122.38972795339399 | (37.7860227033174, -122.389727953394) | |||
| 149774 | 149774 | 208365 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Junipero Serra Blvd | 40 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991343.18171 | 2093534.72216 | 37.727949907536605 | -122.472188319753 | (37.7279499075366, -122.472188319753) | |||
| 49261 | 49261 | 202483 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6015577.75199 | 2114193.56391 | 37.786047395123 | -122.38985046265199 | (37.786047395123, -122.389850462652) | |||
| 184758 | 184758 | 228983 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6003399.166619999 | 2095595.2622599998 | 37.734298015935295 | -122.430657448703 | (37.7342980159353, -122.430657448703) | ||||
| 48 | 48 | 3528 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2017 04:23:00 PM | 3 | 3X3 | 6018298.55272 | 2097894.94115 | 37.7414453176516 | -122.37930460042801 | (37.7414453176516, -122.379304600428) | ||
| 49721 | 49721 | 228982 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6003411.177 | 2095606.2844200002 | 37.734328960702896 | -122.43061671121299 | (37.7343289607029, -122.430616711213) | ||||
| 158440 | 158440 | 202482 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6015595.0476400005 | 2114167.41934 | 37.7859765671981 | -122.38978879703899 | (37.7859765671981, -122.389788797039) | |||
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 41377 | 41377 | 228981 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6003423.97246 | 2095615.4048 | 37.73435472807571 | -122.430573123757 | (37.7343547280757, -122.430573123757) | ||||
| 98774 | 98774 | 3527 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 138214 | 138214 | 191589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 37 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6015171.71316 | 2097880.19375 | 37.7412318941435 | -122.390115192457 | (37.7412318941435, -122.390115192457) | |||
| 187839 | 187839 | 202481 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6015568.22944 | 2114180.97701 | 37.7860123062744 | -122.389882528859 | (37.7860123062744, -122.389882528859) | |||
| 25362 | 25362 | 202480 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015580.99244 | 2114153.97742 | 37.7859388793178 | -122.38983648536001 | (37.7859388793178, -122.38983648536) | |||
| 67867 | 67867 | 191588 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 36 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015182.9315599995 | 2097895.4139799997 | 37.7412743079666 | -122.3900774659 | (37.7412743079666, -122.3900774659) | |||
| 163635 | 163635 | 250611 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998832.7511599995 | 2111418.50425 | 37.7774849687826 | -122.447583589827 | (37.7774849687826, -122.447583589827) | ||||
| 188686 | 188686 | 228980 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6003436.04165 | 2095624.2228 | 37.7343796240226 | -122.430532025653 | (37.7343796240226, -122.430532025653) | ||||
| 16844 | 16844 | 3525 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018249.90262 | 2097930.34785 | 37.7415398543705 | -122.379475276478 | (37.7415398543705, -122.379475276478) | ||
| 31539 | 31539 | 250610 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998818.59622 | 2111415.77935 | 37.777476677952706 | -122.44763236005899 | (37.7774766779527, -122.447632360059) | ||||
| 69980 | 69980 | 191561 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 35 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015295.46676 | 2098743.9280000003 | 37.7436103932138 | -122.389747607174 | (37.7436103932138, -122.389747607174) | |||
| 149431 | 149431 | 202479 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015568.58129 | 2114139.55574 | 37.7858985923926 | -122.38987841716299 | (37.7858985923926, -122.389878417163) | |||
| 168731 | 168731 | 191587 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 35 | : 4 | Tree 1 | Private 1 | 13 | Width 2ft | 6015188.55124 | 2097905.48754 | 37.7413022795673 | -122.390058738419 | (37.7413022795673, -122.390058738419) | |||
| 43065 | 43065 | 191586 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 34 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015199.63566 | 2097918.1836200003 | 37.741337755145395 | -122.390021298767 | (37.7413377551454, -122.390021298767) | |||
| 152421 | 152421 | 202478 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015550.71566 | 2114125.71718 | 37.7858596040738 | -122.389939260812 | (37.7858596040738, -122.389939260812) | |||
| 156897 | 156897 | 201171 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 34 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015282.61602 | 2098753.2960599996 | 37.743635403348996 | -122.389792696471 | (37.743635403349, -122.389792696471) | |||
| 185930 | 185930 | 250609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998802.7301 | 2111413.8391299997 | 37.7774704438335 | -122.447687106294 | (37.7774704438335, -122.447687106294) | ||||
| 4931 | 4931 | 3597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018273.82586 | 2098018.1543799997 | 37.7417822729228 | -122.37939865514299 | (37.7417822729228, -122.379398655143) | ||
| 30877 | 30877 | 208324 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 500x Junipero Serra Blvd | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991437.25771 | 2094134.10925 | 37.729601118599206 | -122.471906766296 | (37.7296011185992, -122.471906766296) | |||
| 62036 | 62036 | 191585 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 33 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6015208.13272 | 2097929.24715 | 37.7413686045706 | -122.38999269132799 | (37.7413686045706, -122.389992691328) | |||
| 63587 | 63587 | 201170 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 33 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015271.48555 | 2098760.70975 | 37.74365514256971 | -122.389831700987 | (37.7436551425697, -122.389831700987) | |||
| 166559 | 166559 | 250608 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998787.15443 | 2111411.5145799997 | 37.777463171018205 | -122.447740820088 | (37.7774631710182, -122.447740820088) | ||||
| 182334 | 182334 | 202477 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015533.73334 | 2114108.54783 | 37.7858115191191 | -122.389996815608 | (37.7858115191191, -122.389996815608) | |||
| 4978 | 4978 | 3596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:07:00 PM | 3 | 3X3 | 6018288.66955 | 2098007.43076 | 37.7417536466133 | -122.379346585295 | (37.7417536466133, -122.379346585295) | ||
| 14447 | 14447 | 3522 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018199.47638 | 2097970.41074 | 37.7416470778412 | -122.37965241772699 | (37.7416470778412, -122.379652417727) | ||
| 61008 | 61008 | 208224 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 5992451.143569999 | 2096889.8321099998 | 37.737226259776705 | -122.468602117489 | (37.7372262597767, -122.468602117489) | |||
| 136663 | 136663 | 191584 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 32 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015217.63759 | 2097940.53991 | 37.741400139299294 | -122.389960615188 | (37.7414001392993, -122.389960615188) | |||
| 159342 | 159342 | 202476 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015520.41468 | 2114096.2744299998 | 37.785777080493204 | -122.390042037134 | (37.7857770804932, -122.390042037134) | |||
| 169943 | 169943 | 250607 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998769.74892 | 2111409.2448299997 | 37.7774559440593 | -122.447800867812 | (37.7774559440593, -122.447800867812) | ||||
| 24913 | 24913 | 191583 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 31 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6015226.42584 | 2097953.59483 | 37.741436472805 | -122.389931139928 | (37.741436472805, -122.389931139928) | |||
| 38729 | 38729 | 208223 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992435.89911 | 2096873.99402 | 37.7371818917371 | -122.468653672024 | (37.7371818917371, -122.468653672024) | |||
| 39474 | 39474 | 201169 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 31 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6015248.38904 | 2098778.84927 | 37.743703669084 | -122.38991283062 | (37.743703669084, -122.38991283062) | |||
| 156557 | 156557 | 202475 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015507.02911 | 2114080.68877 | 37.7857335434255 | -122.390087258636 | (37.7857335434255, -122.390087258636) | |||
| 186988 | 186988 | 250606 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998755.1093 | 2111407.10323 | 37.777449227027795 | -122.447851356665 | (37.7774492270278, -122.447851356665) | ||||
| 28240 | 28240 | 201168 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 30 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015234.89257 | 2098788.2579099997 | 37.7437287547683 | -122.38996015566099 | (37.7437287547683, -122.389960155661) | |||
| 130807 | 130807 | 208222 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992415.0111 | 2096860.89526 | 37.737144719158394 | -122.46872493790899 | (37.7371447191584, -122.468724937909) | |||
| 137684 | 137684 | 191582 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 30 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6015236.45689 | 2097966.12518 | 37.741471434864394 | -122.38989733079599 | (37.7414714348644, -122.389897330796) | |||
| 147582 | 147582 | 202474 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015493.02664 | 2114069.8490299997 | 37.78570300334229 | -122.390134946073 | (37.7857030033423, -122.390134946073) | |||
| 150069 | 150069 | 228925 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Florida St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009149.255919999 | 2106933.11235 | 37.765753310882104 | -122.411578252344 | (37.7657533108821, -122.411578252344) | |||
| 152639 | 152639 | 250605 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998735.90805 | 2111405.0281 | 37.777442431746 | -122.44791763041401 | (37.777442431746, -122.447917630414) | ||||
| 16155 | 16155 | 19897 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 STAIRWAY33 | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 29147 | 29147 | 191581 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 29 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6015243.91638 | 2097975.462 | 37.741497485528896 | -122.389872190262 | (37.7414974855289, -122.389872190262) | |||
| 43743 | 43743 | 208221 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992396.177080001 | 2096841.2023200002 | 37.7370895592414 | -122.468788622512 | (37.7370895592414, -122.468788622512) | |||
| 128887 | 128887 | 22144 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3795X 03rd St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6015845.491830001 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | ||
| 131197 | 131197 | 192703 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017168.52543 | 2095602.6308900001 | 37.7350887115578 | -122.383052378458 | (37.7350887115578, -122.383052378458) | |||
| 147798 | 147798 | 202473 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6015456.8379 | 2114031.29549 | 37.7855951368532 | -122.390257455324 | (37.7855951368532, -122.390257455324) | |||
| 149775 | 149775 | 250604 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998717.2926900005 | 2111402.6365099996 | 37.7774348009994 | -122.44798185458099 | (37.7774348009994, -122.447981854581) | ||||
| 152234 | 152234 | 201167 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 29 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6015223.45555 | 2098795.37813 | 37.7437476711241 | -122.390000199761 | (37.7437476711241, -122.390000199761) | |||
| 5065 | 5065 | 3592 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018357.04475 | 2097955.64275 | 37.741615217581796 | -122.379106567936 | (37.7416152175818, -122.379106567936) | ||
| 14223 | 14223 | 19896 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 STAIRWAY33 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 60994 | 60994 | 192702 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017169.66256 | 2095613.0705099998 | 37.7351174395099 | -122.383049173305 | (37.7351174395099, -122.383049173305) | |||
| 64565 | 64565 | 191580 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 28 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015252.40332 | 2097986.0262700003 | 37.741526963490706 | -122.389843582826 | (37.7415269634907, -122.389843582826) | |||
| 93491 | 93491 | 47647 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Anza St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 136101 | 136101 | 200463 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6015004.67935 | 2103032.93993 | 37.7553709885956 | -122.39105280405899 | (37.7553709885956, -122.391052804059) | |||
| 164454 | 164454 | 250603 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998697.83635 | 2111399.4102 | 37.7774248302192 | -122.448048927835 | (37.7774248302192, -122.448048927835) | ||||
| 165747 | 165747 | 201113 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3601 03rd St | 28 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016070.43631 | 2099104.0370400003 | 37.744642122429205 | -122.387093039618 | (37.7446421224292, -122.387093039618) | |||
| 179825 | 179825 | 208220 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992380.47609 | 2096824.50033 | 37.737042792691895 | -122.46884169241001 | (37.7370427926919, -122.46884169241) | |||
| 3964 | 3964 | 253117 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:31:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 45361 | 45361 | 250602 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998679.25957 | 2111396.77415 | 37.7774165303825 | -122.448113000908 | (37.7774165303825, -122.448113000908) | ||||
| 57183 | 57183 | 208219 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5992363.48731 | 2096809.1359 | 37.7369996243189 | -122.46889931197501 | (37.7369996243189, -122.468899311975) | |||
| 65998 | 65998 | 202431 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 120 Brannan St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015604.80646 | 2113392.7297099996 | 37.7838499862168 | -122.38970090628 | (37.7838499862168, -122.38970090628) | |||
| 80744 | 80744 | 47646 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Anza St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 147159 | 147159 | 200462 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6015004.144730001 | 2103052.19137 | 37.7554238192792 | -122.391055998461 | (37.7554238192792, -122.391055998461) | |||
| 154586 | 154586 | 192701 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017190.43176 | 2095600.95922 | 37.7350853319278 | -122.38297652335699 | (37.7350853319278, -122.382976523357) | |||
| 161144 | 161144 | 191579 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 27 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015259.1451 | 2097995.49976 | 37.7415533496106 | -122.389820933416 | (37.7415533496106, -122.389820933416) | |||
| 5044 | 5044 | 3721 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 401X Cargo Way | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:35:00 AM | 3 | 3X3 | 6016902.32221 | 2098985.73936 | 37.7443633317003 | -122.384208277087 | (37.7443633317003, -122.384208277087) | ||
| 9056 | 9056 | 3823 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628003 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | ||
| 34389 | 34389 | 191578 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 26 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015266.28931 | 2098006.8821400004 | 37.741584999461104 | -122.38979702581301 | (37.7415849994611, -122.389797025813) |
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");