trees
2,180 rows where qSpecies_id = 57 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8136 | 208000 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999487.48138 | 2094942.52217 | 37.7322833591869 | -122.444134470345 | (37.7322833591869, -122.444134470345) | 9 | 7 | 4 | 63 | 40 | |||
23570 | 122138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.474534863989 | (37.7868169072323, -122.474534863989) | 11 | 6 | 1 | 54 | 33 | ||||
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 | |||
49625 | 207942 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992674.85425 | 2100498.92504 | 37.7471488342516 | -122.468091108325 | (37.7471488342516, -122.468091108325) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |
55358 | 129661 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009779.91781 | 2121666.56674 | 37.8062432068281 | -122.41043735801 | (37.8062432068281, -122.41043735801) | 3 | 1 | 10 | 308 | 23 | |||
57516 | 129652 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009798.02273 | 2121850.39999 | 37.8067489819353 | -122.410387691144 | (37.8067489819353, -122.410387691144) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||||
77998 | 191459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6014515.87712 | 2115897.32843 | 37.7906665955326 | -122.393643582697 | (37.7906665955326, -122.393643582697) | 12 | 2 | 9 | 28855 | 6 | |||
85696 | 207904 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991482.67128 | 2097068.49544 | 37.7376608310875 | -122.471963555773 | (37.7376608310875, -122.471963555773) | 1 | 8 | 4 | 29491 | 40 | |||
92933 | 227338 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008438.44095 | 2096875.57764 | 37.7380976866659 | -122.41332550649 | (37.7380976866659, -122.41332550649) | 10 | 7 | 7 | 28859 | 2 | |||
94177 | 129671 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009327.56968 | 2121786.16938 | 37.8065462369833 | -122.412011249831 | (37.8065462369833, -122.412011249831) | 3 | 1 | 10 | 308 | 23 | |||
99709 | 27655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006765.6884 | 2108667.1143 | 37.7703804801687 | -122.419945578015 | (37.7703804801687, -122.419945578015) | 8 | 2 | 9 | 28853 | 19 | |||
101427 | 227460 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Corbin Pl | 9 | Side Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | 15 | 5 | 5 | 28862 | 3 | |||
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 | ||
110548 | 250116 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006001.66865 | 2115410.83979 | 37.7888540326289 | -122.423067729093 | (37.7888540326289, -122.423067729093) | 13 | 9 | 1 | 28858 | 41 | |||
121474 | 207871 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5992427.77388 | 2104765.50377 | 37.7588494808325 | -122.469255976794 | (37.7588494808325, -122.469255976794) | 1 | 8 | 4 | 56 | 12 | |||
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 | |
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 | ||
138818 | 227220 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007878.47133 | 2104829.72546 | 37.7599065331661 | -122.415824681956 | (37.7599065331661, -122.415824681956) | 2 | 4 | 7 | 28859 | 19 | |||
139672 | 207824 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998157.01661 | 2093811.48705 | 37.7291018131794 | -122.448652738959 | (37.7291018131794, -122.448652738959) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |
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 | ||||
168982 | 177058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998964.8504 | 2090194.57209 | 37.7192167629302 | -122.445600013628 | (37.7192167629302, -122.445600013628) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
172386 | 207866 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 374 Irving St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995689.69251 | 2106690.80313 | 37.7643238106111 | -122.458114159946 | (37.7643238106111, -122.458114159946) | 15 | 5 | 11 | 56 | 12 | |||
173087 | 23385 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006030.41853 | 2115547.69719 | 37.7892314313446 | -122.422977989336 | (37.7892314313446, -122.422977989336) | 13 | 9 | 1 | 28858 | 41 | |||
175144 | 129564 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2399 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999360.9422 | 2120457.57627 | 37.8023340544371 | -122.446406844005 | (37.8023340544371, -122.446406844005) | 13 | 9 | 1 | 57 | 17 | |||
185273 | 177130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006962.96943 | 2093340.12514 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | 9 | 3 | 7 | 309 | 5 | |||
2778 | 227271 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001729.31648 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | 2 | 7 | 5 | 63 | 22 | |||
6482 | 120477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5988623.03819 | 2114641.82381 | 37.785746527658 | -122.483138270198 | (37.785746527658, -122.483138270198) | 11 | 6 | 2 | 55 | 26 | |||
16833 | 23387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006004.32963 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | 13 | 9 | 1 | 28858 | 41 | |||
18458 | 191458 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6014482.2077 | 2115927.08829 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |
28121 | 113967 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658 | 2107333 | 37.7669917162652 | -122.402929122897 | (37.7669917162652, -122.402929122897) | 8 | 2 | 8 | 28853 | 20 | ||||
30045 | 207903 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991490.36095 | 2097069.60585 | 37.7376643249521 | -122.471937050068 | (37.7376643249521, -122.471937050068) | 1 | 8 | 4 | 29491 | 40 | |||
35183 | 15320 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2004 12:00:00 AM | 3 | 3X3 | 6006776.8374 | 2108697.9883 | 37.7704658809505 | -122.419909204722 | (37.7704658809505, -122.419909204722) | 8 | 2 | 9 | 28853 | 19 | ||
40930 | 103608 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
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 | |||||
53296 | 207943 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992681.5782 | 2100498.78362 | 37.7471488342639 | -122.468067847362 | (37.7471488342639, -122.468067847362) | 1 | 8 | 4 | 29491 | 40 | |||
57293 | 226687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 22nd St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6011241.49222 | 2103724.78971 | 37.7570611132947 | -122.404115802095 | (37.7570611132947, -122.404115802095) | 10 | 4 | 8 | 28859 | 19 | ||||
67102 | 129660 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009777.61633 | 2121686.62202 | 37.8062981445983 | -122.410446739741 | (37.8062981445983, -122.410446739741) | 3 | 1 | 10 | 308 | 23 | |||
78441 | 129651 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 2 | Width 3ft | 6009800.43185 | 2121827.80217 | 37.8066870690198 | -122.410377757248 | (37.8066870690198, -122.410377757248) | 3 | 1 | 10 | 308 | 23 | ||
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 | ||||
89858 | 177129 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006955.53979 | 2093363.24603 | 37.7283702254814 | -122.418203699955 | (37.7283702254814, -122.418203699955) | 9 | 3 | 7 | 309 | 5 | |||
91189 | 129670 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009329.84162 | 2121764.6853 | 37.8064873745564 | -122.412001868104 | (37.8064873745564, -122.412001868104) | 3 | 1 | 10 | 308 | 23 | |||
100754 | 177057 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998963.19339 | 2090191.18353 | 37.7192073641203 | -122.445605497718 | (37.7192073641203, -122.445605497718) | 9 | 7 | 6 | 28861 | 25 | |||
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 |
113097 | 129681 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6012011.03614 | 2116789.35281 | 37.7929763782966 | -122.402372995143 | (37.7929763782966, -122.402372995143) | 4 | 1 | 10 | 28854 | 6 | |||
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 | ||
132875 | 207870 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5992427.18816 | 2104766.73387 | 37.7588528245185 | -122.469258092 | (37.7588528245185, -122.469258092) | 1 | 8 | 4 | 56 | 12 | |||
134620 | 227193 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 434 Banks St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008555.86345 | 2096552.67511 | 37.7372176586621 | -122.412896693524 | (37.7372176586621, -122.412896693524) | 10 | 7 | 7 | 28859 | 2 | |||
140147 | 250115 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006022.68533 | 2115414.23246 | 37.7888645340073 | -122.422995255427 | (37.7888645340073, -122.422995255427) | 13 | 9 | 1 | 28858 | 41 | |||
152335 | 207986 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 714 Detroit St | 8 | Side Yard : Yard | Tree | Private 2 | 7 | 5999466.52885 | 2095410.65053 | 37.7335675344178 | -122.444240535497 | (37.7335675344178, -122.444240535497) | 9 | 7 | 4 | 63 | 40 | ||||
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 | ||||
168813 | 191432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6010899.91125 | 2105517.41089 | 37.7619641586404 | -122.405423368691 | (37.7619641586404, -122.405423368691) | 10 | 3 | 8 | 28856 | 29 | ||||
179043 | 207823 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998174.84145 | 2093811.63794 | 37.7291032467189 | -122.448591128189 | (37.7291032467189, -122.448591128189) | 9 | 7 | 4 | 28861 | 40 | |||
181449 | 122137 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083 | (37.786826966306, -122.47453884083) | 11 | 6 | 1 | 54 | 33 | ||||
185197 | 227339 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008435.91827 | 2096862.8615 | 37.7380626292878 | -122.413333329675 | (37.7380626292878, -122.413333329675) | 10 | 7 | 7 | 28859 | 2 | |||
188622 | 227258 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6005985.64044 | 2096389.90351 | 37.7366261169846 | -122.421771586598 | (37.7366261169846, -122.421771586598) | 2 | 7 | 7 | 28859 | 2 | |||
189529 | 207999 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5999487.38528 | 2094945.27116 | 37.7322909017866 | -122.444135000045 | (37.7322909017866, -122.444135000045) | 9 | 7 | 4 | 63 | 40 | |||
193271 | 177064 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 102 France Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | 9 | 7 | 6 | 28861 | 5 | |||
193927 | 6754 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
4363 | 227340 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008451 | 2096866 | 37.7380720936745 | -122.413281406339 | (37.7380720936745, -122.413281406339) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
31380 | 227459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Corbin Pl | 7 | Side Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000082.87905 | 2105698.79506 | 37.761851449312 | -122.442848168232 | (37.761851449312, -122.442848168232) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||||
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 | ||
51228 | 177056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998961.55007 | 2090188.45269 | 37.71919977204 | -122.445610981758 | (37.71919977204, -122.445610981758) | 9 | 7 | 6 | 28861 | 25 | |||
58782 | 129669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009331.79783 | 2121743.36685 | 37.8064289491925 | -122.411993590749 | (37.8064289491925, -122.411993590749) | 3 | 1 | 10 | 308 | 23 | |||
62320 | 129640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1201 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007123.06001 | 2119804.16548 | 37.8009802258023 | -122.419499676077 | (37.8009802258023, -122.419499676077) | 5 | 1 | 1 | 28858 | 32 | |||
68645 | 226757 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 209 Day St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6004291.47259 | 2098662.30016 | 37.7427699165123 | -122.427790919941 | (37.7427699165123, -122.427790919941) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||||
77439 | 227175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 146 Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997854.99117 | 2106199.18059 | 37.7630981165085 | -122.450589589933 | (37.7630981165085, -122.450589589933) | 15 | 5 | 11 | 29492 | 9 | |||
79679 | 191457 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6014474.34711 | 2115936.1277 | 37.7907708215543 | -122.393789992334 | (37.7907708215543, -122.393789992334) | 12 | 2 | 9 | 28855 | 6 | |||
81473 | 207835 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1209 Capitol Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995030.31814 | 2091918.85126 | 37.7237258071947 | -122.459324908222 | (37.7237258071947, -122.459324908222) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
85895 | 207998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999486.80728 | 2094946.96177 | 37.7322955108311 | -122.444137119754 | (37.7322955108311, -122.444137119754) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||||
97403 | 207924 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993576.36868 | 2095065.49282 | 37.7322820128957 | -122.464579299802 | (37.7322820128957, -122.464579299802) | 9 | 8 | 4 | 59 | 40 | |||
107807 | 103607 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
108129 | 207902 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991496.24681 | 2097069.99079 | 37.7376657224794 | -122.471916728076 | (37.7376657224794, -122.471916728076) | 1 | 8 | 4 | 29491 | 40 | |||
109873 | 177128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006947.17025 | 2093387.19061 | 37.7284355009944 | -122.418234330861 | (37.7284355009944, -122.418234330861) | 9 | 3 | 7 | 309 | 5 | |||
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 |
113912 | 207962 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Woodside Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995734.92484 | 2100251.73667 | 37.7466463650506 | -122.45749181559 | (37.7466463650506, -122.45749181559) | 1 | 5 | 4 | 59 | 40 | |||
115045 | 207857 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993273.27728 | 2090450.48631 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | 9 | 8 | 6 | 64 | 24 | |||
116491 | 249354 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Leavenworth St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008321.82308 | 2114687.6754 | 37.7869990523159 | -122.414989085893 | (37.7869990523159, -122.414989085893) | 13 | 1 | 9 | 28858 | 36 | |||
117074 | 250114 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006046.02245 | 2115417.23585 | 37.7888740974074 | -122.422914725648 | (37.7888740974074, -122.422914725648) | 13 | 9 | 1 | 28858 | 41 | |||
119438 | 122136 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5991117.00305 | 2114994.02901 | 37.7868583993583 | -122.47453565898 | (37.7868583993583, -122.47453565898) | 11 | 6 | 1 | 54 | 33 | ||||
120021 | 17747 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005995.83513 | 2115543.3505 | 37.7892175449029 | -122.423097334789 | (37.7892175449029, -122.423097334789) | 13 | 9 | 1 | 28858 | 41 | |||
127774 | 6762 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782839 | (37.7386467866108, -122.38268782839) | 10 | 3 | 8 | 58 | 1 | ||
127846 | 227194 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 434 Banks St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008558.34873 | 2096582.15264 | 37.737298737043 | -122.412890184243 | (37.737298737043, -122.412890184243) | 10 | 7 | 7 | 28859 | 2 | |||
136111 | 113966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6011669.86697 | 2107203.74799 | 37.7666374820482 | -122.402878985182 | (37.7666374820482, -122.402878985182) | 8 | 2 | 8 | 28853 | 20 | |||
146811 | 129650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009803.21453 | 2121807.89591 | 37.8066325673946 | -122.410366720757 | (37.8066325673946, -122.410366720757) | 3 | 1 | 10 | 308 | 23 | |||
149137 | 227257 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6006008.96633 | 2096389.42446 | 37.7366261169982 | -122.421690904818 | (37.7366261169982, -122.421690904818) | 2 | 7 | 7 | 28859 | 2 | |||
151354 | 129659 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009774.54384 | 2121707.96355 | 37.8063565708655 | -122.410458880595 | (37.8063565708655, -122.410458880595) | 3 | 1 | 10 | 308 | 23 | |||
168819 | 247878 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 388 Mayflower St | 7 | Side Yard : Yard | Tree | Private 2 | 7 | 6009913.73125 | 2098387.19098 | 37.7423309691095 | -122.408331258187 | (37.7423309691095, -122.408331258187) | 10 | 7 | 7 | 28859 | 2 | ||||
169260 | 207868 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1541 12th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5992426.05558 | 2104800.10163 | 37.7589443781928 | -122.46926443762 | (37.7589443781928, -122.46926443762) | 1 | 8 | 4 | 56 | 12 | |||
169794 | 129680 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012023.67826 | 2116790.52383 | 37.7929802993494 | -122.40232933485 | (37.7929802993494, -122.40232933485) | 4 | 1 | 10 | 28854 | 6 | |||
171355 | 227270 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001726.6658 | 2099973.10248 | 37.7462236486214 | -122.43675308951 | (37.7462236486214, -122.43675308951) | 2 | 7 | 5 | 63 | 22 |
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) );