trees
3,587 rows where qSpecies_id = 28 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
1723 | 19755 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1845 | 20002 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
2868 | 255125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3319 | 255128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3449 | 19754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
4083 | 19998 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
5059 | 255129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5129 | 255126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
6473 | 48743 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
7374 | 48751 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8604 | 48746 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8612 | 255133 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
8893 | 50823 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
9839 | 48748 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10173 | 48744 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10360 | 30354 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1956 12:00:00 AM | Permit Number 43 | ||||||||||||||
10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
12040 | 48742 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12785 | 48747 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12883 | 255123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15071 | 48749 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15641 | 48745 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
1661 | 126293 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009210.11859 | 2121881.78828 | 37.8068021921193 | -122.412424475734 | (37.8068021921193, -122.412424475734) | 3 | 1 | 10 | 308 | 23 | |||
4157 | 52083 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||
5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
7755 | 126345 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6011901.4963 | 2117456.13794 | 37.7948010955445 | -122.402798926636 | (37.7948010955445, -122.402798926636) | 3 | 1 | 10 | 28860 | 4 | |||
8333 | 126339 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012176.42228 | 2117479.41237 | 37.7948803483084 | -122.401849275842 | (37.7948803483084, -122.401849275842) | 3 | 1 | 10 | 28860 | 4 | |||
12205 | 142979 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 0ft | 6010333.0283 | 2120985.7302 | 37.8044047900705 | -122.40847515981 | (37.8044047900705, -122.40847515981) | 3 | 1 | 10 | 308 | 23 | |||
15569 | 4741 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/1992 12:00:00 AM | 12 | 3X3 | 6008069.3023022 | 2121114.6784448 | 37.8046318166674 | -122.416318139035 | (37.8046318166674, -122.416318139035) | 5 | 1 | 10 | 308 | 23 | ||
20003 | 99987 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
20023 | 126333 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011888.21181 | 2117712.45326 | 37.7955041342546 | -122.402862928705 | (37.7955041342546, -122.402862928705) | 3 | 1 | 10 | 28860 | 4 | |||
20154 | 126324 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012230.12166 | 2117309.16104 | 37.7944158754575 | -122.401651495115 | (37.7944158754575, -122.401651495115) | 3 | 1 | 10 | 28860 | 4 | |||
21249 | 112640 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 299X STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x9 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
23313 | 67885 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 558 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1993 12:00:00 AM | 11 | 4x4 | Permit Number 31579 | 6012000.40021 | 2117278.49262 | 37.7943188457921 | -122.402444206153 | (37.7943188457921, -122.402444206153) | 3 | 1 | 10 | 28860 | 4 | |
24340 | 126290 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007603.03986 | 2121549.62811 | 37.8057998482576 | -122.417962541334 | (37.8057998482576, -122.417962541334) | 5 | 1 | 10 | 308 | 23 | |||
25543 | 126300 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008880.73692 | 2121834.44066 | 37.8066536978683 | -122.413561019128 | (37.8066536978683, -122.413561019128) | 3 | 1 | 10 | 308 | 23 | |||
25628 | 100017 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011791.69231 | 2117640.10072 | 37.7953000816886 | -122.403191812578 | (37.7953000816886, -122.403191812578) | 3 | 1 | 10 | 28860 | 4 | ||||
26881 | 97635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
29377 | 114412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1345 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6008898.23064 | 2117525.75314 | 37.7948240957174 | -122.413195602999 | (37.7948240957174, -122.413195602999) | 5 | 1 | 10 | 28857 | 21 | ||||
29882 | 100026 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
30430 | 102606 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
31020 | 126304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 150 Lombard St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6011511.53944 | 2120807.30084 | 37.8039807949437 | -122.40438423177 | (37.8039807949437, -122.40438423177) | 3 | 1 | 10 | 28860 | 6 | |||
33339 | 100023 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
33792 | 142978 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1905 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010357.7464 | 2121006.2509 | 37.8044625190574 | -122.408391068632 | (37.8044625190574, -122.408391068632) | 3 | 1 | 10 | 308 | 23 | |||
33929 | 126323 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6013218.19178 | 2116960.71116 | 37.7935142007749 | -122.398208171762 | (37.7935142007749, -122.398208171762) | 4 | 1 | 10 | 28860 | 6 | |||
33988 | 126305 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6011380.98964 | 2121084.38787 | 37.8047343117091 | -122.404855530454 | (37.8047343117091, -122.404855530454) | 3 | 1 | 10 | 28860 | 6 | |||
37746 | 142611 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2424 JONES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6008004.2032 | 2120795.1714 | 37.8037508700928 | -122.416520774929 | (37.8037508700928, -122.416520774929) | 5 | 1 | 10 | 308 | 32 | |||
39908 | 126191 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1490 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007656.60094 | 2116516.3176 | 37.7919826517202 | -122.417420253753 | (37.7919826517202, -122.417420253753) | 5 | 1 | 10 | 28858 | 21 | |||
40252 | 126270 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007122.07694 | 2121536.84547 | 37.8057376700126 | -122.419626082101 | (37.8057376700126, -122.419626082101) | 5 | 1 | 1 | 28858 | 32 | |||
40556 | 126308 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6011431.79108 | 2121090.48477 | 37.8047538917423 | -122.404680155458 | (37.8047538917423, -122.404680155458) | 3 | 1 | 10 | 28860 | 6 | |||
42643 | 258040 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
43802 | 57383 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1038 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 20 | Permit Number 16222 | 6008178.63757 | 2116060.00557 | 37.790759089023 | -122.415581676167 | (37.790759089023, -122.415581676167) | 5 | 1 | 10 | 28858 | 21 | ||
43941 | 46350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 12 | Permit Number 44594 | 6011800.91872 | 2117592.16753 | 37.7951689839044 | -122.403156514164 | (37.7951689839044, -122.403156514164) | 3 | 1 | 10 | 28860 | 4 | ||
44086 | 142980 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010297.117 | 2120982.4656 | 37.8043938151268 | -122.408599204074 | (37.8043938151268, -122.408599204074) | 3 | 1 | 10 | 308 | 23 | |||
44347 | 126299 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008955.34228 | 2121845.45564 | 37.806688131109 | -122.413303611596 | (37.806688131109, -122.413303611596) | 3 | 1 | 10 | 308 | 23 | |||
44949 | 100027 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
45551 | 126301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008867.14931 | 2121833.93475 | 37.8066515458005 | -122.413608006 | (37.8066515458005, -122.413608006) | 3 | 1 | 10 | 308 | 23 | |||
46872 | 27432 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X4 | 6007580.92749 | 2121572.89753 | 37.8058624956614 | -122.418040715371 | (37.8058624956614, -122.418040715371) | 5 | 1 | 10 | 308 | 23 | |||
50134 | 100004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
51500 | 126291 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007589.25664 | 2121562.16822 | 37.8058335044831 | -122.418011129904 | (37.8058335044831, -122.418011129904) | 5 | 1 | 10 | 308 | 23 | |||
51864 | 126255 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1234 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6008711.5059 | 2117324.04043 | 37.7942597576443 | -122.413827423524 | (37.7942597576443, -122.413827423524) | 5 | 1 | 10 | 28857 | 21 | |||
51876 | 126343 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6011928.96747 | 2117459.63842 | 37.7948122408476 | -122.402704118326 | (37.7948122408476, -122.402704118326) | 3 | 1 | 10 | 28860 | 4 | |||
53056 | 46349 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 15 | Permit Number 44594 | 6011797.44129 | 2117605.10565 | 37.7952043146792 | -122.403169457224 | (37.7952043146792, -122.403169457224) | 3 | 1 | 10 | 28860 | 4 | ||
56878 | 126342 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011942.798 | 2117460.48455 | 37.7948153363017 | -122.402656322025 | (37.7948153363017, -122.402656322025) | 3 | 1 | 10 | 28860 | 4 | |||
57271 | 100029 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
57942 | 142990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1847 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010376.3672 | 2120881.545 | 37.804121150252 | -122.408317828181 | (37.804121150252, -122.408317828181) | 3 | 1 | 10 | 308 | 23 | |||
59629 | 126268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007089.07712 | 2121533.77158 | 37.8057273709962 | -122.419740064856 | (37.8057273709962, -122.419740064856) | 5 | 1 | 1 | 28858 | 32 | |||
59651 | 126346 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6011888.53477 | 2117453.47011 | 37.7947930466025 | -122.402843587862 | (37.7947930466025, -122.402843587862) | 3 | 1 | 10 | 28860 | 4 | |||
60177 | 99996 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
60809 | 100009 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
61486 | 67390 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1992 12:00:00 AM | 21 | Permit Number 30887 | 6013339.22791 | 2116980.96183 | 37.7935765453846 | -122.397790795502 | (37.7935765453846, -122.397790795502) | 4 | 1 | 10 | 28860 | 6 | ||
62295 | 106457 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x CHESTNUT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011546 | 2121132 | 37.8048742648975 | -122.404287845465 | (37.8048742648975, -122.404287845465) | 3 | 1 | 10 | 28860 | 6 | |||||
64433 | 126309 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6011549.22604 | 2121109.21321 | 37.8048118782298 | -122.404275076545 | (37.8048118782298, -122.404275076545) | 3 | 1 | 10 | 28860 | 6 | |||
64698 | 114701 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 645 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010496 | 2116407 | 37.7918418395307 | -122.407588155464 | (37.7918418395307, -122.407588155464) | 5 | 1 | 10 | 28857 | 21 | ||||
65772 | 126289 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007647.01376 | 2121508.69836 | 37.8056899403132 | -122.417807459567 | (37.8056899403132, -122.417807459567) | 5 | 1 | 10 | 308 | 23 | |||
71604 | 126335 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011914.41162 | 2117716.44369 | 37.7955165539073 | -122.40277255313 | (37.7955165539073, -122.40277255313) | 3 | 1 | 10 | 28860 | 4 | |||
72445 | 142612 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2424 JONES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6008004.2032 | 2120805.2808 | 37.8037786279563 | -122.416521491468 | (37.8037786279563, -122.416521491468) | 5 | 1 | 10 | 308 | 32 | |||
72568 | 112306 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008684 | 2117318 | 37.7942416273691 | -122.413922169868 | (37.7942416273691, -122.413922169868) | 5 | 1 | 10 | 28857 | 21 | ||||
72619 | 100020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
74115 | 126307 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6011412.75588 | 2121088.95225 | 37.8047486199155 | -122.404745921109 | (37.8047486199155, -122.404745921109) | 3 | 1 | 10 | 28860 | 6 | |||
74316 | 106886 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 580 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2014 12:00:00 AM | 3 | Permit Number 772874 | 6011893.85928 | 2117261.69096 | 37.7942667642387 | -122.402811670039 | (37.7942667642387, -122.402811670039) | 3 | 1 | 10 | 28860 | 4 | ||
74445 | 249775 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 102 Pfeiffer St | 6 | Side Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6010401.04426 | 2121152.23114 | 37.8048657692012 | -122.40825153419 | (37.8048657692012, -122.40825153419) | 3 | 1 | 10 | 308 | 23 | |||
75097 | 126296 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6009109.48206 | 2121867.97371 | 37.8067586127902 | -122.412771772309 | (37.8067586127902, -122.412771772309) | 3 | 1 | 10 | 308 | 23 | |||
75648 | 100015 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6011789.64079 | 2117672.98825 | 37.795390268386 | -122.403201225768 | (37.795390268386, -122.403201225768) | 3 | 1 | 10 | 28860 | 4 | ||||
76298 | 126322 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6013251.89041 | 2116966.13143 | 37.7935309605345 | -122.398091951502 | (37.7935309605345, -122.398091951502) | 4 | 1 | 10 | 28860 | 6 | |||
76653 | 100018 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011793.71356 | 2117622.45121 | 37.7952517332473 | -122.403183576561 | (37.7952517332473, -122.403183576561) | 3 | 1 | 10 | 28860 | 4 | ||||
76867 | 126332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011860.92866 | 2117711.02916 | 37.7954987005659 | -122.402957233402 | (37.7954987005659, -122.402957233402) | 3 | 1 | 10 | 28860 | 4 | |||
78272 | 126292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6007576.38379 | 2121572.19977 | 37.8058603240585 | -122.418056390085 | (37.8058603240585, -122.418056390085) | 5 | 1 | 10 | 308 | 23 | |||
78962 | 142483 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 502 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010521.5126 | 2119626.8488 | 37.8006841900348 | -122.407727016144 | (37.8006841900348, -122.407727016144) | 3 | 1 | 10 | 308 | 23 | |||
79115 | 112307 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | 6008684 | 2117318 | 37.7942416273691 | -122.413922169868 | (37.7942416273691, -122.413922169868) | 5 | 1 | 10 | 28857 | 21 |
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) );