trees
336 rows where SiteOrder = 1 and qSpecies_id = 5 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
846 | 115842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003573.21553 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | 13 | 9 | 1 | 57 | 17 | |||
2297 | 16623 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | 15 | 5 | 5 | 28862 | 3 | |||
3395 | 17446 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012949.46477 | 2096727.20845 | 37.7379425338291 | -122.397718137505 | (37.7379425338291, -122.397718137505) | 10 | 3 | 8 | 58 | 1 | |||
4137 | 61685 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.7304214900476 | -122.394362775032 | (37.7304214900476, -122.394362775032) | 10 | 3 | 8 | 58 | 1 | |
6002 | 65883 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3100X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2013 12:00:00 AM | 3 | Permit Number 770126 | 6002440.42815 | 2118878.88214 | 37.7981747762893 | -122.435637321312 | (37.7981747762893, -122.435637321312) | 13 | 9 | 1 | 57 | 17 | ||
9688 | 52724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | 12 | 2 | 9 | 28855 | 6 | ||
9983 | 248199 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698122 | (37.7440974516285, -122.41868698122) | 2 | 7 | 7 | 28859 | 2 | |||
13041 | 19762 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
14153 | 61726 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1984 12:00:00 AM | 9 | Permit Number 21728 | 6013869.02725 | 2093995.24936 | 37.7304922999628 | -122.39434750634 | (37.7304922999628, -122.39434750634) | 10 | 3 | 8 | 58 | 1 | |
16205 | 222929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | 15 | 5 | 11 | 29492 | 9 | |
18217 | 222886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Webster St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | 7 | 9 | 11 | 29492 | 10 | |||
18873 | 61724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1984 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.394301699376 | (37.7307052783181, -122.394301699376) | 10 | 3 | 8 | 58 | 1 | |
18931 | 16634 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.433406271499 | (37.7664480128774, -122.433406271499) | 15 | 5 | 5 | 28862 | 3 | |||
19336 | 247504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.445142787454 | (37.7703040400286, -122.445142787454) | 15 | 5 | 11 | 29492 | 9 | |||
19461 | 138737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2945 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999415.669 | 2114277.6236 | 37.7853686673978 | -122.445772761062 | (37.7853686673978, -122.445772761062) | 15 | 6 | 1 | 29490 | 31 | |||
20031 | 17400 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014126.91093 | 2095851.18558 | 37.7356026534403 | -122.393585802156 | (37.7356026534403, -122.393585802156) | 10 | 3 | 8 | 58 | 1 | |||
21471 | 139360 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2807 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000073 | 2114379 | 37.7856845299005 | -122.443505885647 | (37.7856845299005, -122.443505885647) | 15 | 6 | 1 | 29490 | 31 | |||
22352 | 16479 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
22540 | 225094 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | 15 | 5 | 5 | 29492 | 9 | |
22673 | 248195 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006895.3062 | 2099022.51404 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | 2 | 7 | 7 | 28859 | 2 | |||
24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
24626 | 93109 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.35417 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | 10 | 3 | 8 | 58 | 1 | |
24938 | 188478 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 San Bruno Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6010892.5271 | 2106015.01328 | 37.7633300498768 | -122.405483954234 | (37.7633300498768, -122.405483954234) | 8 | 4 | 8 | 28856 | 19 | |||
25903 | 125969 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2672 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002023.76351 | 2115741.9503 | 37.7895379005066 | -122.43685441882 | (37.7895379005066, -122.43685441882) | 13 | 6 | 1 | 29490 | 27 | |||
26053 | 16540 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.7417809401523 | -122.386827291768 | (37.7417809401523, -122.386827291768) | 10 | 3 | 8 | 58 | 1 | |||
26621 | 222916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.428493839936 | (37.7712463798496, -122.428493839936) | 7 | 9 | 11 | 28852 | 10 | |||
28248 | 248203 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | 2 | 7 | 7 | 28859 | 2 | |||
29498 | 225099 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.7706120358534 | -122.430685739554 | (37.7706120358534, -122.430685739554) | 15 | 9 | 11 | 29492 | 10 | |
30088 | 5432 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | 6004968.15127 | 2105494.35348 | 37.7615674029223 | -122.425937381218 | (37.7615674029223, -122.425937381218) | 8 | 4 | 5 | 28859 | 19 | |||
30477 | 222899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005393.47694 | 2104277.70893 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | 2 | 4 | 5 | 28859 | 19 | |||
32130 | 5658 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.7479520016853 | -122.42464442051 | (37.7479520016853, -122.42464442051) | 2 | 4 | 5 | 28859 | 19 | |||
32220 | 17420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.7369065543995 | -122.395898900707 | (37.7369065543995, -122.395898900707) | 10 | 3 | 8 | 58 | 1 | |||
32299 | 222920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998076.5165 | 2106905.97838 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | 15 | 5 | 11 | 29492 | 9 | |||
34635 | 225051 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.7524988021808 | -122.439839555559 | (37.7524988021808, -122.439839555559) | 2 | 4 | 5 | 28862 | 22 | |||
35126 | 15121 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6013826.37134 | 2116069.93693 | 37.7911022004845 | -122.396041353962 | (37.7911022004845, -122.396041353962) | 12 | 2 | 9 | 28855 | 6 | |||
35456 | 225068 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009114.1902 | 2103856.87983 | 37.7573047117606 | -122.411482183163 | (37.7573047117606, -122.411482183163) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
36850 | 21792 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
55304 | 14686 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6005447.7824 | 2111997.5051 | 37.7794505882327 | -122.424741179621 | (37.7794505882327, -122.424741179621) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
56518 | 237914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 4ft | 5997227 | 2107052 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | 15 | 5 | 11 | 29492 | 12 | |||
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 | |||
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 | |||
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 | ||
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 | |||
62291 | 5529 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 895 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6005093.86648 | 2103161.82188 | 37.7551699235695 | -122.425336590916 | (37.7551699235695, -122.425336590916) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
62764 | 16626 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | 15 | 5 | 5 | 28862 | 3 | ||
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 | |||
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 | |||
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 | |||
63609 | 222900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.7582550109751 | -122.424310747749 | (37.7582550109751, -122.424310747749) | 2 | 4 | 5 | 28859 | 19 | |||
64038 | 248270 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | 2 | 7 | 7 | 28859 | 2 | |||
64807 | 248261 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | 2 | 7 | 7 | 28859 | 2 | |||
65527 | 248255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | 2 | 7 | 7 | 28859 | 2 | |||
65585 | 248202 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | 2 | 7 | 7 | 28859 | 2 | |||
66277 | 222890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009529.18788 | 2103922.95806 | 37.757509416346 | -122.4100516172 | (37.757509416346, -122.4100516172) | 2 | 4 | 7 | 28859 | 19 | |||
66656 | 16644 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002849.24717 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | 15 | 5 | 5 | 28862 | 3 | |||
66742 | 225072 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.7573510817046 | -122.410574009103 | (37.7573510817046, -122.410574009103) | 2 | 4 | 7 | 28859 | 19 | |||
66852 | 222897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2771 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009509.00989 | 2103333.02961 | 37.7558884746751 | -122.41007975427 | (37.7558884746751, -122.41007975427) | 2 | 4 | 7 | 28859 | 19 | |||
66893 | 199696 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | 10 | 3 | 8 | 58 | 1 | |||
67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
67860 | 57316 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | 15 | 6 | 1 | 29490 | 31 | ||
69631 | 189954 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | 12 | 2 | 9 | 28855 | 6 | |||
70301 | 2533 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016180.33193 | 2099126.30756 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | 10 | 3 | 8 | 58 | 1 | |||
71054 | 21785 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | |||
71557 | 125966 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | 13 | 9 | 1 | 57 | 17 | |||
72128 | 225047 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009431.36633 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | 2 | 4 | 7 | 28859 | 19 | |||
72504 | 225095 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | 7 | 9 | 11 | 28852 | 10 | |||
73221 | 189956 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.7733498689462 | -122.403749639528 | (37.7733498689462, -122.403749639528) | 14 | 2 | 9 | 28853 | 34 | |||
74084 | 124322 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996192.87314 | 2113669.73604 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | 11 | 6 | 1 | 54 | 31 | |||
74298 | 225086 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.7563110786983 | -122.429732966312 | (37.7563110786983, -122.429732966312) | 2 | 4 | 5 | 28862 | 22 | |||
75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
75395 | 125996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558 | (37.8055637294392, -122.41688295558) | 5 | 1 | 10 | 308 | 23 | |||
76472 | 225100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | 8 | 2 | 9 | 28853 | 19 | |||
77396 | 125972 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006913.21617 | 2121857.59743 | 37.8066066057793 | -122.420371657826 | (37.8066066057793, -122.420371657826) | 5 | 1 | 1 | 28858 | 32 |
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) );