trees
406 rows where qSpecies_id = 47 sorted by PlotSize descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
163899 | 191389 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.7581491445771 | -122.403906816767 | (37.7581491445771, -122.403906816767) | 10 | 3 | 8 | 28856 | 29 | |||
46607 | 176987 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6002815.8897 | 2094148.38707 | 37.7302921639516 | -122.432570708688 | (37.7302921639516, -122.432570708688) | 9 | 7 | 5 | 28861 | 25 | |||
104265 | 129463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.7916643510872 | -122.436174782264 | (37.7916643510872, -122.436174782264) | 13 | 9 | 1 | 29490 | 27 | |||
107523 | 123588 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994278.22027 | 2115268.89087 | 37.7877957491728 | -122.463618619297 | (37.7877957491728, -122.463618619297) | 11 | 6 | 1 | 54 | 11 | |||
28693 | 191372 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011446.77315 | 2104664.66226 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | 10 | 3 | 8 | 28856 | 29 | |||
30568 | 129464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | 13 | 9 | 1 | 28858 | 27 | |||
49514 | 227681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997959.25406 | 2106183.43699 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | 15 | 5 | 11 | 29492 | 9 | |||
54525 | 191388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 40 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011282.56063 | 2104153.62595 | 37.7582408970175 | -122.40400394893 | (37.7582408970175, -122.40400394893) | 10 | 3 | 8 | 28856 | 29 | |||
105151 | 129466 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.7918582853821 | -122.425769315008 | (37.7918582853821, -122.425769315008) | 13 | 9 | 1 | 28858 | 27 | |||
105958 | 191384 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011268.81564 | 2104171.75859 | 37.7582899172605 | -122.40405276143 | (37.7582899172605, -122.40405276143) | 10 | 3 | 8 | 28856 | 29 | |||
115683 | 129467 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6006504.31748 | 2119710.78815 | 37.8006889650949 | -122.421634156713 | (37.8006889650949, -122.421634156713) | 13 | 9 | 1 | 28858 | 32 | |||
122863 | 129465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | 13 | 9 | 1 | 28858 | 27 | |||
123019 | 191383 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 34 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6011269.17641 | 2104180.10815 | 37.7583128634534 | -122.404052101317 | (37.7583128634534, -122.404052101317) | 10 | 3 | 8 | 28856 | 29 | |||
132662 | 176986 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.432060704959 | (37.7170867510327, -122.432060704959) | 9 | 7 | 6 | 28861 | 5 | |||
133496 | 191385 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | 10 | 3 | 8 | 28856 | 29 | |||
155046 | 129469 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | 5 | 1 | 10 | 308 | 21 | |||
167360 | 191381 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011271.17001 | 2104191.36243 | 37.7583438765916 | -122.404045998546 | (37.7583438765916, -122.404045998546) | 10 | 3 | 8 | 28856 | 29 | |||
179733 | 191387 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 39 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6011279.1597 | 2104155.21456 | 37.7582450689735 | -122.404015822688 | (37.7582450689735, -122.404015822688) | 10 | 3 | 8 | 28856 | 29 | |||
181108 | 191382 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011269.01089 | 2104184.59965 | 37.7583251868659 | -122.404052989848 | (37.7583251868659, -122.404052989848) | 10 | 3 | 8 | 28856 | 29 | |||
182337 | 191386 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6011275.59142 | 2104157.94605 | 37.7582523696726 | -122.404028355649 | (37.7582523696726, -122.404028355649) | 10 | 3 | 8 | 28856 | 29 | |||
4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
5099 | 261940 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Verna St | 5 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
24415 | 119095 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 6700 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5982534.89521 | 2109675.70682 | 37.7717548615052 | -122.503833231018 | (37.7717548615052, -122.503833231018) | 11 | 6 | 2 | 55 | 26 | |||
24427 | 207105 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995373.14858 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | 9 | 8 | 4 | 28861 | 24 | |||
30167 | 207101 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990477.30542 | 2106226.48097 | 37.7627480320102 | -122.476108237903 | (37.7627480320102, -122.476108237903) | 1 | 8 | 3 | 56 | 12 | |||
43157 | 227687 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.451424345184 | (37.7653509793933, -122.451424345184) | 15 | 5 | 11 | 29492 | 9 | |||
47837 | 227688 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.7407809344798 | -122.41570987722 | (37.7407809344798, -122.41570987722) | 2 | 7 | 7 | 28859 | 2 | |||
52711 | 207102 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990480.89082 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | 1 | 8 | 3 | 56 | 12 | |||
58696 | 119085 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 886 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5982037.396 | 2109722.65545 | 37.7718545033558 | -122.505557564286 | (37.7718545033558, -122.505557564286) | 11 | 6 | 2 | 55 | 26 | |||
59598 | 191367 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 548 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6011194.69766 | 2105791.52689 | 37.7627332975312 | -122.404423107658 | (37.7627332975312, -122.404423107658) | 8 | 3 | 8 | 28856 | 29 | |||
62642 | 227686 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997629.48637 | 2107046.84316 | 37.7654126728718 | -122.451430672783 | (37.7654126728718, -122.451430672783) | 15 | 5 | 11 | 29492 | 9 | |||
65610 | 237552 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003566.97457 | 2105097.88602 | 37.7603995118464 | -122.430755182518 | (37.7603995118464, -122.430755182518) | 2 | 4 | 5 | 28862 | 3 | |
67268 | 118441 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 5201 Anza St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5982477.73735 | 2111660.7356 | 37.7772018111581 | -122.504178007129 | (37.7772018111581, -122.504178007129) | 11 | 6 | 2 | 55 | 26 | |||
71469 | 176984 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | Width 3ft | 5996985 | 2087493 | 37.71168564061 | -122.45224873895 | (37.71168564061, -122.45224873895) | 9 | 7 | 6 | 28861 | 25 | |||
76454 | 227670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005513.92482 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | 2 | 4 | 5 | 28859 | 19 | |||
77195 | 237551 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.7604095509682 | -122.430689380017 | (37.7604095509682, -122.430689380017) | 2 | 4 | 5 | 28862 | 3 | |
81496 | 207129 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4986 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990655.7482 | 2093855.39662 | 37.7287905920011 | -122.47458816511 | (37.7287905920011, -122.47458816511) | 9 | 8 | 4 | 64 | 40 | |||
84866 | 227691 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006868.92044 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | 2 | 7 | 7 | 28859 | 2 | |||
89012 | 227683 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 923 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007409.88053 | 2101914.88747 | 37.7518767015549 | -122.417238758882 | (37.7518767015549, -122.417238758882) | 2 | 4 | 7 | 28859 | 19 | |||
93754 | 227689 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008214.29979 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | 2 | 7 | 7 | 28859 | 2 | |||
94578 | 207099 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990478.55232 | 2106260.78747 | 37.7628423007597 | -122.476106431162 | (37.7628423007597, -122.476106431162) | 1 | 8 | 3 | 56 | 12 | |||
98973 | 250332 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 141 27th Ave | 1 | : | Tree | Private 2 | 05/08/2002 12:00:00 AM | 4 | Width 3ft | Permit Number 45150 | 5987387.77846 | 2115003.34197 | 37.7866671925889 | -122.487438428541 | (37.7866671925889, -122.487438428541) | 11 | 6 | 1 | 55 | 33 | |
102941 | 227682 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008186.7931 | 2096476.12564 | 37.7369867469298 | -122.41416732858 | (37.7369867469298, -122.41416732858) | 2 | 7 | 7 | 28859 | 2 | |||
120655 | 207100 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990476.61635 | 2106239.99978 | 37.7627851110794 | -122.476111608564 | (37.7627851110794, -122.476111608564) | 1 | 8 | 3 | 56 | 12 | |||
126484 | 118250 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 759 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985366.8002 | 2110712.822 | 37.7747685933044 | -122.494114082166 | (37.7747685933044, -122.494114082166) | 11 | 6 | 2 | 55 | 26 | |||
127819 | 227694 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.443491144794 | (37.7592869569347, -122.443491144794) | 2 | 4 | 5 | 28862 | 3 | |||
137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
142493 | 227693 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002979.94012 | 2100929.17253 | 37.7489199393117 | -122.432487701248 | (37.7489199393117, -122.432487701248) | 2 | 4 | 5 | 28862 | 22 | |||
145982 | 227697 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | 15 | 9 | 11 | 29492 | 10 | |||
146162 | 207104 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | 9 | 8 | 4 | 28861 | 24 | |||
155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 2 | 7 | 7 | 28859 | 2 | |||
164867 | 118789 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 718 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5981995.4955 | 2110847.43445 | 37.7749403522663 | -122.505785898051 | (37.7749403522663, -122.505785898051) | 11 | 6 | 2 | 55 | 26 | |||
167551 | 207139 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996097.00713 | 2094250.77954 | 37.7301899955731 | -122.455806057116 | (37.7301899955731, -122.455806057116) | 9 | 7 | 4 | 28861 | 40 | |||
181786 | 176983 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 5996985 | 2087493 | 37.71168564061 | -122.45224873895 | (37.71168564061, -122.45224873895) | 9 | 7 | 6 | 28861 | 25 | |||
29184 | 176980 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5999548.76247 | 2089280.82364 | 37.7167411370713 | -122.443516055124 | (37.7167411370713, -122.443516055124) | 9 | 7 | 6 | 28861 | 25 | |||
29255 | 176982 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5999995.5387 | 2089705.60981 | 37.7179329735202 | -122.442002247903 | (37.7179329735202, -122.442002247903) | 9 | 7 | 6 | 28861 | 25 | |||
56832 | 227680 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003988.60954 | 2099295.31119 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | 2 | 7 | 5 | 63 | 22 | |||
75879 | 176985 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2571 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5998574.33272 | 2088565.20963 | 37.7147206041402 | -122.446832699994 | (37.7147206041402, -122.446832699994) | 9 | 7 | 6 | 28861 | 25 | |||
77789 | 201278 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 28 Lydia Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | 10 | 3 | 8 | 58 | 1 | |||
114789 | 207103 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.7260456803487 | -122.457364540844 | (37.7260456803487, -122.457364540844) | 9 | 7 | 4 | 28861 | 40 | |||
123108 | 227677 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003907.02908 | 2099270.15617 | 37.7444171939021 | -122.429163548878 | (37.7444171939021, -122.429163548878) | 2 | 7 | 5 | 63 | 22 | |||
134621 | 227679 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003556.92712 | 2099495.03666 | 37.7450148383554 | -122.430390170187 | (37.7450148383554, -122.430390170187) | 2 | 7 | 5 | 63 | 22 | |||
147419 | 227696 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003774.74871 | 2108065.24722 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | 7 | 9 | 5 | 28862 | 3 | |||
174228 | 227684 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2560 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002253.36783 | 2096984.49578 | 37.7380475512412 | -122.434718147625 | (37.7380475512412, -122.434718147625) | 2 | 7 | 5 | 63 | 7 | |||
176307 | 227678 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.7444117377113 | -122.429222690078 | (37.7444117377113, -122.429222690078) | 2 | 7 | 5 | 63 | 22 | |||
95742 | 176981 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 1ft | 5999571.4621 | 2089300.92693 | 37.7167976306892 | -122.443439037193 | (37.7167976306892, -122.443439037193) | 9 | 7 | 6 | 28861 | 25 | |||
1399 | 185502 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 56 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | 1 | 8 | 3 | 29491 | 35 | |||
13132 | 207127 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | 1 | 8 | 4 | 64 | 40 | |||
13504 | 207123 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.7338001863266 | -122.472359368113 | (37.7338001863266, -122.472359368113) | 1 | 8 | 4 | 64 | 40 | ||
17241 | 186756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | 1 | 8 | 3 | 56 | 35 | |||
23023 | 185776 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2113 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987480.2363 | 2102327.5294 | 37.7518683261067 | -122.486187667743 | (37.7518683261067, -122.486187667743) | 1 | 8 | 3 | 29491 | 35 | |||
25781 | 207137 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 103 | : | Tree | Private 2 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | 9 | 8 | 4 | 64 | 40 | |||
26539 | 207135 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991243.40911 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | 9 | 8 | 4 | 64 | 40 | |||
27854 | 185961 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2001 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984861.3455 | 2101337.8929 | 37.7489980727428 | -122.495171051634 | (37.7489980727428, -122.495171051634) | 1 | 8 | 3 | 29491 | 35 | |||
27885 | 200618 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 59 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.385517359434 | (37.733637339432, -122.385517359434) | 10 | 3 | 8 | 58 | 1 | |||
31750 | 200604 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 61 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016455.981 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | 10 | 3 | 8 | 58 | 1 | |||
34278 | 181438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | 1 | 8 | 3 | 56 | 35 | |||
34911 | 185504 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 58 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.494105581845 | (37.7420078978362, -122.494105581845) | 1 | 8 | 3 | 29491 | 35 | |||
37655 | 207106 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Tara St | 2 | : | Tree | Private 2 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | 9 | 8 | 6 | 28861 | 24 | |||
40373 | 186512 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 13 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | 1 | 8 | 3 | 56 | 35 | |||
40962 | 183209 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4212 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5982952.5112 | 2098143.3306 | 37.7401147458032 | -122.501535410067 | (37.7401147458032, -122.501535410067) | 1 | 8 | 3 | 29491 | 35 | |||
42527 | 207128 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 5991324.62806 | 2095649.61894 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | 1 | 8 | 4 | 64 | 40 | |||
43944 | 184307 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | 1 | 8 | 3 | 56 | 35 | |||
46544 | 183430 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | 1 | 8 | 3 | 29491 | 35 | |||
47779 | 138264 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 32 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.446995936272 | (37.7823276740968, -122.446995936272) | 15 | 5 | 1 | 54 | 16 | |||
49589 | 186745 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | 1 | 8 | 3 | 56 | 35 | |||
49732 | 186510 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 11 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.7591962518414 | -122.509142853237 | (37.7591962518414, -122.509142853237) | 1 | 8 | 3 | 56 | 35 | |||
55330 | 186759 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | 1 | 8 | 3 | 56 | 35 | |||
58446 | 183252 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5980914.4873 | 2106074.217 | 37.7617708050911 | -122.509170734828 | (37.7617708050911, -122.509170734828) | 1 | 8 | 3 | 56 | 35 | |||
60345 | 207132 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | 9 | 8 | 4 | 64 | 40 | |||
60657 | 183431 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2506 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988944.9633 | 2098242.436 | 37.7407369950817 | -122.480823446497 | (37.7407369950817, -122.480823446497) | 1 | 8 | 3 | 29491 | 35 | |||
61664 | 207136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 100 | : | Tree | Private 2 | 6 | Width 0ft | 5991240.31686 | 2092039.54753 | 37.7238385767639 | -122.472434966904 | (37.7238385767639, -122.472434966904) | 9 | 8 | 4 | 64 | 40 | |||
64416 | 183208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.7401199309313 | -122.501448961428 | (37.7401199309313, -122.501448961428) | 1 | 8 | 3 | 29491 | 35 | |||
66429 | 183655 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4000 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982394.94 | 2104929.8732 | 37.7587159336991 | -122.503965765246 | (37.7587159336991, -122.503965765246) | 1 | 8 | 3 | 56 | 35 | |||
69315 | 138260 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | 15 | 5 | 1 | 54 | 16 | |||
71159 | 207133 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 90 | : | Tree | Private 2 | 10 | Width 0ft | 5991231.48328 | 2092142.91587 | 37.7241218892943 | -122.472473035196 | (37.7241218892943, -122.472473035196) | 9 | 8 | 4 | 64 | 40 | |||
78917 | 207118 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 12 | Front Yard : Yard | Tree | Private 2 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | 1 | 8 | 4 | 64 | 40 | |||
79037 | 200614 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 55 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.7336998293082 | -122.385562980445 | (37.7336998293082, -122.385562980445) | 10 | 3 | 8 | 58 | 1 | |||
83580 | 207121 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 8 | Front Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.7338330421511 | -122.472331306559 | (37.7338330421511, -122.472331306559) | 1 | 8 | 4 | 64 | 40 | |||
85806 | 207130 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Junipero Serra Blvd | 22 | : | Tree | Private 2 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | 9 | 8 | 4 | 64 | 40 |
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) );