Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3230 | 3230 | 1713 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085005 | -122.40074798855 | (37.796643729085, -122.40074798855) | |||
| 3485 | 3485 | 1714 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.796550687018204 | -122.400732648813 | (37.7965506870182, -122.400732648813) | |||
| 7931 | 7931 | 1715 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x6 | 6012518.40757 | 2118034.67495 | 37.796424046287996 | -122.400704977573 | (37.796424046288, -122.400704977573) | |||
| 7985 | 7985 | 1718 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 9x6 | 6012538.2564900005 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | |||
| 138646 | 138646 | 4517 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 87087 | 87087 | 4518 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 97837 | 97837 | 4519 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2015 11:31:00 AM | 12 | 3x3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | ||
| 77532 | 77532 | 4538 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 99626 | 99626 | 4541 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 121552 | 121552 | 4543 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 61696 | 61696 | 4545 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 122987 | 122987 | 4550 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | |||
| 144085 | 144085 | 4551 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1991 12:00:00 AM | 24 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | ||
| 7797 | 7797 | 6925 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 460 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005200.4571 | 2110629.3361 | 37.7756799587692 | -122.42549938705099 | (37.7756799587692, -122.425499387051) | |||
| 96001 | 96001 | 7147 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003730.753719999 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | |||
| 16227 | 16227 | 7404 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1060 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 24 | 3X3 | 6010543.2443 | 2111181.3457 | 37.777496075538004 | -122.407056190657 | (37.777496075538, -122.407056190657) | ||
| 23013 | 23013 | 15425 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6006866.3108 | 2106096.3931 | 37.7633275539022 | -122.41941512219401 | (37.7633275539022, -122.419415122194) | |||
| 18345 | 18345 | 16909 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 457 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2009 12:00:00 AM | 18 | 3X3 | 6004854.34153 | 2110178.37501 | 37.7744221674765 | -122.42666456674101 | (37.7744221674765, -122.426664566741) | ||
| 69 | 69 | 19206 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.40169859442699 | (37.7962500076802, -122.401698594427) | |||
| 3315 | 3315 | 20250 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1880 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6002537.9918 | 2114673.3066 | 37.78663289034311 | -122.43499878671301 | (37.7866328903431, -122.434998786713) | |||
| 17457 | 17457 | 25179 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999420.685330001 | 2104753.2461200003 | 37.7592174321694 | -122.445070446966 | (37.7592174321694, -122.445070446966) | ||
| 17244 | 17244 | 25180 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999422.34121 | 2104738.79635 | 37.7591778511874 | -122.445063681349 | (37.7591778511874, -122.445063681349) | ||
| 20331 | 20331 | 25181 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999423.66493 | 2104708.37976 | 37.7590944103092 | -122.44505691664101 | (37.7590944103092, -122.445056916641) | ||
| 22166 | 22166 | 25182 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 3 | 3X3 | 5999429.9273 | 2104670.84771 | 37.7589917140099 | -122.4450325603 | (37.7589917140099, -122.4450325603) | ||
| 118583 | 118583 | 26205 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 750 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/20/2007 12:00:00 AM | 12 | 3X3 | 6005640.0872799 | 2098758.1364942 | 37.743109258996206 | -122.423134597972 | (37.7431092589962, -122.423134597972) | ||
| 2850 | 2850 | 27607 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001133.4058 | 2111053.0447 | 37.7766127217509 | -122.439598674592 | (37.7766127217509, -122.439598674592) | |||
| 6797 | 6797 | 27608 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001149.4313 | 2111053.53 | 37.776614966343296 | -122.439543272646 | (37.7766149663433, -122.439543272646) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 89255 | 89255 | 89080 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 498X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990331.33174 | 2112032.1373799997 | 37.7786803168555 | -122.477037357467 | (37.7786803168555, -122.477037357467) | ||
| 109044 | 109044 | 89081 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 482 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990329.59035 | 2112107.51338 | 37.778887177480705 | -122.477048890931 | (37.7788871774807, -122.477048890931) | ||
| 138916 | 138916 | 89082 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990324.88294 | 2112207.2474 | 37.7791607464072 | -122.477072465426 | (37.7791607464072, -122.477072465426) | ||
| 121223 | 121223 | 89083 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 434 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990318.24185 | 2112394.83116 | 37.779675414185704 | -122.477109150816 | (37.7796754141857, -122.477109150816) | ||
| 99099 | 99099 | 89084 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 430 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990316.3630800005 | 2112431.39135 | 37.7797756893394 | -122.477118322615 | (37.7797756893394, -122.477118322615) | ||
| 92272 | 92272 | 89085 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 410 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990312.707669999 | 2112537.21644 | 37.78006604363139 | -122.477138703582 | (37.7800660436314, -122.477138703582) | ||
| 82382 | 82382 | 89086 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 406 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990312.19916 | 2112568.90758 | 37.780153029212705 | -122.47714277925199 | (37.7801530292127, -122.477142779252) | ||
| 113805 | 113805 | 89087 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 401 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990264.81657 | 2112592.30835 | 37.780214532141706 | -122.477308406147 | (37.7802145321417, -122.477308406147) | ||
| 106037 | 106037 | 89088 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 401 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990265.0064900005 | 2112569.67776 | 37.780152405839 | -122.477306094769 | (37.780152405839, -122.477306094769) | ||
| 122678 | 122678 | 89089 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 409 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990266.49746 | 2112545.35592 | 37.78008571132089 | -122.477299158886 | (37.7800857113209, -122.477299158886) | ||
| 128881 | 128881 | 89090 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 411 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990267.41171 | 2112525.37211 | 37.780030894366895 | -122.477294535249 | (37.7800308943669, -122.477294535249) | ||
| 110683 | 110683 | 89091 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 467 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990279.30017 | 2112189.56022 | 37.7791095377355 | -122.4772288603 | (37.7791095377355, -122.4772288603) | ||
| 119218 | 119218 | 89092 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 483 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990282.36221 | 2112092.5227900003 | 37.778843277465796 | -122.477211174284 | (37.7788432774658, -122.477211174284) | ||
| 87859 | 87859 | 89093 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990291.48047 | 2111913.4147099997 | 37.7783520252361 | -122.477166538778 | (37.7783520252361, -122.477166538778) | ||
| 107023 | 107023 | 89094 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 543 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990300.0620099995 | 2111662.7982900003 | 37.777664399650604 | -122.477118533728 | (37.7776643996506, -122.477118533728) | ||
| 85766 | 85766 | 89095 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 547 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990300.3364699995 | 2111641.2158 | 37.7776051560139 | -122.477116006748 | (37.7776051560139, -122.477116006748) | ||
| 100752 | 100752 | 89096 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 551 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990302.22714 | 2111615.47744 | 37.7775345952701 | -122.47710758505501 | (37.7775345952701, -122.477107585055) | ||
| 120732 | 120732 | 89098 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 567 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990305.127830001 | 2111522.32055 | 37.7772789804391 | -122.477090741641 | (37.7772789804391, -122.477090741641) | ||
| 118373 | 118373 | 89099 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 583 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990307.45252 | 2111413.41703 | 37.776980096273 | -122.477074739943 | (37.776980096273, -122.477074739943) | ||
| 114490 | 114490 | 89100 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990315.52162 | 2111207.6584 | 37.7764156078929 | -122.47703178789499 | (37.7764156078929, -122.477031787895) | ||
| 103217 | 103217 | 89101 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 617 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990317.59695 | 2111167.61171 | 37.7763057711064 | -122.477021681856 | (37.7763057711064, -122.477021681856) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 78569 | 78569 | 89433 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2750X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990101.1887300005 | 2111991.79472 | 37.7785561929756 | -122.477830552774 | (37.7785561929756, -122.477830552774) | ||
| 144383 | 144383 | 89434 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2750X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990083.37165 | 2111991.81654 | 37.7785552188238 | -122.47789218978001 | (37.7785552188238, -122.47789218978) | ||
| 85475 | 85475 | 89435 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2750X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990064.10708 | 2111990.80436 | 37.7785513215492 | -122.477958758538 | (37.7785513215492, -122.477958758538) |
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");