trees
7,157 rows where qSpecies_id = 36 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130844 | 234224 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999289.876 | 2107671.91305 | 37.7672238957976 | -122.445732744568 | (37.7672238957976, -122.445732744568) | 15 | 5 | 5 | 29492 | 9 | |||
131117 | 245088 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 120 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000333.8152 | 2109484.8426 | 37.7722612943898 | -122.442252080471 | (37.7722612943898, -122.442252080471) | 15 | 5 | 11 | 29492 | 9 | |||
134374 | 236102 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 87 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002831.35347 | 2108779.93542 | 37.7704678187661 | -122.433562497221 | (37.7704678187661, -122.433562497221) | 15 | 5 | 5 | 29492 | 9 | |||
135585 | 234214 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 852 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998731.1279 | 2107040.18435 | 37.7654574105555 | -122.447619884669 | (37.7654574105555, -122.447619884669) | 15 | 5 | 11 | 29492 | 9 | |||
136532 | 122504 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1235 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999347.5913 | 2108562.9387 | 37.7696737226303 | -122.445597197572 | (37.7696737226303, -122.445597197572) | 15 | 5 | 11 | 29492 | 9 | ||||
137423 | 248341 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 12 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998806.4445 | 2108179.6343 | 37.7685903563749 | -122.447441405844 | (37.7685903563749, -122.447441405844) | 15 | 5 | 11 | 29492 | 9 | |||
139781 | 5171 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 326 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1990 12:00:00 AM | 6 | 3X3 | 6001797.4433 | 2109582.7514 | 37.7726134355257 | -122.437196281778 | (37.7726134355257, -122.437196281778) | 15 | 5 | 11 | 29492 | 9 | ||
141546 | 246208 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1370 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999571.5422 | 2107962.9601 | 37.7680391156288 | -122.444779428494 | (37.7680391156288, -122.444779428494) | 15 | 5 | 11 | 29492 | 9 | |||
141598 | 246931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 343 Frederick St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 5998355.56694 | 2107545.5996 | 37.7668236821967 | -122.448955269095 | (37.7668236821967, -122.448955269095) | 15 | 5 | 11 | 29492 | 9 | |||
142049 | 244179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1923 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997336.8906 | 2108781.9808 | 37.7701601573691 | -122.452567921078 | (37.7701601573691, -122.452567921078) | 15 | 5 | 11 | 29492 | 9 | |||
143521 | 234222 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 242 Upper Ter | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5999490.49615 | 2106181.27388 | 37.7631424261039 | -122.444931663573 | (37.7631424261039, -122.444931663573) | 15 | 5 | 5 | 29492 | 9 | |||
143691 | 247467 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 401 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003188.1538 | 2109715.7925 | 37.7730576900371 | -122.43239517552 | (37.7730576900371, -122.43239517552) | 15 | 9 | 11 | 29492 | 9 | |||
144355 | 247336 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 399 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003213.908 | 2109535.2867 | 37.7725635258846 | -122.432293194636 | (37.7725635258846, -122.432293194636) | 15 | 9 | 11 | 29492 | 9 | |||
144672 | 102359 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 399 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 24435 | 6003200 | 2109625 | 37.772809067914 | -122.432347712361 | (37.772809067914, -122.432347712361) | 15 | 9 | 11 | 29492 | 9 | ||
144756 | 10328 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 820 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002200.749 | 2109167.913 | 37.7714973097013 | -122.435771521087 | (37.7714973097013, -122.435771521087) | 15 | 5 | 11 | 29492 | 9 | |||
146865 | 235072 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1136 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998920.04785 | 2105995.59166 | 37.7626000161968 | -122.446891282714 | (37.7626000161968, -122.446891282714) | 15 | 5 | 5 | 29492 | 9 | |||
146938 | 5153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 251 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1990 12:00:00 AM | 6 | 3X3 | 6001788.2748 | 2109168.2263 | 37.7714747315645 | -122.437198311096 | (37.7714747315645, -122.437198311096) | 15 | 5 | 11 | 29492 | 9 | ||
149002 | 246209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1369 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999529.1461 | 2107961.4459 | 37.7680325384959 | -122.444925962649 | (37.7680325384959, -122.444925962649) | 15 | 5 | 11 | 29492 | 9 | |||
149585 | 97927 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | Permit Number 12389 | 5997436 | 2106416 | 37.7636694565674 | -122.452054375547 | (37.7636694565674, -122.452054375547) | 15 | 5 | 11 | 29492 | 9 | |||
150569 | 236107 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 76 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002884.6374 | 2108734.07424 | 37.7703449183216 | -122.433374910325 | (37.7703449183216, -122.433374910325) | 15 | 5 | 5 | 29492 | 9 | |||
150781 | 221706 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1242 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5998236.32564 | 2106048.29156 | 37.7627056325849 | -122.449259817288 | (37.7627056325849, -122.449259817288) | 15 | 5 | 11 | 29492 | 9 | |||
151083 | 94459 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 209 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998946 | 2106961 | 37.7652522679777 | -122.446870995634 | (37.7652522679777, -122.446870995634) | 15 | 5 | 11 | 29492 | 9 | ||||
151293 | 248540 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 801 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997613.2979 | 2107765.3641 | 37.7673846212673 | -122.451538496032 | (37.7673846212673, -122.451538496032) | 15 | 5 | 11 | 29492 | 9 | |||
152802 | 245034 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1277 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000494.4463 | 2109229.6688 | 37.7715698048605 | -122.441678128858 | (37.7715698048605, -122.441678128858) | 15 | 5 | 11 | 29492 | 9 | |||
154561 | 245033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1277 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000474.9963 | 2109228.72 | 37.7715660914872 | -122.441745339211 | (37.7715660914872, -122.441745339211) | 15 | 5 | 11 | 29492 | 9 | |||
155087 | 247228 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 754 Duboce Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6002077.4337 | 2108306.87592 | 37.769126109423 | -122.436136447766 | (37.769126109423, -122.436136447766) | 15 | 5 | 5 | 29492 | 9 | |||
157009 | 246928 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 353 Frederick St | 1 | : | Tree | Private 2 | 20 | Width 4ft | 5998287.77397 | 2107536.30237 | 37.7667942770619 | -122.449189082904 | (37.7667942770619, -122.449189082904) | 15 | 5 | 11 | 29492 | 9 | |||
157959 | 235078 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 172 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999431.23903 | 2107199.48847 | 37.7659348066594 | -122.445209823002 | (37.7659348066594, -122.445209823002) | 15 | 5 | 5 | 29492 | 9 | |||
158294 | 31684 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 199 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35189 | 5997261.38189671 | 2107041.72248487 | 37.7653775273705 | -122.452703485118 | (37.7653775273705, -122.452703485118) | 15 | 5 | 11 | 29492 | 9 | |||
159115 | 246380 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1237 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999422.7017 | 2108560.5932 | 37.7696715703395 | -122.445337225361 | (37.7696715703395, -122.445337225361) | 15 | 5 | 11 | 29492 | 9 | |||
161140 | 247335 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 399 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003210.1975 | 2109560.1999 | 37.7726317210107 | -122.432307809235 | (37.7726317210107, -122.432307809235) | 15 | 9 | 11 | 29492 | 9 | |||
161433 | 234221 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 242 Upper Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5999506.47767 | 2106197.26722 | 37.7631872519103 | -122.444877538783 | (37.7631872519103, -122.444877538783) | 15 | 5 | 5 | 29492 | 9 | |||
165507 | 246246 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 90 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999701.153 | 2107777.9315 | 37.767538469237 | -122.444317821901 | (37.767538469237, -122.444317821901) | 15 | 5 | 11 | 29492 | 9 | |||
166063 | 5152 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 251 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2007 12:00:00 AM | 3 | 3X3 | 6001785.2834 | 2109187.8368 | 37.7715284070769 | -122.437210062841 | (37.7715284070769, -122.437210062841) | 15 | 5 | 11 | 29492 | 9 | ||
167034 | 10495 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | 15 | 5 | 11 | 29492 | 9 | |||
167305 | 246919 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 419 Frederick St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 5997808.62932 | 2107469.47498 | 37.7665833689406 | -122.450841537706 | (37.7665833689406, -122.450841537706) | 15 | 5 | 11 | 29492 | 9 | |||
168883 | 246922 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 417 Frederick St | 2 | : | Tree | Private 2 | 15 | Width 4ft | 5997854.3485 | 2107475.00928 | 37.7666011818151 | -122.45068380291 | (37.7666011818151, -122.45068380291) | 15 | 5 | 11 | 29492 | 9 | |||
170974 | 247471 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 832 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002566.8873 | 2109564.8892 | 37.7726080991396 | -122.434533419986 | (37.7726080991396, -122.434533419986) | 15 | 5 | 11 | 29492 | 9 | |||
171786 | 235068 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 205 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998939.38523 | 2106968.04956 | 37.7652712464017 | -122.446894381778 | (37.7652712464017, -122.446894381778) | 15 | 5 | 11 | 29492 | 9 | |||
172073 | 234040 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 93 Scott St | 2 | : | Tree | Private 2 | 17 | Width 4ft | 6002349.12315 | 2108730.62809 | 37.7703050603571 | -122.435227004733 | (37.7703050603571, -122.435227004733) | 15 | 5 | 5 | 29492 | 9 | |||
172449 | 236106 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 47 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002861.76275 | 2108549.18088 | 37.7698359488 | -122.433440818943 | (37.7698359488, -122.433440818943) | 15 | 5 | 5 | 29492 | 9 | |||
172969 | 247263 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1547 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999298.409 | 2109064.9562 | 37.7710493275536 | -122.445803426226 | (37.7710493275536, -122.445803426226) | 15 | 5 | 11 | 29492 | 9 | |||
173514 | 234212 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998629.83807 | 2107280.41528 | 37.7661112347632 | -122.447987519429 | (37.7661112347632, -122.447987519429) | 15 | 5 | 11 | 29492 | 9 | |||
174215 | 235076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 144 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999453.63616 | 2106546.58256 | 37.7641433688325 | -122.44508541348 | (37.7641433688325, -122.44508541348) | 15 | 5 | 5 | 29492 | 9 | |||
176374 | 52143 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1357 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48324 | 5999514.23601743 | 2108029.65989982 | 37.768218986019 | -122.444982439169 | (37.768218986019, -122.444982439169) | 15 | 5 | 11 | 29492 | 9 | ||
178534 | 221739 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 960 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 3ft | 5997261.09109 | 2107110.0824 | 37.7655652095945 | -122.452709425124 | (37.7655652095945, -122.452709425124) | 15 | 5 | 11 | 29492 | 9 | |||
178559 | 102485 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1501X Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999365.6 | 2109075.3 | 37.7710815652008 | -122.445571755181 | (37.7710815652008, -122.445571755181) | 15 | 5 | 11 | 29492 | 9 | ||||
181450 | 248569 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 328 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998418.8233 | 2107598.8081 | 37.7669733966711 | -122.448740309535 | (37.7669733966711, -122.448740309535) | 15 | 5 | 11 | 29492 | 9 | |||
181834 | 248589 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 838 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997679.1632 | 2107620.1575 | 37.7669896925779 | -122.451300204556 | (37.7669896925779, -122.451300204556) | 15 | 5 | 11 | 29492 | 9 | |||
182590 | 246389 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1267 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999655.2744 | 2108419.1721 | 37.7692965369897 | -122.444522601091 | (37.7692965369897, -122.444522601091) | 15 | 5 | 11 | 29492 | 9 | |||
182710 | 247334 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 399 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003207.0171 | 2109588.8236 | 37.7727101343112 | -122.432320855239 | (37.7727101343112, -122.432320855239) | 15 | 9 | 11 | 29492 | 9 | |||
183053 | 51505 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 669 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | Permit Number 47815 | 5997540.70991297 | 2108257.09815627 | 37.7687306401362 | -122.451825044516 | (37.7687306401362, -122.451825044516) | 15 | 5 | 11 | 29492 | 9 | |||
183108 | 99680 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
185659 | 39971 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 120 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43989 | 6000362.27717462 | 2109312.40872014 | 37.7717894564736 | -122.442141248293 | (37.7717894564736, -122.442141248293) | 15 | 5 | 11 | 29492 | 9 | ||
185840 | 236104 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 67 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002842.56959 | 2108684.34504 | 37.7702059874511 | -122.433516868323 | (37.7702059874511, -122.433516868323) | 15 | 5 | 5 | 29492 | 9 | |||
186368 | 236116 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 139 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003320.47554 | 2108734.91383 | 37.7703719402379 | -122.431867407359 | (37.7703719402379, -122.431867407359) | 15 | 9 | 5 | 29492 | 9 | |||
186606 | 248366 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1335 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999499.0146 | 2108169.9437 | 37.7686033012576 | -122.445045174599 | (37.7686033012576, -122.445045174599) | 15 | 5 | 11 | 29492 | 9 | |||
188298 | 245873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 230 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001287.71 | 2109606.3036 | 37.7726491151375 | -122.438961187116 | (37.7726491151375, -122.438961187116) | 15 | 5 | 11 | 29492 | 9 | |||
188394 | 246205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1357 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999520.6669 | 2108013.8353 | 37.7681759026799 | -122.444959057744 | (37.7681759026799, -122.444959057744) | 15 | 5 | 11 | 29492 | 9 | |||
188534 | 234227 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1210 Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997761.79664 | 2106363.60396 | 37.7635442467959 | -122.450923773515 | (37.7635442467959, -122.450923773515) | 15 | 5 | 11 | 29492 | 9 | |||
194110 | 236117 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003342.25441 | 2108624.99064 | 37.7700713526377 | -122.431784224572 | (37.7700713526377, -122.431784224572) | 15 | 9 | 5 | 29492 | 9 | |||
194459 | 248440 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 724 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Permit Number 788001 | 5997627.8337 | 2107978.5557 | 37.7679708233346 | -122.451503597918 | (37.7679708233346, -122.451503597918) | 15 | 5 | 11 | 29492 | 9 | ||
83308 | 246892 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 518 Frederick St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5997047.74113 | 2107409.49515 | 37.7663750931603 | -122.453468970923 | (37.7663750931603, -122.453468970923) | 15 | 5 | 11 | 29492 | 8 | |||
167194 | 246893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 520 Frederick St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997024.70855 | 2107406.99938 | 37.7663669201092 | -122.45354845569 | (37.7663669201092, -122.45354845569) | 15 | 5 | 11 | 29492 | 8 | |||
5952 | 9359 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 248 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001030.76503 | 2098329.85795 | 37.7416721140896 | -122.439041675227 | (37.7416721140896, -122.439041675227) | 2 | 7 | 5 | 63 | 7 | ||
11160 | 243737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3 | Width 3ft | Permit Number 42146 | 6003566.61414 | 2096423.59732 | 37.7365819207118 | -122.430137601881 | (37.7365819207118, -122.430137601881) | 2 | 7 | 5 | 63 | 7 | |
15195 | 211662 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Brompton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002143.70362 | 2095479.08195 | 37.7339078054814 | -122.434989676339 | (37.7339078054814, -122.434989676339) | 2 | 7 | 5 | 63 | 7 | |||
19435 | 211660 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002152.71446 | 2095506.80314 | 37.7339844331387 | -122.434960505045 | (37.7339844331387, -122.434960505045) | 2 | 7 | 5 | 63 | 7 | |||
21565 | 235058 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 459 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003542.9119 | 2096359.45447 | 37.7364044565879 | -122.430214975956 | (37.7364044565879, -122.430214975956) | 2 | 7 | 5 | 63 | 7 | |||
21808 | 2253 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 40 Brompton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/1990 12:00:00 AM | 6 | 3X3 | 6002131.11056 | 2095479.12403 | 37.7339072059768 | -122.435033217323 | (37.7339072059768, -122.435033217323) | 2 | 7 | 5 | 63 | 7 | ||
23380 | 236149 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 74 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003623.44985 | 2097893.78964 | 37.7406219514548 | -122.43004594206 | (37.7406219514548, -122.43004594206) | 2 | 7 | 5 | 63 | 7 | |||
23963 | 2249 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002175.63898 | 2095478.72159 | 37.7339086292652 | -122.434879240483 | (37.7339086292652, -122.434879240483) | 2 | 7 | 5 | 63 | 7 | ||
25442 | 236163 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 136 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004316.79506 | 2097329.09834 | 37.7391106812228 | -122.427608398006 | (37.7391106812228, -122.427608398006) | 2 | 7 | 5 | 63 | 7 | |||
25681 | 236178 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 24 Addison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003507.58493 | 2096904.50368 | 37.7378990363042 | -122.430375992359 | (37.7378990363042, -122.430375992359) | 2 | 7 | 5 | 63 | 7 | |||
28435 | 236181 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 32 Harry St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6003220.63755 | 2097676.79622 | 37.7400033159045 | -122.431423224995 | (37.7400033159045, -122.431423224995) | 2 | 7 | 5 | 63 | 7 | ||||
28572 | 236176 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 44 Miguel St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6003678.32801 | 2097312.06482 | 37.7390277763068 | -122.429814711994 | (37.7390277763068, -122.429814711994) | 2 | 7 | 5 | 63 | 7 | ||||
30049 | 235057 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 109 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003455.05837 | 2096167.54613 | 37.7358725435864 | -122.430505033389 | (37.7358725435864, -122.430505033389) | 2 | 7 | 5 | 63 | 7 | |||
33835 | 26485 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 168 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6000891.06606 | 2098710.64377 | 37.7427097122815 | -122.439551997339 | (37.7427097122815, -122.439551997339) | 2 | 7 | 5 | 63 | 7 | |||
34120 | 58949 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 91 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1980 12:00:00 AM | 3x3 | Permit Number 50911 | 6003609.463337 | 2097799.84135396 | 37.7403631988963 | -122.43008760169 | (37.7403631988963, -122.43008760169) | 2 | 7 | 5 | 63 | 7 | ||
39035 | 236159 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004325.74936 | 2097416.45831 | 37.7393510583066 | -122.427583660361 | (37.7393510583066, -122.427583660361) | 2 | 7 | 5 | 63 | 7 | |||
39950 | 236153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003754.04772 | 2097550.76904 | 37.7396874910799 | -122.42956992731 | (37.7396874910799, -122.42956992731) | 2 | 7 | 5 | 63 | 7 | |||
43176 | 94649 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 363 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53787 | 6004189 | 2098364 | 37.7419450553656 | -122.428123987508 | (37.7419450553656, -122.428123987508) | 2 | 7 | 5 | 63 | 7 | |
44623 | 235056 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 48 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003703.89788 | 2096567.53718 | 37.7369849213109 | -122.429673216262 | (37.7369849213109, -122.429673216262) | 2 | 7 | 5 | 63 | 7 | |||
45459 | 236183 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 7 | Width 2ft | 6002335.35488 | 2096511.41776 | 37.7367532424671 | -122.434400864109 | (37.7367532424671, -122.434400864109) | 2 | 7 | 5 | 63 | 7 | |||
51929 | 26473 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2011 12:00:00 AM | 1 | 3x3 | 6001353.2668 | 2098903.24503 | 37.7432648448922 | -122.437967635622 | (37.7432648448922, -122.437967635622) | 2 | 7 | 5 | 63 | 7 | ||
52957 | 235065 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2400 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | 6 | Width 2ft | Permit Number 38465 | 6001951.69941 | 2097144.86437 | 37.7384707551305 | -122.435772634203 | (37.7384707551305, -122.435772634203) | 2 | 7 | 5 | 63 | 7 | |
53170 | 2243 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11X Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3X3 | 6002237.57574 | 2095673.35187 | 37.7344465557347 | -122.434679019267 | (37.7344465557347, -122.434679019267) | 2 | 7 | 5 | 63 | 7 | ||
54823 | 236152 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6003736.81128 | 2097568.44033 | 37.7397350364308 | -122.429630783539 | (37.7397350364308, -122.429630783539) | 2 | 7 | 5 | 63 | 7 | |||
56217 | 211661 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Brompton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002149.12202 | 2095493.37369 | 37.7339473549751 | -122.434971965077 | (37.7339473549751, -122.434971965077) | 2 | 7 | 5 | 63 | 7 | |||
56243 | 236166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 291 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003722.98481 | 2097888.79785 | 37.7406138818302 | -122.4297014325 | (37.7406138818302, -122.4297014325) | 2 | 7 | 5 | 63 | 7 | |||
68054 | 235062 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 252 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001471.0215 | 2096463.17314 | 37.7365716738462 | -122.437385782342 | (37.7365716738462, -122.437385782342) | 2 | 7 | 5 | 63 | 7 | |||
68313 | 34448 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 86 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38192 | 6004275.25867273 | 2097657.15578649 | 37.7400091026953 | -122.427775380416 | (37.7400091026953, -122.427775380416) | 2 | 7 | 5 | 63 | 7 | ||
69567 | 2251 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 40 Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 8 | 3X3 | 6002140.73385 | 2095502.48934 | 37.7339719081741 | -122.435001617226 | (37.7339719081741, -122.435001617226) | 2 | 7 | 5 | 63 | 7 | ||
69637 | 236179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 204 Addison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002607.59179 | 2097588.82345 | 37.7397269991967 | -122.433536596734 | (37.7397269991967, -122.433536596734) | 2 | 7 | 5 | 63 | 7 | |||
71435 | 236156 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002802.5744 | 2096155.94381 | 37.7358037022675 | -122.432760097816 | (37.7358037022675, -122.432760097816) | 2 | 7 | 5 | 63 | 7 | |||
74814 | 236167 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 291 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003711.87551 | 2097898.41036 | 37.7406396465046 | -122.42974052962 | (37.7406396465046, -122.42974052962) | 2 | 7 | 5 | 63 | 7 | |||
75537 | 235060 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004425.97504 | 2097103.10605 | 37.7384963327505 | -122.427214809728 | (37.7384963327505, -122.427214809728) | 2 | 7 | 5 | 63 | 7 | |||
77419 | 236180 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 32 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6003238.18945 | 2097690.75977 | 37.7400426513484 | -122.431363534325 | (37.7400426513484, -122.431363534325) | 2 | 7 | 5 | 63 | 7 | ||||
78792 | 236164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 118 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004290.62535 | 2097412.66165 | 37.7393386467599 | -122.427704833222 | (37.7393386467599, -122.427704833222) | 2 | 7 | 5 | 63 | 7 | |||
80092 | 236145 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 36 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004257.50092 | 2098060.41158 | 37.7411153464848 | -122.427865506099 | (37.7411153464848, -122.427865506099) | 2 | 7 | 5 | 63 | 7 |
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) );