trees
309 rows where Supervisor Districts = 7 and qSpecies_id = 97 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107742 | 121142 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
165184 | 121141 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
28999 | 224659 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009169.14858 | 2102873.09479 | 37.7546065423583 | -122.41122262175 | (37.7546065423583, -122.41122262175) | 2 | 4 | 7 | 28859 | 19 | |||
65684 | 65243 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.7545136503205 | -122.411231929366 | (37.7545136503205, -122.411231929366) | 2 | 4 | 7 | 28859 | 19 | ||
158180 | 224647 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 11 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006471.9777 | 2098350.49655 | 37.7420368818048 | -122.420229213316 | (37.7420368818048, -122.420229213316) | 2 | 7 | 7 | 28859 | 2 | |||
71345 | 224503 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006785.20384 | 2096905.74889 | 37.7380875710875 | -122.419043723383 | (37.7380875710875, -122.419043723383) | 2 | 7 | 7 | 28859 | 2 | |||
109279 | 68204 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1110 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.7542458964916 | -122.408413088762 | (37.7542458964916, -122.408413088762) | 2 | 4 | 7 | 28859 | 19 |
59992 | 224513 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | 2 | 4 | 7 | 28859 | 19 | |||
50814 | 224511 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | 2 | 4 | 7 | 28859 | 19 | |||
4606 | 224510 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007627.97792 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | 2 | 4 | 7 | 28859 | 19 | |||
74599 | 224486 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | 2 | 7 | 7 | 28859 | 2 | |||
104706 | 224676 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 123 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007744.73276 | 2107219.69106 | 37.766461304874 | -122.416456511479 | (37.766461304874, -122.416456511479) | 8 | 4 | 7 | 28853 | 19 | |||
173711 | 173681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010317 | 2099454 | 37.7452827689443 | -122.407012047483 | (37.7452827689443, -122.407012047483) | 2 | 7 | 7 | 28859 | 2 | ||||
55334 | 224658 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.7469678609981 | -122.41772795229 | (37.7469678609981, -122.41772795229) | 2 | 7 | 7 | 28859 | 2 | |||
111571 | 224487 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6007167.09986 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | 2 | 7 | 7 | 28859 | 2 | |||
170253 | 224641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.419323735419 | (37.7460721011655, -122.419323735419) | 2 | 7 | 7 | 28859 | 2 | |||
174424 | 224640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006790.58194 | 2099800.70275 | 37.7460367694939 | -122.41923042716 | (37.7460367694939, -122.41923042716) | 2 | 7 | 7 | 28859 | 2 | |||
194157 | 224494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005454.36959 | 2096149.25289 | 37.7359353702183 | -122.423591316208 | (37.7359353702183, -122.423591316208) | 2 | 7 | 7 | 28859 | 2 | |||
18694 | 255585 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 141 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2105290 | 37.7611036239675 | -122.419957321446 | (37.7611036239675, -122.419957321446) | 2 | 4 | 7 | 28859 | 19 | ||||
189791 | 224495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005480.01407 | 2096145.74782 | 37.7359271935727 | -122.423502403815 | (37.7359271935727, -122.423502403815) | 2 | 7 | 7 | 28859 | 2 | |||
103250 | 111889 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011076.19973 | 2092521.56402 | 37.7262902239912 | -122.403899105983 | (37.7262902239912, -122.403899105983) | 10 | 3 | 7 | 309 | 28 | |||
82624 | 224655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | 2 | 7 | 7 | 28859 | 2 | |||
44250 | 224525 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006711.81921 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | 2 | 4 | 7 | 28859 | 19 | |||
159096 | 224524 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | 2 | 4 | 7 | 28859 | 19 | |||
82623 | 224638 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006127.41253 | 2098099.44281 | 37.7413281233964 | -122.421402787214 | (37.7413281233964, -122.421402787214) | 2 | 7 | 7 | 28859 | 2 | |||
161072 | 224639 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006112.4253 | 2098109.96948 | 37.7413561822494 | -122.421455355286 | (37.7413561822494, -122.421455355286) | 2 | 7 | 7 | 28859 | 2 | |||
23294 | 224483 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007282.93524 | 2107366.34912 | 37.7668380128917 | -122.418064187227 | (37.7668380128917, -122.418064187227) | 8 | 4 | 7 | 28853 | 19 | |||
95454 | 255584 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 151 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006696 | 2105242 | 37.7609719961735 | -122.41994353943 | (37.7609719961735, -122.41994353943) | 2 | 4 | 7 | 28859 | 19 | ||||
169407 | 224484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1514 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007262.01073 | 2107365.0441 | 37.7668332518872 | -122.418136469321 | (37.7668332518872, -122.418136469321) | 8 | 4 | 7 | 28853 | 19 | |||
96429 | 224485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007214.09312 | 2107363.71404 | 37.7668269026679 | -122.418302114548 | (37.7668269026679, -122.418302114548) | 8 | 4 | 7 | 28853 | 19 | |||
61132 | 38252 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.7668030933038 | -122.418866676369 | (37.7668030933038, -122.418866676369) | 8 | 4 | 7 | 28853 | 19 | |
67398 | 224635 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007212.97385 | 2098214.14312 | 37.7417042108849 | -122.417657415761 | (37.7417042108849, -122.417657415761) | 2 | 7 | 7 | 28859 | 2 | |||
129041 | 33581 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | 2 | 7 | 7 | 28859 | 2 | |||
33103 | 224636 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | 2 | 7 | 7 | 28859 | 2 | |||
42809 | 33580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | 2 | 7 | 7 | 28859 | 2 | |||
143559 | 33576 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336117 | (37.7412413768938, -122.41810336117) | 2 | 7 | 7 | 28859 | 2 | |
102288 | 224527 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 171 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6006719.85919 | 2102790.50948 | 37.7542421146046 | -122.419687075893 | (37.7542421146046, -122.419687075893) | 2 | 4 | 7 | 28859 | 19 | |||
10092 | 224526 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | 2 | 4 | 7 | 28859 | 19 | |||
26097 | 53744 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
165400 | 33589 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
115554 | 33588 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | 2 | 7 | 7 | 28859 | 2 | |||
132295 | 255588 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 185 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006715 | 2105087 | 37.7605474726944 | -122.419866827586 | (37.7605474726944, -122.419866827586) | 2 | 4 | 7 | 28859 | 19 | ||||
79542 | 226495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008685.71484 | 2107616.88585 | 37.7676047820563 | -122.413229904031 | (37.7676047820563, -122.413229904031) | 8 | 4 | 7 | 28853 | 19 | |||
127678 | 226498 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008688.72129 | 2107547.38011 | 37.7674141042173 | -122.413214589496 | (37.7674141042173, -122.413214589496) | 8 | 4 | 7 | 28853 | 19 | |||
141866 | 226497 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008687.35447 | 2107561.73783 | 37.7674534504487 | -122.41322033256 | (37.7674534504487, -122.41322033256) | 8 | 4 | 7 | 28853 | 19 | |||
157515 | 226496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008684.6321 | 2107591.00428 | 37.767533656488 | -122.413231818694 | (37.767533656488, -122.413231818694) | 8 | 4 | 7 | 28853 | 19 | |||
130048 | 224633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 196 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007335.08307 | 2097320.51793 | 37.7392573849237 | -122.417171894266 | (37.7392573849237, -122.417171894266) | 2 | 7 | 7 | 28859 | 2 | |||
108034 | 224502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 203 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006664.46693 | 2098372.33412 | 37.7421076872335 | -122.419565194404 | (37.7421076872335, -122.419565194404) | 2 | 7 | 7 | 28859 | 2 | |||
126873 | 33585 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.7405430288873 | -122.418608458082 | (37.7405430288873, -122.418608458082) | 2 | 7 | 7 | 28859 | 2 | |||
184443 | 224505 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2200 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008118.04648 | 2105348.76718 | 37.7613451678544 | -122.415032844197 | (37.7613451678544, -122.415032844197) | 2 | 4 | 7 | 28859 | 19 | |||
59644 | 224508 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6008177.84488 | 2105327.19464 | 37.761289294789 | -122.414824499172 | (37.761289294789, -122.414824499172) | 2 | 4 | 7 | 28859 | 19 | |||
92825 | 224507 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008190.11914 | 2105143.75528 | 37.760786302162 | -122.414769064951 | (37.760786302162, -122.414769064951) | 2 | 4 | 7 | 28859 | 19 | |||
130469 | 224509 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008178.36373 | 2105370.35117 | 37.76140782184 | -122.414825759103 | (37.76140782184, -122.414825759103) | 2 | 4 | 7 | 28859 | 19 | |||
17320 | 226492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | 2 | 4 | 7 | 28859 | 19 | |||
36516 | 226493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008772.32666 | 2104949.65017 | 37.7602860290962 | -122.41274173856 | (37.7602860290962, -122.41274173856) | 2 | 4 | 7 | 28859 | 19 | |||
59124 | 226494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008770.52865 | 2104997.08999 | 37.7604161870861 | -122.412751310945 | (37.7604161870861, -122.412751310945) | 2 | 4 | 7 | 28859 | 19 | |||
47723 | 224642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006381.67631 | 2098450.75503 | 37.742307080422 | -122.420548562565 | (37.742307080422, -122.420548562565) | 2 | 7 | 7 | 28859 | 2 | |||
92219 | 33508 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | 2 | 7 | 7 | 28859 | 2 | |||
39589 | 224649 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | 2 | 7 | 7 | 28859 | 2 | |||
152514 | 224650 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007190.04837 | 2099393.66184 | 37.7449416155647 | -122.417820274 | (37.7449416155647, -122.417820274) | 2 | 7 | 7 | 28859 | 2 | |||
172434 | 224506 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2404 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008170.5791 | 2104405.7281 | 37.7587587509332 | -122.414784412782 | (37.7587587509332, -122.414784412782) | 2 | 4 | 7 | 28859 | 19 | |||
25421 | 226491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008819.81577 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | 2 | 4 | 7 | 28859 | 19 | |||
138764 | 226490 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2450 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008822.75268 | 2104167.00903 | 37.7581399049582 | -122.412512013916 | (37.7581399049582, -122.412512013916) | 2 | 4 | 7 | 28859 | 19 | |||
11588 | 224634 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 248 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6006846.03495 | 2097621.06949 | 37.740055107862 | -122.418884118001 | (37.740055107862, -122.418884118001) | 2 | 7 | 7 | 28859 | 2 | |||
161744 | 226489 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2496 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008832.21298 | 2104006.96318 | 37.757700986321 | -122.41246798312 | (37.757700986321, -122.41246798312) | 2 | 4 | 7 | 28859 | 19 | |||
167771 | 226488 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2498 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008832.88031 | 2103985.45214 | 37.7576419593387 | -122.41246415471 | (37.7576419593387, -122.41246415471) | 2 | 4 | 7 | 28859 | 19 | |||
175733 | 224677 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 254 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007152.66781 | 2105827.76249 | 37.7626060812304 | -122.418405656216 | (37.7626060812304, -122.418405656216) | 8 | 4 | 7 | 28859 | 19 | |||
52676 | 224579 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2577 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008913.82756 | 2103471.3398 | 37.7562348656635 | -122.412147871222 | (37.7562348656635, -122.412147871222) | 2 | 4 | 7 | 28859 | 19 | |||
156936 | 224648 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 26 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006463.11483 | 2098326.07704 | 37.7419693319081 | -122.420258125606 | (37.7419693319081, -122.420258125606) | 2 | 7 | 7 | 28859 | 2 | |||
39862 | 7496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008261.67558 | 2102751.78327 | 37.754222512966 | -122.414352332587 | (37.754222512966, -122.414352332587) | 2 | 4 | 7 | 28859 | 19 | |||
65251 | 116393 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
74671 | 116392 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
90379 | 105718 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | |||
120282 | 116391 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
124391 | 116390 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
129976 | 116389 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
54721 | 224580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | Permit Number 781047 | 6008616.55983 | 2106802.76672 | 37.7653655169234 | -122.413411521233 | (37.7653655169234, -122.413411521233) | 8 | 4 | 7 | 28859 | 19 | ||
146057 | 224585 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | Permit Number 781047 | 6008501.81805 | 2106792.30192 | 37.7653303399343 | -122.413807647409 | (37.7653303399343, -122.413807647409) | 8 | 4 | 7 | 28859 | 19 | ||
8924 | 224586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2757 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008370.39736 | 2106782.63343 | 37.7652964112246 | -122.414261518161 | (37.7652964112246, -122.414261518161) | 8 | 4 | 7 | 28859 | 19 | |||
625 | 245416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010170.0429 | 2102204.1541 | 37.7528258621349 | -122.407714081565 | (37.7528258621349, -122.407714081565) | 2 | 4 | 7 | 28859 | 19 | |
11640 | 245417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | 2 | 4 | 7 | 28859 | 19 | |
13405 | 245415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010145.3814 | 2102202.4336 | 37.752819757444 | -122.407799244655 | (37.752819757444, -122.407799244655) | 2 | 4 | 7 | 28859 | 19 | |
27007 | 224588 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008276.68417 | 2106776.83741 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | 8 | 4 | 7 | 28859 | 19 | |||
116584 | 224587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008334.82797 | 2106780.39435 | 37.7652882651653 | -122.414384386251 | (37.7652882651653, -122.414384386251) | 8 | 4 | 7 | 28859 | 19 | |||
194356 | 224589 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008256.05874 | 2106775.28704 | 37.7652698164603 | -122.414656469826 | (37.7652698164603, -122.414656469826) | 8 | 4 | 7 | 28859 | 19 | |||
33181 | 224693 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006755.71735 | 2102172.37571 | 37.7525468808523 | -122.41951921745 | (37.7525468808523, -122.41951921745) | 2 | 4 | 7 | 28859 | 19 | |||
165930 | 224528 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006752.85457 | 2102173.99446 | 37.7525511643191 | -122.419529232289 | (37.7525511643191, -122.419529232289) | 2 | 4 | 7 | 28859 | 19 | |||
190230 | 26514 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | 2 | 4 | 7 | 28859 | 19 | |||
122395 | 224578 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2881 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009009.60186 | 2101733.0677 | 37.7514673346644 | -122.411693832315 | (37.7514673346644, -122.411693832315) | 2 | 4 | 7 | 28859 | 19 | |||
9506 | 26517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | 2 | 4 | 7 | 28859 | 19 | |||
13271 | 551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009445.64374 | 2102206.22318 | 37.7527909649347 | -122.41021934346 | (37.7527909649347, -122.41021934346) | 2 | 4 | 7 | 28859 | 19 | |||
138825 | 60292 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2902 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19857 | 6009437.54414231 | 2102795.33502096 | 37.7544080802013 | -122.410288944543 | (37.7544080802013, -122.410288944543) | 2 | 4 | 7 | 28859 | 19 | ||
38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
125391 | 554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2912X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009391.31353 | 2102200.13523 | 37.7527712032402 | -122.410406798162 | (37.7527712032402, -122.410406798162) | 2 | 4 | 7 | 28859 | 19 | |||
171938 | 60290 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2915 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19854 | 6009379.15115854 | 2102740.05515277 | 37.7542530206621 | -122.41048698011 | (37.7542530206621, -122.41048698011) | 2 | 4 | 7 | 28859 | 19 | ||
97958 | 224539 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008666.00775 | 2103876.41315 | 37.7573331968792 | -122.413033560461 | (37.7573331968792, -122.413033560461) | 2 | 4 | 7 | 28859 | 19 | |||
128820 | 224538 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008618.62403 | 2103873.92813 | 37.7573237135349 | -122.413197256868 | (37.7573237135349, -122.413197256868) | 2 | 4 | 7 | 28859 | 19 | |||
159135 | 224542 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008789.37213 | 2103883.03365 | 37.7573582996747 | -122.412607384336 | (37.7573582996747, -122.412607384336) | 2 | 4 | 7 | 28859 | 19 | |||
181644 | 224540 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008691.13752 | 2103878.13413 | 37.7573393329509 | -122.412946773194 | (37.7573393329509, -122.412946773194) | 2 | 4 | 7 | 28859 | 19 | |||
193316 | 224541 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008764.83764 | 2103880.48748 | 37.7573499314791 | -122.412692054597 | (37.7573499314791, -122.412692054597) | 2 | 4 | 7 | 28859 | 19 |
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) );