trees
661 rows where qCaretaker_id = 2 and qSpecies_id = 5 sorted by qCaretaker_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35579 | 63232 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23779 | 6007031.32644483 | 2099242.02691528 | 37.7445163265111 | -122.418358357204 | (37.7445163265111, -122.418358357204) | 2 | 7 | 7 | 28859 | 2 | ||
35660 | 115844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | 13 | 9 | 1 | 57 | 17 | |||
35885 | 189864 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6015974.53489 | 2097767.48194 | 37.7409669053009 | -122.387331434622 | (37.7409669053009, -122.387331434622) | 10 | 3 | 8 | 58 | 1 | |||
35932 | 222922 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998725.13711 | 2107078.63003 | 37.7655626303238 | -122.44764337315 | (37.7655626303238, -122.44764337315) | 15 | 5 | 11 | 29492 | 9 | |||
36033 | 37053 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2015 12:00:00 AM | 3 | 6x9 | Permit Number 775674 | 6005030.06979159 | 2099868.96006137 | 37.7461248828886 | -122.425322907066 | (37.7461248828886, -122.425322907066) | 2 | 7 | 5 | 63 | 22 |
36090 | 58566 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | 15 | 5 | 11 | 29492 | 9 | ||
37593 | 63223 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 74 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/1986 12:00:00 AM | Permit Number 23767 | 6007024.24525419 | 2099097.21630379 | 37.7441183104389 | -122.418372576893 | (37.7441183104389, -122.418372576893) | 2 | 7 | 7 | 28859 | 2 | ||
37802 | 119741 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
37876 | 125979 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.8057422979318 | -122.41523987894 | (37.8057422979318, -122.41523987894) | 5 | 1 | 10 | 308 | 23 | |||
37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
38272 | 125985 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | 5 | 1 | 10 | 308 | 23 | |||
38322 | 206016 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | |||
38377 | 189958 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010386.69691 | 2108550.07878 | 37.7702624648584 | -122.407412194212 | (37.7702624648584, -122.407412194212) | 8 | 2 | 9 | 28853 | 34 | |||
38483 | 189924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013405.38871 | 2116121.70148 | 37.7912209025705 | -122.397501581628 | (37.7912209025705, -122.397501581628) | 12 | 2 | 9 | 28855 | 6 | |||
39064 | 6846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | 10 | 3 | 8 | 58 | 1 | |||
39895 | 189881 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 6 | : | Tree | Private 2 | 10 | Width 3ft | 6016559.49898 | 2098322.63372 | 37.7425236182725 | -122.385347500499 | (37.7425236182725, -122.385347500499) | 10 | 3 | 8 | 58 | 1 | |||
40377 | 103339 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
40384 | 16481 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
40554 | 189850 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 14 | : | Tree | Private 2 | 9 | Width 3ft | 6017345.72519 | 2098082.05897 | 37.7419065142755 | -122.382612199015 | (37.7419065142755, -122.382612199015) | 10 | 3 | 8 | 58 | 1 | |||
41267 | 63222 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.418392594768 | (37.7440872763149, -122.418392594768) | 2 | 7 | 7 | 28859 | 2 | ||
41358 | 115360 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 205 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6012944 | 2106057 | 37.7635598294353 | -122.398391479388 | (37.7635598294353, -122.398391479388) | 14 | 3 | 8 | 28856 | 29 | ||||
41601 | 222917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 88 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6004303.69708 | 2109018.65394 | 37.7712067098536 | -122.428486670528 | (37.7712067098536, -122.428486670528) | 7 | 9 | 11 | 28852 | 10 | |||
41676 | 175842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004274.97667 | 2092050.61974 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | 9 | 7 | 6 | 28861 | 5 | |||
42288 | 199691 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841 | (37.7276897308085, -122.38666058841) | 10 | 3 | 8 | 58 | 1 | |||
42305 | 182440 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1530 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985926.0511 | 2104791.6519 | 37.7585434265078 | -122.49174356194 | (37.7585434265078, -122.49174356194) | 1 | 8 | 3 | 56 | 35 | |||
42963 | 97180 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
43272 | 105450 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | 2 | 4 | 7 | 28859 | 19 | |||||
43480 | 65221 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 411 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 28008 | 6002203.13463286 | 2091195.37244375 | 37.7221490848593 | -122.434478026037 | (37.7221490848593, -122.434478026037) | 9 | 7 | 6 | 28861 | 5 | ||
44357 | 248229 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006943.33301 | 2099166.51729 | 37.7443040402894 | -122.418657267644 | (37.7443040402894, -122.418657267644) | 2 | 7 | 7 | 28859 | 2 | |||
44548 | 189913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6013888.27035 | 2094422.90108 | 37.731667614051 | -122.39431091023 | (37.731667614051, -122.39431091023) | 10 | 3 | 8 | 58 | 1 | |||
44569 | 119744 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
45877 | 248276 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.419278012984 | (37.7431956465585, -122.419278012984) | 2 | 7 | 7 | 28859 | 2 | |||
46212 | 61684 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 49 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21681 | 6013901.59422939 | 2093898.15648128 | 37.7302275129585 | -122.394228121663 | (37.7302275129585, -122.394228121663) | 10 | 3 | 8 | 58 | 1 | ||
46538 | 205998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998781.20203 | 2096512.57724 | 37.7365540408212 | -122.446689155601 | (37.7365540408212, -122.446689155601) | 9 | 7 | 4 | 59 | 40 | |||
47090 | 222910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004846.32395 | 2109834.20253 | 37.7734767003282 | -122.426667787188 | (37.7734767003282, -122.426667787188) | 7 | 9 | 11 | 28852 | 10 | |||
47329 | 16647 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 178 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 14 | 4x4 | 6002850.60519 | 2107244.6681 | 37.7662534427777 | -122.433386179722 | (37.7662534427777, -122.433386179722) | 15 | 5 | 5 | 28862 | 3 | ||
47459 | 189921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013437.41222 | 2116091.23603 | 37.7911390345977 | -122.397388642991 | (37.7911390345977, -122.397388642991) | 12 | 2 | 9 | 28855 | 6 | |||
47524 | 205997 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998801.07075 | 2096511.79706 | 37.7365530335853 | -122.446620405109 | (37.7365530335853, -122.446620405109) | 9 | 7 | 4 | 59 | 40 | |||
47785 | 63130 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 26 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23644 | 6007187.15982152 | 2099399.82780325 | 37.7449583833589 | -122.417830699083 | (37.7449583833589, -122.417830699083) | 2 | 7 | 7 | 28859 | 2 | ||
47941 | 218315 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.466425098064 | (37.7455947140337, -122.466425098064) | 1 | 8 | 4 | 29491 | 40 | |||
48025 | 248201 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.418633720666 | (37.7441794671077, -122.418633720666) | 2 | 7 | 7 | 28859 | 2 | |||
48301 | 225091 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | 15 | 5 | 5 | 28862 | 3 | |||
48751 | 189873 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 13 | : | Tree | Private 2 | 13 | Width 4ft | 6015949.19552 | 2097817.31467 | 37.7411023324162 | -122.387422525146 | (37.7411023324162, -122.387422525146) | 10 | 3 | 8 | 58 | 1 | |||
48763 | 225089 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 838 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004316.16009 | 2104019.9015 | 37.7574820391842 | -122.428087274435 | (37.7574820391842, -122.428087274435) | 2 | 4 | 5 | 28862 | 3 | |||
49432 | 222887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 123 Webster St | 1 | : | Tree | Private 2 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.428767500918 | (37.77173547164, -122.428767500918) | 7 | 9 | 11 | 29492 | 10 | |||
49612 | 125976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | 5 | 1 | 1 | 28858 | 32 | |||
49970 | 2531 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.386392104106 | (37.7447358261247, -122.386392104106) | 10 | 3 | 8 | 58 | 1 | |||
50058 | 103976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2440 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6000022.661 | 2113372.9775 | 37.7829193814773 | -122.44360774817 | (37.7829193814773, -122.44360774817) | 15 | 5 | 1 | 29490 | 31 | |||
50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
50667 | 2542 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016211.040056 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | 10 | 3 | 8 | 58 | 1 | |||
50898 | 49041 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46216 | 6004132.32350443 | 2101573.22879489 | 37.7507536483556 | -122.428548658976 | (37.7507536483556, -122.428548658976) | 2 | 4 | 5 | 28862 | 22 | ||
51291 | 225053 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.7369115105593 | -122.438267032523 | (37.7369115105593, -122.438267032523) | 2 | 7 | 5 | 63 | 7 | |||
52185 | 63117 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23624 | 6006928.92708318 | 2099162.96302102 | 37.7442934699851 | -122.418706828381 | (37.7442934699851, -122.418706828381) | 2 | 7 | 7 | 28859 | 2 | ||
52265 | 95955 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675 | 2116143.7 | 37.791351915434 | -122.393110267966 | (37.791351915434, -122.393110267966) | 12 | 2 | 9 | 28855 | 6 | ||
52442 | 188480 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 209 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012920.54855 | 2106035.89651 | 37.7635005775036 | -122.398471110175 | (37.7635005775036, -122.398471110175) | 14 | 3 | 8 | 28856 | 29 | |||
52787 | 222885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Valencia St | 3 | : | Tree | Private 2 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | 8 | 2 | 9 | 28853 | 19 | |||
53007 | 106030 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | 12 | 2 | 9 | 28855 | 6 | |||
53125 | 248260 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | 2 | 7 | 7 | 28859 | 2 | |||
53638 | 138239 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999639.177 | 2114119.037 | 37.784945988756 | -122.444988088871 | (37.784945988756, -122.444988088871) | 15 | 6 | 1 | 29490 | 31 | |||
53679 | 56848 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 6x5 | Permit Number 14082 | 5998817.86133668 | 2106377.94605096 | 37.7636440271414 | -122.447272227776 | (37.7636440271414, -122.447272227776) | 15 | 5 | 11 | 29492 | 9 | ||
53701 | 51842 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 34 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 48069 | 6007044.58832094 | 2099374.8552715 | 37.7448817898933 | -122.418321916232 | (37.7448817898933, -122.418321916232) | 2 | 7 | 7 | 28859 | 2 | ||
54072 | 4915 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
54428 | 50386 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
54510 | 225090 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002851.63466 | 2107200.77986 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | 15 | 5 | 5 | 28862 | 3 | |||
54786 | 106031 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014640.7 | 2115990 | 37.7909279854042 | -122.39321818634 | (37.7909279854042, -122.39321818634) | 12 | 2 | 9 | 28855 | 6 | ||||
55436 | 126001 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466 | (37.8058471777553, -122.41693886466) | 5 | 1 | 10 | 308 | 23 | |||
56161 | 18866 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2241 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004050.55009 | 2115976.04283 | 37.7902956422834 | -122.429858659173 | (37.7902956422834, -122.429858659173) | 13 | 9 | 1 | 29490 | 27 | |||
56324 | 225070 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009108.93583 | 2103990.98377 | 37.757672636103 | -122.411509829221 | (37.757672636103, -122.411509829221) | 2 | 4 | 7 | 28859 | 19 | |||
56492 | 21779 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2535 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6008355.3148 | 2121474.21304 | 37.8056350868765 | -122.415353830252 | (37.8056350868765, -122.415353830252) | 5 | 1 | 10 | 308 | 23 | |||
56519 | 44334 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 57 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2001 12:00:00 AM | Permit Number 43719 | 6004283.91720992 | 2108781.91004669 | 37.770555549309 | -122.428538212023 | (37.770555549309, -122.428538212023) | 7 | 9 | 11 | 29492 | 10 | ||
56752 | 189914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 11 | : | Tree | Private 2 | 5 | Width 3ft | 6013894.18582 | 2094452.33408 | 37.7317487598799 | -122.394292519091 | (37.7317487598799, -122.394292519091) | 10 | 3 | 8 | 58 | 1 | |||
56818 | 139055 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2693 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999732.7035 | 2113978.0164 | 37.7845641202108 | -122.444654378813 | (37.7845641202108, -122.444654378813) | 15 | 6 | 11 | 29490 | 31 | |||
57257 | 189907 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6016312.90853 | 2098309.60993 | 37.7424742122044 | -122.386199237601 | (37.7424742122044, -122.386199237601) | 10 | 3 | 8 | 58 | 1 | |||
57482 | 140579 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.431800729752 | (37.7783626547096, -122.431800729752) | 15 | 9 | 11 | 29492 | 41 | |||
57765 | 225058 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996870.76469 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | 15 | 5 | 11 | 29492 | 12 | |||
58282 | 115847 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003582.67693 | 2120834.73516 | 37.8036098524612 | -122.431824529496 | (37.8036098524612, -122.431824529496) | 13 | 9 | 1 | 57 | 17 | |||
58785 | 16556 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 | |||
59975 | 125986 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008368.52895 | 2121668.47116 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | 5 | 1 | 10 | 308 | 23 | |||
60278 | 189935 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013248.49941 | 2116191.11402 | 37.791402756277 | -122.398049289468 | (37.791402756277, -122.398049289468) | 12 | 2 | 9 | 28855 | 6 | |||
60431 | 103341 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
60751 | 64436 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2445 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1988 12:00:00 AM | 12 | Permit Number 25292 | 6006658.75135 | 2119650.10198 | 37.8005310432266 | -122.421095439396 | (37.8005310432266, -122.421095439396) | 5 | 9 | 1 | 28858 | 32 | ||
60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
60927 | 189962 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | 8 | 2 | 9 | 28853 | 34 | |||
61480 | 246510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | 2 | 7 | 5 | 63 | 22 | |||
61840 | 222914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6004276.58953 | 2109191.75922 | 37.7716804808011 | -122.428592777936 | (37.7716804808011, -122.428592777936) | 7 | 9 | 11 | 28852 | 10 | |||
61904 | 110184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
62069 | 4912 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
62178 | 189960 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010412.08756 | 2108524.30899 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | 8 | 2 | 9 | 28853 | 34 | |||
62355 | 225056 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901045 | -122.438748363154 | (37.737188901045, -122.438748363154) | 2 | 7 | 5 | 63 | 7 | |||
62483 | 119737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | 12 | 2 | 9 | 28855 | 6 | ||||
62803 | 189959 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010397.61848 | 2108539.03358 | 37.7702327485634 | -122.40737363759 | (37.7702327485634, -122.40737363759) | 8 | 2 | 9 | 28853 | 34 | |||
62825 | 246517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 41 Waller St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005417.73549 | 2109222.56247 | 37.7718295731126 | -122.424647671566 | (37.7718295731126, -122.424647671566) | 7 | 9 | 5 | 28852 | 10 | |||
62864 | 62271 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22405 | 6004283.36290773 | 2109163.56782991 | 37.7716034574246 | -122.428567338549 | (37.7716034574246, -122.428567338549) | 7 | 9 | 11 | 28852 | 10 | ||
62929 | 57320 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | 15 | 6 | 1 | 29490 | 31 | ||
63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
63341 | 189955 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014561.09202 | 2115949.59191 | 37.790812611275 | -122.393490799583 | (37.790812611275, -122.393490799583) | 12 | 2 | 9 | 28855 | 6 | |||
63547 | 57317 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.445093871748 | (37.7846624482509, -122.445093871748) | 15 | 6 | 1 | 29490 | 31 | ||
63557 | 17398 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | 10 | 3 | 8 | 58 | 1 |
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) );