Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes
PlantType ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
3436 | 3436 | 100973 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 0 | Permit Number 37341 | 6009614.0 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | ||
4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
8197 | 8197 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
8408 | 8408 | 103664 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
8431 | 8431 | 97593 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001569.9782 | 2110730.4395 | 37.7757517668907 | -122.438065332169 | (37.7757517668907, -122.438065332169) | |||
10665 | 10665 | 103665 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
11415 | 11415 | 103667 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
12885 | 12885 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
15949 | 15949 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
28296 | 28296 | 33101 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11/01/1997 12:00:00 AM | 14 | Permit Number 37341 | 6009682.3141 | 2120901.0273 | 37.804135754366996 | -122.410721035819 | (37.804135754367, -122.410721035819) | |
40243 | 40243 | 100970 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | Permit Number 37341 | 6009657.9659 | 2120896.9693 | 37.804123246932896 | -122.41080500812201 | (37.8041232469329, -122.410805008122) | ||
47263 | 47263 | 100971 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Permit Number 37341 | 6009642.5454 | 2120895.3461 | 37.8041179253888 | -122.410858257388 | (37.8041179253888, -122.410858257388) | ||
55605 | 55605 | 100978 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009524.0508 | 2120877.4907 | 37.8040622540071 | -122.41126705605801 | (37.8040622540071, -122.411267056058) | ||
57285 | 57285 | 100977 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | ||
59125 | 59125 | 100975 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | Permit Number 37341 | 6009580.8633 | 2120886.4184 | 37.8040899533369 | -122.411071082632 | (37.8040899533369, -122.411071082632) | ||
61687 | 61687 | 97564 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 252 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001879.6 | 2109184.5 | 37.7715246060424 | -122.43688357823 | (37.7715246060424, -122.43688357823) | |||
64540 | 64540 | 100974 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 15 | Permit Number 37341 | 6009596.2838 | 2120888.8532 | 37.8040975034287 | -122.41101789076099 | (37.8040975034287, -122.411017890761) | ||
77875 | 77875 | 106884 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 6 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
80527 | 80527 | 97588 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 327 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001736.6 | 2109522.6 | 37.7724448159613 | -122.437402436672 | (37.7724448159613, -122.437402436672) | |||
81591 | 81591 | 95239 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | |||
85658 | 85658 | 96467 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
88343 | 88343 | 97566 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 338 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001793.0 | 2109569.0 | 37.7725754250276 | -122.437210666805 | (37.7725754250276, -122.437210666805) | |||
89325 | 89325 | 96464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
94262 | 94262 | 106880 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 3 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 5 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
94772 | 94772 | 98675 | Permitted Site 1 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
100514 | 100514 | 97565 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 258 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001879.6 | 2109184.5 | 37.7715246060424 | -122.43688357823 | (37.7715246060424, -122.43688357823) | |||
103701 | 103701 | 96466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
104559 | 104559 | 114737 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
108200 | 108200 | 97586 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 285 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001769.0 | 2109329.0 | 37.771915080469 | -122.437276497302 | (37.771915080469, -122.437276497302) | |||
108228 | 108228 | 106878 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 180X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 26 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
109915 | 109915 | 109999 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501X Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | ||||
113485 | 113485 | 97567 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 342 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001791.0 | 2109583.0 | 37.772613751849605 | -122.43721858759199 | (37.7726137518496, -122.437218587592) | |||
114247 | 114247 | 106879 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 180X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 6 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
115707 | 115707 | 96469 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
116328 | 116328 | 5157 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 270 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 6001849.8958745 | 2109240.8779841997 | 37.7716777176824 | -122.43699036314301 | (37.7716777176824, -122.436990363143) | |||
118803 | 118803 | 97587 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 319 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001745.0 | 2109492.0 | 37.772361273527004 | -122.437371188758 | (37.772361273527, -122.437371188758) | |||
119651 | 119651 | 97570 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 546 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001754.3 | 2110345.0 | 37.7747039272721 | -122.437400111383 | (37.7747039272721, -122.437400111383) | |||
119702 | 119702 | 111096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 15 | 5992079.0 | 2088073.0 | 37.712995910736204 | -122.46924723728901 | (37.7129959107362, -122.469247237289) | |||
120725 | 120725 | 96465 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
124890 | 124890 | 96470 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
125523 | 125523 | 106883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 4 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
128369 | 128369 | 109998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | ||||
144888 | 144888 | 96468 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
145311 | 145311 | 100972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 03/24/2016 07:43:00 AM | 3 | Permit Number 37341 | 6009614.0 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | |
145991 | 145991 | 97568 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 500 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001703.0 | 2110108.0 | 37.7740502679918 | -122.437560592174 | (37.7740502679918, -122.437560592174) | |||
147766 | 147766 | 100979 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | Permit Number 37341 | 6009507.0071 | 2120874.2443 | 37.8040523843138 | -122.411325807727 | (37.8040523843138, -122.411325807727) | ||
177834 | 177834 | 100976 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | ||
80719 | 80719 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | DPW 4 | 30 | 10X10 | 5991377.0 | 2094742.0 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | ||
87276 | 87276 | 112509 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW 4 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | |||
94993 | 94993 | 112510 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW 4 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | |||
120473 | 120473 | 112511 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW 4 | 08/08/2015 03:37:00 PM | 3 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | |
95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
657 | 657 | 5214 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 835 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/09/2001 12:00:00 AM | 3 | 3X3 | 6001489.0793 | 2111327.2763 | 37.7773859294292 | -122.438387950593 | (37.7773859294292, -122.438387950593) | |
1065 | 1065 | 24631 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 601 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/03/2013 12:00:00 AM | 3 | 3X3 | 6001596.3507 | 2110541.037 | 37.775233214934104 | -122.43796053363701 | (37.7752332149341, -122.437960533637) | |
2484 | 2484 | 5197 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 631 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 3X3 | 6001585.1623 | 2110622.5519999997 | 37.7754563984119 | -122.438005076955 | (37.7754563984119, -122.438005076955) | |
2929 | 2929 | 28092 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 528 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/12/2001 12:00:00 AM | 3 | 3X3 | 6001704.4418 | 2110256.1887 | 37.774457239071104 | -122.43756621922199 | (37.7744572390711, -122.437566219222) | |
3798 | 3798 | 5199 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 643 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001573.1748 | 2110709.1284 | 37.7756934337528 | -122.43805274745701 | (37.7756934337528, -122.438052747457) | |
5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
6000 | 6000 | 28097 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001567.17 | 2110752.9686 | 37.7758134664372 | -122.438076660597 | (37.7758134664372, -122.438076660597) | ||
6072 | 6072 | 24616 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001554.3804 | 2111297.3519 | 37.777307478654706 | -122.438159908991 | (37.7773074786547, -122.438159908991) | |
6760 | 6760 | 24628 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 536 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001694.2572 | 2110311.9357 | 37.774609727324204 | -122.437605442785 | (37.7746097273242, -122.437605442785) | |
7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
17669 | 17669 | 5170 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 318 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6001801.5136 | 2109559.6859 | 37.7725503347821 | -122.43718055043101 | (37.7725503347821, -122.437180550431) | |
18219 | 18219 | 5158 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 275 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001773.6501 | 2109268.6052 | 37.771749515715605 | -122.437256087151 | (37.7717495157156, -122.437256087151) | |
18577 | 18577 | 5154 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001780.9624 | 2109220.4101 | 37.771617599631604 | -122.43722734206499 | (37.7716175996316, -122.437227342065) | ||
20046 | 20046 | 5155 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 265 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001777.3063 | 2109242.3472 | 37.7716776256193 | -122.43724155970399 | (37.7716776256193, -122.437241559704) | |
22149 | 22149 | 16024 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 776129 | 6001188.36813 | 2094689.80455 | 37.731686341545206 | -122.43823603107799 | (37.7316863415452, -122.438236031078) |
82894 | 82894 | 24632 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 605 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/08/2014 11:30:00 AM | 3 | 3X3 | 6001606.913089 | 2110457.4002288003 | 37.7750041699802 | -122.437918004082 | (37.7750041699802, -122.437918004082) | |
83032 | 83032 | 28101 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 305 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001749.0605888 | 2109439.6370142 | 37.7722177286516 | -122.437353392664 | (37.7722177286516, -122.437353392664) | ||
84168 | 84168 | 28096 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 850 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001561.6093482 | 2111313.2017111 | 37.77735140937129 | -122.43813603744499 | (37.7773514093713, -122.438136037445) | ||
104363 | 104363 | 24644 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 845 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001484.9123945 | 2111282.0018462 | 37.7772613801811 | -122.43839912079099 | (37.7772613801811, -122.438399120791) | |
108016 | 108016 | 28093 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 508 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001722.1241568 | 2110151.9438084 | 37.7741720139963 | -122.43749758605 | (37.7741720139963, -122.43749758605) | ||
120836 | 120836 | 24637 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 425 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/25/2011 12:00:00 AM | 3 | 3X3 | 6001690.3813095 | 2109822.1283023 | 37.773264618286 | -122.437583765683 | (37.773264618286, -122.437583765683) | |
8085 | 8085 | 5202 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X4 | 6001595.2588 | 2111007.3853 | 37.7765136281427 | -122.437997722367 | (37.7765136281427, -122.437997722367) | |
22018 | 22018 | 24636 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 443 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/17/2014 12:00:00 AM | 3 | 3X4 | 6001673.68932 | 2109984.60324 | 37.773709784823296 | -122.437653143592 | (37.7737097848233, -122.437653143592) | |
144879 | 144879 | 24627 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 444 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/06/2006 12:00:00 AM | 3 | 3X4 | 6001753.1685929 | 2109931.6605583 | 37.7735689361616 | -122.43737442109699 | (37.7735689361616, -122.437374421097) | |
621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
985 | 985 | 97601 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 855 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001476.9066 | 2111398.2834 | 37.7775802046297 | -122.43843514847099 | (37.7775802046297, -122.438435148471) | ||
1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
3158 | 3158 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | DPW 4 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | |
4425 | 4425 | 97577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001652.1221 | 2110620.3263 | 37.775454094869296 | -122.43777328811301 | (37.7754540948693, -122.437773288113) | ||
5125 | 5125 | 97583 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 748 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001590.7259 | 2111040.5 | 37.776604295001 | -122.438015775508 | (37.776604295001, -122.438015775508) | ||
5209 | 5209 | 169218 | Permitted Site 1 | Potential Site :: Potential Site 29 | 824 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006905.3054599995 | 2113639.6299099997 | 37.7840416758297 | -122.419815533287 | (37.7840416758297, -122.419815533287) | ||
5210 | 5210 | 83637 | Permitted Site 1 | Tree(s) :: 17 | 840 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/19/2005 12:00:00 AM | 3x3 | 6006834.966315799 | 2113631.30048912 | 37.784014842491395 | -122.420058290383 | (37.7840148424914, -122.420058290383) | ||
5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5217 | 5217 | 169168 | Permitted Site 1 | Potential Site :: Potential Site 29 | 701 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6007051.56678 | 2113380.55802 | 37.7833385660552 | -122.41929113679599 | (37.7833385660552, -122.419291136796) | ||
5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) |
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");