trees
3,965 rows where qSpecies_id = 70 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129676 | 124915 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998988.26407 | 2115868.61122 | 37.7897126891444 | -122.447366000661 | (37.7897126891444, -122.447366000661) | 13 | 6 | 1 | 54 | 31 | |||
135977 | 122607 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1214 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5987094.0342 | 2106930.3359 | 37.7644838586853 | -122.487861336886 | (37.7644838586853, -122.487861336886) | 1 | 8 | 3 | 56 | 35 | |||
137480 | 175039 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 131 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010504.44618 | 2086648.52266 | 37.7101320966946 | -122.405462199623 | (37.7101320966946, -122.405462199623) | 9 | 7 | 8 | 309 | 39 | |||
137484 | 124899 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3767 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996752.2261 | 2115619.8625 | 37.7889016643383 | -122.455084444714 | (37.7889016643383, -122.455084444714) | 11 | 6 | 1 | 54 | 31 | |||
141550 | 124960 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3134 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999039.1649 | 2119590.46461 | 37.799934816085 | -122.447457896076 | (37.799934816085, -122.447457896076) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
142936 | 124846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001825.64723 | 2121584.78063 | 37.8055695210879 | -122.437958561455 | (37.8055695210879, -122.437958561455) | 13 | 9 | 1 | 57 | 17 | |||
146251 | 184864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984647.1621 | 2106835.0674 | 37.7640792451971 | -122.496317240818 | (37.7640792451971, -122.496317240818) | 1 | 8 | 3 | 56 | 35 | |||
146909 | 125241 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1182 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009140.01829 | 2116726.36565 | 37.7926427442163 | -122.41230245299 | (37.7926427442163, -122.41230245299) | 3 | 1 | 10 | 28857 | 21 | |||
147170 | 142567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008908.0459 | 2120998.3361 | 37.8043594981364 | -122.413407342952 | (37.8043594981364, -122.413407342952) | 3 | 1 | 10 | 308 | 23 | |||
149934 | 188628 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 26 | : | Tree | Private 2 | 9 | Width 3ft | 6016060.05409 | 2099067.529 | 37.7445413039446 | -122.38712639369 | (37.7445413039446, -122.38712639369) | 10 | 3 | 8 | 58 | 1 | |||
150030 | 200605 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 46 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6016398.6886 | 2095199.7747 | 37.7339399806144 | -122.385685937001 | (37.7339399806144, -122.385685937001) | 10 | 3 | 8 | 58 | 1 | |||
153757 | 220181 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 46 | Front Yard : Yard | Tree | Private 2 | 9 | 6004987.92222 | 2096576.46546 | 37.7370820597802 | -122.425234401841 | (37.7370820597802, -122.425234401841) | 2 | 7 | 5 | 28859 | 2 | ||||
156107 | 98789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 133 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6001814.61015 | 2121625.31821 | 37.805680198848 | -122.437999662255 | (37.805680198848, -122.437999662255) | 13 | 9 | 1 | 57 | 17 | |||
158386 | 188642 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Cargo Way | 3 | Median : Yard | Tree | DPW 1 | 9 | 6018846.51114 | 2097536.89048 | 37.7404923843103 | -122.377385089264 | (37.7404923843103, -122.377385089264) | 10 | 3 | 8 | 58 | 1 | ||||
160468 | 188678 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Middle Point Rd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6018276.23172 | 2096494.25688 | 37.7375980862711 | -122.37928451137 | (37.7375980862711, -122.37928451137) | 10 | 3 | 8 | 58 | 1 | ||||
163657 | 174996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6000640.56256 | 2088159.86327 | 37.7137254368584 | -122.439661934055 | (37.7137254368584, -122.439661934055) | 9 | 7 | 6 | 28861 | 5 | |||
164474 | 24141 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.7337286308528 | -122.38459886076 | (37.7337286308528, -122.38459886076) | 10 | 3 | 8 | 58 | 1 | |||
166224 | 124785 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3055 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000941.10837 | 2118864.21184 | 37.7980492219479 | -122.440824344682 | (37.7980492219479, -122.440824344682) | 13 | 9 | 1 | 57 | 17 | |||
167240 | 12740 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 5990313.43665 | 2114711.35166 | 37.7860356551531 | -122.477295116444 | (37.7860356551531, -122.477295116444) | 11 | 6 | 2 | 55 | 26 | |||
169725 | 138345 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2250 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001736.79 | 2114308.7957 | 37.7855865118356 | -122.437744629649 | (37.7855865118356, -122.437744629649) | 13 | 6 | 1 | 29490 | 27 | |||
171234 | 24212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2002 12:00:00 AM | 9 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | ||
173107 | 124847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 170 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001902.65662 | 2121695.37415 | 37.8058775604571 | -122.437699985677 | (37.8058775604571, -122.437699985677) | 13 | 9 | 1 | 57 | 17 | |||
175371 | 94602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2939 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.94586 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | 13 | 9 | 1 | 57 | 27 | ||
179084 | 124901 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3799 Washington St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5996718.28092 | 2115614.59001 | 37.7888852400214 | -122.455201508555 | (37.7888852400214, -122.455201508555) | 11 | 6 | 1 | 54 | 31 | |||
183190 | 125097 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2011 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999412.93795 | 2115766.79645 | 37.789457390495 | -122.445889350706 | (37.789457390495, -122.445889350706) | 13 | 6 | 1 | 29490 | 31 | |||
183295 | 125284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1022 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008534.98172 | 2118654.3458 | 37.7979025326232 | -122.414532399365 | (37.7979025326232, -122.414532399365) | 5 | 1 | 10 | 308 | 21 | ||||
185074 | 125031 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1460 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002203.82941 | 2121591.63903 | 37.8056098511681 | -122.436650302387 | (37.8056098511681, -122.436650302387) | 13 | 9 | 1 | 57 | 17 | |||
185173 | 124861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55 Retiro Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001746.80672 | 2121376.93282 | 37.8049943425735 | -122.43821650049 | (37.8049943425735, -122.43821650049) | 13 | 9 | 1 | 57 | 17 | |||
191403 | 121109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 416 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | 5996806.9264 | 2110369.3662 | 37.7744883268229 | -122.454515741886 | (37.7744883268229, -122.454515741886) | 15 | 5 | 2 | 29492 | 16 | |||
191431 | 200535 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 11 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6016168.4829 | 2095664.0064 | 37.7352019267754 | -122.386514194261 | (37.7352019267754, -122.386514194261) | 10 | 3 | 8 | 58 | 1 | |||
136887 | 6254 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1315 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 85 | 3X3 | 6004557.65 | 2113267.8319 | 37.7828882768645 | -122.427911069574 | (37.7828882768645, -122.427911069574) | 7 | 9 | 11 | 29490 | 41 | |||
42073 | 10282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.7723369589176 | -122.428103893873 | (37.7723369589176, -122.428103893873) | 7 | 9 | 11 | 28852 | 10 | |||
45882 | 10255 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 140 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005448.27784 | 2109623.58668 | 37.7729324136912 | -122.424570554491 | (37.7729324136912, -122.424570554491) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
67590 | 10261 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X4 | 6005221.62679 | 2109603.34443 | 37.772864030808 | -122.425353127526 | (37.772864030808, -122.425353127526) | 7 | 9 | 11 | 28852 | 10 | |||
73315 | 12750 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1720 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5990071.96011 | 2114756.1152 | 37.7861445495756 | -122.478133824936 | (37.7861445495756, -122.478133824936) | 11 | 6 | 1 | 55 | 33 | |||
98118 | 22800 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5999029.37493 | 2111788.901 | 37.7785132178028 | -122.446930065887 | (37.7785132178028, -122.446930065887) | 15 | 5 | 11 | 54 | 16 | |||
111177 | 23867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1460 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X6 | 6003686.8148 | 2113759.4476 | 37.7841888268021 | -122.430958893029 | (37.7841888268021, -122.430958893029) | 13 | 9 | 11 | 29490 | 41 | |||
168160 | 20107 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1875X Haight St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5997178.90707 | 2108418.46554 | 37.7691529849708 | -122.453088136651 | (37.7691529849708, -122.453088136651) | 15 | 5 | 11 | 29492 | 9 | |||
175892 | 5476 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | 2 | 4 | 5 | 28859 | 19 | |||
183805 | 23863 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6003705.9488 | 2113626.0727 | 37.7838236969294 | -122.430883174483 | (37.7838236969294, -122.430883174483) | 13 | 9 | 11 | 29490 | 41 | |||
3727 | 175033 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010491.77199 | 2086707.01072 | 37.7102919844537 | -122.405510120904 | (37.7102919844537, -122.405510120904) | 9 | 7 | 8 | 309 | 39 | |||
4800 | 203692 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994219.3315 | 2106013.86798 | 37.762380528552 | -122.46315056576 | (37.762380528552, -122.46315056576) | 1 | 5 | 11 | 56 | 12 | |||
14540 | 125028 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1454 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002238.36811 | 2121596.51915 | 37.8056252134011 | -122.436531126017 | (37.8056252134011, -122.436531126017) | 13 | 9 | 1 | 57 | 17 | |||
14773 | 203979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992248.70603 | 2096739.03136 | 37.7368005027325 | -122.469291057549 | (37.7368005027325, -122.469291057549) | 1 | 8 | 4 | 59 | 40 | |||
18624 | 184510 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1975 42nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5983188.0663 | 2101709.4842 | 37.7499202536606 | -122.500984645445 | (37.7499202536606, -122.500984645445) | 1 | 8 | 3 | 29491 | 35 | |||
20956 | 188641 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011091.32099 | 2096197.80071 | 37.7363852434915 | -122.404105441008 | (37.7363852434915, -122.404105441008) | 10 | 3 | 8 | 58 | 1 | ||||
24486 | 124784 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3055 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000935.85485 | 2118878.39953 | 37.7980878784058 | -122.440843541621 | (37.7980878784058, -122.440843541621) | 13 | 9 | 1 | 57 | 17 | |||
25302 | 247541 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6000212.07193 | 2108508.73139 | 37.7695741993109 | -122.442603102947 | (37.7695741993109, -122.442603102947) | 15 | 5 | 11 | 29492 | 9 | ||||
25505 | 188633 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6010969.7403 | 2096191.55002 | 37.7363612864506 | -122.40452535877 | (37.7363612864506, -122.40452535877) | 10 | 3 | 8 | 58 | 1 | ||||
26650 | 220155 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 8 | 6004171.83717 | 2095877.84681 | 37.7351176733377 | -122.428006207723 | (37.7351176733377, -122.428006207723) | 2 | 7 | 5 | 28861 | 2 | ||||
27679 | 175034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010467.70028 | 2086649.87132 | 37.7101337451556 | -122.40558929631 | (37.7101337451556, -122.40558929631) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||||
30715 | 73286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
35884 | 220200 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 8 | Width 5ft | 6003513.54179 | 2095663.72893 | 37.7344924889333 | -122.430266900093 | (37.7344924889333, -122.430266900093) | 2 | 7 | 5 | 63 | 7 | |||
40618 | 203958 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2429 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992007.36594 | 2098897.6008 | 37.7427134372901 | -122.470282614065 | (37.7427134372901, -122.470282614065) | 1 | 8 | 4 | 29491 | 40 | |||
41680 | 124839 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001764.30069 | 2121488.69691 | 37.8053022119874 | -122.438163971998 | (37.8053022119874, -122.438163971998) | 13 | 9 | 1 | 57 | 17 | |||
43119 | 125313 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013202.9728 | 2118462.79402 | 37.7976377164748 | -122.398366273498 | (37.7976377164748, -122.398366273498) | 3 | 1 | 10 | 28860 | 6 | |||
46412 | 125041 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1431 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002357.41951 | 2121568.78695 | 37.8055558324875 | -122.436117146515 | (37.8055558324875, -122.436117146515) | 13 | 9 | 1 | 57 | 17 | |||
46939 | 220174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 8 | 6004973.16585 | 2096557.19919 | 37.7370283252818 | -122.425284050737 | (37.7370283252818, -122.425284050737) | 2 | 7 | 5 | 28859 | 2 | ||||
47454 | 205130 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1261 Portola Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5994507.93911 | 2097882.15417 | 37.7400695293918 | -122.461562807282 | (37.7400695293918, -122.461562807282) | 1 | 8 | 4 | 59 | 40 | |||
50973 | 43163 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.26694 | 37.7260364164322 | -122.422690190993 | (37.7260364164322, -122.422690190993) | 9 | 7 | 7 | 309 | 5 | |
51426 | 188679 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Middle Point Rd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6018264.75043 | 2096477.95592 | 37.7375526939091 | -122.379323076118 | (37.7375526939091, -122.379323076118) | 10 | 3 | 8 | 58 | 1 | ||||
52222 | 181923 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2394 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986746.4023 | 2099044.7509 | 37.7428119016984 | -122.488484088714 | (37.7428119016984, -122.488484088714) | 1 | 8 | 3 | 29491 | 35 | |||
52811 | 125027 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1448 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002258.73025 | 2121599.52736 | 37.8056346302032 | -122.436460875479 | (37.8056346302032, -122.436460875479) | 13 | 9 | 1 | 57 | 17 | |||
53098 | 188733 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Executive Park Blvd | 1 | : | Tree | Private 2 | 8 | Width 8ft | 6014289.08954 | 2086985.67825 | 37.7112687498269 | -122.392405184751 | (37.7112687498269, -122.392405184751) | 10 | 3 | 8 | 58 | 1 | |||
55185 | 187706 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6013695.62833 | 2087031.11322 | 37.7113605319472 | -122.394459530409 | (37.7113605319472, -122.394459530409) | 10 | 3 | 8 | 58 | 1 | |||
56916 | 186372 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984837.3524 | 2102531.5146 | 37.7522740255983 | -122.495342034865 | (37.7522740255983, -122.495342034865) | 1 | 8 | 3 | 56 | 35 | |||
57619 | 125200 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2105 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003810.25178 | 2115708.07465 | 37.7895462587878 | -122.430670943933 | (37.7895462587878, -122.430670943933) | 13 | 9 | 1 | 29490 | 27 | |||
58780 | 125024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1436 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002311.60856 | 2121606.01355 | 37.8056554441143 | -122.436278347281 | (37.8056554441143, -122.436278347281) | 13 | 9 | 1 | 57 | 17 | |||
61549 | 124993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 259 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000738.67207 | 2121522.9779 | 37.8053379546353 | -122.4417157428 | (37.8053379546353, -122.4417157428) | 13 | 9 | 1 | 57 | 17 | |||
62280 | 125311 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013212.98295 | 2118400.3892 | 37.7974669253095 | -122.398327254619 | (37.7974669253095, -122.398327254619) | 3 | 1 | 10 | 28860 | 6 | |||
64037 | 125004 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3768 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002047.18275 | 2121687.67631 | 37.8058646408085 | -122.437199280038 | (37.8058646408085, -122.437199280038) | 13 | 9 | 1 | 57 | 17 | |||
64043 | 125039 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1449 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002279.25009 | 2121557.58939 | 37.8055206456272 | -122.43638686036 | (37.8055206456272, -122.43638686036) | 13 | 9 | 1 | 57 | 17 | |||
64841 | 175066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Thornton Ave | 1 | Side Yard : Yard | Tree | Private 2 | 8 | 6010981.07617 | 2094029.55145 | 37.7304255280198 | -122.404334038786 | (37.7304255280198, -122.404334038786) | 10 | 3 | 7 | 309 | 28 | ||||
66434 | 221378 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 190 Storrie St | 17 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000803.23299 | 2105309.21717 | 37.7608228056365 | -122.440328815537 | (37.7608228056365, -122.440328815537) | 15 | 4 | 5 | 28862 | 3 | |||
66735 | 125042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002587.96608 | 2121001.45923 | 37.8040111956201 | -122.435278703153 | (37.8040111956201, -122.435278703153) | 13 | 9 | 1 | 57 | 17 | |||
66883 | 181726 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987306.6309 | 2107085.0591 | 37.7649210846351 | -122.487137397154 | (37.7649210846351, -122.487137397154) | 1 | 8 | 3 | 56 | 35 | |||
69126 | 102186 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3999X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
74168 | 124838 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6001766.13786 | 2121465.01579 | 37.8052372944152 | -122.438155916785 | (37.8052372944152, -122.438155916785) | 13 | 9 | 1 | 57 | 17 | |||
75565 | 125132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2731 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999973.04689 | 2117760.51196 | 37.794963575153 | -122.444094758959 | (37.794963575153, -122.444094758959) | 13 | 9 | 1 | 57 | 27 | |||
76824 | 125040 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1431 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002342.1489 | 2121566.576 | 37.8055488942277 | -122.436169834191 | (37.8055488942277, -122.436169834191) | 13 | 9 | 1 | 57 | 17 | |||
80188 | 125082 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2623 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001483.5504 | 2116927.90461 | 37.7927635060916 | -122.438808514329 | (37.7927635060916, -122.438808514329) | 13 | 6 | 1 | 29490 | 27 | |||
80573 | 203690 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991410.69594 | 2105237.51163 | 37.7600866646964 | -122.472807886998 | (37.7600866646964, -122.472807886998) | 1 | 8 | 4 | 56 | 12 | |||
81693 | 218112 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 70 Lopez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5993956.84555 | 2100550.43401 | 37.747364218292 | -122.463661857311 | (37.747364218292, -122.463661857311) | 1 | 8 | 4 | 29491 | 40 | |||
82296 | 175002 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Newton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000849.25835 | 2088363.04115 | 37.7142951942344 | -122.438955158647 | (37.7142951942344, -122.438955158647) | 9 | 7 | 6 | 28861 | 5 | |||
83922 | 143046 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 602 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009427.651 | 2120519.2315 | 37.8030731565489 | -122.411575328122 | (37.8030731565489, -122.411575328122) | 3 | 1 | 10 | 308 | 23 | |||
85311 | 138336 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1739 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002023.5926 | 2114535.4746 | 37.786225217828 | -122.436768610156 | (37.786225217828, -122.436768610156) | 13 | 6 | 1 | 29490 | 27 | |||
85526 | 188650 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x Quesada Ave | 51 | Median : Yard | Tree | DPW 1 | 8 | 6014234.97615 | 2095377.10029 | 37.734306916536 | -122.393179013597 | (37.734306916536, -122.393179013597) | 10 | 3 | 8 | 58 | 1 | ||||
85963 | 183048 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2600 20th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990217.9332 | 2097368.8862 | 37.7384123615974 | -122.476358250403 | (37.7384123615974, -122.476358250403) | 1 | 8 | 3 | 29491 | 35 | |||
86403 | 124959 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3134 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999039.99548 | 2119574.12922 | 37.7998900109606 | -122.447453845514 | (37.7998900109606, -122.447453845514) | 13 | 9 | 1 | 57 | 17 | |||
90387 | 188632 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Charter Oak Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6010956.26861 | 2096182.79853 | 37.7363365038229 | -122.404571320413 | (37.7363365038229, -122.404571320413) | 10 | 3 | 8 | 58 | 1 | ||||
92568 | 6832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||
95651 | 73287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
96541 | 124949 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998111.26638 | 2115445.13532 | 37.78849978339 | -122.450369772273 | (37.78849978339, -122.450369772273) | 13 | 6 | 1 | 54 | 31 | |||
100326 | 124893 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3663 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997243.12279 | 2115686.80182 | 37.7891136120499 | -122.453390853122 | (37.7891136120499, -122.453390853122) | 11 | 6 | 1 | 54 | 31 | |||
100888 | 221412 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 45 Harry St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6003250.45835 | 2097675.29375 | 37.7400008805364 | -122.431320009807 | (37.7400008805364, -122.431320009807) | 2 | 7 | 5 | 63 | 7 | |||
102880 | 120066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987632.04577 | 2115290.91646 | 37.7874710320346 | -122.486614456615 | (37.7874710320346, -122.486614456615) | 11 | 6 | 1 | 55 | 33 | |||
104202 | 203681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1499 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991787.95791 | 2105297.3097 | 37.7602726867557 | -122.471507488006 | (37.7602726867557, -122.471507488006) | 1 | 8 | 4 | 56 | 12 |
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) );