trees
2,180 rows where qSpecies_id = 57 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53821 | 9998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 122 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005390.2576582 | 2108319.0051408 | 37.7693470701553 | -122.424678431625 | (37.7693470701553, -122.424678431625) | 8 | 4 | 5 | 28853 | 19 | |||
27836 | 99747 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002274 | 2100636 | 37.7480748999105 | -122.434907877013 | (37.7480748999105, -122.434907877013) | 2 | 4 | 5 | 28862 | 22 | ||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
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 | ||
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 | |
62054 | 9946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.419357387093 | (37.8003111812757, -122.419357387093) | 5 | 1 | 1 | 28858 | 32 | |||
68439 | 99103 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 201 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006380 | 2111267.6 | 37.7774990526419 | -122.421464387784 | (37.7774990526419, -122.421464387784) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
146369 | 98326 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5999516.2 | 2114621.9 | 37.7863197000983 | -122.445449719271 | (37.7863197000983, -122.445449719271) | 15 | 6 | 1 | 29490 | 31 | |||
71710 | 98240 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 800 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
132355 | 97818 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 431 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5997175.35999 | 2114852.37402 | 37.7868186114345 | -122.453565028427 | (37.7868186114345, -122.453565028427) | 11 | 6 | 1 | 54 | 31 | |||
102355 | 96885 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
72943 | 96884 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
48518 | 96883 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
44319 | 96882 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
90220 | 96757 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 68 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005174.6 | 2107453.9 | 37.7669595167235 | -122.425362810214 | (37.7669595167235, -122.425362810214) | 8 | 4 | 5 | 28853 | 19 | |||
136788 | 96700 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
122602 | 96699 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1849 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
35027 | 96011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.64536 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) | 5 | 1 | 10 | 28857 | 21 |
63465 | 96010 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.20911 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) | 5 | 1 | 10 | 28857 | 21 |
108182 | 96009 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.90014 | 2116412.09513 | 37.7918121879409 | -122.410284212457 | (37.7918121879409, -122.410284212457) | 5 | 1 | 10 | 28857 | 21 |
108834 | 96008 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.65151 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) | 5 | 1 | 10 | 28857 | 21 |
125787 | 96007 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.7917880618207 | -122.410480028126 | (37.7917880618207, -122.410480028126) | 5 | 1 | 10 | 28857 | 21 |
13594 | 96006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009630.99676 | 2116399.7599 | 37.7917735027068 | -122.410580567837 | (37.7917735027068, -122.410580567837) | 5 | 1 | 10 | 28857 | 21 |
111216 | 94496 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1600X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | 6x7 | 5998899.3 | 2109049 | 37.7709827197678 | -122.447182803026 | (37.7709827197678, -122.447182803026) | 15 | 5 | 11 | 29492 | 9 | |||
7581 | 9343 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6000760.2622834 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | 2 | 7 | 5 | 63 | 7 | |||
83199 | 9319 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
109724 | 9317 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | ||
113239 | 93119 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000421 | 2110261 | 37.774397395284 | -122.442006222093 | (37.774397395284, -122.442006222093) | 15 | 5 | 11 | 29492 | 16 | |||
110206 | 92942 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5992043 | 2096735 | 37.73677754441 | -122.470001973507 | (37.73677754441, -122.470001973507) | 1 | 8 | 4 | 59 | 40 | ||||
156629 | 92938 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 345 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992182.7 | 2096880.8 | 37.7371859491769 | -122.469529584198 | (37.7371859491769, -122.469529584198) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
115293 | 92932 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 329 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5992099 | 2097070 | 37.7377006069055 | -122.469832741501 | (37.7377006069055, -122.469832741501) | 1 | 8 | 4 | 59 | 40 | ||||
190925 | 92919 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 362 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5991957 | 2096928 | 37.7373025018195 | -122.470313361151 | (37.7373025018195, -122.470313361151) | 1 | 8 | 4 | 59 | 40 | ||||
141850 | 92910 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 312 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5992168 | 2097141 | 37.7378995431122 | -122.469599344661 | (37.7378995431122, -122.469599344661) | 1 | 8 | 4 | 59 | 40 | ||||
131250 | 92843 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2009 12:00:00 AM | 3x3 | 6006883 | 2101475 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | 2 | 4 | 7 | 28859 | 19 | |||
53178 | 92842 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2009 12:00:00 AM | 3x3 | 6006883 | 2101475 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | 2 | 4 | 7 | 28859 | 19 | |||
146790 | 92634 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
124351 | 92632 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
171918 | 89036 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
163617 | 89035 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
68654 | 89034 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
85101 | 89033 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
68814 | 89032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
145375 | 89007 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005558 | 2104034 | 37.757590932481 | -122.42379349206 | (37.757590932481, -122.42379349206) | 2 | 4 | 5 | 28859 | 19 | ||
35329 | 88365 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411 | (37.7707473776731, -122.44194989411) | 15 | 5 | 11 | 29492 | 9 | |||
61795 | 88217 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51182 | 6002528.21368 | 2117927.18 | 37.7955666353375 | -122.435265448048 | (37.7955666353375, -122.435265448048) | 13 | 9 | 1 | 57 | 17 | |
181148 | 87383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 431 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 11 | 3x3 | Permit Number 50363 | 5997173.61731 | 2114868.15858 | 37.7868618517374 | -122.453572197813 | (37.7868618517374, -122.453572197813) | 11 | 6 | 1 | 54 | 31 | |
67290 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
129455 | 87082 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3119 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50024 | 5999240.5872 | 2116291.11958 | 37.7908872010279 | -122.446523400642 | (37.7908872010279, -122.446523400642) | 13 | 6 | 1 | 29490 | 31 | |
83738 | 85306 | - 12 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005989.138522 | 2115548.501173 | 37.7892313094718 | -122.423120870526 | (37.7892313094718, -122.423120870526) | 13 | 9 | 1 | 28858 | 41 | |||
10089 | 83062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016802.22624 | 2097268.63088 | 37.7396429656544 | -122.384434818109 | (37.7396429656544, -122.384434818109) | 10 | 3 | 8 | 58 | 1 | |||
125416 | 8121 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 850X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | |||
75426 | 8120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | |||
140957 | 7994 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2250 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | |||
78093 | 7993 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | |||
54055 | 7986 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | 13 | 9 | 1 | 28858 | 27 | |||
92842 | 7985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005519.50842 | 2117258.74677 | 37.7939007015449 | -122.424867459092 | (37.7939007015449, -122.424867459092) | 13 | 9 | 1 | 28858 | 27 | |||
121081 | 7978 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2020 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005621.04444 | 2116972.96262 | 37.7931217447269 | -122.424495796768 | (37.7931217447269, -122.424495796768) | 13 | 9 | 1 | 28858 | 27 | |||
106136 | 7975 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2003 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005570.14471 | 2116971.51831 | 37.7931149044793 | -122.42467181028 | (37.7931149044793, -122.42467181028) | 13 | 9 | 1 | 28858 | 27 | |||
28045 | 7974 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005597.93587 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | 13 | 9 | 1 | 28858 | 27 | |||
121590 | 7972 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1950 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005640.29534 | 2116816.43094 | 37.7926930351995 | -122.424418048575 | (37.7926930351995, -122.424418048575) | 13 | 9 | 1 | 28858 | 27 | |||
148932 | 7971 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1950 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005647.3062 | 2116796.91124 | 37.7926398349056 | -122.42439240169 | (37.7926398349056, -122.42439240169) | 13 | 9 | 1 | 28858 | 27 | |||
90876 | 7970 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1930 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005659.59563 | 2116718.6943 | 37.7924257647952 | -122.424344314057 | (37.7924257647952, -122.424344314057) | 13 | 9 | 1 | 28858 | 27 | |||
96608 | 7969 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1920 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005664.22303 | 2116673.38884 | 37.7923016286726 | -122.42432507934 | (37.7923016286726, -122.42432507934) | 13 | 9 | 1 | 28858 | 27 | |||
164140 | 7967 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1901 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005619.52925 | 2116640.16995 | 37.7922078941213 | -122.424477357045 | (37.7922078941213, -122.424477357045) | 13 | 9 | 1 | 28858 | 27 | |||
148456 | 7966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1901 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005614.52229 | 2116667.02972 | 37.7922813615542 | -122.424496592638 | (37.7922813615542, -122.424496592638) | 13 | 9 | 1 | 28858 | 27 | |||
52203 | 7963 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1840 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005718.27737 | 2116441.98594 | 37.7916693064652 | -122.424121585933 | (37.7916693064652, -122.424121585933) | 13 | 9 | 1 | 28858 | 27 | |||
150509 | 7960 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1800 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005701.62625 | 2116374.60015 | 37.7914833418188 | -122.42417440425 | (37.7914833418188, -122.42417440425) | 13 | 9 | 1 | 28858 | 27 | |||
86634 | 7959 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1800 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005709.66614 | 2116337.52814 | 37.791382005314 | -122.424143948706 | (37.791382005314, -122.424143948706) | 13 | 9 | 1 | 28858 | 27 | |||
149510 | 7952 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1740 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005743.00192 | 2116111.24948 | 37.7907625828685 | -122.424012509171 | (37.7907625828685, -122.424012509171) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 |
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) );