trees
3,965 rows where qSpecies_id = 70 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8376 | 124888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3779 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5996596.43965 | 2115271.00259 | 37.7879348499518 | -122.455598215684 | (37.7879348499518, -122.455598215684) | 11 | 6 | 1 | 54 | 31 | |||
8386 | 20019 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
8416 | 20389 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
8459 | 142451 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 612 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004562.1168 | 2110606.9092 | 37.7755822921182 | -122.427705966737 | (37.7755822921182, -122.427705966737) | 7 | 9 | 11 | 28852 | 10 | |||
8511 | 60095 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3343 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 10 | Permit Number 19596 | 5998235.21709 | 2116151.87187 | 37.7904473875938 | -122.449991880723 | (37.7904473875938, -122.449991880723) | 13 | 6 | 1 | 54 | 31 | |
8592 | 186947 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985208.6903 | 2095991.5414 | 37.7343387611716 | -122.493576064205 | (37.7343387611716, -122.493576064205) | 1 | 8 | 3 | 29491 | 35 | |||
8626 | 188622 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 20 | : | Tree | Private 2 | 16 | Width 3ft | 6016025.72974 | 2098951.35828 | 37.7442204222503 | -122.387236979699 | (37.7442204222503, -122.387236979699) | 10 | 3 | 8 | 58 | 1 | |||
8673 | 175076 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1262 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6001389.55659 | 2087620.87899 | 37.7122881079857 | -122.437034577295 | (37.7122881079857, -122.437034577295) | 9 | 7 | 6 | 28861 | 5 | |||
8880 | 218201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 950 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 2ft | 5993067.47845 | 2098384.45783 | 37.7413657105616 | -122.466579789523 | (37.7413657105616, -122.466579789523) | 1 | 8 | 4 | 59 | 40 | |||
8928 | 116888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 799X Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999171.6155 | 2121461.35655 | 37.8050793482968 | -122.447134285827 | (37.8050793482968, -122.447134285827) | 13 | 9 | 1 | 57 | 17 | |||
8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
8988 | 125125 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2921 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | Permit Number 784827 | 5999533.93344 | 2117358.43143 | 37.7938345087112 | -122.445585222496 | (37.7938345087112, -122.445585222496) | 13 | 9 | 1 | 57 | 27 | ||
9096 | 249565 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | |||
9246 | 254278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
9385 | 247789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 30th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | |||
9481 | 10434 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259864 | (37.7700106766776, -122.44636259864) | 15 | 5 | 11 | 29492 | 9 | |||
9517 | 246826 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400 Franconia St | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6009973.79808 | 2098728.47143 | 37.7432714144464 | -122.408147628312 | (37.7432714144464, -122.408147628312) | 10 | 7 | 7 | 28859 | 2 | ||||
9545 | 125091 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2145 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5999825.73653 | 2116332.01645 | 37.7910328983896 | -122.444501757055 | (37.7910328983896, -122.444501757055) | 13 | 6 | 1 | 29490 | 27 | |||
9651 | 140669 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996810.1841 | 2110348.4784 | 37.7744311612044 | -122.4545029637 | (37.7744311612044, -122.4545029637) | 15 | 5 | 2 | 29492 | 16 | |||
9682 | 19808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY23 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
9702 | 254280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
9708 | 261204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
9851 | 187722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6017248.25374 | 2094957.00254 | 37.7333203494413 | -122.382731813344 | (37.7333203494413, -122.382731813344) | 10 | 3 | 8 | 58 | 1 | |||
9883 | 262003 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1503X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 5984810 | 2104956 | 37.7589293895364 | -122.495615433308 | (37.7589293895364, -122.495615433308) | 1 | 8 | 3 | 56 | 35 | ||||
10158 | 203254 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 355 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5996025.0602 | 2095489.12153 | 37.7335860541429 | -122.456144283154 | (37.7335860541429, -122.456144283154) | 9 | 7 | 4 | 59 | 40 | |||
10167 | 16529 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
10275 | 125283 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1022 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6008553.3357 | 2118652.52979 | 37.7978985774107 | -122.414468760628 | (37.7978985774107, -122.414468760628) | 5 | 1 | 10 | 308 | 21 | ||||
10310 | 23457 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6005866.88323 | 2118164.3475 | 37.7964068674367 | -122.423729927819 | (37.7964068674367, -122.423729927819) | 13 | 9 | 1 | 28858 | 27 | |||
10320 | 247790 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 30th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | |||
10444 | 20024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
10569 | 50188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3134 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | 12 | Permit Number 46895 | 5999411.86905 | 2119620.94961 | 37.8000398110413 | -122.446170397871 | (37.8000398110413, -122.446170397871) | 13 | 9 | 1 | 57 | 17 | ||
10690 | 124815 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3766 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999638.74415 | 2121468.4947 | 37.8051256264981 | -122.44551825176 | (37.8051256264981, -122.44551825176) | 13 | 9 | 1 | 57 | 17 | |||
10693 | 125255 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008483 | 2116904 | 37.7930935946089 | -122.4145883443 | (37.7930935946089, -122.4145883443) | 5 | 1 | 10 | 28858 | 21 | |||
10730 | 138280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2181 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001790.7253 | 2113918.6029 | 37.7845182087175 | -122.43753007696 | (37.7845182087175, -122.43753007696) | 13 | 6 | 11 | 29490 | 13 | |||
10864 | 203957 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 Taraval St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5992667.73438 | 2099093.54036 | 37.743289595145 | -122.468013518407 | (37.743289595145, -122.468013518407) | 1 | 8 | 4 | 29491 | 40 | |||
10950 | 221380 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 17 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x6 | 6001456.08064 | 2108152.14288 | 37.768665929923 | -122.438274581434 | (37.768665929923, -122.438274581434) | 15 | 5 | 5 | 29492 | 3 | |||
11032 | 221382 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 715 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002069.15258 | 2108242.45894 | 37.7689487658061 | -122.436160481228 | (37.7689487658061, -122.436160481228) | 15 | 5 | 5 | 29492 | 3 | |||
11242 | 203747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 265 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992322.04503 | 2097512.5452 | 37.7389286143523 | -122.469093773255 | (37.7389286143523, -122.469093773255) | 1 | 8 | 4 | 59 | 40 | |||
11322 | 203935 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991414.01915 | 2104819.13724 | 37.7589381117154 | -122.472765887756 | (37.7589381117154, -122.472765887756) | 1 | 8 | 4 | 56 | 12 | |||
11343 | 200776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 | |||
11370 | 188616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 13 | : | Tree | Private 2 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442492 | (37.7437624397877, -122.38739442492) | 10 | 3 | 8 | 58 | 1 | |||
11389 | 203909 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5993407.09821 | 2104662.05397 | 37.7586219766534 | -122.465861529796 | (37.7586219766534, -122.465861529796) | 1 | 8 | 4 | 56 | 12 | |||
11390 | 186929 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985223.4885 | 2095932.3487 | 37.7341770994248 | -122.493520542824 | (37.7341770994248, -122.493520542824) | 1 | 8 | 3 | 29491 | 35 | |||
11522 | 125190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003477.09721 | 2118091.6097 | 37.7960719563118 | -122.431993895221 | (37.7960719563118, -122.431993895221) | 13 | 9 | 1 | 57 | 17 | |||
11537 | 125159 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2695 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000739.26248 | 2117523.11724 | 37.7943554320128 | -122.441426505548 | (37.7943554320128, -122.441426505548) | 13 | 9 | 1 | 57 | 27 | |||
11631 | 125182 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2409 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002021.80255 | 2117699.99218 | 37.7949140656765 | -122.437001442682 | (37.7949140656765, -122.437001442682) | 13 | 9 | 1 | 57 | 27 | |||
11658 | 6629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575 | (37.7408992492988, -122.38498513575) | 10 | 3 | 8 | 58 | 1 | ||
11795 | 20386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
11987 | 123197 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 535 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5993108.64325 | 2111815.91 | 37.7782473453158 | -122.467413915116 | (37.7782473453158, -122.467413915116) | 11 | 6 | 2 | 54 | 11 | |||
12035 | 182056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1338 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5987434.16 | 2106158.3393 | 37.7623840025198 | -122.486628260583 | (37.7623840025198, -122.486628260583) | 1 | 8 | 3 | 56 | 35 | |||
12083 | 109385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5990496.07684 | 2114830.6827 | 37.7863739000635 | -122.476671958733 | (37.7863739000635, -122.476671958733) | 11 | 6 | 1 | 55 | 33 | |||
12119 | 20453 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12179 | 220312 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.7591589249724 | -122.436118906483 | (37.7591589249724, -122.436118906483) | 2 | 4 | 5 | 28862 | 3 | |||
12317 | 124989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2330 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999632.98493 | 2120193.24081 | 37.8016237941718 | -122.445446428326 | (37.8016237941718, -122.445446428326) | 13 | 9 | 1 | 57 | 17 | |||
12430 | 220123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Haight St | 1 | : | Tree | Private 2 | 26 | Width 4ft | 6003680.56736 | 2109328.54381 | 37.772022309504 | -122.430664217001 | (37.772022309504, -122.430664217001) | 15 | 9 | 11 | 29492 | 10 | |||
12630 | 24191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
12631 | 184116 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986935.2197 | 2104347.7839 | 37.7573836158365 | -122.488220831337 | (37.7573836158365, -122.488220831337) | 1 | 8 | 3 | 56 | 35 | |||
12649 | 157063 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1617 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 10ft | 5995578.39636 | 2094696.59169 | 37.7313843105403 | -122.457631195237 | (37.7313843105403, -122.457631195237) | 9 | 7 | 4 | 59 | 40 | |||
12663 | 203708 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2492 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991744.37549 | 2098480.08331 | 37.7415518324448 | -122.471161539499 | (37.7415518324448, -122.471161539499) | 1 | 8 | 4 | 29491 | 40 | |||
12665 | 125122 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2950 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 5999479.00894 | 2117042.99572 | 37.7929652698817 | -122.445752570148 | (37.7929652698817, -122.445752570148) | 13 | 9 | 1 | 57 | 27 | |||
12706 | 203693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994214.99035 | 2106013.29581 | 37.7623787074434 | -122.463165538553 | (37.7623787074434, -122.463165538553) | 1 | 5 | 11 | 56 | 12 | |||
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 | |||||
12816 | 220238 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 699 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6007928.58069 | 2103932.3959 | 37.7574454889439 | -122.415587844621 | (37.7574454889439, -122.415587844621) | 2 | 4 | 7 | 28859 | 19 | |||
12857 | 125310 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013216.03203 | 2118385.20589 | 37.7974254053999 | -122.398315638071 | (37.7974254053999, -122.398315638071) | 3 | 1 | 10 | 28860 | 6 | |||
12860 | 203770 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1601 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 5ft | 5992012.04264 | 2096406.00998 | 37.7358724311684 | -122.470085057304 | (37.7358724311684, -122.470085057304) | 1 | 8 | 4 | 59 | 40 | |||
13033 | 20683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1505X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984801 | 2104643 | 37.7580694516324 | -122.495623472482 | (37.7580694516324, -122.495623472482) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
13357 | 125065 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3400 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 5997930.57243 | 2116155.0527 | 37.7904386848382 | -122.45104615598 | (37.7904386848382, -122.45104615598) | 11 | 6 | 1 | 54 | 31 | |||
13449 | 123516 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2750 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5994807.17299 | 2110239.19888 | 37.7740160273107 | -122.461423785316 | (37.7740160273107, -122.461423785316) | 11 | 6 | 2 | 54 | 11 | |||
13471 | 20029 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
13523 | 248109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 138 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | 2 | 7 | 7 | 28859 | 2 | ||||
13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
13821 | 187767 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6016274.41454 | 2097399.64045 | 37.7399734907733 | -122.386268912575 | (37.7399734907733, -122.386268912575) | 10 | 3 | 8 | 58 | 1 | |||
13825 | 87087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | 13 | 6 | 1 | 29490 | 27 | ||
13976 | 1368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.7461879050589 | -122.445863385507 | (37.7461879050589, -122.445863385507) | 2 | 7 | 5 | 63 | 22 | ||
14009 | 125068 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6001667.65947 | 2115975.31483 | 37.7901584138266 | -122.438103221909 | (37.7901584138266, -122.438103221909) | 13 | 6 | 1 | 29490 | 27 | |||
14016 | 249712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 1 | Back Yard : Yard | Tree | Private 2 | 21 | 5999372.04623 | 2116967.23886 | 37.7927511539072 | -122.44611721374 | (37.7927511539072, -122.44611721374) | 13 | 9 | 1 | 29490 | 27 | ||||
14017 | 181325 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1229 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5987669.8168 | 2106894.9032 | 37.7644201395656 | -122.485867286736 | (37.7644201395656, -122.485867286736) | 1 | 8 | 3 | 56 | 35 | |||
14165 | 22132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6015998.68116 | 2098857.5612 | 37.743961376797 | -122.387323966992 | (37.743961376797, -122.387323966992) | 10 | 3 | 8 | 58 | 1 | |||
14184 | 82402 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41X 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5990494.67077 | 2114802.82802 | 37.7862973373572 | -122.476674787546 | (37.7862973373572, -122.476674787546) | 11 | 6 | 1 | 55 | 33 | |||
14224 | 83328 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1653-1655 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 23 | 6008329.52279 | 2118179.08917 | 37.7965860510686 | -122.415209687771 | (37.7965860510686, -122.415209687771) | 5 | 1 | 10 | 28858 | 21 | |||
14404 | 261203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
14423 | 114573 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3621 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | 5997465.48926 | 2115720.33673 | 37.7892184334409 | -122.452623918478 | (37.7892184334409, -122.452623918478) | 11 | 6 | 1 | 54 | 31 | ||
14483 | 22142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
14554 | 205138 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1998 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993815.52591 | 2101897.64726 | 37.7510551789624 | -122.464248318725 | (37.7510551789624, -122.464248318725) | 1 | 8 | 4 | 29491 | 12 | |||
14555 | 247858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Bradford St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.409495368525 | (37.7414618274161, -122.409495368525) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | |||
14836 | 221387 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 701 Church St | 38 | Front Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6004318.36502 | 2104792.37844 | 37.7596032026492 | -122.428134698373 | (37.7596032026492, -122.428134698373) | 2 | 4 | 5 | 28862 | 3 | |||
14952 | 124990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2354 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999518.65691 | 2120176.7884 | 37.8015720930274 | -122.44584087006 | (37.8015720930274, -122.44584087006) | 13 | 9 | 1 | 57 | 17 | |||
15068 | 59890 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 12 | Permit Number 19356 | 5998808.9736 | 2111008.0431 | 37.7763565892826 | -122.447636289265 | (37.7763565892826, -122.447636289265) | 15 | 6 | 2 | 29492 | 16 | |
15072 | 246185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999538.3824 | 2108204.1634 | 37.7686995067752 | -122.444911465275 | (37.7686995067752, -122.444911465275) | 15 | 5 | 11 | 29492 | 9 | |||
15095 | 182345 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1522 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x8 | 5988118 | 2104920 | 37.7590237008279 | -122.484172322146 | (37.7590237008279, -122.484172322146) | 1 | 8 | 3 | 56 | 35 | |||
15097 | 125078 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2402 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6002281.85498 | 2116525.22121 | 37.7917032260602 | -122.4360175223 | (37.7917032260602, -122.4360175223) | 13 | 9 | 1 | 29490 | 27 | |||
15115 | 203925 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799X 12th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5992470.02129 | 2103495.15392 | 37.755363873152 | -122.469017416317 | (37.755363873152, -122.469017416317) | 1 | 8 | 4 | 56 | 12 | |||
15118 | 247553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000067.12392 | 2108379.27144 | 37.7692104712049 | -122.443095172401 | (37.7692104712049, -122.443095172401) | 15 | 5 | 11 | 29492 | 9 | |||
15187 | 6707 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017570.5024 | 2096779.609 | 37.7383426628708 | -122.381744418894 | (37.7383426628708, -122.381744418894) | 10 | 3 | 8 | 58 | 1 | |||
15359 | 124880 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3820 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5996409.41763 | 2115616.90715 | 37.7888738770624 | -122.456270294343 | (37.7888738770624, -122.456270294343) | 11 | 6 | 1 | 54 | 31 | |||
15463 | 20023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST |
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) );