Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 403 | 403 | 65940 | Planning Code 138.1 required 4 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.78332336932171 | -122.41797588370702 | (37.7833233693217, -122.417975883707) | |
| 404 | 404 | 249555 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.787898211588704 | -122.423418809148 | (37.7878982115887, -122.423418809148) | |
| 405 | 405 | 13887 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1028 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009423.7082400005 | 2112763.96692 | 37.781778865529105 | -122.411040866943 | (37.7817788655291, -122.411040866943) | |||
| 406 | 406 | 249556 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005884.0832400005 | 2115105.79396 | 37.7880098165527 | -122.423452863778 | (37.7880098165527, -122.423452863778) | |
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 408 | 408 | 23369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 6006387.07969 | 2115184.64805 | 37.788254707334 | -122.421718185767 | (37.788254707334, -122.421718185767) | |||
| 409 | 409 | 251278 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 01/27/2016 09:31:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 410 | 410 | 251287 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 411 | 411 | 154366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6006164.37856 | 2107202.76015 | 37.7663258166161 | -122.42192147568899 | (37.7663258166161, -122.421921475689) | |||
| 412 | 412 | 251290 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 413 | 413 | 249558 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005877.98213 | 2115146.79048 | 37.7881220384566 | -122.42347688825899 | (37.7881220384566, -122.423476888259) | |
| 414 | 414 | 17191 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1804X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6004806.1465 | 2115088.0891 | 37.7879003042654 | -122.427181073064 | (37.7879003042654, -122.427181073064) | |||
| 415 | 415 | 250074 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 416 | 416 | 192564 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 417 | 417 | 229177 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 789 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006284.79968 | 2105036.34994 | 37.7603841541343 | -122.42135109956699 | (37.7603841541343, -122.421351099567) | |||
| 418 | 418 | 23307 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.6232900005 | 2114014.0044299997 | 37.785049178209206 | -122.421096875635 | (37.7850491782092, -122.421096875635) | ||
| 419 | 419 | 13971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008925.3091 | 2112314.2981 | 37.780516220741 | -122.412733301341 | (37.780516220741, -122.412733301341) | |||
| 420 | 420 | 54426 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.758841631549394 | -122.400163199892 | (37.7588416315494, -122.400163199892) | |
| 421 | 421 | 236222 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006212.30332 | 2105198.62923 | 37.7608256474983 | -122.42161335716801 | (37.7608256474983, -122.421613357168) | |||
| 422 | 422 | 23174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 5 | 3x3 | 6006908.21847 | 2111432.04348 | 37.777980343250796 | -122.419648771078 | (37.7779803432508, -122.419648771078) | |||
| 423 | 423 | 109554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006839.87541 | 2111919.81075 | 37.7793157843461 | -122.41991981597201 | (37.7793157843461, -122.419919815972) | |||
| 424 | 424 | 122666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 426 | 426 | 21683 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 2x2 | 6003770.0848 | 2114594.6383 | 37.786486768354294 | -122.430730428794 | (37.7864867683543, -122.430730428794) | ||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 428 | 428 | 14314 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6003589.1349 | 2107204.4091 | 37.766184772649495 | -122.430828874247 | (37.7661847726495, -122.430828874247) | |||
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 430 | 430 | 103824 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.6460599997 | 37.786183288961205 | -122.419709589538 | (37.7861832889612, -122.419709589538) | ||
| 431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 434 | 434 | 136390 | Undocumented 2 | Tree(s) :: 17 | 3395 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779746 | 5998765.27001 | 2115243.09553 | 37.787982442971604 | -122.448092477507 | (37.7879824429716, -122.448092477507) | |
| 435 | 435 | 95185 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001223.4102 | 2113260.1588 | 37.78267801898829 | -122.43944557401699 | (37.7826780189883, -122.439445574017) | |||
| 436 | 436 | 6932 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004980.8762 | 2110598.20876 | 37.775582081585895 | -122.42625675563801 | (37.7755820815859, -122.426256755638) | |||
| 437 | 437 | 20292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 438 | 438 | 157409 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 3x5 | 6005572.56549 | 2096690.1102099998 | 37.7374271143738 | -122.423221099494 | (37.7374271143738, -122.423221099494) | ||
| 439 | 439 | 136984 | Undocumented 2 | Tree(s) :: 17 | 454 Walnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779785 | 5998641.89853 | 2115102.68231 | 37.7875898520492 | -122.448509202661 | (37.7875898520492, -122.448509202661) | |
| 440 | 440 | 157410 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 2x5 | 6005546.67522 | 2096690.9332 | 37.7374279129674 | -122.423310672857 | (37.7374279129674, -122.423310672857) | ||
| 441 | 441 | 251295 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 220 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 3x3 | Permit Number 27117 | 5982087.0 | 2112698.0 | 37.7800268469822 | -122.50560657808902 | (37.7800268469822, -122.505606578089) | ||
| 442 | 442 | 9602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003083.4108 | 2112017.0963 | 37.779370559175206 | -122.432921935155 | (37.7793705591752, -122.432921935155) | |||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 445 | 445 | 251285 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1299x Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 447 | 447 | 27524 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999021.2149 | 2114925.4479 | 37.787124893549795 | -122.447184087894 | (37.7871248935498, -122.447184087894) | |||
| 448 | 448 | 224849 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 779889 | 6003244.1353400005 | 2095137.54828 | 37.733032453088704 | -122.431160782146 | (37.7330324530887, -122.431160782146) | ||
| 449 | 449 | 200971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | ||
| 450 | 450 | 142159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 490X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 451 | 451 | 192346 | Planning Code 138.1 required 4 | Fraxinus spp :: Ash Spp 83 | 118 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.5452799997 | 37.7750719195804 | -122.41581539288201 | (37.7750719195804, -122.415815392882) | |
| 452 | 452 | 221749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 24 | Width 4ft | 5997432.91763 | 2106413.5715 | 37.763662611962 | -122.452064861225 | (37.763662611962, -122.452064861225) | |||
| 453 | 453 | 200966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.776035520315205 | -122.418324330264 | (37.7760355203152, -122.418324330264) | ||
| 454 | 454 | 251309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2111 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | ||||
| 455 | 455 | 234501 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2423 Market St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 8ft | 6002117.5892 | 2105782.84009 | 37.7621980066439 | -122.435816935712 | (37.7621980066439, -122.435816935712) | |||
| 456 | 456 | 23112 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.396269999 | 2101132.22455 | 37.74967287242389 | -122.42054965793899 | (37.7496728724239, -122.420549657939) | |
| 457 | 457 | 142162 | Undocumented 2 | Prunus spp :: Cherry 84 | 490X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 458 | 458 | 221750 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 11 | Width 4ft | 5997409.41415 | 2106414.31665 | 37.7636633116224 | -122.45214620578699 | (37.7636633116224, -122.452146205787) | |||
| 459 | 459 | 35612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768882 | 6000549.03074 | 2116799.12347 | 37.792356695946005 | -122.442032735847 | (37.792356695946, -122.442032735847) | |
| 460 | 460 | 142327 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 461 | 461 | 98533 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x6 | Permit Number 779899 | 5999986.39066 | 2115181.83206 | 37.787883958235504 | -122.44386322941901 | (37.7878839582355, -122.443863229419) | ||
| 462 | 462 | 187628 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779889 | 6003236.0 | 2095183.0 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | |||
| 463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 465 | 465 | 200701 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1433 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 1 | Width 0ft | 6014951.6841 | 2095311.6378 | 37.7341669595219 | -122.390696529464 | (37.7341669595219, -122.390696529464) | ||
| 466 | 466 | 1665 | DPW Maintained 3 | Tristania conferta :: 79 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.44202322778901 | (37.7735783473195, -122.442023227789) | ||
| 467 | 467 | 85277 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 801 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49566 | ||||||||
| 468 | 468 | 18829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.42495419379601 | (37.791048376629, -122.424954193796) | |||
| 469 | 469 | 85530 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.5044400003 | 37.772288880253704 | -122.418030010287 | (37.7722888802537, -122.418030010287) | |||
| 470 | 470 | 98535 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | Permit Number 779899 | 5999990.232999999 | 2115142.7171 | 37.7877767779168 | -122.44384712433799 | (37.7877767779168, -122.443847124338) | ||
| 471 | 471 | 10470 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1614 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2015 08:11:00 AM | 3 | 3x3 | 5998358.4613 | 2108632.1531 | 37.76980724742621 | -122.449023538308 | (37.7698072474262, -122.449023538308) | ||
| 472 | 472 | 236059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004719.95486 | 2107769.51353 | 37.7678004187701 | -122.42695783742799 | (37.7678004187701, -122.426957837428) | |||
| 473 | 473 | 142160 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 475 | 475 | 6052 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2003 12:00:00 AM | 3 | 3X3 | 6001270.4508 | 2112511.2313 | 37.7806243318768 | -122.439229137442 | (37.7806243318768, -122.439229137442) | ||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 478 | 478 | 142161 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 490X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 480 | 480 | 200973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1416 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 482 | 482 | 142326 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1652 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 483 | 483 | 236058 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004683.7857099995 | 2107762.8709299997 | 37.767780134560205 | -122.427082469082 | (37.7677801345602, -122.427082469082) | |||
| 484 | 484 | 205880 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 5993348.04769 | 2101170.42115 | 37.7490314462559 | -122.46581205990499 | (37.7490314462559, -122.465812059905) | |||
| 485 | 485 | 142163 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490X Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 486 | 486 | 98534 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 779899 | 5999986.755609999 | 2115164.0145 | 37.787835056676705 | -122.443860686142 | (37.7878350566767, -122.443860686142) | ||
| 487 | 487 | 85532 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007270.64018 | 2109417.23244 | 37.7724685621036 | -122.418252136526 | (37.7724685621036, -122.418252136526) | |||
| 488 | 488 | 2821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008831.67633 | 2116355.92064 | 37.7916082855564 | -122.41334312239701 | (37.7916082855564, -122.413343122397) | |||
| 489 | 489 | 200974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1422 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 490 | 490 | 85529 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | ||
| 491 | 491 | 236057 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004642.9908 | 2107763.18347 | 37.767778685763 | -122.427223596101 | (37.767778685763, -122.427223596101) | |||
| 492 | 492 | 173939 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341.0 | 2104455.0 | 37.7592388085315 | -122.39344754111201 | (37.7592388085315, -122.393447541112) | |
| 493 | 493 | 14089 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 498 | 498 | 248943 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 01:08:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 499 | 499 | 248944 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 12:58:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 500 | 500 | 6742 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.500630001 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | ||
| 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 |
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");