trees
3,965 rows where qSpecies_id = 70 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100203 | 174978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001016.58593 | 2088794.32712 | 37.7154889282344 | -122.438407690968 | (37.7154889282344, -122.438407690968) | 9 | 7 | 6 | 28861 | 5 | |||
173929 | 174979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6001031.1498 | 2088817.30686 | 37.7155528538591 | -122.438358997196 | (37.7155528538591, -122.438358997196) | 9 | 7 | 6 | 28861 | 5 | |||
41158 | 175050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991220.94101 | 2089033.65994 | 37.7155840279702 | -122.472282930219 | (37.7155840279702, -122.472282930219) | 1 | 8 | 4 | 64 | 14 | |||
118067 | 102444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.7157989956067 | -122.436645469419 | (37.7157989956067, -122.436645469419) | 9 | 7 | 6 | 28861 | 5 | |||
148042 | 174976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 842 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001033.7824 | 2088915.45345 | 37.7158224921953 | -122.438356925152 | (37.7158224921953, -122.438356925152) | 9 | 7 | 6 | 28861 | 5 | |||
54547 | 105345 | - 12 | Acacia melanoxylon :: Blackwood Acacia 70 | 466 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | |||||
19477 | 203874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5993391.13026 | 2089210.06391 | 37.7161937512299 | -122.464794638879 | (37.7161937512299, -122.464794638879) | 9 | 8 | 6 | 64 | 24 | |||
113463 | 175027 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1277 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011799.53488 | 2088981.40633 | 37.7166100572882 | -122.401149908137 | (37.7166100572882, -122.401149908137) | 10 | 7 | 8 | 309 | 39 | |||
91798 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
181284 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
120769 | 115677 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | 1 | 8 | 4 | 64 | 14 | ||||
96699 | 11795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | ||||
112768 | 11794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
133684 | 114109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | ||||
160184 | 11793 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
177424 | 254155 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5991180 | 2089593 | 37.717117469349 | -122.472465193375 | (37.717117469349, -122.472465193375) | 9 | 8 | 6 | 64 | 24 | ||||
134245 | 11817 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
152891 | 11815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
55364 | 11774 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 2x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
76918 | 11791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
79561 | 11788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
100294 | 11789 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
145746 | 11787 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
167696 | 11773 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
89517 | 188722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 67 Jennings Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012907.82508 | 2089194.67107 | 37.7172574063701 | -122.397334024441 | (37.7172574063701, -122.397334024441) | 10 | 3 | 8 | 58 | 1 | |||
87061 | 104723 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.7174475379801 | -122.477917527277 | (37.7174475379801, -122.477917527277) | 1 | 8 | 4 | 64 | 14 | ||||
16567 | 175055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989631.25858 | 2089762.2141 | 37.7174923263774 | -122.477830757993 | (37.7174923263774, -122.477830757993) | 1 | 8 | 4 | 64 | 14 | |||
154984 | 175054 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 5989611.995 | 2089764.54456 | 37.717497607213 | -122.477897512877 | (37.717497607213, -122.477897512877) | 1 | 8 | 4 | 64 | 14 | |||
9745 | 175056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989706.76868 | 2089771.19579 | 37.7175213699925 | -122.477570413242 | (37.7175213699925, -122.477570413242) | 1 | 8 | 4 | 64 | 14 | |||
128311 | 203864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Capitol Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5995082.38491 | 2089680.15869 | 37.717581884482 | -122.458982907738 | (37.717581884482, -122.458982907738) | 9 | 8 | 6 | 28861 | 24 | |||
30644 | 188724 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 961 Le Conte Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013382.05808 | 2089359.66984 | 37.7177368520568 | -122.395706366661 | (37.7177368520568, -122.395706366661) | 10 | 3 | 8 | 58 | 1 | ||||
51482 | 203865 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995933.09889 | 2089739.90956 | 37.7177948124633 | -122.456046712088 | (37.7177948124633, -122.456046712088) | 9 | 8 | 6 | 28861 | 24 | |||
44628 | 188723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013346.44573 | 2089388.27628 | 37.7178134185452 | -122.395831466855 | (37.7178134185452, -122.395831466855) | 10 | 3 | 8 | 58 | 1 | ||||
180154 | 203856 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5991221.72934 | 2089959.84815 | 37.7181271596151 | -122.472347684124 | (37.7181271596151, -122.472347684124) | 9 | 8 | 6 | 64 | 24 | |||
185980 | 200237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 919 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351 | (37.7182212977035, -122.39160673351) | 10 | 3 | 8 | 58 | 1 | |||
42797 | 203857 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991224.82027 | 2090017.23176 | 37.7182848998132 | -122.472341181102 | (37.7182848998132, -122.472341181102) | 9 | 8 | 6 | 64 | 24 | |||
83311 | 174980 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002900.06306 | 2089775.87856 | 37.7182910061937 | -122.431967604438 | (37.7182910061937, -122.431967604438) | 9 | 7 | 6 | 28861 | 5 | |||
70395 | 174981 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002909.51396 | 2089790.51984 | 37.7183317437001 | -122.431935981587 | (37.7183317437001, -122.431935981587) | 9 | 7 | 6 | 28861 | 5 | |||
118961 | 203872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995594.11167 | 2089942.67302 | 37.7183320899249 | -122.457233092344 | (37.7183320899249, -122.457233092344) | 9 | 8 | 6 | 28861 | 24 | |||
163400 | 203871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995594.53815 | 2089951.54412 | 37.7183564723638 | -122.457232259578 | (37.7183564723638, -122.457232259578) | 9 | 8 | 6 | 28861 | 24 | |||
48689 | 203870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995594.9546 | 2089959.93559 | 37.7183795372759 | -122.457231426804 | (37.7183795372759, -122.457231426804) | 9 | 8 | 6 | 28861 | 24 | |||
190858 | 203869 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995595.19547 | 2089971.45111 | 37.7184111700071 | -122.457231426804 | (37.7184111700071, -122.457231426804) | 9 | 8 | 6 | 28861 | 24 | |||
154192 | 203868 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995595.34601 | 2089978.64807 | 37.7184309398048 | -122.457231426799 | (37.7184309398048, -122.457231426799) | 9 | 8 | 6 | 28861 | 24 | |||
164405 | 203858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5991229.23047 | 2090077.70959 | 37.7184512123295 | -122.472330343369 | (37.7184512123295, -122.472330343369) | 9 | 8 | 6 | 64 | 24 | |||
147113 | 203867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5995596.42501 | 2089995.66595 | 37.7184777288524 | -122.457228927574 | (37.7184777288524, -122.457228927574) | 9 | 8 | 6 | 28861 | 24 | |||
115084 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard | Tree | Private 2 | 5989494 | 2090180 | 37.7186314952818 | -122.47833572412 | (37.7186314952818, -122.47833572412) | 1 | 8 | 4 | 64 | 14 | |||||
71845 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 443X ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988110 | 2090275 | 37.7188118998372 | -122.483126550771 | (37.7188118998372, -122.483126550771) | 1 | 8 | 4 | 64 | 14 | ||||
13081 | 203859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991237.16543 | 2090216.16791 | 37.7188318441037 | -122.472313003552 | (37.7188318441037, -122.472313003552) | 9 | 8 | 6 | 64 | 24 | |||
102128 | 121403 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1089 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6015119.7462 | 2089795.6867 | 37.7190305799817 | -122.389730343556 | (37.7190305799817, -122.389730343556) | 10 | 3 | 8 | 58 | 1 | |||
167970 | 188725 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3311 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6013382.39836 | 2089856.62059 | 37.7191013987931 | -122.395739991411 | (37.7191013987931, -122.395739991411) | 10 | 3 | 8 | 58 | 1 | ||||
117611 | 104976 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | 9 | 8 | 4 | 64 | 40 | |||
57299 | 203860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991248.87422 | 2090355.17031 | 37.719214188172 | -122.472282658627 | (37.719214188172, -122.472282658627) | 9 | 8 | 6 | 64 | 24 | |||
111808 | 203861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991252.63127 | 2090414.41238 | 37.7193770697644 | -122.472273988268 | (37.7193770697644, -122.472273988268) | 9 | 8 | 6 | 64 | 24 | |||
152722 | 188721 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1062 Key Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Width 5ft | 6013117.817 | 2089964.07481 | 37.7193817246629 | -122.396662082497 | (37.7193817246629, -122.396662082497) | 10 | 3 | 8 | 58 | 1 | |||
142717 | 200159 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857 | -122.393795976203 | (37.719486864857, -122.393795976203) | 10 | 3 | 8 | 58 | 1 | |||
179080 | 203895 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5990601.67154 | 2090472.14101 | 37.719497882902 | -122.474528301759 | (37.719497882902, -122.474528301759) | 9 | 8 | 4 | 64 | 40 | |||
63360 | 203898 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5990605.80648 | 2090479.00693 | 37.7195169745995 | -122.474514509734 | (37.7195169745995, -122.474514509734) | 9 | 8 | 4 | 64 | 40 | |||
20230 | 203896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5990596.84308 | 2090479.69294 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | 9 | 8 | 4 | 64 | 40 | |||
75951 | 203899 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990601.43491 | 2090484.56274 | 37.7195319761887 | -122.474530025745 | (37.7195319761887, -122.474530025745) | 9 | 8 | 4 | 64 | 40 | |||
23392 | 203897 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | 9 | 8 | 4 | 64 | 40 | |||
138449 | 203900 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 2ft | 5990599.12007 | 2090493.05504 | 37.7195551598198 | -122.474538646659 | (37.7195551598198, -122.474538646659) | 9 | 8 | 4 | 64 | 40 | |||
179266 | 116959 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1090x KEY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013239 | 2090033 | 37.719577723269 | -122.396248023097 | (37.719577723269, -122.396248023097) | 10 | 3 | 8 | 58 | 1 | ||||
184296 | 104943 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 830X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||||
161228 | 2161 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.7198074367343 | -122.408342124702 | (37.7198074367343, -122.408342124702) | 9 | 3 | 7 | 309 | 28 | |||
96067 | 203866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996236.4849 | 2090473.91249 | 37.7198276211289 | -122.455051057381 | (37.7198276211289, -122.455051057381) | 9 | 8 | 6 | 28861 | 24 | |||
60433 | 203901 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 12 | Width 3ft | 5990470.12167 | 2090714.31084 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | 9 | 8 | 4 | 64 | 40 | |||
63078 | 396 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3790X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2 | 5990481.42225 | 2090722.77019 | 37.7201790804753 | -122.474962240321 | (37.7201790804753, -122.474962240321) | 9 | 8 | 4 | 64 | 40 | |||
32807 | 175020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6010396.84323 | 2090323.76583 | 37.7202175482911 | -122.406092851014 | (37.7202175482911, -122.406092851014) | 10 | 3 | 8 | 309 | 28 | |||
189187 | 203863 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997075.35009 | 2090631.23429 | 37.720307679246 | -122.452162755132 | (37.720307679246, -122.452162755132) | 9 | 8 | 6 | 28861 | 24 | |||
141243 | 203873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 178 Tara St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5997913.09605 | 2090617.66256 | 37.7203183685688 | -122.449265978542 | (37.7203183685688, -122.449265978542) | 9 | 8 | 6 | 28861 | 24 | |||
194273 | 263629 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1985X Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 785142 | 6000955 | 2090559 | 37.7203308201534 | -122.438746936552 | (37.7203308201534, -122.438746936552) | 9 | 7 | 6 | 28861 | 25 | |||
12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
156844 | 203862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 951 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5991278.5837 | 2090872.19555 | 37.7206355315929 | -122.472217633157 | (37.7206355315929, -122.472217633157) | 9 | 8 | 6 | 64 | 24 | |||
63323 | 382 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | |||
7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
96578 | 358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | |||
179293 | 174971 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 5999223.81864 | 2090928.80368 | 37.7212475759866 | -122.444757609674 | (37.7212475759866, -122.444757609674) | 9 | 7 | 6 | 28861 | 25 | |||
135909 | 11755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 901X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X4 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
3045 | 261353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5990864 | 2091394 | 37.7220442755547 | -122.473688749933 | (37.7220442755547, -122.473688749933) | 9 | 8 | 4 | 64 | 40 | ||||
107957 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1107 Bowdoin St | 2 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | ||
30315 | 114947 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 146 STRATFORD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990875 | 2091468 | 37.7222480982686 | -122.473656121456 | (37.7222480982686, -122.473656121456) | 9 | 8 | 4 | 64 | 40 | ||||
104965 | 258052 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 856 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x6 | 5991236 | 2091663 | 37.7228044207006 | -122.472422451465 | (37.7228044207006, -122.472422451465) | 9 | 8 | 4 | 64 | 40 | ||||
7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
174895 | 339 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3590X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
133198 | 175071 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 327 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6003750.62272 | 2091634.49721 | 37.7234425468108 | -122.429160031623 | (37.7234425468108, -122.429160031623) | 9 | 7 | 6 | 28861 | 5 | |||
31283 | 203854 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995041.91528 | 2091943.51422 | 37.7237941925307 | -122.4592866043 | (37.7237941925307, -122.4592866043) | 9 | 8 | 4 | 28861 | 24 | |||
17569 | 98514 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||||
192441 | 98513 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.7238693046984 | -122.459376132933 | (37.7238693046984, -122.459376132933) | 9 | 8 | 4 | 28861 | 24 | ||
113841 | 174982 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 323 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002277.67573 | 2091830.36717 | 37.7238968690373 | -122.434265730182 | (37.7238968690373, -122.434265730182) | 9 | 7 | 6 | 28861 | 5 | |||
55903 | 203855 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 330 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5994200.98333 | 2092085.6479 | 37.7241360734166 | -122.46220384765 | (37.7241360734166, -122.46220384765) | 9 | 8 | 4 | 28861 | 24 | |||
3682 | 261986 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Bancroft Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | |||||
83959 | 255873 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990871 | 2092383 | 37.7247602290732 | -122.473736664855 | (37.7247602290732, -122.473736664855) | 9 | 8 | 4 | 64 | 40 | ||||
26685 | 324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
28825 | 30290 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | 9 | 3 | 7 | 309 | 28 | |||
163441 | 30291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | 9 | 3 | 7 | 309 | 28 | |||
45252 | 256859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991007 | 2092571 | 37.7252843060575 | -122.473280239218 | (37.7252843060575, -122.473280239218) | 9 | 8 | 4 | 64 | 40 | ||||
161459 | 175068 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Woolsey St | 5 | Side Yard : Yard | Tree | Private 2 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | 10 | 3 | 7 | 309 | 28 | ||||
26769 | 175069 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Woolsey St | 6 | Side Yard : Yard | Tree | Private 2 | 20 | 6011573.1556 | 2092162.22602 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | 10 | 3 | 7 | 309 | 28 |
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) );