trees
508 rows where qSpecies_id = 25 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
139521 | 10000 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 2X2 | 6005403.54778 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | 8 | 4 | 5 | 28853 | 19 | |||
181241 | 10001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.7687236538132 | -122.424371552702 | (37.7687236538132, -122.424371552702) | 8 | 4 | 5 | 28853 | 19 | |||
107304 | 10020 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.424441220501 | (37.767158847823, -122.424441220501) | 8 | 4 | 5 | 28853 | 19 | |||
23576 | 10026 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2x3 | 6005455.03663 | 2107324.13866 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | 8 | 4 | 5 | 28853 | 19 | |||
63677 | 10032 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 315 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X2 | 6005527.20527 | 2107119.43239 | 37.7660610633959 | -122.424119414293 | (37.7660610633959, -122.424119414293) | 8 | 4 | 5 | 28853 | 19 | |||
46773 | 10037 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x2 | 6005536.77146 | 2106975.88456 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | 8 | 4 | 5 | 28853 | 19 | |||
153413 | 10054 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 426 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X2 | 6005501.95571 | 2106458.62904 | 37.764245228771 | -122.424159747992 | (37.764245228771, -122.424159747992) | 8 | 4 | 5 | 28859 | 19 | |||
10559 | 10061 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 490 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 2X2 | 6005517.65207 | 2106131.14555 | 37.7633469229371 | -122.424082167969 | (37.7633469229371, -122.424082167969) | 8 | 4 | 5 | 28859 | 19 | |||
142003 | 10068 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005603.73706 | 2105778.33301 | 37.762383043055 | -122.423759340124 | (37.762383043055, -122.423759340124) | 8 | 4 | 5 | 28859 | 19 | |||
96105 | 10071 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 563 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x3 | 6005607.25335 | 2105721.20389 | 37.7622263784702 | -122.423743116346 | (37.7622263784702, -122.423743116346) | 8 | 4 | 5 | 28859 | 19 | |||
157767 | 10076 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2x2 | 6005555.84644 | 2105437.30746 | 37.7614439637781 | -122.423900725242 | (37.7614439637781, -122.423900725242) | 2 | 4 | 5 | 28859 | 19 | |||
38084 | 10079 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | 2 | 4 | 5 | 28859 | 19 | |||
35950 | 10087 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005642.33302 | 2105078.49447 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | 2 | 4 | 5 | 28859 | 19 | |||
126060 | 10089 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 700 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005586.51976 | 2104851.24563 | 37.7598365074586 | -122.423752966647 | (37.7598365074586, -122.423752966647) | 2 | 4 | 5 | 28859 | 19 | |||
21411 | 10091 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.7597558823477 | -122.423740797923 | (37.7597558823477, -122.423740797923) | 2 | 4 | 5 | 28859 | 19 | ||
131459 | 10112 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 821 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005694.08607 | 2104163.28117 | 37.7579535897166 | -122.423332040744 | (37.7579535897166, -122.423332040744) | 2 | 4 | 5 | 28859 | 19 | |||
74513 | 10124 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005714.7162163 | 2103867.2939475 | 37.7571420422058 | -122.42323965319 | (37.7571420422058, -122.42323965319) | 2 | 4 | 5 | 28859 | 19 | |||
87206 | 10130 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005717.32362 | 2103778.46659 | 37.7568982901448 | -122.423224321766 | (37.7568982901448, -122.423224321766) | 2 | 4 | 5 | 28859 | 19 | ||
53260 | 10131 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005716.19449 | 2103799.35315 | 37.7569555760466 | -122.423229711377 | (37.7569555760466, -122.423229711377) | 2 | 4 | 5 | 28859 | 19 | ||
176770 | 10132 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005714.0796 | 2103814.39751 | 37.756996764997 | -122.423238094856 | (37.756996764997, -122.423238094856) | 2 | 4 | 5 | 28859 | 19 | ||
186906 | 10133 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005711.897824 | 2103735.5027185 | 37.7567800151629 | -122.423240032254 | (37.7567800151629, -122.423240032254) | 2 | 4 | 5 | 28859 | 19 | ||
94079 | 10152 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005742.33218 | 2103287.18966 | 37.7555507693625 | -122.423102914188 | (37.7555507693625, -122.423102914188) | 2 | 4 | 5 | 28859 | 19 | |||
90032 | 10155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | 2 | 4 | 5 | 28859 | 19 | |||
126477 | 10165 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1019 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6005763.39401 | 2102897.66691 | 37.7544824188306 | -122.423002391551 | (37.7544824188306, -122.423002391551) | 2 | 4 | 5 | 28859 | 19 | |||
41440 | 10174 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2x2 | 6005692.3267338 | 2102916.9952862 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | 2 | 4 | 5 | 28859 | 19 | |||
58513 | 102247 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.7619482253485 | -122.394424198727 | (37.7619482253485, -122.394424198727) | 10 | 3 | 8 | 28856 | 29 | |||
179106 | 10227 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6005821.31625 | 2100751.57346 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) | 2 | 4 | 5 | 28859 | 19 | |||
35598 | 102652 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | |||||
109140 | 102653 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | ||||
77790 | 103262 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770698 | 6006511 | 2108178 | 37.769023136516 | -122.420791817714 | (37.769023136516, -122.420791817714) | 8 | 4 | 7 | 28853 | 19 | |
29569 | 105213 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
161550 | 105214 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
37585 | 105310 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | 11 | 6 | 2 | 55 | 26 | |||
63451 | 105311 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.7793822053088 | -122.476225875432 | (37.7793822053088, -122.476225875432) | 11 | 6 | 2 | 55 | 26 | |||
40018 | 105804 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 117 ALPINE TER | 1 | Front Yard : Cutout | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | 15 | 5 | 5 | 29492 | 3 | |
79612 | 105962 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 6013706.37383 | 2104134.52437 | 37.7583235710722 | -122.395619946844 | (37.7583235710722, -122.395619946844) | 10 | 3 | 8 | 28856 | 29 | ||||
68217 | 10694 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001838.4236 | 2110502.6134 | 37.7751414763631 | -122.437120398394 | (37.7751414763631, -122.437120398394) | 15 | 5 | 11 | 29492 | 10 | |||
119640 | 10695 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.437059807317 | (37.7751961745675, -122.437059807317) | 15 | 5 | 11 | 29492 | 10 | |||
4752 | 107181 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | |||
89804 | 108167 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009908 | 2100009 | 37.7467837814289 | -122.40846544894 | (37.7467837814289, -122.40846544894) | 2 | 7 | 7 | 28859 | 2 | ||||
34641 | 108168 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||||
45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
136527 | 108571 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 223 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772573 | 6009406.56 | 2094751.33642 | 37.7323192844032 | -122.409828317318 | (37.7323192844032, -122.409828317318) | 10 | 3 | 7 | 309 | 28 |
142128 | 109686 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) | 9 | 7 | 6 | 28861 | 25 |
192132 | 112711 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 782 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 1 | 6009126.82605 | 2110111.36785 | 37.774478803191 | -122.411880442527 | (37.774478803191, -122.411880442527) | 8 | 2 | 9 | 28853 | 34 | ||
87972 | 112871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | 15 | 5 | 11 | 29492 | 16 | |||
16772 | 113034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 251 06th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993975.1139 | 2113804.1265 | 37.7837564355183 | -122.464560902617 | (37.7837564355183, -122.464560902617) | 11 | 6 | 2 | 54 | 11 | |||
15108 | 113387 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
55201 | 113388 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
89613 | 113389 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
147726 | 114483 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x2 | 6009096 | 2110140 | 37.7745556909018 | -122.411989099957 | (37.7745556909018, -122.411989099957) | 8 | 2 | 9 | 28853 | 34 | |||
69946 | 115126 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
11961 | 115127 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
181947 | 115130 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
171972 | 115822 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
55349 | 115881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.09601 | 37.737410632491 | -122.390459765022 | (37.737410632491, -122.390459765022) | 10 | 3 | 8 | 58 | 1 | ||
172579 | 116342 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 611 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778005 | 6009887 | 2105445 | 37.7617086481783 | -122.408921539166 | (37.7617086481783, -122.408921539166) | 2 | 4 | 8 | 28859 | 19 | |
88260 | 116598 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 454 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x4 | 5999760.624 | 2110077.6149 | 37.7738562121972 | -122.444277398119 | (37.7738562121972, -122.444277398119) | 15 | 5 | 11 | 29492 | 16 | |||
44035 | 117516 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010054 | 2102576 | 37.7538403715297 | -122.408141603779 | (37.7538403715297, -122.408141603779) | 2 | 4 | 7 | 28859 | 19 | |||
193185 | 119913 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013509 | 2106013 | 37.7634704729857 | -122.396434224989 | (37.7634704729857, -122.396434224989) | 14 | 3 | 8 | 28856 | 29 | ||||
130161 | 122086 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990589.94258 | 2112248.552 | 37.7792895311955 | -122.476158542806 | (37.7792895311955, -122.476158542806) | 11 | 6 | 2 | 55 | 26 | |||
15349 | 122920 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 330 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2020 12:00:00 AM | 3 | Width 2ft | 5992493.10071 | 2113220.22773 | 37.7820676636923 | -122.469645543184 | (37.7820676636923, -122.469645543184) | 11 | 6 | 2 | 54 | 11 | ||
179219 | 123212 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | 11 | 6 | 2 | 54 | 11 | |||
67621 | 128862 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 Hayes St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | 7 | 9 | 11 | 28852 | 10 | |||
92573 | 128863 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.427772325535 | (37.7759621899439, -122.427772325535) | 7 | 9 | 11 | 28852 | 10 | |||
95938 | 128864 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.427790646526 | (37.7760451281037, -122.427790646526) | 7 | 9 | 11 | 28852 | 10 | |||
25269 | 128865 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001864.71047 | 2116045.71849 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | 13 | 6 | 1 | 29490 | 27 | |||
53060 | 128866 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.7903441535036 | -122.43764656594 | (37.7903441535036, -122.43764656594) | 13 | 6 | 1 | 29490 | 27 | |||
119348 | 128867 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | 13 | 6 | 1 | 29490 | 27 | |||
186337 | 128868 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001720.521 | 2116028.9102 | 37.790308579028 | -122.437924165962 | (37.790308579028, -122.437924165962) | 13 | 6 | 1 | 29490 | 27 | |||
47916 | 128869 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | 13 | 6 | 1 | 29490 | 27 | |||
179715 | 128870 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6001597.99168 | 2116010.93406 | 37.7902522526915 | -122.438346819465 | (37.7902522526915, -122.438346819465) | 13 | 6 | 1 | 29490 | 27 | |||
149327 | 128871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6001562.05606 | 2116003.40074 | 37.7902295241198 | -122.438470613846 | (37.7902295241198, -122.438470613846) | 13 | 6 | 1 | 29490 | 27 | |||
182240 | 128872 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008617.8933 | 2116985.80522 | 37.7933257892186 | -122.414127394165 | (37.7933257892186, -122.414127394165) | 5 | 1 | 10 | 28857 | 21 | |||
92905 | 128873 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | 5 | 1 | 10 | 28857 | 21 | |||
34506 | 128874 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.414254814618 | (37.7933104368651, -122.414254814618) | 5 | 1 | 10 | 28857 | 21 | |||
172661 | 128875 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 2 | Median : Yard | Tree | DPW 1 | 2 | 6007636.05536 | 2118136.67489 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | 5 | 1 | 10 | 28858 | 32 | ||||
121745 | 128876 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 5 | Median : Yard | Tree | DPW 1 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | 5 | 1 | 10 | 28858 | 32 | ||||
23417 | 128877 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 6 | Median : Yard | Tree | DPW 1 | 3 | 6007635.08843 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | 5 | 1 | 10 | 28858 | 32 | ||||
46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
64250 | 128879 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Balance St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6012011.13763 | 2118129.24016 | 37.7966553941982 | -122.402466903231 | (37.7966553941982, -122.402466903231) | 3 | 1 | 10 | 28860 | 4 | |||
67850 | 140156 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | 15 | 5 | 11 | 29492 | 16 | |||
171054 | 140348 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1314 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004545.774 | 2113311.1445 | 37.7830065306397 | -122.427955242977 | (37.7830065306397, -122.427955242977) | 7 | 9 | 11 | 29490 | 41 | |||
189829 | 141447 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | 15 | 6 | 2 | 54 | 16 | |||
112936 | 142206 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | 15 | 5 | 11 | 29492 | 16 | |||
53663 | 142232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.7759314506272 | -122.427749815271 | (37.7759314506272, -122.427749815271) | 7 | 9 | 11 | 28852 | 10 | |||
48618 | 142233 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | 7 | 9 | 11 | 28852 | 10 | |||
64629 | 142235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | 7 | 9 | 11 | 28852 | 10 | |||
35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
139062 | 142338 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | 15 | 5 | 11 | 29492 | 16 | |||
11951 | 142340 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.7745244442512 | -122.444402018718 | (37.7745244442512, -122.444402018718) | 15 | 5 | 11 | 29492 | 16 | |||
13990 | 142563 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 555 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:42:00 PM | 3 | Width 0ft | 6008640.5494 | 2121060.0298 | 37.8045138709312 | -122.414337407838 | (37.8045138709312, -122.414337407838) | 3 | 1 | 10 | 308 | 23 | ||
96423 | 142687 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 550 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008655.2673 | 2121104.5109 | 37.8046368316065 | -122.414289624157 | (37.8046368316065, -122.414289624157) | 3 | 1 | 10 | 308 | 23 | |||
176686 | 142688 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | 3 | 1 | 10 | 308 | 23 | |||
88947 | 142690 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 560 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008610.8035 | 2121097.1003 | 37.8046139862257 | -122.414442971246 | (37.8046139862257, -122.414442971246) | 3 | 1 | 10 | 308 | 23 | |||
173725 | 142691 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 590x Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008663 | 2121123 | 37.8046880323907 | -122.414264173266 | (37.8046880323907, -122.414264173266) | 3 | 1 | 10 | 308 | 23 | |||
100419 | 142692 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 590x Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008663 | 2121123 | 37.8046880323907 | -122.414264173266 | (37.8046880323907, -122.414264173266) | 3 | 1 | 10 | 308 | 23 | |||
58362 | 142702 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | 3 | 1 | 10 | 308 | 23 |
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) );