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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23148 | 23148 | 973 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 56915 | 56915 | 38348 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1607 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 0 | Permit Number 40415 | 5981863.96536039 | 2104143.69244361 | 37.756526067201705 | -122.505743805317 | (37.7565260672017, -122.505743805317) | |
| 115064 | 115064 | 105256 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185683998 | (37.7195776934466, -122.42687185684) | ||
| 93065 | 93065 | 31600 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1631 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35126 | 5988991.64827869 | 2102380.23074862 | 37.7521010026968 | -122.480964913447 | (37.7521010026968, -122.480964913447) | ||
| 115167 | 115167 | 47225 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1643 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45170 | 6006193.94874397 | 2092417.83045771 | 37.7257314225765 | -122.42076946999399 | (37.7257314225765, -122.420769469994) | ||
| 123140 | 123140 | 40483 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 165 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41562 | 5996732.70371963 | 2089259.1130924 | 37.716520521088796 | -122.45324815845699 | (37.7165205210888, -122.453248158457) | ||
| 29645 | 29645 | 50707 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1658 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 47266 | 5983788.66504778 | 2103867.70402192 | 37.75588137239 | -122.499067221884 | (37.75588137239, -122.499067221884) | |
| 65640 | 65640 | 46969 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1658 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 7 | Permit Number 44989 | 5982547.49278996 | 2103828.23178681 | 37.7557001072445 | -122.503356606053 | (37.7557001072445, -122.503356606053) | |
| 91138 | 91138 | 47550 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | ||
| 115428 | 115428 | 36089 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.754536221771204 | -122.508568229446 | (37.7545362217712, -122.508568229446) | ||
| 37604 | 37604 | 184574 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1706 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981029.903 | 2103411.5484 | 37.754466683478604 | -122.50857388751899 | (37.7544666834786, -122.508573887519) | |||
| 66814 | 66814 | 52554 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1719 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 8 | Permit Number 48649 | 5984370.92860727 | 2103469.2332854997 | 37.754821420904996 | -122.49702418509099 | (37.754821420905, -122.497024185091) | |
| 67487 | 67487 | 47082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 5 | Permit Number 45068 | 5996827.60082146 | 2111762.20695793 | 37.778313889032205 | -122.45454486671998 | (37.7783138890322, -122.45454486672) | |
| 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) | |||||
| 47735 | 47735 | 46973 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1783 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 7 | Permit Number 44992 | 5982214.017865701 | 2102979.50871383 | 37.753350143755796 | -122.504446973742 | (37.7533501437558, -122.504446973742) | |
| 34046 | 34046 | 186310 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1800 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.7705 | 2102775.9332 | 37.7529527085207 | -122.49491251324899 | (37.7529527085207, -122.494912513249) | |||
| 140587 | 140587 | 31580 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1841 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35119 | 5989049.89925793 | 2102807.07383274 | 37.75327638601021 | -122.48079472188999 | (37.7532763860102, -122.48079472189) | ||
| 92356 | 92356 | 79056 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50038 | 5983215.17096299 | 2102463.12302331 | 37.7519911277095 | -122.500946646871 | (37.7519911277095, -122.500946646871) | ||
| 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) | |||
| 128843 | 128843 | 47111 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45095 | 6007076.38254046 | 2097931.15674799 | 37.740919506174706 | -122.41810964654499 | (37.7409195061747, -122.418109646545) |
| 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) | |||
| 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) | |||
| 178737 | 178737 | 186058 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1901 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984794.5256 | 2102183.7824 | 37.7513167410032 | -122.495464490464 | (37.7513167410032, -122.495464490464) | |||
| 83936 | 83936 | 31575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1922 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35114 | 5989431.17806618 | 2102257.22974077 | 37.7517888142139 | -122.479435972521 | (37.7517888142139, -122.479435972521) | ||
| 145098 | 145098 | 68368 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 194 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | Permit Number 32189 | 6002712.41508002 | 2094283.54436078 | 37.730657406687 | -122.432938086411 | (37.730657406687, -122.432938086411) | ||
| 165701 | 165701 | 42597 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.42515859980499 | (37.7919342879744, -122.425158599805) | ||
| 54198 | 54198 | 129465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | |||
| 57626 | 57626 | 129464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | |||
| 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) | |||
| 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) | |||||
| 178473 | 178473 | 122182 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991497.785680001 | 2114857.01928 | 37.7865042639669 | -122.473208256238 | (37.7865042639669, -122.473208256238) | ||||
| 51787 | 51787 | 217831 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5991381.66969 | 2095739.8250799999 | 37.734006793868 | -122.472215938837 | (37.734006793868, -122.472215938837) | ||||
| 53270 | 53270 | 207125 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991332.892440001 | 2095658.5010099998 | 37.733780675521395 | -122.47237864866001 | (37.7337806755214, -122.47237864866) | |||
| 60545 | 60545 | 207126 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991329.52565 | 2095655.7745299998 | 37.733772994434204 | -122.472390089849 | (37.7337729944342, -122.472390089849) | |||
| 72315 | 72315 | 207127 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | |||
| 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) | |||
| 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) | |||
| 174722 | 174722 | 207118 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | |||
| 178438 | 178438 | 207120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | |||
| 179845 | 179845 | 207123 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.733800186326604 | -122.472359368113 | (37.7338001863266, -122.472359368113) | |||
| 180846 | 180846 | 207121 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.733833042151105 | -122.47233130655898 | (37.7338330421511, -122.472331306559) | |||
| 184814 | 184814 | 207122 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.47234340152399 | (37.7338141267018, -122.472343401524) | |||
| 188736 | 188736 | 207124 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | |||
| 54994 | 54994 | 191408 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6016232.34971 | 2100308.61772 | 37.747958617113596 | -122.38661714986 | (37.7479586171136, -122.38661714986) | ||||
| 72105 | 72105 | 191406 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6016222.17813 | 2100305.9500599997 | 37.74795072915779 | -122.386652137081 | (37.7479507291578, -122.386652137081) | ||||
| 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) | ||||
| 172620 | 172620 | 191407 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6016225.71134 | 2100306.15132 | 37.747951477381 | -122.386639933312 | (37.747951477381, -122.386639933312) | ||||
| 185104 | 185104 | 191404 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6016173.59275 | 2100299.3088 | 37.7479298037296 | -122.3868196817 | (37.7479298037296, -122.3868196817) | ||||
| 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) | |||
| 87840 | 87840 | 50881 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2040 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47391 | 5991642.80129947 | 2101534.85210656 | 37.7499335653235 | -122.47173531309299 | (37.7499335653235, -122.471735313093) | ||
| 138680 | 138680 | 36317 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51552 | 5996115.78800404 | 2094224.07875239 | 37.730117759471895 | -122.455739200241 | (37.7301177594719, -122.455739200241) | ||
| 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) | |||
| 158119 | 158119 | 46395 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.74756255280229 | -122.505118527994 | (37.7475625528023, -122.505118527994) | |
| 49267 | 49267 | 191398 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010740.07849 | 2107915.77093 | 37.768540573414896 | -122.406145147482 | (37.7685405734149, -122.406145147482) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 171831 | 171831 | 191396 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010761.0499599995 | 2107917.30957 | 37.7685459711594 | -122.40607271698799 | (37.7685459711594, -122.406072716988) | ||||
| 177899 | 177899 | 191399 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010727.66479 | 2107914.7241700003 | 37.7685370048986 | -122.406188011877 | (37.7685370048986, -122.406188011877) | ||||
| 89703 | 89703 | 37850 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681196998 | 37.725668101811706 | -122.42855239521201 | (37.7256681018117, -122.428552395212) | ||
| 173361 | 173361 | 46399 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2110 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 5 | Permit Number 44629 | 5981721.80383178 | 2100709.75793181 | 37.7470890826019 | -122.505980852245 | (37.7470890826019, -122.505980852245) | |
| 70945 | 70945 | 185776 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2113 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5987480.2363 | 2102327.5294 | 37.7518683261067 | -122.486187667743 | (37.7518683261067, -122.486187667743) | |||
| 65265 | 65265 | 83279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.449010201 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | |
| 175633 | 175633 | 176982 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5999995.5387 | 2089705.6098099998 | 37.717932973520206 | -122.442002247903 | (37.7179329735202, -122.442002247903) | |||
| 35370 | 35370 | 248189 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 216 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | ||||
| 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) | |||
| 66262 | 66262 | 138270 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.44922707658199 | (37.7809154323836, -122.449227076582) | |||
| 105491 | 105491 | 31546 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.44919042402901 | (37.7809035197163, -122.449190424029) | |
| 139074 | 139074 | 63714 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1997 12:00:00 AM | Permit Number 24378 | 6007857.54148412 | 2100263.37846132 | 37.7473672046192 | -122.41557376317499 | (37.7473672046192, -122.415573763175) | ||
| 80038 | 80038 | 35417 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 221 Crestmont Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.45969708953301 | (37.7562443131302, -122.459697089533) | |||
| 114397 | 114397 | 35418 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.45969708953301 | (37.7562443131302, -122.459697089533) | |||
| 144258 | 144258 | 35419 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 221 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.45969708953301 | (37.7562443131302, -122.459697089533) | |||
| 28427 | 28427 | 83251 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | |
| 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) | |||
| 159182 | 159182 | 78557 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | |
| 49254 | 49254 | 48530 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2251(REVISED) 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 6 | Permit Number 45852 | 5988214.95937948 | 2099991.18132471 | 37.7454961303111 | -122.48347566224899 | (37.7454961303111, -122.483475662249) | |
| 172830 | 172830 | 84447 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.744321183805106 | -122.503635505549 | (37.7443211838051, -122.503635505549) | |
| 33610 | 33610 | 84133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 23 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50705 | 6011012.12355 | 2088466.5124700002 | 37.7151523039101 | -122.403835398892 | (37.7151523039101, -122.403835398892) | |
| 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) | |||
| 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) | |||
| 8136 | 8136 | 2477 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.790123955413705 | -122.43124522668998 | (37.7901239554137, -122.43124522669) | |||
| 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) | |||
| 175676 | 175676 | 176981 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 1ft | 5999571.4621 | 2089300.9269299998 | 37.7167976306892 | -122.44343903719299 | (37.7167976306892, -122.443439037193) | |||
| 42954 | 42954 | 79486 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | |
| 8966 | 8966 | 18882 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6003557.0695 | 2115907.1327400003 | 37.7900784748972 | -122.43156114415001 | (37.7900784748972, -122.43156114415) | |||
| 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) | |||
| 66736 | 66736 | 68069 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 239 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31806 | 5993313.66059206 | 2103207.09024288 | 37.7546216328473 | -122.466078949095 | (37.7546216328473, -122.466078949095) | ||
| 59085 | 59085 | 185502 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 56 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | |||
| 65093 | 65093 | 185504 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 58 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.49410558184499 | (37.7420078978362, -122.494105581845) | |||
| 37103 | 37103 | 207104 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | |||
| 103787 | 103787 | 50490 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | ||
| 107841 | 107841 | 50489 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) |
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");