Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | 21823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2741 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 4x4 | 6008229.33947 | 2122327.41953 | 37.8079706947476 | -122.415850241604 | (37.8079706947476, -122.415850241604) | ||
106 | 106 | 10645 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.775849351151706 | -122.431543829861 | (37.7758493511517, -122.431543829861) | |||
110 | 110 | 97646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988290.0 | 2103126.0 | 37.7541078738982 | -122.48344595561899 | (37.7541078738982, -122.483445955619) | |||
132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
138 | 138 | 72565 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/16/1996 12:00:00 AM | 3 | 4x4 | Permit Number 770847 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |
139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
158 | 158 | 21682 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:00:00 AM | 3 | 4x4 | 6003825.2217 | 2114604.0634 | 37.7865157709252 | -122.43054034167 | (37.7865157709252, -122.43054034167) | ||
210 | 210 | 13438 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2002 12:00:00 AM | 6 | 4x4 | 6014077.43398 | 2117238.82075 | 37.794325647358704 | -122.395254594939 | (37.7943256473587, -122.395254594939) | ||
227 | 227 | 13622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 562 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6012358.746590001 | 2115584.5782 | 37.789687756343604 | -122.401085198325 | (37.7896877563436, -122.401085198325) | |||
275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
345 | 345 | 13664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 648 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6011893.33766 | 2115132.41268 | 37.788420242855395 | -122.402663664993 | (37.7884202428554, -122.402663664993) | |||
353 | 353 | 13824 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009889.5706 | 2113199.7435 | 37.7830015179357 | -122.40945995866699 | (37.7830015179357, -122.409459958667) | |||
356 | 356 | 5230 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1051 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2004 12:00:00 AM | 3 | 4x4 | 6001389.4157 | 2112056.3671 | 37.7793821590717 | -122.43878497743201 | (37.7793821590717, -122.438784977432) | ||
360 | 360 | 6307 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | |||
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) | |||
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) | |||
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) | |||
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) | ||
506 | 506 | 4706 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 950 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 09:29:00 PM | 3 | 4x4 | 6008667.8262 | 2120581.3066 | 37.8032009492885 | -122.414209123056 | (37.8032009492885, -122.414209123056) | ||
535 | 535 | 13638 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 576 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6012273.72895 | 2115490.3220900004 | 37.7894242082171 | -122.40137272597799 | (37.7894242082171, -122.401372725978) | |||
584 | 584 | 14069 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007575.3554 | 2111000.5411 | 37.7768330981624 | -122.417310315452 | (37.7768330981624, -122.417310315452) | |||
609 | 609 | 13247 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2372X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 40 | 4x4 | 6001031.9779 | 2119351.2951 | 37.7993917986357 | -122.44054486433201 | (37.7993917986357, -122.440544864332) | ||
647 | 647 | 13705 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011215.546569999 | 2114485.16599 | 37.786605191509295 | -122.404963137048 | (37.7866051915093, -122.404963137048) | |||
899 | 899 | 23949 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003202.444680001 | 2115904.93175 | 37.7900523252984 | -122.43278795880501 | (37.7900523252984, -122.432787958805) | |
987 | 987 | 14059 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2017 03:10:00 PM | 3 | 4x4 | 6007777.9052 | 2111198.2219 | 37.7773872760423 | -122.416623639707 | (37.7773872760423, -122.416623639707) | ||
1007 | 1007 | 14064 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 08:26:00 AM | 3 | 4x4 | 6007685.3945 | 2111107.6588 | 37.7771334080887 | -122.41693724725599 | (37.7771334080887, -122.416937247256) | ||
1008 | 1008 | 14063 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 08:13:00 AM | 3 | 4x4 | 6007701.949 | 2111122.2657 | 37.7771744463261 | -122.416881015003 | (37.7771744463261, -122.416881015003) | ||
1026 | 1026 | 13476 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6013666.75675 | 2116818.6011799998 | 37.7931489752948 | -122.396646124018 | (37.7931489752948, -122.396646124018) | |||
1066 | 1066 | 23276 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6006534.60812 | 2113350.76252 | 37.7832276265901 | -122.421077496141 | (37.7832276265901, -122.421077496141) | |||
1077 | 1077 | 98926 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3541 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 5997927.34517 | 2115124.9687799998 | 37.7876101632223 | -122.450983011859 | (37.7876101632223, -122.450983011859) | |||
1133 | 1133 | 13945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 12 | 4x4 | 6009115.3446 | 2112460.3733 | 37.7809279727613 | -122.412086202614 | (37.7809279727613, -122.412086202614) | ||
1147 | 1147 | 14071 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007529.5869 | 2110959.6416 | 37.7767182228199 | -122.41746574362101 | (37.7767182228199, -122.417465743621) | |||
1155 | 1155 | 14734 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 895 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6004929.3578 | 2111921.9134 | 37.7792137381495 | -122.42652924677799 | (37.7792137381495, -122.426529246778) | |||
1163 | 1163 | 2939 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1910 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6005122.54257 | 2115837.0032200003 | 37.789974522242105 | -122.42613973678499 | (37.7899745222421, -122.426139736785) | |||
1246 | 1246 | 108487 | Undocumented 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 1 Rausch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009617.99137 | 2111001.7892 | 37.7769512346475 | -122.410244280743 | (37.7769512346475, -122.410244280743) | |
1248 | 1248 | 108486 | Undocumented 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 1 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009630.796130001 | 2110990.10713 | 37.7769198761764 | -122.410199159984 | (37.7769198761764, -122.410199159984) | |
1265 | 1265 | 108488 | Undocumented 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 1 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009599.94268 | 2111020.96873 | 37.777002885413104 | -122.410308071481 | (37.7770028854131, -122.410308071481) | |
1276 | 1276 | 229197 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3186 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 4x4 | 6008575.05448 | 2100617.97477 | 37.7483811527748 | -122.41311771451599 | (37.7483811527748, -122.413117714516) | |||
1281 | 1281 | 231175 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 4x4 | 6008989.553669999 | 2100618.8922900003 | 37.7484069327314 | -122.41168444520599 | (37.7484069327314, -122.411684445206) | ||
1304 | 1304 | 231176 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008965.15097 | 2100617.87341 | 37.7484027661782 | -122.411768757547 | (37.7484027661782, -122.411768757547) | |||
1311 | 1311 | 237352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | |||
1314 | 1314 | 92967 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3022 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779165 | 6000091.47375 | 2115801.73595 | 37.7895920459934 | -122.443544210206 | (37.7895920459934, -122.443544210206) | |
1353 | 1353 | 14712 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 845 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1993 12:00:00 AM | 8 | 4x4 | 6005208.5684 | 2111961.5273 | 37.779338288494 | -122.42556616152099 | (37.779338288494, -122.425566161521) | ||
1403 | 1403 | 122808 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1830 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x4 | 6011911.59203 | 2106562.15691 | 37.7648893115244 | -122.401997787192 | (37.7648893115244, -122.401997787192) | ||
1415 | 1415 | 9957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 165X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 4x4 | 6007023.214790001 | 2111521.59802 | 37.778232715494205 | -122.41925731148399 | (37.7782327154942, -122.419257311484) | |||
1429 | 1429 | 102682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001423.65551 | 2115717.83054 | 37.7894375487454 | -122.438928994703 | (37.7894375487454, -122.438928994703) | |||
1437 | 1437 | 111252 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3129x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5983208.5024 | 2097401.5189 | 37.7380929647396 | -122.500595473335 | (37.7380929647396, -122.500595473335) | |||
1455 | 1455 | 184625 | Permitted Site 1 | Tree(s) :: 17 | 1762 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2017 12:00:00 AM | 3 | 4x4 | Permit Number 778834 | 5981059.357000001 | 2103059.0208 | 37.7535004788576 | -122.50844586217698 | (37.7535004788576, -122.508445862177) | |
1546 | 1546 | 237042 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779999 | 6010308.84654 | 2103966.51965 | 37.757672694545896 | -122.407358302349 | (37.7576726945459, -122.407358302349) | |
1564 | 1564 | 106910 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3536 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997359.139830001 | 2116076.9553400003 | 37.7901915187728 | -122.453017625461 | (37.7901915187728, -122.453017625461) | |
1567 | 1567 | 251594 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
1574 | 1574 | 251596 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
1583 | 1583 | 251593 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
1592 | 1592 | 251595 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
1596 | 1596 | 14066 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007645.4688 | 2111067.7331 | 37.7770215357502 | -122.41707253353701 | (37.7770215357502, -122.417072533537) | |||
1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
1612 | 1612 | 13833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009828.1026 | 2113177.7906 | 37.782937796191504 | -122.40967106357901 | (37.7829377961915, -122.409671063579) | |||
1655 | 1655 | 13618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 554 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x4 | 6012397.92719 | 2115620.9372799997 | 37.7897897754213 | -122.400952192186 | (37.7897897754213, -122.400952192186) | |||
1656 | 1656 | 9731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.42359898745899 | (37.7794635560295, -122.423598987459) | |||
1671 | 1671 | 13627 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 570 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6012289.31562 | 2115520.12346 | 37.789506905374395 | -122.401320892642 | (37.7895069053744, -122.401320892642) | |||
1689 | 1689 | 13884 | DPW Maintained 3 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1025 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2017 12:00:00 AM | 3 | 4x4 | 6009472.3125 | 2112691.0532 | 37.781581387255294 | -122.410867567036 | (37.7815813872553, -122.410867567036) | ||
1738 | 1738 | 13966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
1741 | 1741 | 28362 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 6 | 4x4 | 6005809.8912 | 2098114.7936 | 37.7413523657119 | -122.422501756572 | (37.7413523657119, -122.422501756572) | ||
1754 | 1754 | 245399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6005818.4513 | 2098127.8856 | 37.7413887962973 | -122.42247308874201 | (37.7413887962973, -122.422473088742) | |||
1755 | 1755 | 13965 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
1815 | 1815 | 71427 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.802997311571104 | -122.409613538987 | (37.8029973115711, -122.409613538987) | |
1823 | 1823 | 38862 | Permitted Site 1 | Tree(s) :: 17 | 1551 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779966 | 5989293.07470895 | 2104790.33093507 | 37.7587360109051 | -122.4800989152 | (37.7587360109051, -122.4800989152) | |
2041 | 2041 | 13773 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 6010487.82969 | 2113786.8175 | 37.7846469870112 | -122.407431620471 | (37.7846469870112, -122.407431620471) | |||
2112 | 2112 | 13981 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008866.9651 | 2112266.4261 | 37.7803815007944 | -122.412931755866 | (37.7803815007944, -122.412931755866) | |||
2264 | 2264 | 14060 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/07/2017 12:00:00 AM | 3 | 4x4 | 6007755.5079 | 2111176.7984 | 37.777327192558104 | -122.41669960143999 | (37.7773271925581, -122.41669960144) | ||
2307 | 2307 | 122432 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778941 | 6013714.3488 | 2114207.9998 | 37.7859835205848 | -122.396298394128 | (37.7859835205848, -122.396298394128) | ||
2309 | 2309 | 122433 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013698.925 | 2114193.6044 | 37.785943135879 | -122.396350747311 | (37.785943135879, -122.396350747311) | ||
2330 | 2330 | 6147 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 939 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6006318.99495 | 2113507.73043 | 37.7836464651567 | -122.42183458592 | (37.7836464651567, -122.42183458592) | |||
2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
2332 | 2332 | 122438 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 778941 | 6013622.8347 | 2114119.5705 | 37.785735621476 | -122.396608809095 | (37.785735621476, -122.396608809095) | ||
2334 | 2334 | 122437 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013638.2584 | 2114134.9942 | 37.7857788297664 | -122.396556528653 | (37.7857788297664, -122.396556528653) | ||
2337 | 2337 | 122436 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | Permit Number 778941 | 6013651.6256 | 2114147.3332 | 37.7858134537143 | -122.39651114681001 | (37.7858134537143, -122.39651114681) | ||
2340 | 2340 | 13486 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013525.0360199995 | 2116684.5106599997 | 37.7927729057886 | -122.39712708324801 | (37.7927729057886, -122.397127083248) | |||
2344 | 2344 | 122435 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 778941 | 6013667.0494 | 2114164.8134 | 37.785862308640105 | -122.396459010111 | (37.7858623086401, -122.396459010111) | ||
2350 | 2350 | 122434 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013681.4448 | 2114180.2371 | 37.7859054596404 | -122.39641028715201 | (37.7859054596404, -122.396410287152) | ||
2360 | 2360 | 122439 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Permit Number 778941 | 6013610.4957 | 2114107.2315 | 37.7857010547146 | -122.39665063354099 | (37.7857010547146, -122.396650633541) | ||
2451 | 2451 | 2187 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000917.5615 | 2112301.3252 | 37.7800278959817 | -122.440434888409 | (37.7800278959817, -122.440434888409) | |||
2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2579 | 2579 | 14672 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 739 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005639.1537 | 2112019.7041 | 37.7795223479045 | -122.424080723662 | (37.7795223479045, -122.424080723662) | |||
2635 | 2635 | 13840 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 974 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6009780.9039 | 2113133.8849 | 37.78281459658329 | -122.40983125198 | (37.7828145965833, -122.40983125198) | |||
2665 | 2665 | 21684 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2004 12:00:00 AM | 3 | 4x4 | 6003739.9244 | 2114585.2131 | 37.7864591803505 | -122.43083410335501 | (37.7864591803505, -122.430834103355) | ||
2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
2693 | 2693 | 98923 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3527 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5997962.31773 | 2115134.58282 | 37.7876385629149 | -122.450862707746 | (37.7876385629149, -122.450862707746) | |||
2740 | 2740 | 72022 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 550 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1989 12:00:00 AM | 12 | 4x4 | 6010599.26481 | 2116134.30998 | 37.791098878065796 | -122.40721162653401 | (37.7910988780658, -122.407211626534) | ||
2889 | 2889 | 102687 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2155 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6001348.89021 | 2115903.63348 | 37.7899434614624 | -122.43920099642901 | (37.7899434614624, -122.439200996429) | |||
2938 | 2938 | 60590 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481.0 | 2111039.0 | 37.77653700517929 | -122.441854521628 | (37.7765370051793, -122.441854521628) |
3066 | 3066 | 13737 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 780155 | 6010751.43772 | 2114034.04518 | 37.7853405666668 | -122.40653704776001 | (37.7853405666668, -122.40653704776) | ||
3078 | 3078 | 13812 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 950 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6009942.8788 | 2113250.7921 | 37.783144672032705 | -122.409279136989 | (37.7831446720327, -122.409279136989) |
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");