trees
3,267 rows where qSpecies_id = 67 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69309 | 125768 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2016 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 5 | Width 3ft | Permit Number 33440 | 6002127.62309 | 2119848.58748 | 37.8008195610256 | -122.43678917031 | (37.8008195610256, -122.43678917031) | 13 | 9 | 1 | 57 | 17 | |
71598 | 250071 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1520 Gough St | 3 | : | Tree | Private 2 | 9 | Width 4ft | 6005405.66402 | 2115050.94063 | 37.7878321887404 | -122.425104206101 | (37.7878321887404, -122.425104206101) | 13 | 9 | 1 | 28858 | 41 | |||
71825 | 125803 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6002008.1217 | 2121228.27649 | 37.8046010303654 | -122.43730154104 | (37.8046010303654, -122.43730154104) | 13 | 9 | 1 | 57 | 17 | |||
74980 | 115241 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2401 FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6005332 | 2118242 | 37.7965898731316 | -122.425586268684 | (37.7965898731316, -122.425586268684) | 13 | 9 | 1 | 57 | 17 | |||
77050 | 140752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000404.091 | 2112884.1722 | 37.7815989943159 | -122.442253061461 | (37.7815989943159, -122.442253061461) | 15 | 5 | 1 | 29490 | 16 | |||
79372 | 125741 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001003.19261 | 2118734.07853 | 37.7976954457528 | -122.440600176954 | (37.7976954457528, -122.440600176954) | 13 | 9 | 1 | 57 | 17 | |||
79479 | 125797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002015.52454 | 2121185.67578 | 37.8044844809378 | -122.437272870653 | (37.8044844809378, -122.437272870653) | 13 | 9 | 1 | 57 | 17 | |||
79727 | 13246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2361 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001096.9833 | 2119276.5389 | 37.7991902392326 | -122.440314559231 | (37.7991902392326, -122.440314559231) | 13 | 9 | 1 | 57 | 17 | |||
83710 | 125782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999068.0918 | 2119447.80624 | 37.7995447675413 | -122.447347524977 | (37.7995447675413, -122.447347524977) | 13 | 9 | 1 | 57 | 17 | |||
83819 | 8681 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
84449 | 125754 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999481.92865 | 2118436.50892 | 37.7967916540714 | -122.44584273436 | (37.7967916540714, -122.44584273436) | 13 | 9 | 1 | 57 | 17 | |||
84922 | 123570 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 176 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994307.9716 | 2114435.29269 | 37.7855086295893 | -122.463455168138 | (37.7855086295893, -122.463455168138) | 11 | 6 | 1 | 54 | 11 | |||
85165 | 125760 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 253 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002145.57423 | 2118944.40464 | 37.7983379321998 | -122.436662293934 | (37.7983379321998, -122.436662293934) | 13 | 9 | 1 | 57 | 17 | |||
85498 | 125856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6006461.58499 | 2121022.99007 | 37.804289527702 | -122.421875291912 | (37.804289527702, -122.421875291912) | 5 | 9 | 1 | 28858 | 32 | |||
85847 | 125790 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2829 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999396.9981 | 2118378.46939 | 37.7966274432433 | -122.446132435676 | (37.7966274432433, -122.446132435676) | 13 | 9 | 1 | 57 | 17 | |||
86783 | 123904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992691.51284 | 2114864.97618 | 37.7865951572882 | -122.469078872446 | (37.7865951572882, -122.469078872446) | 11 | 6 | 1 | 54 | 11 | |||
86872 | 54138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2460 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 12 | Permit Number 9871 | 6001817.46051 | 2117723.34964 | 37.7949665825052 | -122.437710167809 | (37.7949665825052, -122.437710167809) | 13 | 9 | 1 | 57 | 27 | ||
87892 | 125755 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999499.30193 | 2118438.9235 | 37.7967992758322 | -122.445782792755 | (37.7967992758322, -122.445782792755) | 13 | 9 | 1 | 57 | 17 | |||
88544 | 8682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
89472 | 8728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
90020 | 8727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
90556 | 123016 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 88 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993977.61053 | 2114979.99187 | 37.7869851857738 | -122.464637678044 | (37.7869851857738, -122.464637678044) | 11 | 6 | 1 | 54 | 11 | |||
90575 | 8714 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3134 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997363.0327 | 2113062.182 | 37.7819139740148 | -122.452786470687 | (37.7819139740148, -122.452786470687) | 15 | 6 | 1 | 54 | 31 | |||
90795 | 8677 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
91719 | 23956 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2004X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002791.01315 | 2119592.00114 | 37.8001527217578 | -122.434475209441 | (37.8001527217578, -122.434475209441) | 13 | 9 | 1 | 57 | 17 | |||
91943 | 13273 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2499X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000515.185 | 2119195.2822 | 37.7989339874751 | -122.442321938486 | (37.7989339874751, -122.442321938486) | 13 | 9 | 1 | 57 | 17 | |||
93912 | 125769 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2010 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 7 | Width 3ft | Permit Number 33440 | 6002145.10351 | 2119851.40209 | 37.8008282826453 | -122.436728882426 | (37.8008282826453, -122.436728882426) | 13 | 9 | 1 | 57 | 17 | |
94035 | 123003 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 18 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993654.96499 | 2115360.31123 | 37.7880108328673 | -122.465781592699 | (37.7880108328673, -122.465781592699) | 11 | 6 | 1 | 54 | 11 | |||
94742 | 41819 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Fortuna Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42205 | 6000254.75248069 | 2112385.7950317 | 37.780222066079 | -122.442733903375 | (37.780222066079, -122.442733903375) | 15 | 5 | 1 | 29490 | 16 | ||
96100 | 125783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999067.20465 | 2119454.38129 | 37.7995627701683 | -122.447351068322 | (37.7995627701683, -122.447351068322) | 13 | 9 | 1 | 57 | 17 | |||
96398 | 125811 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2210 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000356.45327 | 2116306.07701 | 37.7909919432784 | -122.442663639026 | (37.7909919432784, -122.442663639026) | 13 | 6 | 1 | 29490 | 27 | |||
98444 | 123018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 88 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993978.77466 | 2114929.90124 | 37.7868477176856 | -122.464630011811 | (37.7868477176856, -122.464630011811) | 11 | 6 | 1 | 54 | 11 | |||
98573 | 120080 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 221 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5987716.29079 | 2114480.20301 | 37.7852499554652 | -122.486263449798 | (37.7852499554652, -122.486263449798) | 11 | 6 | 1 | 55 | 26 | |||
98718 | 99596 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001@Filbert Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
99137 | 125758 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2102 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002844.96112 | 2118904.79694 | 37.7982689002438 | -122.434239372863 | (37.7982689002438, -122.434239372863) | 13 | 9 | 1 | 57 | 17 | |||
99173 | 125780 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Emerson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5998681.19546 | 2113401.84982 | 37.7829220585575 | -122.448250722201 | (37.7829220585575, -122.448250722201) | 15 | 6 | 1 | 54 | 31 | |||
99803 | 125746 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1824 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004290.24305 | 2118412.29995 | 37.796998554791 | -122.42920312802 | (37.796998554791, -122.42920312802) | 13 | 9 | 1 | 57 | 17 | |||
100183 | 125787 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2760 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999175.1799 | 2118283.40423 | 37.7963537498842 | -122.446893129025 | (37.7963537498842, -122.446893129025) | 13 | 9 | 1 | 57 | 17 | |||
100563 | 125827 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2411 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005396.53977 | 2118250.38526 | 37.7966165434615 | -122.4253635436 | (37.7966165434615, -122.4253635436) | 13 | 9 | 1 | 57 | 17 | |||
101575 | 125855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6006460.99405 | 2121028.21686 | 37.8043038458052 | -122.421877708416 | (37.8043038458052, -122.421877708416) | 5 | 9 | 1 | 28858 | 32 | |||
101668 | 125831 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005313.11199 | 2118207.21627 | 37.7964932985791 | -122.425649148516 | (37.7964932985791, -122.425649148516) | 13 | 9 | 1 | 28858 | 17 | |||
103006 | 8722 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
103185 | 140787 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 71 PARKER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5996813.6049 | 2114078.6319 | 37.7846733774063 | -122.454760686436 | (37.7846733774063, -122.454760686436) | 11 | 6 | 1 | 54 | 31 | |||
103540 | 8721 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
104264 | 18979 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2916 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000692.61661 | 2115558.68007 | 37.7889589430353 | -122.4414468761 | (37.7889589430353, -122.4414468761) | 13 | 6 | 1 | 29490 | 27 | |||
108915 | 250786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 276 32nd Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5985914.65421 | 2114070.62696 | 37.7840202063211 | -122.492466298901 | (37.7840202063211, -122.492466298901) | 11 | 6 | 1 | 55 | 33 | |||
109068 | 125774 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3500 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998053.56512 | 2115190.0164 | 37.7877959919383 | -122.450551009029 | (37.7877959919383, -122.450551009029) | 11 | 6 | 1 | 54 | 31 | |||
109081 | 125751 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2870 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999201.16809 | 2118397.93355 | 37.7966697014868 | -122.446811449891 | (37.7966697014868, -122.446811449891) | 13 | 9 | 1 | 57 | 17 | |||
109242 | 13131 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003964.7125 | 2119675.6431 | 37.8004489355963 | -122.430419726797 | (37.8004489355963, -122.430419726797) | 13 | 9 | 1 | 57 | 17 | |||
110300 | 143152 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2308 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001295.2498 | 2119386.2355 | 37.799502723648 | -122.439636359152 | (37.799502723648, -122.439636359152) | 13 | 9 | 1 | 57 | 17 | |||
110922 | 125784 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999066.91137 | 2119461.38091 | 37.7995819724856 | -122.447352587247 | (37.7995819724856, -122.447352587247) | 13 | 9 | 1 | 57 | 17 | |||
114326 | 8724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
114672 | 125766 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001936.34491 | 2121152.73709 | 37.8043895386146 | -122.437544518078 | (37.8043895386146, -122.437544518078) | 13 | 9 | 1 | 57 | 17 | |||
115379 | 125735 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3124 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000470.22373 | 2119054.48758 | 37.7985448401339 | -122.44246740516 | (37.7985448401339, -122.44246740516) | 13 | 9 | 1 | 57 | 17 | |||
116736 | 13236 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2308 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6001297.71761 | 2119386.00749 | 37.7995022380504 | -122.439627803312 | (37.7995022380504, -122.439627803312) | 13 | 9 | 1 | 57 | 17 | |||
117013 | 97908 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
117921 | 69349 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002263.91991676 | 2119868.04210329 | 37.8008807234583 | -122.436318920048 | (37.8008807234583, -122.436318920048) | 13 | 9 | 1 | 57 | 17 | ||
118619 | 141315 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2301 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000377.7943 | 2113003.1537 | 37.7819241882085 | -122.44235257958 | (37.7819241882085, -122.44235257958) | 15 | 5 | 1 | 29490 | 16 | |||
119217 | 105958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1915 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6003627.84338 | 2119315.76937 | 37.7994417277114 | -122.431559722312 | (37.7994417277114, -122.431559722312) | 13 | 9 | 1 | 57 | 17 | ||||
119563 | 61447 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1745 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1994 12:00:00 AM | 7 | Permit Number 33475 | 6004648.5784 | 2118760.76141 | 37.7979756196421 | -122.427988045036 | (37.7979756196421, -122.427988045036) | 13 | 9 | 1 | 57 | 17 | ||
120162 | 8743 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
120232 | 141045 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997350.1727 | 2113060.1515 | 37.7819076618834 | -122.452830813511 | (37.7819076618834, -122.452830813511) | 15 | 6 | 1 | 54 | 31 | |||
121944 | 9884 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1530 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6005423.33111 | 2115078.55002 | 37.7879089952385 | -122.425045046399 | (37.7879089952385, -122.425045046399) | 13 | 9 | 1 | 28858 | 41 | |||
122938 | 21531 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1301 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6006257.76496 | 2114889.71602 | 37.7874376040064 | -122.422144632576 | (37.7874376040064, -122.422144632576) | 13 | 9 | 1 | 28858 | 41 | |||
123368 | 21530 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1307 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6006237.14055 | 2114887.59542 | 37.7874306180636 | -122.422215838204 | (37.7874306180636, -122.422215838204) | 13 | 9 | 1 | 28858 | 41 | |||
123766 | 46369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2002 12:00:00 AM | 12 | Permit Number 44606 | 5993652.77755 | 2115385.98394 | 37.788081196911 | -122.465791026812 | (37.788081196911, -122.465791026812) | 11 | 6 | 1 | 54 | 11 | ||
125153 | 139097 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1324 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999782.4795 | 2113453.1972 | 37.7831259428927 | -122.444444440719 | (37.7831259428927, -122.444444440719) | 15 | 6 | 1 | 29490 | 31 | |||
126171 | 250852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986481.27041 | 2114308.88206 | 37.7847074978842 | -122.490523574402 | (37.7847074978842, -122.490523574402) | 11 | 6 | 1 | 55 | 33 | |||
126178 | 8715 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997354.19765 | 2113077.89785 | 37.7819566193322 | -122.452818170395 | (37.7819566193322, -122.452818170395) | 15 | 6 | 1 | 54 | 31 | |||
126385 | 21537 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1350 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006105.21197 | 2114916.89235 | 37.7875036178563 | -122.422674367433 | (37.7875036178563, -122.422674367433) | 13 | 9 | 1 | 28858 | 41 | |||
127992 | 8725 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
128454 | 8717 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3140 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | 15 | 6 | 1 | 54 | 31 | |||
129268 | 125861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2456 Leavenworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007523.93323 | 2120832.54539 | 37.8038264685723 | -122.418185431117 | (37.8038264685723, -122.418185431117) | 5 | 1 | 1 | 308 | 32 | |||
130391 | 123017 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 88 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993978.40728 | 2114952.99032 | 37.7869110928192 | -122.464632960066 | (37.7869110928192, -122.464632960066) | 11 | 6 | 1 | 54 | 11 | |||
131163 | 125796 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002014.56051 | 2121190.75221 | 37.8044983646672 | -122.437276570469 | (37.8044983646672, -122.437276570469) | 13 | 9 | 1 | 57 | 17 | |||
131682 | 95673 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3508 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x5 | 5998079 | 2115190 | 37.7877974026763 | -122.450463008357 | (37.7877974026763, -122.450463008357) | 11 | 6 | 1 | 54 | 31 | ||||
131785 | 250060 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Sutter St | 6 | : | Tree | Private 2 | 2 | Width 1ft | 6006175.05227 | 2114929.06733 | 37.7875409873764 | -122.422433599133 | (37.7875409873764, -122.422433599133) | 13 | 9 | 1 | 28858 | 41 | |||
131813 | 125852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1294 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006829.97271 | 2119121.43017 | 37.799089094537 | -122.420465395978 | (37.799089094537, -122.420465395978) | 5 | 1 | 1 | 28858 | 32 | |||
133397 | 125738 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001012.2526 | 2118670.44762 | 37.797521247954 | -122.440564260726 | (37.797521247954, -122.440564260726) | 13 | 9 | 1 | 57 | 17 | |||
133779 | 41232 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | 13 | 9 | 1 | 57 | 17 | |
134003 | 125777 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997331.47974 | 2114281.0433 | 37.7852588371725 | -122.452983637392 | (37.7852588371725, -122.452983637392) | 15 | 6 | 1 | 54 | 31 | |||
134156 | 8739 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
134236 | 21525 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6006287.01156 | 2114943.32312 | 37.7875864454 | -122.422047254877 | (37.7875864454, -122.422047254877) | 13 | 9 | 1 | 28858 | 41 | |||
135575 | 250781 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 267 32nd Ave | 2 | : | Tree | Private 2 | 10 | Width 3ft | 5985871.01478 | 2114139.87947 | 37.7842078021793 | -122.492622375346 | (37.7842078021793, -122.492622375346) | 11 | 6 | 1 | 55 | 33 | |||
136401 | 9882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1530 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6005403.02502 | 2115071.76703 | 37.7878892237663 | -122.425114819002 | (37.7878892237663, -122.425114819002) | 13 | 9 | 1 | 28858 | 41 | |||
136701 | 125825 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1871 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004090.00748 | 2118336.91412 | 37.7967802272889 | -122.429890611181 | (37.7967802272889, -122.429890611181) | 13 | 9 | 1 | 57 | 17 | |||
139821 | 250737 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2801 Lake St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986760.11257 | 2114418.92368 | 37.7850259235532 | -122.489566980832 | (37.7850259235532, -122.489566980832) | 11 | 6 | 1 | 55 | 33 | |||
140447 | 64202 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.8059523049123 | -122.419175447994 | (37.8059523049123, -122.419175447994) | 5 | 1 | 1 | 28858 | 32 | ||
142401 | 125736 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3124 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000473.08995 | 2119036.09992 | 37.7984945158666 | -122.44245616634 | (37.7984945158666, -122.44245616634) | 13 | 9 | 1 | 57 | 17 | |||
144759 | 58086 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1977 12:00:00 AM | 7 | Permit Number 17057 | 6002870.87342 | 2118942.93288 | 37.7983750823084 | -122.434152436312 | (37.7983750823084, -122.434152436312) | 13 | 9 | 1 | 57 | 17 | ||
146043 | 125828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2411 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005398.28798 | 2118235.77605 | 37.7965765290478 | -122.425356454246 | (37.7965765290478, -122.425356454246) | 13 | 9 | 1 | 57 | 17 | |||
146145 | 8726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
147750 | 97909 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
147993 | 125853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 743 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007172.66204 | 2121545.51126 | 37.8057643133355 | -122.419451639674 | (37.8057643133355, -122.419451639674) | 5 | 1 | 1 | 28858 | 32 | |||
149564 | 125785 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999066.01183 | 2119467.37321 | 37.7995983743294 | -122.447356131501 | (37.7995983743294, -122.447356131501) | 13 | 9 | 1 | 57 | 17 | |||
150115 | 21527 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 4X4 | 6006243.80488 | 2114938.20274 | 37.7875699491469 | -122.422196377756 | (37.7875699491469, -122.422196377756) | 13 | 9 | 1 | 28858 | 41 | |||
151223 | 125757 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2102 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002844.99609 | 2118906.48858 | 37.7982735470321 | -122.434239372857 | (37.7982735470321, -122.434239372857) | 13 | 9 | 1 | 57 | 17 | |||
151483 | 124410 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3906 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5996063.66719 | 2115240.01775 | 37.7878191866385 | -122.457439257578 | (37.7878191866385, -122.457439257578) | 11 | 6 | 1 | 54 | 31 | |||
151752 | 125819 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003119.3814 | 2118201.7628 | 37.7963541221954 | -122.433239536279 | (37.7963541221954, -122.433239536279) | 13 | 9 | 1 | 57 | 17 | |||
153857 | 250775 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 254 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985910.66114 | 2114192.07133 | 37.7843534240234 | -122.492489059847 | (37.7843534240234, -122.492489059847) | 11 | 6 | 1 | 55 | 33 |
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) );