Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74619 | 74619 | 129475 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012586.0999300005 | 2120128.51859 | 37.8021770130129 | -122.40061790879999 | (37.8021770130129, -122.4006179088) | ||||
| 74734 | 74734 | 227671 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005087.18528 | 2097058.7145599998 | 37.738411814457706 | -122.42492550452101 | (37.7384118144577, -122.424925504521) | ||||
| 76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
| 76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
| 77293 | 77293 | 227685 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997626.030809999 | 2107071.20572 | 37.765479368391 | -122.45144438204599 | (37.765479368391, -122.451444382046) | |||
| 79154 | 79154 | 976 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1599 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 6001942.44101 | 2093088.0021099998 | 37.7273310167784 | -122.43551450655701 | (37.7273310167784, -122.435514506557) | |||
| 79594 | 79594 | 12917 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
| 84781 | 84781 | 101254 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3700X Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005840.6 | 2100555.6 | 37.74805599841039 | -122.422568977073 | (37.7480559984104, -122.422568977073) | |||||
| 93184 | 93184 | 119281 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992077.0 | 2088275.0 | 37.713550438396396 | -122.469268843393 | (37.7135504383964, -122.469268843393) | ||||
| 94398 | 94398 | 116654 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 95215 | 95215 | 116655 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 95391 | 95391 | 113478 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6006917.0 | 2098966.0 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | ||||
| 95944 | 95944 | 116681 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 98542 | 98542 | 12918 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
| 100529 | 100529 | 9277 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000049.092019999 | 2089751.6792400002 | 37.7180625213905 | -122.44182044273701 | (37.7180625213905, -122.441820442737) | |||
| 102052 | 102052 | 23670 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 317 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006937.941544901 | 2098264.8464559 | 37.7418279505329 | -122.41861198258002 | (37.7418279505329, -122.41861198258) | |||
| 105136 | 105136 | 18878 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6003659.521319999 | 2115878.15996 | 37.7900047293604 | -122.43120460047501 | (37.7900047293604, -122.431204600475) | |||
| 108468 | 108468 | 1383 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | |||
| 120269 | 120269 | 85386 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | ||||
| 121074 | 121074 | 117519 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
| 122500 | 122500 | 115975 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006168.0 | 2102576.0 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | |||
| 123417 | 123417 | 247871 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009746.3542 | 2098404.30325 | 37.742368581453704 | -122.40891120669201 | (37.7423685814537, -122.408911206692) | ||||
| 123731 | 123731 | 227678 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.744411737711296 | -122.42922269007799 | (37.7444117377113, -122.429222690078) | |||
| 128729 | 128729 | 105136 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175X ESMERALDA AVE | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | |||||
| 129429 | 129429 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 38 | 155 Winston Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990788.0 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | |||||
| 130073 | 130073 | 227688 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.740780934479794 | -122.41570987722 | (37.7407809344798, -122.41570987722) | |||
| 130081 | 130081 | 207105 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995373.148580001 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | |||
| 130276 | 130276 | 191375 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6011300.325759999 | 2104333.131 | 37.7587347705187 | -122.40395514093399 | (37.7587347705187, -122.403955140934) | ||||
| 130366 | 130366 | 191373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011285.49599 | 2104337.84522 | 37.758746886173896 | -122.40400676112 | (37.7587468861739, -122.40400676112) | ||||
| 130724 | 130724 | 227681 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997959.25406 | 2106183.4369900003 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | |||
| 130969 | 130969 | 250332 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 141 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987387.77846 | 2115003.34197 | 37.786667192588894 | -122.487438428541 | (37.7866671925889, -122.487438428541) | |||
| 131762 | 131762 | 191368 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6012502.16132 | 2102909.3105599997 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | ||||
| 132080 | 132080 | 207131 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991341.745569999 | 2093676.61882 | 37.7283394372056 | -122.47220362351901 | (37.7283394372056, -122.472203623519) | |||
| 132288 | 132288 | 207130 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Junipero Serra Blvd | 22 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | |||
| 132346 | 132346 | 191376 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011285.447430001 | 2104312.53247 | 37.758677380280105 | -122.40400514772699 | (37.7586773802801, -122.404005147727) | ||||
| 132469 | 132469 | 129472 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | ||||
| 132758 | 132758 | 191401 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010711.19096 | 2107913.74245 | 37.768533387842396 | -122.406244924566 | (37.7685333878424, -122.406244924566) | ||||
| 133677 | 133677 | 185961 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2001 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984861.3455 | 2101337.8929 | 37.74899807274279 | -122.495171051634 | (37.7489980727428, -122.495171051634) | |||
| 133879 | 133879 | 227670 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005513.924819999 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | |||
| 135684 | 135684 | 183373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.736548599668104 | -122.492356136884 | (37.7365485996681, -122.492356136884) | |||
| 136036 | 136036 | 129466 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.791858285382105 | -122.425769315008 | (37.7918582853821, -122.425769315008) | |||
| 136052 | 136052 | 218293 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.47284238406799 | (37.7329801745819, -122.472842384068) | ||||
| 136406 | 136406 | 191382 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6011269.0108900005 | 2104184.59965 | 37.758325186865896 | -122.404052989848 | (37.7583251868659, -122.404052989848) | |||
| 136701 | 136701 | 207107 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992169.5585900005 | 2088419.4087099999 | 37.7139522980308 | -122.46895943344299 | (37.7139522980308, -122.468959433443) | ||||
| 136797 | 136797 | 191395 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6010771.29847 | 2107917.19939 | 37.7685462418407 | -122.406037260315 | (37.7685462418407, -122.406037260315) | ||||
| 136946 | 136946 | 244098 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.770831393246496 | -122.44746952816901 | (37.7708313932465, -122.447469528169) | |||
| 137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
| 137835 | 137835 | 129468 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | ||||
| 137935 | 137935 | 176980 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 5999548.7624699995 | 2089280.82364 | 37.716741137071295 | -122.443516055124 | (37.7167411370713, -122.443516055124) | |||
| 137937 | 137937 | 129474 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | ||||
| 139249 | 139249 | 16565 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.716870613942795 | -122.443365227339 | (37.7168706139428, -122.443365227339) | |||
| 140815 | 140815 | 16566 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.716806377922104 | -122.44343023048201 | (37.7168063779221, -122.443430230482) | |||
| 143078 | 143078 | 121420 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1155x Prague St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6000780.0 | 2086820.0 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | ||||
| 144076 | 144076 | 889 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1136X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6003353.033430001 | 2094335.58352 | 37.7308366096666 | -122.43072708407401 | (37.7308366096666, -122.430727084074) | |||
| 147326 | 147326 | 191386 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6011275.5914199995 | 2104157.94605 | 37.758252369672604 | -122.40402835564899 | (37.7582523696726, -122.404028355649) | |||
| 147602 | 147602 | 129471 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.40082938436701 | (37.8023912773999, -122.400829384367) | ||||
| 148023 | 148023 | 207134 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 98 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.723889216687496 | -122.47242285485201 | (37.7238892166875, -122.472422854852) | |||
| 148496 | 148496 | 227674 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 83 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005065.1015800005 | 2097012.05309 | 37.7382824451638 | -122.42499854026899 | (37.7382824451638, -122.424998540269) | ||||
| 148752 | 148752 | 207137 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | |||
| 150156 | 150156 | 191402 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010700.42675 | 2107913.45144 | 37.7685319866755 | -122.406282136733 | (37.7685319866755, -122.406282136733) | ||||
| 150938 | 150938 | 227672 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.42489737911801 | (37.7383979127325, -122.424897379118) | ||||
| 151013 | 151013 | 118250 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985366.8002 | 2110712.8219999997 | 37.7747685933044 | -122.494114082166 | (37.7747685933044, -122.494114082166) | |||
| 151432 | 151432 | 186745 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | |||
| 151607 | 151607 | 191377 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6011285.82751 | 2104250.98235 | 37.75850839857429 | -122.40399950177601 | (37.7585083985743, -122.403999501776) | ||||
| 152163 | 152163 | 207138 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 123 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991217.227519999 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | |||
| 152532 | 152532 | 129478 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012509.68294 | 2120230.66756 | 37.80245322719529 | -122.400889531035 | (37.8024532271953, -122.400889531035) | ||||
| 152713 | 152713 | 129469 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | |||
| 153486 | 153486 | 207109 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992170.77084 | 2088338.0326 | 37.713728928924105 | -122.46894932506599 | (37.7137289289241, -122.468949325066) | ||||
| 154014 | 154014 | 227691 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006868.9204400005 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | |||
| 154023 | 154023 | 207128 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 5991324.62806 | 2095649.6189400002 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | |||
| 154113 | 154113 | 201278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 28 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | |||
| 154417 | 154417 | 191378 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011285.84337 | 2104240.2990099997 | 37.7584790653842 | -122.40399869511002 | (37.7584790653842, -122.40399869511) | ||||
| 154704 | 154704 | 191400 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010721.657430001 | 2107914.21049 | 37.76853525842721 | -122.406208754734 | (37.7685352584272, -122.406208754734) | ||||
| 156319 | 156319 | 186749 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | |||
| 158536 | 158536 | 207119 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.733863573243205 | -122.47230902406099 | (37.7338635732432, -122.472309024061) | |||
| 159286 | 159286 | 191372 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011446.77315 | 2104664.6622599997 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | |||
| 159748 | 159748 | 191397 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6010751.13717 | 2107916.6697400003 | 37.768543659889005 | -122.406106959582 | (37.768543659889, -122.406106959582) | ||||
| 159861 | 159861 | 227676 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 427 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | ||||
| 160044 | 160044 | 186041 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1900 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984992.0482 | 2102149.6578 | 37.7512346080754 | -122.494778929254 | (37.7512346080754, -122.494778929254) | |||
| 161309 | 161309 | 207102 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990480.890819999 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | |||
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 162968 | 162968 | 191403 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010692.2016199995 | 2107913.0668 | 37.7685304704432 | -122.40631055979601 | (37.7685304704432, -122.406310559796) | ||||
| 163400 | 163400 | 207139 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996097.007130001 | 2094250.7795400003 | 37.7301899955731 | -122.45580605711599 | (37.7301899955731, -122.455806057116) | |||
| 163790 | 163790 | 227694 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.44349114479401 | (37.7592869569347, -122.443491144794) | |||
| 164114 | 164114 | 184169 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3734 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982587.082 | 2104253.9424 | 37.7568713157118 | -122.503251214898 | (37.7568713157118, -122.503251214898) | |||
| 164118 | 164118 | 191384 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6011268.81564 | 2104171.75859 | 37.7582899172605 | -122.40405276143 | (37.7582899172605, -122.40405276143) | |||
| 164300 | 164300 | 186000 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | |||
| 164558 | 164558 | 138264 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.44699593627199 | (37.7823276740968, -122.446995936272) | |||
| 164753 | 164753 | 207116 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992178.8337 | 2088240.4151599999 | 37.7134613608383 | -122.46891435762801 | (37.7134613608383, -122.468914357628) | ||||
| 166033 | 166033 | 129485 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.40163364357099 | (37.803343726885, -122.401633643571) | ||||
| 166550 | 166550 | 227682 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008186.7931 | 2096476.1256400002 | 37.7369867469298 | -122.41416732857999 | (37.7369867469298, -122.41416732858) | |||
| 167635 | 167635 | 207136 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 100 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991240.31686 | 2092039.5475299999 | 37.723838576763896 | -122.47243496690399 | (37.7238385767639, -122.472434966904) | |||
| 168815 | 168815 | 191391 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.40393797827299 | (37.7588597960547, -122.403937978273) | ||||
| 169449 | 169449 | 191383 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6011269.17641 | 2104180.10815 | 37.7583128634534 | -122.404052101317 | (37.7583128634534, -122.404052101317) | |||
| 169634 | 169634 | 191405 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6016216.75475 | 2100305.37684 | 37.7479488549636 | -122.386670851103 | (37.7479488549636, -122.386670851103) | ||||
| 169951 | 169951 | 183438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2506 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5988326.6233 | 2098215.7152 | 37.7406276663345 | -122.48295944841401 | (37.7406276663345, -122.482959448414) | |||
| 170082 | 170082 | 191380 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6011289.9844 | 2104226.0484599997 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | ||||
| 170757 | 170757 | 184168 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3732 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5982616.4158 | 2104253.9424 | 37.756873039994204 | -122.503149769389 | (37.7568730399942, -122.503149769389) | |||
| 171177 | 171177 | 207103 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.726045680348705 | -122.457364540844 | (37.7260456803487, -122.457364540844) | |||
| 171541 | 171541 | 186059 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1901 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984803.9529 | 2102180.8195 | 37.751309157700604 | -122.495431671777 | (37.7513091577006, -122.495431671777) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");