trees
198 rows where qCareAssistant = "" and qCaretaker_id = 4 sorted by qLegalStatus_id
This data as json, CSV (advanced)
These facets timed out: qCareAssistant
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | |||
| 92249 | 115964 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
| 92761 | 110187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
| 95849 | 234073 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | 10 | 4 | 8 | 28859 | 19 | |||
| 98442 | 142544 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:55:00 PM | 26 | Width 0ft | 6009534.8661 | 2121184.7078 | 37.8049064021217 | -122.411251344133 | (37.8049064021217, -122.411251344133) | 3 | 1 | 10 | 308 | 23 | ||
| 99299 | 142522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.8049757647303 | -122.410719306308 | (37.8049757647303, -122.410719306308) | 3 | 1 | 10 | 308 | 23 | |||
| 102251 | 95513 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.28561 | 37.7783619491242 | -122.49205757976 | (37.7783619491242, -122.49205757976) | 11 | 6 | 2 | 55 | 26 | |||
| 102329 | 91788 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 830X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012494.965717 | 2112152.388469 | 37.7802713613915 | -122.400372717325 | (37.7802713613915, -122.400372717325) | 6 | 2 | 9 | 28856 | 34 | ||
| 104893 | 95486 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.7771040325177 | -122.491959800837 | (37.7771040325177, -122.491959800837) | 11 | 6 | 2 | 55 | 26 | |||
| 106937 | 95512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985990.17986 | 2112026.52369 | 37.7784121011104 | -122.492054459017 | (37.7784121011104, -122.492054459017) | 11 | 6 | 2 | 55 | 26 | |||
| 108286 | 253726 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 109856 | 253733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 110253 | 95500 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985980.30461 | 2112381.8602 | 37.7793871762895 | -122.492114790789 | (37.7793871762895, -122.492114790789) | 11 | 6 | 2 | 55 | 26 | |||
| 110617 | 225504 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 6x6 | 6004179.96928 | 2106475.61191 | 37.7642171285539 | -122.428733333881 | (37.7642171285539, -122.428733333881) | 8 | 4 | 5 | 28862 | 3 | |||
| 111453 | 95488 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | 11 | 6 | 2 | 55 | 26 | |||
| 112874 | 95489 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.56221 | 37.7769305539658 | -122.491953559362 | (37.7769305539658, -122.491953559362) | 11 | 6 | 2 | 55 | 26 | |||
| 113363 | 95502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.492111670045 | (37.7792737200362, -122.492111670045) | 11 | 6 | 2 | 55 | 26 | |||
| 114542 | 225505 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 19 | 6x6 | 6004182.33297 | 2106439.09947 | 37.7641170079293 | -122.428722555516 | (37.7641170079293, -122.428722555516) | 8 | 4 | 5 | 28862 | 3 | |||
| 117212 | 95495 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986000.95497 | 2111699.3103 | 37.7775142963957 | -122.491993087037 | (37.7775142963957, -122.491993087037) | 11 | 6 | 2 | 55 | 26 | |||
| 118868 | 95499 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985977.73249 | 2112402.27637 | 37.7794430828921 | -122.49212519236 | (37.7794430828921, -122.49212519236) | 11 | 6 | 2 | 55 | 26 | |||
| 118940 | 95491 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.7768072273274 | -122.491945237383 | (37.7768072273274, -122.491945237383) | 11 | 6 | 2 | 55 | 26 | |||
| 121060 | 92961 | DPW Maintained 1 | Tree(s) :: 17 | 2051 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369 | -122.492270870248 | (37.748848003369, -122.492270870248) | 1 | 8 | 3 | 29491 | 35 | ||
| 121669 | 234075 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.7513035456277 | -122.404297986789 | (37.7513035456277, -122.404297986789) | 10 | 4 | 8 | 28859 | 19 | |||
| 122635 | 96583 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401x Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
| 123553 | 95503 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.49633 | 2112291.66361 | 37.7791397088392 | -122.492097106557 | (37.7791397088392, -122.492097106557) | 11 | 6 | 2 | 55 | 26 | |||
| 123758 | 95505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.492096067193 | (37.7790213190615, -122.492096067193) | 11 | 6 | 2 | 55 | 26 | |||
| 124230 | 107423 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 251 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993968.46376 | 2113916.3836 | 37.7840642796834 | -122.464592063385 | (37.7840642796834, -122.464592063385) | 11 | 6 | 2 | 54 | 11 | |||
| 125465 | 142523 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.8049770715314 | -122.410638645677 | (37.8049770715314, -122.410638645677) | 3 | 1 | 10 | 308 | 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );