trees
969 rows where qSpecies_id = 97 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29430 | 114806 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
29906 | 224646 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006447.48473 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | 2 | 7 | 7 | 28859 | 2 | |||
30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
30056 | 250762 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 231 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985862.1127 | 2114339.73432 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | 11 | 6 | 1 | 55 | 33 | |||
30326 | 99286 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
30441 | 116039 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008038.31567 | 2116541.76159 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | 5 | 1 | 10 | 28858 | 21 | |||
30487 | 99178 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008617 | 2122137 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | 3 | 1 | 10 | 308 | 23 | ||||
30525 | 109918 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6010269.5 | 2121152.3 | 37.8048585915517 | -122.408706764133 | (37.8048585915517, -122.408706764133) | 3 | 1 | 10 | 308 | 23 | ||||
30771 | 101430 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
31188 | 116841 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6002015 | 2107091 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | 15 | 5 | 5 | 28862 | 3 | |||
31557 | 199435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | 10 | 3 | 8 | 58 | 1 | |||
31709 | 224519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007848.49243 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | 2 | 4 | 7 | 28859 | 19 | |||
32503 | 176413 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001088.39895 | 2089005.35886 | 37.7160724587542 | -122.4381745822 | (37.7160724587542, -122.4381745822) | 9 | 7 | 6 | 28861 | 5 | |||
32511 | 117226 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
32764 | 224689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | 2 | 4 | 5 | 28859 | 19 | |||
32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
33097 | 176407 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 65 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998589.29961 | 2087923.49641 | 37.7129594608753 | -122.446734823157 | (37.7129594608753, -122.446734823157) | 9 | 7 | 6 | 28861 | 25 | |||
33103 | 224636 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | 2 | 7 | 7 | 28859 | 2 | |||
33181 | 224693 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006755.71735 | 2102172.37571 | 37.7525468808523 | -122.41951921745 | (37.7525468808523, -122.41951921745) | 2 | 4 | 7 | 28859 | 19 | |||
33250 | 224563 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3121 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008575.93906 | 2105040.68247 | 37.7605249582808 | -122.413427391562 | (37.7605249582808, -122.413427391562) | 2 | 4 | 7 | 28859 | 19 | |||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
33799 | 112160 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | 14 | 3 | 8 | 28856 | 29 | |||
34847 | 173694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011772 | 2114653 | 37.7870971135768 | -122.403049742128 | (37.7870971135768, -122.403049742128) | 12 | 2 | 9 | 28853 | 6 | ||||
34968 | 258294 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
35053 | 224682 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.7506386642487 | -122.420640252069 | (37.7506386642487, -122.420640252069) | 2 | 4 | 5 | 28859 | 19 | |||
35509 | 224601 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3328 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006122.42737 | 2103775.96782 | 37.756914282788 | -122.421823142019 | (37.756914282788, -122.421823142019) | 2 | 4 | 5 | 28859 | 19 | |||
36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
36191 | 251014 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995959.01851 | 2115881.76769 | 37.7895752475348 | -122.457847777179 | (37.7895752475348, -122.457847777179) | 11 | 6 | 1 | 54 | 31 | |||
36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
36309 | 577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.7526513982496 | -122.412443801263 | (37.7526513982496, -122.412443801263) | 2 | 4 | 7 | 28859 | 19 | |||
36324 | 102902 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012556 | 2118523 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | 3 | 1 | 10 | 28860 | 6 | ||||
36516 | 226493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008772.32666 | 2104949.65017 | 37.7602860290962 | -122.41274173856 | (37.7602860290962, -122.41274173856) | 2 | 4 | 7 | 28859 | 19 | |||
36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
37042 | 224690 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006361.82473 | 2101451.21677 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | 2 | 4 | 5 | 28859 | 19 | |||
37053 | 176425 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011982.06755 | 2090001.33634 | 37.7194207606357 | -122.400590586484 | (37.7194207606357, -122.400590586484) | 10 | 7 | 8 | 309 | 28 | |||
37346 | 250802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | 11 | 6 | 1 | 55 | 33 | |||
37377 | 176427 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6010742.02473 | 2089174.64706 | 37.7170816042145 | -122.404818807562 | (37.7170816042145, -122.404818807562) | 9 | 7 | 8 | 309 | 39 | |||
37941 | 184315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.7574413473895 | -122.498265228241 | (37.7574413473895, -122.498265228241) | 1 | 8 | 3 | 56 | 35 | |||
38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
38158 | 101288 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
38685 | 224661 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008966.38412 | 2105242.83972 | 37.7611019507102 | -122.412091302998 | (37.7611019507102, -122.412091302998) | 2 | 4 | 7 | 28859 | 19 | |||
38823 | 218811 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Williar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997101.63162 | 2090622.46989 | 37.7202851197392 | -122.45207127697 | (37.7202851197392, -122.45207127697) | 9 | 8 | 6 | 28861 | 24 | |||
39200 | 111610 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.7183345981422 | -122.403290521257 | (37.7183345981422, -122.403290521257) | 10 | 7 | 8 | 309 | 39 | |||
39540 | 251008 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995662.21487 | 2115838.76904 | 37.7894401289022 | -122.458871565395 | (37.7894401289022, -122.458871565395) | 11 | 6 | 1 | 54 | 31 | |||
39589 | 224649 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | 2 | 7 | 7 | 28859 | 2 | |||
39650 | 224603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3360 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6005941.90978 | 2103767.20067 | 37.7568800285 | -122.42244681736 | (37.7568800285, -122.42244681736) | 2 | 4 | 5 | 28859 | 19 | |||
39862 | 7496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008261.67558 | 2102751.78327 | 37.754222512966 | -122.414352332587 | (37.754222512966, -122.414352332587) | 2 | 4 | 7 | 28859 | 19 | |||
39941 | 6742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.50063 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | 10 | 3 | 8 | 58 | 1 | ||
40301 | 218803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.469130812732 | (37.7439598068059, -122.469130812732) | 1 | 8 | 4 | 29491 | 40 | |||
40635 | 24450 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.420651186023 | (37.7507621663522, -122.420651186023) | 2 | 4 | 5 | 28859 | 19 | |||
40903 | 224617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 970 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999693.04498 | 2101841.13049 | 37.7512370173901 | -122.443919267953 | (37.7512370173901, -122.443919267953) | 2 | 5 | 5 | 63 | 38 | |||
41384 | 176403 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998770.03746 | 2087851.68696 | 37.7127726114513 | -122.446104973962 | (37.7127726114513, -122.446104973962) | 9 | 7 | 6 | 28861 | 25 | |||
42094 | 107775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | 15 | 5 | 11 | 29492 | 12 | |||||
42243 | 226471 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008696.07449 | 2105092.67763 | 37.760674469666 | -122.413015573106 | (37.760674469666, -122.413015573106) | 2 | 4 | 7 | 28859 | 19 | |||
42368 | 255609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 355X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006938 | 2104061 | 37.7577428748963 | -122.419022796788 | (37.7577428748963, -122.419022796788) | 2 | 4 | 7 | 28859 | 19 | ||||
42763 | 224607 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3540 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6005920.82892 | 2102594.51157 | 37.753658906948 | -122.42243640053 | (37.753658906948, -122.42243640053) | 2 | 4 | 5 | 28859 | 19 | |||
42798 | 224620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1316 Clayton St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5999063.56077 | 2105040.06353 | 37.759984571857 | -122.446326183806 | (37.759984571857, -122.446326183806) | 15 | 5 | 5 | 28862 | 3 | |||
42835 | 218840 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | 1 | 8 | 4 | 59 | 40 | |||
42896 | 249545 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6006121.63422 | 2114038.60368 | 37.7850929805917 | -122.422555115551 | (37.7850929805917, -122.422555115551) | 13 | 9 | 11 | 28858 | 41 | |||
43225 | 249547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 4 | : | Tree | Private 2 | 15 | Width 3ft | 6006068.98024 | 2114032.12876 | 37.7850722314402 | -122.422736821748 | (37.7850722314402, -122.422736821748) | 13 | 9 | 11 | 28858 | 41 | |||
43388 | 102901 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 712 BATTERY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012523 | 2118543 | 37.7978200413762 | -122.400724815577 | (37.7978200413762, -122.400724815577) | 3 | 1 | 10 | 28860 | 6 | ||||
43800 | 218814 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 317 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995878.65108 | 2088143.05914 | 37.7134071101336 | -122.456119525718 | (37.7134071101336, -122.456119525718) | 9 | 8 | 6 | 28861 | 24 | |||
44250 | 224525 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006711.81921 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | 2 | 4 | 7 | 28859 | 19 | |||
44755 | 124423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996107.97218 | 2115471.34233 | 37.78845688642 | -122.457302712744 | (37.78845688642, -122.457302712744) | 11 | 6 | 1 | 54 | 31 | |||
45475 | 224673 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 610 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007868.35883 | 2104304.97763 | 37.7584651276847 | -122.415822498411 | (37.7584651276847, -122.415822498411) | 2 | 4 | 7 | 28859 | 19 | |||
46674 | 111609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 15x3 | 6011168.56615 | 2089615.14952 | 37.7183149668287 | -122.403375421742 | (37.7183149668287, -122.403375421742) | 10 | 7 | 8 | 309 | 39 | |||
46703 | 633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | 2 | 4 | 7 | 28859 | 19 | |||
46826 | 110117 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
46860 | 126624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 801x Greenwich St | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.8019265293585 | -122.412796822924 | (37.8019265293585, -122.412796822924) | 3 | 1 | 10 | 308 | 4 | |||
47140 | 218809 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661 | (37.720406603762, -122.45403210661) | 9 | 8 | 6 | 28861 | 24 | |||
47523 | 75088 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936 | 2108949 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | 15 | 5 | 11 | 29492 | 9 | ||
47706 | 176411 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000874.43024 | 2091115.97701 | 37.7218555689538 | -122.439065336396 | (37.7218555689538, -122.439065336396) | 9 | 7 | 6 | 28861 | 25 | |||
47723 | 224642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006381.67631 | 2098450.75503 | 37.742307080422 | -122.420548562565 | (37.742307080422, -122.420548562565) | 2 | 7 | 7 | 28859 | 2 | |||
47834 | 106690 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4x4 | 6004701 | 2103385 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | 2 | 4 | 5 | 28862 | 22 | |||
47963 | 226470 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008736.33721 | 2105092.98384 | 37.76067757053 | -122.412876343665 | (37.76067757053, -122.412876343665) | 2 | 4 | 7 | 28859 | 19 | |||
48982 | 176417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 825 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001125.80716 | 2088973.54213 | 37.7159872246076 | -122.438043004189 | (37.7159872246076, -122.438043004189) | 9 | 7 | 6 | 28861 | 5 | |||
49450 | 111387 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014036 | 2112699 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | 6 | 2 | 9 | 28856 | 6 | ||||
50071 | 218822 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 210 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | 9 | 8 | 6 | 64 | 24 | |||
50215 | 176416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 860 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000990.84724 | 2088839.6326 | 37.715611862882 | -122.438499899353 | (37.715611862882, -122.438499899353) | 9 | 7 | 6 | 28861 | 5 | |||
50814 | 224511 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | 2 | 4 | 7 | 28859 | 19 | |||
50896 | 226475 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008399.69622 | 2105072.76604 | 37.7606031552393 | -122.414039206643 | (37.7606031552393, -122.414039206643) | 2 | 4 | 7 | 28859 | 19 | |||
51336 | 24449 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006348.43077 | 2102831.95647 | 37.7543349884778 | -122.420974512988 | (37.7543349884778, -122.420974512988) | 2 | 4 | 5 | 28859 | 19 | |||
51462 | 218829 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 833 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | 1 | 8 | 4 | 29491 | 40 | |||
51797 | 224520 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007846.93969 | 2105383.76914 | 37.7614260366957 | -122.41597297028 | (37.7614260366957, -122.41597297028) | 2 | 4 | 7 | 28859 | 19 | |||
52542 | 224684 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006347.14535 | 2101407.65794 | 37.7504241193009 | -122.420877843938 | (37.7504241193009, -122.420877843938) | 2 | 4 | 5 | 28859 | 19 | |||
52676 | 224579 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2577 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008913.82756 | 2103471.3398 | 37.7562348656635 | -122.412147871222 | (37.7562348656635, -122.412147871222) | 2 | 4 | 7 | 28859 | 19 | |||
53327 | 176434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389842 | (37.714006934552, -122.47040389842) | 9 | 8 | 6 | 64 | 24 | |||
53715 | 108962 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
54116 | 24446 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.7544300800889 | -122.420987008139 | (37.7544300800889, -122.420987008139) | 2 | 4 | 5 | 28859 | 19 | |||
54673 | 224671 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533 | -122.410721013192 | (37.758881337533, -122.410721013192) | 2 | 4 | 7 | 28859 | 19 | |||
55089 | 600 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.413621638824 | (37.7525711157729, -122.413621638824) | 2 | 4 | 7 | 28859 | 19 | |||
55241 | 5358 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004797.67228 | 2107012.30465 | 37.7657256990156 | -122.426635095043 | (37.7657256990156, -122.426635095043) | 8 | 4 | 5 | 28862 | 3 | |||
55334 | 224658 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.7469678609981 | -122.41772795229 | (37.7469678609981, -122.41772795229) | 2 | 7 | 7 | 28859 | 2 | |||
55915 | 224624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | 15 | 5 | 5 | 28862 | 12 | |||
56103 | 224554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3363 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007798.32865 | 2104414.86293 | 37.7587629102964 | -122.416072476661 | (37.7587629102964, -122.416072476661) | 2 | 4 | 7 | 28859 | 19 | |||
57015 | 224709 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006609.60192 | 2103216.71936 | 37.7554061772577 | -122.420098619173 | (37.7554061772577, -122.420098619173) | 2 | 4 | 7 | 28859 | 19 | |||
57245 | 99116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
57590 | 218841 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1522 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994017.40797 | 2105128.44374 | 37.7599377495509 | -122.463784669644 | (37.7599377495509, -122.463784669644) | 1 | 5 | 4 | 56 | 12 | |||
57933 | 224547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007651.432 | 2104404.91293 | 37.758727329511 | -122.416579809432 | (37.758727329511, -122.416579809432) | 2 | 4 | 7 | 28859 | 19 |
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) );