1,098 rows where qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

Police Districts

  • 7 189
  • 4 180
  • 3 177
  • 6 164
  • 9 127
  • 1 118
  • 8 82
  • 5 44
  • 2 16
  • - 1

PlantType

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant ▼ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
297 113036 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
1119 113031 DPW Maintained 1 Quercus suber :: Cork Oak 78 251 06th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665) 11 6 2 54 11
2474 256556 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 5 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
4401 258690 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
4591 113471 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 28 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
5745 193934 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 Width 3ft   6016623.26344 2095403.70542 37.7345123576517 -122.384923708478 (37.7345123576517, -122.384923708478) 10 3 8 58 1
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
6926 96580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
7677 258687 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 9 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
7851 220311 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151) 2 4 5 28862 3
8020 95515 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5985992.57608 2111969.58011 37.7782558903759 -122.492041976045 (37.7782558903759, -122.492041976045) 11 6 2 55 26
8590 142524 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 14 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/23/2016 02:52:00 PM 20 Width 0ft   6009733.2838 2121208.6135 37.8049831671154 -122.410566384357 (37.8049831671154, -122.410566384357) 3 1 10 308 23
9009 258692 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100x Whitney Young Cir   Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
9627 228661 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943) 2 4 5 28862 3
10723 113037 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
11601 95514 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/19/2015 02:29:00 PM 3 3x3   5985991.7561 2111987.56369 37.7783052202186 -122.492046137036 (37.7783052202186, -122.492046137036) 11 6 2 55 26
12066 258686 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 8 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12179 220312 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     15 Width 3ft   6002007.42492 2104678.29116 37.7591589249724 -122.436118906483 (37.7591589249724, -122.436118906483) 2 4 5 28862 3
12415 258693 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100 Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12520 228662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999) 2 4 5 28862 3
15342 113473 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 30 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
15996 258691 Property Tree 8 Pinus radiata :: Monterey Pine 15 100x Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
16064 235284 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4235 19th St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.436539154285 (37.7591334867264, -122.436539154285) 2 4 5 28862 3
16134 106952 Undocumented 4 Tree(s) :: 17 399X SOMERSET ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6009953 2092875 37.7271978698015 -122.407806879765 (37.7271978698015, -122.407806879765) 10 3 7 309 28
16772 113034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
17049 112023 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
17413 112021 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
17872 258685 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 2 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
18625 113033 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 251 06th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993974.82941 2113822.74411 37.7838075380241 -122.464563239136 (37.7838075380241, -122.464563239136) 11 6 2 54 11
19099 113032 DPW Maintained 1 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 251 06th Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 3x3   5993973.41927 2113841.38508 37.7838586397785 -122.464569471656 (37.7838586397785, -122.464569471656) 11 6 2 54 11
23043 95519 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5985993.74648 2111883.31804 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445) 11 6 2 55 26
23905 96578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
23915 96577 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 401x Otsego Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM 2 3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
24124 142520 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145) 3 1 10 308 23
27100 92958 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
31248 96579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
33807 113465 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
34431 256554 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 3 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
37736 101041 Significant Tree 6 Tree(s) :: 17 3750 18th St 1 Front Yard : Yard Tree SFUSD 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
38417 95498 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X 32nd Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     18 3x3   5985976.05543 2112422.37376 37.7794981665366 -122.492132474117 (37.7794981665366, -122.492132474117) 11 6 2 55 26
38459 107872 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
39581 142525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
42099 234076 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400 San Bruno Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     12 Width 4ft   6011147.1312 2101589.6307 37.751193164657 -122.404291863299 (37.751193164657, -122.404291863299) 10 4 8 28859 19
42731 115967 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986812.8086 2104676.4366 37.7582788637421 -122.488668327875 (37.7582788637421, -122.488668327875) 1 8 3 56 35
43317 113469 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 26 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
44433 94516 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1106X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.94736 37.7534025731789 -122.398672553793 (37.7534025731789, -122.398672553793) 10 3 8 28856 29
47600 107870 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
47875 234074 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400 San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     11 Width 3ft   6011143.5049 2101689.85229 37.751468148542 -122.404311456823 (37.751468148542, -122.404311456823) 10 4 8 28859 19
48931 95501 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500X 32nd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5985979.29593 2112362.71829 37.7793345591202 -122.492116870392 (37.7793345591202, -122.492116870392) 11 6 2 55 26
49723 115970 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
51523 107874 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
51808 111862 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
51837 113436 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
52455 117257 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1570 31ST AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
55266 142521 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/04/2013 12:00:00 AM 0 Width 0ft   6009485.2617 2121177.5361 37.8048839283261 -122.411422499274 (37.8048839283261, -122.411422499274) 3 1 10 308 23
56509 95507 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600X 32nd Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 3x3   5985983.58763 2112182.96811 37.7788412674233 -122.492088785464 (37.7788412674233, -122.492088785464) 11 6 2 55 26
57689 117255 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
58400 113437 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
60043 111861 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
60432 112026 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 2101x 22nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4       5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
62037 95492 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 600X 32nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986013.63252 2111419.06509 37.7767455639501 -122.491928594276 (37.7767455639501, -122.491928594276) 11 6 2 55 26
62341 225510 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4     21 6x6   6004199.54992 2106135.78909 37.7632851647079 -122.42864138449 (37.7632851647079, -122.42864138449) 8 4 5 28862 3
62536 112022 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 2101x 22nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
65054 113474 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 31 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
65057 142547 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
66275 142545 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
66912 95490 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 3x3   5986007.65609 2111463.21002 37.7768664240251 -122.491952519112 (37.7768664240251, -122.491952519112) 11 6 2 55 26
67077 113468 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   06/21/2016 02:14:00 PM 3 6x7   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
67453 173941 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 3750 18th St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6004590 2105440 37.7613967828987 -122.427241380377 (37.7613967828987, -122.427241380377) 8 4 5 28862 3
68404 107869 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
68939 43903 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
68964 113434 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     12 4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
69868 142549 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 11 Sidewalk: Curb side : Cutout Tree SFUSD 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.410795492578 (37.8049613971858, -122.410795492578) 3 1 10 308 23
71668 142546 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847) 3 1 10 308 23
71723 79386 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2355 Folsom St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008491.21757684 2104497.38565881 37.7590284322587 -122.4136819767 (37.7590284322587, -122.4136819767) 2 4 7 28859 19
72835 253729 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
73519 253732 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
73651 112027 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 2101x 22nd Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4       5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
75070 253734 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
75199 113039 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
76617 107873 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
80723 142526 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 17 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206) 3 1 10 308 23
81017 117256 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
81910 225512 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4   01/08/2019 12:00:00 AM 3 6x6   6004203.25115 2106055.40872 37.7630646689183 -122.428622853063 (37.7630646689183, -122.428622853063) 8 4 5 28862 3
82489 253724 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
83117 113466 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
83242 113035 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 251 06th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     1 3x3   5993975.80165 2113783.25834 37.7836991768592 -122.464557007516 (37.7836991768592, -122.464557007516) 11 6 2 54 11
83356 142550 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 16 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/26/2016 09:53:00 AM 22 Width 0ft   6009784.6811 2121219.3711 37.8050155861628 -122.410389277522 (37.8050155861628, -122.410389277522) 3 1 10 308 23
85468 95510 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 500X 32nd Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/19/2015 02:35:00 PM 3 3x3   5985969.9 2112493.2 37.7796922752829 -122.492158984519 (37.7796922752829, -122.492158984519) 11 6 2 55 26
87079 225503 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     17 6x6   6004180.73654 2106512.8354 37.7643193787498 -122.428733333891 (37.7643193787498, -122.428733333891) 8 4 5 28862 3
87145 113435 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
88433 107871 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
88671 95484 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986002.98697 2111639.37953 37.7773498623685 -122.491981644298 (37.7773498623685, -122.491981644298) 11 6 2 55 26
89046 113040 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
90011 256555 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 4 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:48:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
91360 110190 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 625 Holly Park Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
91388 105784 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
91889 113472 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 29 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);