Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2575 | 2575 | 253126 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 182 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779117 | 6002742.73008 | 2092646.2038099999 | 37.726163358663705 | -122.432716365158 | (37.7261633586637, -122.432716365158) | ||
2639 | 2639 | 253101 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2642 | 2642 | 253105 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1295 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2663 | 2663 | 253102 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2666 | 2666 | 253103 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2669 | 2669 | 253104 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2715 | 2715 | 253166 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.48968039586501 | (37.742306656921, -122.489680395865) | |
2759 | 2759 | 253203 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999103.0 | 2095207.0 | 37.732987611392005 | -122.44548271607799 | (37.732987611392, -122.445482716078) | ||||
2853 | 2853 | 253248 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
2868 | 2868 | 253247 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
2897 | 2897 | 253249 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
3030 | 3030 | 224462 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.40714655877301 | (37.7497653433983, -122.407146558773) | |
3035 | 3035 | 240686 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.749767577309605 | -122.40709853768499 | (37.7497675773096, -122.407098537685) | |
3048 | 3048 | 253287 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.7941400001 | 37.727152059320204 | -122.383990506478 | (37.7271520593202, -122.383990506478) | |
3083 | 3083 | 252820 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.6863599997 | 37.743137766616 | -122.49941055724301 | (37.743137766616, -122.499410557243) | ||
3172 | 3172 | 253340 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004432.85841 | 2102813.20591 | 37.754175338839204 | -122.427597715268 | (37.7541753388392, -122.427597715268) | |
3255 | 3255 | 253377 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
3525 | 3525 | 253489 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3532 | 3532 | 253483 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3533 | 3533 | 253491 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3538 | 3538 | 253485 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3546 | 3546 | 253495 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3553 | 3553 | 253492 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3554 | 3554 | 253490 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3555 | 3555 | 253487 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3562 | 3562 | 253488 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3563 | 3563 | 253493 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3573 | 3573 | 253496 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3581 | 3581 | 253486 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3582 | 3582 | 253484 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3587 | 3587 | 253494 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
3753 | 3753 | 253554 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.48826692291901 | (37.7526951056681, -122.488266922919) | |
3809 | 3809 | 95203 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | Permit Number 769992 | 5998598.6333800005 | 2115400.1597599997 | 37.7884041728517 | -122.44868032474 | (37.7884041728517, -122.44868032474) | ||
3823 | 3823 | 102525 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 310 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2013 12:00:00 AM | 0 | 3x3 | Permit Number 769739 | 5998596.991169999 | 2115413.44206 | 37.7884405486385 | -122.448686963531 | (37.7884405486385, -122.448686963531) | |
3868 | 3868 | 253576 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
4401 | 4401 | 239088 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.4007099997 | 37.748496089721996 | -122.426200479689 | (37.748496089722, -122.426200479689) | ||
4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) | ||||
5087 | 5087 | 150676 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 548 Rhode Island St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.983990001 | 2105812.52377 | 37.762822244976505 | -122.402486741392 | (37.7628222449765, -122.402486741392) | |
5192 | 5192 | 243370 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.2279900005 | 2103449.78821 | 37.756025819148796 | -122.421361454386 | (37.7560258191488, -122.421361454386) | |
5194 | 5194 | 243372 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1050 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006308.99467 | 2103436.4955 | 37.755992689926295 | -122.42115381712 | (37.7559926899263, -122.42115381712) | |
5195 | 5195 | 253341 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1935 46th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 769984 | 5981944.6810099995 | 2101921.14451 | 37.750428327874204 | -122.505299944249 | (37.7504283278742, -122.505299944249) | |
5205 | 5205 | 243371 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006273.4727300005 | 2103450.37091 | 37.7560287860041 | -122.42127764924 | (37.7560287860041, -122.42127764924) | |
5242 | 5242 | 243740 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 550 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 776473 | 6003047.0557699995 | 2096015.8076799999 | 37.7354327831918 | -122.431904827248 | (37.7354327831918, -122.431904827248) | |
5296 | 5296 | 117021 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | |
5549 | 5549 | 117113 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005663.57094 | 2117913.49378 | 37.7957066076266 | -122.424415580821 | (37.7957066076266, -122.424415580821) | |
5738 | 5738 | 117115 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005638.31982 | 2117909.64088 | 37.7956946025865 | -122.42450268015 | (37.7956946025865, -122.42450268015) | |
5744 | 5744 | 117020 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.6658799998 | 37.7824049150971 | -122.41557516146601 | (37.7824049150971, -122.415575161466) | |
5891 | 5891 | 117112 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005683.22125 | 2117915.42136 | 37.7957130098979 | -122.424347724294 | (37.7957130098979, -122.424347724294) | |
5966 | 5966 | 117017 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | |
6755 | 6755 | 117018 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.664580001 | 2112987.05621 | 37.78231853881321 | -122.415547303188 | (37.7823185388132, -122.415547303188) | |
7045 | 7045 | 117250 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 2474 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773044 | 6001780.62325 | 2117368.05955 | 37.7939889537763 | -122.437812170719 | (37.7939889537763, -122.437812170719) | |
7118 | 7118 | 120115 | Planning Code 138.1 required 4 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2225 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6000127.238390001 | 2120216.52423 | 37.801715927006796 | -122.443737765003 | (37.8017159270068, -122.443737765003) | |||
7243 | 7243 | 116776 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008776.88904 | 2117992.21481 | 37.7960980717264 | -122.41364847189399 | (37.7960980717264, -122.413648471894) | ||
7304 | 7304 | 117114 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005648.88243 | 2117910.88116 | 37.7956986045686 | -122.42446621984399 | (37.7956986045686, -122.424466219844) | |
7735 | 7735 | 116777 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.796092432072705 | -122.41369458194099 | (37.7960924320727, -122.413694581941) | ||
8122 | 8122 | 65944 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 1051 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774496 | 6007126.88528 | 2114657.80083 | 37.7868498044193 | -122.419121190999 | (37.7868498044193, -122.419121190999) | |
8186 | 8186 | 35487 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000866.3431 | 2114483.9624 | 37.7860179417845 | -122.440768684557 | (37.7860179417845, -122.440768684557) | |
8765 | 8765 | 116774 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008811.215480001 | 2117995.14613 | 37.7961080479024 | -122.413529902601 | (37.7961080479024, -122.413529902601) | ||
8943 | 8943 | 116775 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.79610197478279 | -122.413589186808 | (37.7961019747828, -122.413589186808) | ||
9622 | 9622 | 122597 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9623 | 9623 | 75842 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9625 | 9625 | 122599 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9627 | 9627 | 122596 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9628 | 9628 | 122598 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9630 | 9630 | 72480 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9633 | 9633 | 75872 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9718 | 9718 | 105047 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | |||||
9761 | 9761 | 122592 | Planning Code 138.1 required 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9764 | 9764 | 122593 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9765 | 9765 | 122594 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
9769 | 9769 | 159355 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.882680001 | 2087558.1907400002 | 37.7119518775514 | -122.44698304145001 | (37.7119518775514, -122.44698304145) | |
9770 | 9770 | 151746 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008502.962040001 | 2106251.6003 | 37.763845762487 | -122.413765441348 | (37.763845762487, -122.413765441348) | |
9771 | 9771 | 159357 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 49 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998577.1355099995 | 2087591.01668 | 37.7120458522191 | -122.446752958004 | (37.7120458522191, -122.446752958004) | |
9781 | 9781 | 36044 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
9782 | 9782 | 159354 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 417x Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998501.29354 | 2087549.7908 | 37.7119283225022 | -122.44701212372802 | (37.7119283225022, -122.447012123728) | |
9792 | 9792 | 159358 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.8857099998 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | |
9795 | 9795 | 108228 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492.0 | 2106262.0 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | |
9807 | 9807 | 36045 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
9814 | 9814 | 29017 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 120 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | |
9823 | 9823 | 63407 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2125 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770314 | 6000344.0086 | 2116075.3402400003 | 37.790357690994504 | -122.442690122255 | (37.7903576909945, -122.442690122255) | |
9959 | 9959 | 57959 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | |
9960 | 9960 | 173748 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1259 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773489 | 5989520.0 | 2106786.0 | 37.764228762563896 | -122.47946011839899 | (37.7642287625639, -122.479460118399) | |
9964 | 9964 | 173762 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.7192900002 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | |
9965 | 9965 | 173761 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1405 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.7192900002 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | |
9988 | 9988 | 173775 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 1057 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779347 | 6009462.916019999 | 2103024.17334 | 37.7550378411013 | -122.410217357343 | (37.7550378411013, -122.410217357343) | |
10157 | 10157 | 173899 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
10513 | 10513 | 117008 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | 6006952.61647 | 2093135.11232 | 37.7277436552341 | -122.418197638517 | (37.7277436552341, -122.418197638517) | ||
10564 | 10564 | 116803 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 931 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2016 12:00:00 AM | 3 | 3x3 | 6007342.71844 | 2093540.3953900002 | 37.728878425184796 | -122.416877747635 | (37.7288784251848, -122.416877747635) | ||
12646 | 12646 | 115976 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | |||
13325 | 13325 | 187677 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
13326 | 13326 | 187676 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
13329 | 13329 | 60277 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2690 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51145 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||
13332 | 13332 | 187674 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) |
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");