Street_Tree_List

Data source: data.sfgov.org

792 rows where qCareAssistant = 2 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH

qCareAssistant

  • DPW for City Agency · 792
Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
113735 30736 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 490X Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
112231 30737 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 490X Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/05/2000 12:00:00 AM 4 3x3 Permit Number 42884 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
19738 30738 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 380 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004189.67673 2109821.80854 37.773405523491995 -122.428938341537 (37.773405523492, -122.428938341537)
86916 30739 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 490X Page St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
18252 30740 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 380 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004184.33514 2109844.2088200003 37.7734667268354 -122.428958416203 (37.7734667268354, -122.428958416203)
129289 30741 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 490X Page St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
21303 30742 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 380 Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004180.58298 2109863.27384 37.7735188623338 -122.428972754992 (37.7735188623338, -122.428972754992)
89141 30743 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 490X Page St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
17361 30744 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 380 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004178.56485 2109886.0183099997 37.7735811988523 -122.428981357915 (37.7735811988523, -122.428981357915)
17300 30745 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 486X Page St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004274.8073 2109806.6859 37.773368818647 -122.42864278458 (37.773368818647, -122.42864278458)
18822 30746 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 490X Page St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004256.1031 2109802.2559 37.7733555963905 -122.42870716917601 (37.7733555963905, -122.428707169176)
20531 30747 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 496X Page St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004231.9845 2109799.7949 37.77334747404829 -122.42879042330799 (37.7733474740483, -122.428790423308)
77433 31711 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1250X Shrader St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.763837639523395 -122.450514467435 (37.7638376395234, -122.450514467435)
20625 32725 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 431 Capitol Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 3 3x3   5995024.24753 2088599.26436 37.714610662038204 -122.45910563733999 (37.7146106620382, -122.45910563734)
86699 32726 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 200X Farallones St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
22207 32727 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 431 Capitol Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 3 3x3   5995024.97569 2088634.0427 37.7147061970204 -122.459105637321 (37.7147061970204, -122.459105637321)
22123 32728 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 431 Capitol Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 3 3x3   5995024.59612 2088615.9136299998 37.714656397048 -122.45910563732599 (37.714656397048, -122.459105637326)
87708 32729 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 200X Farallones St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 12 3x3 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
18702 32730 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 431 Capitol Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 3 3x3   5995024.5889800005 2088651.07748 37.714752948278104 -122.459108206688 (37.7147529482781, -122.459108206688)
19029 32731 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 431 Capitol Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/29/1996 12:00:00 AM 3 3x3   5995024.91433 2088666.6169099999 37.7147956345921 -122.45910820668699 (37.7147956345921, -122.459108206687)
86573 34754 DPW Maintained 3 Jacaranda mimosifolia :: Jacaranda 52 825 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 04/07/2010 12:00:00 AM 5 3x3 Permit Number 53353 6007982.56974873 2103121.8781615 37.7552230267666 -122.415343751113 (37.7552230267666, -122.415343751113)
10290 37814 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003977.37565 2090552.2455 37.720483755714 -122.428299091747 (37.720483755714, -122.428299091747)
12958 37815 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 2 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009)
2637 37816 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003955.6668300005 2090537.19552 37.720441203374 -122.428373060073 (37.720441203374, -122.428373060073)
2643 37817 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 450X Moscow St 5 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003961.27408 2090526.1025099999 37.7204110616965 -122.428352887393 (37.7204110616965, -122.428352887393)
2641 37818 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 450X Moscow St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003946.32629 2090524.4735599998 37.720405743114 -122.428404441023 (37.720405743114, -122.428404441023)
2652 37819 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 450X Moscow St 7 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003953.55423 2090513.34715 37.7203756014419 -122.428378663762 (37.7203756014419, -122.428378663762)
2667 37820 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 450X Moscow St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003945.80086 2090498.97809 37.7203357084188 -122.428404441018 (37.7203357084188, -122.428404441018)
2654 37821 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 450X Moscow St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003927.902969999 2090495.79555 37.720325957053596 -122.428466081444 (37.7203259570536, -122.428466081444)
4355 37822 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 450X Moscow St 10 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301)
4317 37823 DPW Maintained 3 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 450X Moscow St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941)
104489 37824 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
96417 37825 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 12 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
2647 37826 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 450X Moscow St 14 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.42857143074801 (37.7201841150858, -122.428571430748)
2660 37827 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 450X Moscow St 15 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003888.33038 2090432.03853 37.7201486548235 -122.428598328547 (37.7201486548235, -122.428598328547)
78948 37828 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 15 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/22/2006 12:00:00 AM 8 3x3 Permit Number 48867 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
139322 37829 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 16 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
12710 37830 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 451 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/09/2007 12:00:00 AM 3 6x6 Permit Number 49480 6003635.85955 2090436.9204099998 37.7201477680848 -122.429471383195 (37.7201477680848, -122.429471383195)
2664 37831 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 450X Moscow St 18 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003870.23097 2090403.3538799998 37.720068868758105 -122.42865884842699 (37.7200688687581, -122.428658848427)
2638 37832 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 19 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048)
2661 37833 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 20 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003832.66245 2090342.4611400003 37.719899544415604 -122.428784371324 (37.7198995444156, -122.428784371324)
142748 37835 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 21 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
93136 37837 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 23 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
11797 37838 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 451 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003644.26117 2090451.27602 37.720187661114295 -122.429443364835 (37.7201876611143, -122.429443364835)
10557 37839 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 451 Athens St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003658.0147400005 2090473.5929 37.720249717041504 -122.42939741397 (37.7202497170415, -122.42939741397)
13085 37840 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 451 Athens St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/09/2007 12:00:00 AM 3 4x6 Permit Number 49480 6003672.4294 2090496.5417099998 37.7203135455184 -122.42934922289801 (37.7203135455184, -122.429349222898)
760 38424 DPW Maintained 3 Morus alba :: White Mulberry 112 1451 Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/24/2005 12:00:00 AM 12 3x3 Permit Number 48015 6007280.7970900005 2117415.82487 37.79443132398921 -122.418784361633 (37.7944313239892, -122.418784361633)
105713 40250 DPW Maintained 3 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 3351X 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
118872 40251 DPW Maintained 3 Eriobotrya deflexa :: Bronze Loquat 49 3351X 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
81794 40252 DPW Maintained 3 Eriobotrya deflexa :: Bronze Loquat 49 3351X 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/13/1999 12:00:00 AM 8 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
103810 40253 DPW Maintained 3 Eriobotrya deflexa :: Bronze Loquat 49 3351X 23rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/13/1999 12:00:00 AM 5 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
78701 40254 DPW Maintained 3 Eriobotrya deflexa :: Bronze Loquat 49 3351X 23rd St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
2873 41127 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2049 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2857 41128 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2049 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2880 41129 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2049 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
72481 42343 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
88765 42344 DPW Maintained 3 Melaleuca ericifolia :: Heath Melaleuca 184 380X Flood Ave 3 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
90442 42345 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
121322 42347 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
123438 42348 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 7 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 3 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
100102 42349 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
86065 42350 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
105224 42352 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
93542 42354 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
82646 42355 DPW Maintained 3 Melaleuca ericifolia :: Heath Melaleuca 184 380X Flood Ave 14 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
140146 42356 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
120818 42357 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 3 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
144409 42358 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
94089 42360 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
111991 42361 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 250 Foerster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
114618 42365 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 250 Foerster St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
92098 42366 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 250 Foerster St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
122117 42367 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 250 Foerster St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
121470 42369 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 250 Foerster St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
7911 42632 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x4 Permit Number 42688 6005134.3142099995 2118828.07494 37.7981879136105 -122.42631205408199 (37.7981879136105, -122.426312054082)
3260 42633 DPW Maintained 3 Tristania conferta :: 79 1651 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/22/2016 02:56:00 PM 3 5x5 Permit Number 45045 6005048.16251 2118816.23898 37.7981505449739 -122.426609321383 (37.7981505449739, -122.426609321383)
6421 42634 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1651 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/22/2016 02:52:00 PM 3 5x5 Permit Number 45045 6005069.31611 2118819.49736 37.7981606875253 -122.42653635579398 (37.7981606875253, -122.426536355794)
7354 42635 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x5 Permit Number 42688 6005113.3477300005 2118824.42387 37.7981767035488 -122.426384344263 (37.7981767035488, -122.426384344263)
7085 42636 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x5 Permit Number 42688 6005181.30457 2118838.80185 37.7982200229931 -122.426150217479 (37.7982200229931, -122.426150217479)
6913 42637 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x4 Permit Number 42688 6005203.48268 2118840.06651 37.7982247489172 -122.42607356463999 (37.7982247489172, -122.42607356464)
5300 42638 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1651 Union St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/22/2016 02:49:00 PM 3 5x5 Permit Number 42688 6005231.45083 2118842.40752 37.7982327574016 -122.425976953174 (37.7982327574016, -122.425976953174)
6782 42639 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1651 Union St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/2014 12:00:00 AM 8 3x3 Permit Number 42688 6005258.416780001 2118846.41372 37.798245281357204 -122.425883928195 (37.7982452813572, -122.425883928195)
1697 42640 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1651 Union St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/25/2015 02:08:00 PM 3 3x3 Permit Number 42688 6005273.82097 2118847.7065 37.7982497015198 -122.42583071712299 (37.7982497015198, -122.425830717123)
7033 42641 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 1651 Union St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 22 5x5 Permit Number 42688 6005090.06351 2118821.9865599996 37.798168695097296 -122.426464740961 (37.7981686950973, -122.426464740961)
142663 42642 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1600X GREEN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 5 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
119394 42643 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600X GREEN ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 12 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
96597 42644 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1600X GREEN ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
118188 42645 DPW Maintained 3 Melaleuca ericifolia :: Heath Melaleuca 184 1600X GREEN ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 6 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
100633 42646 DPW Maintained 3 Melaleuca ericifolia :: Heath Melaleuca 184 1600X GREEN ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
121500 42841 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2245 Jones St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/03/2000 12:00:00 AM     Permit Number 42773 6008051.69679947 2120116.37092576 37.8018897255523 -122.416308313185 (37.8018897255523, -122.416308313185)
125598 42983 DPW Maintained 3 Melaleuca quinquenervia :: Cajeput 50 2X Yale St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/16/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
108221 42984 DPW Maintained 3 Tree(s) :: 17 2X Yale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/05/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
82533 42985 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2X Yale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/16/2000 12:00:00 AM 12 9x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
145909 42986 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 2X Yale St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/16/2000 12:00:00 AM 3 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
142357 42987 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 2X Yale St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/16/2000 12:00:00 AM 8 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
109074 42988 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2X Yale St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/16/2000 12:00:00 AM 10 4x5 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
100933 42989 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2X Yale St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
103689 42990 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2X Yale St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
174085 43304 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 693 Vermont St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/12/2000 12:00:00 AM 19   Permit Number 43072 6011287.96925 2105166.37556 37.7610219838923 -122.404056515205 (37.7610219838923, -122.404056515205)
2223 43305 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 693 Vermont St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 604.339ms · Data source: data.sfgov.org