trees
2,180 rows where qSpecies_id = 57 sorted by qCaretaker_id descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
27383 | 109993 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
29374 | 109992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
57725 | 109996 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
117136 | 109995 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
177165 | 109994 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
99343 | 24542 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 500X Cortland Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/29/1999 12:00:00 AM | 18 | 3X3 | 6007686.22354 | 2097194.49045 | 37.7389310892969 | -122.415948881937 | (37.7389310892969, -122.415948881937) | 2 | 7 | 7 | 28859 | 2 | ||
104969 | 5483 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 700X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/28/2008 12:00:00 AM | 6 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | ||
194071 | 142062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | 7 | 9 | 11 | 29490 | 41 | |
1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
9059 | 77640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 0 | 6006980.92428 | 2093193.11147 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | 9 | 3 | 7 | 309 | 5 | ||
9319 | 77642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006942.10409 | 2093179.93326 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | 9 | 3 | 7 | 309 | 5 | ||
10546 | 77641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006964.98892 | 2093186.85252 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | 9 | 3 | 7 | 309 | 5 | ||
17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
24545 | 70470 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
27818 | 98647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | 13 | 9 | 1 | 57 | 17 | ||
32373 | 77649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
33305 | 102189 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
35970 | 122754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 6011277.36342 | 2105334.1858 | 37.7614821606899 | -122.404105006665 | (37.7614821606899, -122.404105006665) | 10 | 3 | 8 | 28856 | 29 | |||
36405 | 98645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.7992008856766 | -122.434457791187 | (37.7992008856766, -122.434457791187) | 13 | 9 | 1 | 57 | 17 | ||
38172 | 34688 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) | 13 | 9 | 1 | 57 | 17 |
41878 | 116060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | 10 | 3 | 8 | 28856 | 29 | ||
43511 | 98646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.7991951444108 | -122.434518715761 | (37.7991951444108, -122.434518715761) | 13 | 9 | 1 | 57 | 17 | ||
45053 | 98657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002607.56666 | 2119218.59599 | 37.7991170337862 | -122.435083283187 | (37.7991170337862, -122.435083283187) | 13 | 9 | 1 | 57 | 17 | ||
49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||||
52882 | 102190 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
52988 | 99678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | |
54545 | 42985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
57109 | 102194 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||||
58686 | 98656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.7991261619004 | -122.435006269744 | (37.7991261619004, -122.435006269744) | 13 | 9 | 1 | 57 | 17 | ||
67353 | 98678 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
67880 | 77637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
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 | |||
71171 | 98681 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
78075 | 98679 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
78897 | 102155 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
85919 | 98676 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | |||||
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 | |||||
93651 | 98648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | 13 | 9 | 1 | 57 | 17 | ||
98851 | 98677 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
100826 | 78999 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 555 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
103551 | 102191 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
103561 | 42990 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
104727 | 78992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
108397 | 102154 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
108543 | 67860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.434397983605 | (37.7992088356751, -122.434397983605) | 13 | 9 | 1 | 57 | 17 |
110109 | 116049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.7615544688802 | -122.403342277248 | (37.7615544688802, -122.403342277248) | 10 | 3 | 8 | 28856 | 29 | ||
110301 | 42989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
120765 | 42988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
123087 | 34690 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) | 13 | 9 | 1 | 57 | 17 |
129312 | 77648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.14742 | 2093142.98247 | 37.7277576387802 | -122.418666516263 | (37.7277576387802, -122.418666516263) | 9 | 3 | 7 | 309 | 5 | |
130673 | 102193 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
133673 | 77636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
135683 | 77635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
137518 | 98655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.7991413757273 | -122.434934390513 | (37.7991413757273, -122.434934390513) | 13 | 9 | 1 | 57 | 17 | ||
141010 | 77633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
142139 | 34693 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.434380455813 | (37.799535058456, -122.434380455813) | 13 | 9 | 1 | 57 | 17 |
151372 | 74109 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 555 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
152683 | 98649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.7991623281478 | -122.434737597267 | (37.7991623281478, -122.434737597267) | 13 | 9 | 1 | 57 | 17 | ||
153285 | 102156 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
155971 | 73874 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
162318 | 34689 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.7994344701793 | -122.434367321195 | (37.7994344701793, -122.434367321195) | 13 | 9 | 1 | 57 | 17 |
165008 | 98682 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
168139 | 34691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.434350145047 | (37.7993346796145, -122.434350145047) | 13 | 9 | 1 | 57 | 17 |
169010 | 102195 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
176008 | 74108 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 555 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
180042 | 99682 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
180726 | 77634 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
183831 | 102192 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
184196 | 122755 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.404117444276 | (37.7615439863765, -122.404117444276) | 10 | 3 | 8 | 28856 | 29 | |||
36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
102801 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
136955 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
141801 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
148884 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
149548 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
156105 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
162950 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
173815 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998921.08183 | 2091519.29315 | 37.7228516427808 | -122.445846526795 | (37.7228516427808, -122.445846526795) | 9 | 7 | 6 | 28861 | 25 | |||
176521 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard | Tree | MTA 3 | 7 | Width 5ft | 5998933.17773 | 2091518.16383 | 37.7228492325857 | -122.445804632792 | (37.7228492325857, -122.445804632792) | 9 | 7 | 6 | 28861 | 25 | |||
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
250 | 248390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998825.2199 | 2108039.7272 | 37.7682072798204 | -122.447366392326 | (37.7682072798204, -122.447366392326) | 15 | 5 | 11 | 29492 | 9 | |||
475 | 102627 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001422 | 2115424 | 37.7886306717674 | -122.438913657053 | (37.7886306717674, -122.438913657053) | 13 | 6 | 1 | 29490 | 27 | |||
573 | 227463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 238 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999836.92244 | 2105557.8617 | 37.7614504560077 | -122.443688706966 | (37.7614504560077, -122.443688706966) | 15 | 5 | 5 | 28862 | 3 | |||
918 | 62597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.497309882833 | (37.7744677278845, -122.497309882833) | 11 | 6 | 2 | 55 | 26 | |
1173 | 227375 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006792.16678 | 2101508.46009 | 37.7507259731465 | -122.419346074576 | (37.7507259731465, -122.419346074576) | 2 | 4 | 7 | 28859 | 19 | |||
1250 | 227382 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008243.43201 | 2102726.48966 | 37.7541520375997 | -122.414413633986 | (37.7541520375997, -122.414413633986) | 2 | 4 | 7 | 28859 | 19 |
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) );