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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 121968 | 121968 | 89102 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 621 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990317.40522 | 2111147.00842 | 37.7762491890218 | -122.477020839229 | (37.7762491890218, -122.477020839229) | ||
| 126204 | 126204 | 89103 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 625 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990317.85123 | 2111122.02756 | 37.7761806243316 | -122.47701747056101 | (37.7761806243316, -122.477017470561) | ||
| 137045 | 137045 | 57079 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | ||
| 108932 | 108932 | 89105 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 635 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990321.35395 | 2111045.8273 | 37.775971602591795 | -122.476999784527 | (37.7759716025918, -122.476999784527) | ||
| 143981 | 143981 | 116237 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 639 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5990321.779490001 | 2111019.87703 | 37.775900374977 | -122.47699641585 | (37.775900374977, -122.47699641585) | |||
| 138922 | 138922 | 89104 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990323.547333 | 2111099.7078 | 37.77611967086071 | -122.476996135109 | (37.7761196708607, -122.476996135109) | ||
| 99532 | 99532 | 89079 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 522 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 2 | 3x3 | 5990340.26635 | 2111799.54514 | 37.7780422011609 | -122.476989449392 | (37.7780422011609, -122.476989449392) | ||
| 118494 | 118494 | 89078 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 526 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990340.85231 | 2111766.5874799998 | 37.7779517425204 | -122.47698501352501 | (37.7779517425204, -122.476985013525) | ||
| 83916 | 83916 | 89107 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990326.6354 | 2110892.4923 | 37.775550893244294 | -122.47697030809401 | (37.7755508932443, -122.476970308094) | ||
| 119685 | 119685 | 89108 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 663 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990326.43317 | 2110871.40415 | 37.775492979250295 | -122.47696946639999 | (37.7754929792503, -122.4769694664) | ||
| 108532 | 108532 | 89077 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990343.546375 | 2111649.81696 | 37.777631279192796 | -122.47696715934299 | (37.7776312791928, -122.476967159343) | ||
| 116465 | 116465 | 89109 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 667 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5990327.355930001 | 2110845.92809 | 37.775423082523396 | -122.47696441245 | (37.7754230825234, -122.47696441245) | ||
| 188902 | 188902 | 182960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990064.3236 | 2098390.6107 | 37.741208843809794 | -122.47696398819299 | (37.7412088438098, -122.476963988193) | |||
| 142878 | 142878 | 89076 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 550 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990345.59029 | 2111614.5302 | 37.777534510056704 | -122.476957509799 | (37.7775345100567, -122.476957509799) | ||
| 91083 | 91083 | 89110 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 675 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990329.58522 | 2110790.11902 | 37.7752699754793 | -122.476952622071 | (37.7752699754793, -122.476952622071) | ||
| 175622 | 175622 | 37630 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40048 | 5990347.694519999 | 2111641.30179 | 37.777608139525 | -122.476952187306 | (37.777608139525, -122.476952187306) | |
| 115691 | 115691 | 89075 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 554 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990347.66295 | 2111591.2456400003 | 37.777470697316 | -122.476948638049 | (37.777470697316, -122.476948638049) | ||
| 106267 | 106267 | 89111 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 691 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990331.56334 | 2110745.46757 | 37.775147489618504 | -122.47694251603501 | (37.7751474896185, -122.476942516035) | ||
| 92694 | 92694 | 89112 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 691 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990332.54501 | 2110711.2620900003 | 37.7750536277141 | -122.476936620369 | (37.7750536277141, -122.476936620369) | ||
| 118581 | 118581 | 89074 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 568 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990349.6336900005 | 2111514.5867 | 37.777260327334 | -122.47693621793199 | (37.777260327334, -122.476936217932) | ||
| 74868 | 74868 | 121865 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 574 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990352.3789099995 | 2111462.4285 | 37.7771172745488 | -122.476922909403 | (37.7771172745488, -122.476922909403) | |||
| 79152 | 79152 | 89072 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 578 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990352.95655 | 2111441.21881 | 37.7770590720957 | -122.47691936106001 | (37.7770590720957, -122.47691936106) | ||
| 83557 | 83557 | 89117 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 727 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990344.4993 | 2110412.80162 | 37.774234830642705 | -122.476873456227 | (37.7742348306427, -122.476873456227) | ||
| 109677 | 109677 | 89070 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 610 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 2 | 3x3 | 5990363.96165 | 2111197.3405 | 37.776390087833796 | -122.476863467892 | (37.7763900878338, -122.476863467892) | ||
| 81167 | 81167 | 89071 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 606 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990364.94891 | 2111219.79426 | 37.776451796946795 | -122.476861693703 | (37.7764517969468, -122.476861693703) | ||
| 79857 | 79857 | 89670 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2643 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990382.48871 | 2111946.2204400003 | 37.778447380347096 | -122.476854108344 | (37.7784473803471, -122.476854108344) | ||
| 119909 | 119909 | 89067 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5990364.470407 | 2111075.081065 | 37.776054426582704 | -122.47685277294902 | (37.7760544265827, -122.476852772949) | ||
| 128398 | 128398 | 89069 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990366.5532599995 | 2111125.77489 | 37.7761937387005 | -122.476849272694 | (37.7761937387005, -122.476849272694) | ||
| 105058 | 105058 | 89068 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990367.60069 | 2111102.5118400003 | 37.7761299255256 | -122.476843949277 | (37.7761299255256, -122.476843949277) | ||
| 187174 | 187174 | 122008 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2650 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990390.42893 | 2112003.07059 | 37.7786039357458 | -122.476830795247 | (37.7786039357458, -122.476830795247) | |||
| 88935 | 88935 | 89118 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 767 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990353.59701 | 2110151.97769 | 37.7735192073496 | -122.47682292511001 | (37.7735192073496, -122.47682292511) | ||
| 120824 | 120824 | 89066 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 656 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990372.2384 | 2110982.1220400003 | 37.7757996372707 | -122.476819108153 | (37.7757996372707, -122.476819108153) | ||
| 108240 | 108240 | 89065 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 664 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990373.51835 | 2110921.31055 | 37.775632739883704 | -122.476810236402 | (37.7756327398837, -122.476810236402) | ||
| 100520 | 100520 | 89671 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2643 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990400.47198 | 2111947.3155099996 | 37.7784514302677 | -122.476791978132 | (37.7784514302677, -122.476791978132) | ||
| 81655 | 81655 | 89431 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2650 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990408.549930001 | 2112000.5588 | 37.7785980902022 | -122.476767924851 | (37.7785980902022, -122.476767924851) | ||
| 118487 | 118487 | 89064 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 706 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990387.44621 | 2110524.3809 | 37.7745436879542 | -122.476733050457 | (37.7745436879542, -122.476733050457) | ||
| 147585 | 147585 | 31733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) |
| 103146 | 103146 | 89063 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 710 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990388.49369 | 2110501.1170799998 | 37.774479872644 | -122.476727727029 | (37.774479872644, -122.476727727029) | ||
| 145001 | 145001 | 89060 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990392.548057 | 2110303.8535700003 | 37.7739384762903 | -122.476699287319 | (37.7739384762903, -122.476699287319) | ||
| 84911 | 84911 | 89061 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990394.60611 | 2110329.10213 | 37.7740079212926 | -122.476694013266 | (37.7740079212926, -122.476694013266) | ||
| 67213 | 67213 | 51275 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | |
| 113266 | 113266 | 89058 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 746 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990395.0930699995 | 2110255.0249900003 | 37.7738045540059 | -122.47668691568899 | (37.7738045540059, -122.476686915689) | ||
| 111180 | 111180 | 89059 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 746 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990397.15719 | 2110267.75159 | 37.7738396174891 | -122.476680705622 | (37.7738396174891, -122.476680705622) | ||
| 103093 | 103093 | 89057 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 768 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990399.549819999 | 2110162.4742900003 | 37.773550693633 | -122.47666473627899 | (37.773550693633, -122.476664736279) | ||
| 86108 | 86108 | 89056 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 774 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990401.329059999 | 2110113.1437 | 37.7734153485371 | -122.476654976983 | (37.7734153485371, -122.476654976983) | ||
| 101833 | 101833 | 89054 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.14743 | 2110052.29751 | 37.773248445022 | -122.476640781805 | (37.773248445022, -122.476640781805) | ||
| 83665 | 83665 | 89055 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.298780001 | 2110035.18225 | 37.773201459979404 | -122.476639007633 | (37.7732014599794, -122.476639007633) | ||
| 109199 | 109199 | 122009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2629 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990447.70869 | 2111948.34575 | 37.77845699894 | -122.476628645569 | (37.77845699894, -122.476628645569) | |||
| 70774 | 70774 | 31727 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) |
| 131574 | 131574 | 31728 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) |
| 116013 | 116013 | 89430 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2626 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990477.756159999 | 2112004.06486 | 37.778611730986206 | -122.476528772678 | (37.7786117309862, -122.476528772678) | ||
| 125089 | 125089 | 89673 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2605 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990503.983109999 | 2111947.71017 | 37.77845851765821 | -122.476433926742 | (37.7784585176582, -122.476433926742) | ||
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 19126 | 19126 | 89429 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2608 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990547.63767 | 2112005.7823900003 | 37.778620499636 | -122.476287153711 | (37.778620499636, -122.476287153711) | ||
| 92557 | 92557 | 89674 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2605 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990556.82661 | 2111951.2036599996 | 37.77847117438171 | -122.476251378309 | (37.7784711743817, -122.476251378309) | ||
| 184877 | 184877 | 31769 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990271.0654 | 2098396.6732 | 37.7412374811669 | -122.476249599037 | (37.7412374811669, -122.476249599037) | ||
| 91285 | 91285 | 89428 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990570.85 | 2112008.13119 | 37.778628294884896 | -122.47620702578001 | (37.7786282948849, -122.47620702578) | ||
| 76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 127523 | 127523 | 89427 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2550 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990691.39312 | 2112012.68258 | 37.7786477812116 | -122.47579035750799 | (37.7786477812116, -122.475790357508) | ||
| 83785 | 83785 | 89426 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2550X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990714.583219999 | 2112013.9673599997 | 37.7786526533285 | -122.475710228678 | (37.7786526533285, -122.475710228678) | ||
| 176799 | 176799 | 182968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5990431.4773 | 2098333.0499 | 37.7410720891089 | -122.475690312642 | (37.7410720891089, -122.475690312642) | |||
| 120563 | 120563 | 34888 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 252 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774542 | 5990895.02345 | 2113704.92636 | 37.7833060185493 | -122.475209503253 | (37.7833060185493, -122.475209503253) | |
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | |||
| 49816 | 49816 | 207050 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | |||
| 77081 | 77081 | 207086 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2167 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990677.28316 | 2100628.1103 | 37.747387978366106 | -122.475007906598 | (37.7473879783661, -122.475007906598) | |||
| 59281 | 59281 | 54994 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.2702900004 | 37.77519937131321 | -122.47479813592301 | (37.7751993713132, -122.474798135923) | ||
| 116787 | 116787 | 89682 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5990978.9280199995 | 2111966.0770799997 | 37.7785364815441 | -122.474792270832 | (37.7785364815441, -122.474792270832) | ||
| 121725 | 121725 | 89425 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2444 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990997.351480001 | 2112022.54755 | 37.7786926015029 | -122.474732660414 | (37.7786926015029, -122.474732660414) | ||
| 120327 | 120327 | 89424 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2444 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991014.1073900005 | 2112022.9035099996 | 37.778694549794295 | -122.47467472179501 | (37.7786945497943, -122.474674721795) | ||
| 138679 | 138679 | 89683 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991013.77238 | 2111967.7388400002 | 37.778543063369604 | -122.474671853461 | (37.7785430633696, -122.474671853461) | ||
| 106957 | 106957 | 89684 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991029.88573 | 2111967.95192 | 37.778544582090504 | -122.47461612736299 | (37.7785445820905, -122.474616127363) | ||
| 111793 | 111793 | 93854 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875.0 | 2103807.0 | 37.7561278331456 | -122.47455618324601 | (37.7561278331456, -122.474556183246) | ||
| 89037 | 89037 | 89685 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991052.102419999 | 2111967.85185 | 37.7785455945924 | -122.47453926483699 | (37.7785455945924, -122.474539264837) | ||
| 115246 | 115246 | 89686 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2435 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991074.90155 | 2111969.0301099997 | 37.7785501507324 | -122.474460480761 | (37.7785501507324, -122.474460480761) | ||
| 110944 | 110944 | 89687 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991137.52605 | 2111970.73345 | 37.778558455774295 | -122.474243965231 | (37.7785584557743, -122.474243965231) | ||
| 116257 | 116257 | 89423 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991174.61875 | 2112030.16247 | 37.778723780309996 | -122.474119986052 | (37.77872378031, -122.474119986052) | ||
| 140061 | 140061 | 89688 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991173.67465 | 2111973.9047 | 37.7785692572369 | -122.474119146124 | (37.7785692572369, -122.474119146124) | ||
| 141554 | 141554 | 89689 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991196.08416 | 2111975.00544 | 37.7785735776786 | -122.47404170417101 | (37.7785735776786, -122.474041704171) | ||
| 142751 | 142751 | 89422 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2400X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991198.491359999 | 2112030.01361 | 37.7787247544447 | -122.474037391358 | (37.7787247544447, -122.474037391358) | ||
| 63865 | 63865 | 98154 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | Permit Number 768787 | 5991271.26635 | 2112266.2977400003 | 37.779377741026394 | -122.473802878969 | (37.7793777410264, -122.473802878969) | ||
| 164481 | 164481 | 31363 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2295 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 2 | Permit Number 34969 | 5991013.007780001 | 2099881.4668 | 37.7453573397732 | -122.47379254479799 | (37.7453573397732, -122.473792544798) | ||
| 100674 | 100674 | 98153 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258.0 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | |||
| 139838 | 139838 | 89690 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2351 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991335.21973 | 2111978.62727 | 37.7785915807726 | -122.473560650038 | (37.7785915807726, -122.473560650038) | ||
| 76395 | 76395 | 89691 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2351 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991367.10083 | 2111979.26618 | 37.7785951812776 | -122.47345040879401 | (37.7785951812776, -122.473450408794) | ||
| 95620 | 95620 | 89692 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2337 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991391.91305 | 2111981.89017 | 37.7786038228381 | -122.47336476609101 | (37.7786038228381, -122.473364766091) | ||
| 140359 | 140359 | 89421 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991477.6623 | 2112038.61858 | 37.778764548514 | -122.47307226747 | (37.778764548514, -122.47307226747) | ||
| 95844 | 95844 | 89420 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991511.6539 | 2112041.01499 | 37.7787730963608 | -122.47295485316499 | (37.7787730963608, -122.472954853165) | ||
| 147671 | 147671 | 207068 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 539 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991225.79939 | 2097692.69128 | 37.739359846476205 | -122.472897178881 | (37.7393598464762, -122.472897178881) | |||
| 88920 | 88920 | 89419 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991532.05809 | 2112041.47431 | 37.778775538782796 | -122.472884301267 | (37.7787755387828, -122.472884301267) | ||
| 175198 | 175198 | 207091 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 520 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991320.331130001 | 2097065.30066 | 37.7376426638631 | -122.47252460501998 | (37.7376426638631, -122.47252460502) | |||
| 170832 | 170832 | 207092 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991411.795390001 | 2097355.25398 | 37.738444095618 | -122.4722295024 | (37.738444095618, -122.4722295024) | |||
| 59171 | 59171 | 207090 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991605.432 | 2098443.60055 | 37.741443622419894 | -122.47163929621 | (37.7414436224199, -122.47163929621) | |||
| 59463 | 59463 | 207089 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991620.77866 | 2098444.2951599997 | 37.7414464175195 | -122.471586283874 | (37.7414464175195, -122.471586283874) | |||
| 164375 | 164375 | 207088 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991634.58199 | 2098444.51298 | 37.7414478141662 | -122.47153857305 | (37.7414478141662, -122.47153857305) | |||
| 62582 | 62582 | 207087 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991668.56365 | 2098444.306 | 37.7414492117217 | -122.471421062245 | (37.7414492117217, -122.471421062245) | |||
| 156929 | 156929 | 217749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 445 West Portal Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991783.05973 | 2096405.3403 | 37.7358573522267 | -122.470876685538 | (37.7358573522267, -122.470876685538) | |||
| 168739 | 168739 | 207051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992092.816880001 | 2106815.43538 | 37.764458690039 | -122.47056370526899 | (37.764458690039, -122.470563705269) | |||
| 138266 | 138266 | 109806 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.47047998805401 | (37.764483341532, -122.470479988054) |
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");