Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, DBH
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113735 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |
28296 | 28296 | 33101 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11/01/1997 12:00:00 AM | 14 | Permit Number 37341 | 6009682.3141 | 2120901.0273 | 37.804135754366996 | -122.410721035819 | (37.804135754367, -122.410721035819) | |
52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
133902 | 133902 | 34692 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) |
61243 | 61243 | 34693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.43438045581301 | (37.799535058456, -122.434380455813) |
86573 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");