661 rows where qCaretaker_id = 2 and qSpecies_id = 5

View and edit SQL

These facets timed out: qCaretaker_id

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);