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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8468 | 8468 | 18164 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005185.0654 | 2114447.3865 | 37.78616251551679 | -122.42582445934299 | (37.7861625155168, -122.425824459343) | |||
5899 | 5899 | 18165 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005168.5828 | 2114444.09 | 37.786152532687105 | -122.42588125009199 | (37.7861525326871, -122.425881250092) | |||
5968 | 5968 | 18166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005153.199 | 2114441.8923 | 37.786145628959204 | -122.42593431751101 | (37.7861456289592, -122.425934317511) | |||
6323 | 6323 | 18167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005136.7165 | 2114437.497 | 37.7861326290509 | -122.425991029638 | (37.7861326290509, -122.425991029638) | |||
106174 | 106174 | 19140 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003499.5609963 | 2108090.4356538 | 37.76861251084271 | -122.43120194209 | (37.7686125108427, -122.43120194209) | |||
90522 | 90522 | 19141 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003499.5609963 | 2108090.4356538 | 37.76861251084271 | -122.43120194209 | (37.7686125108427, -122.43120194209) | |||
21559 | 21559 | 19144 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003508.29583 | 2108036.92775 | 37.768466086156394 | -122.431167909289 | (37.7684660861564, -122.431167909289) | |||
146177 | 146177 | 19145 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003500.9045907995 | 2108066.1860563997 | 37.76854600349329 | -122.431195563592 | (37.7685460034933, -122.431195563592) | |||
87847 | 87847 | 19146 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003500.9045907995 | 2108066.1860563997 | 37.76854600349329 | -122.431195563592 | (37.7685460034933, -122.431195563592) | |||
108719 | 108719 | 19149 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 49 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003514.43662 | 2108031.11939 | 37.7684504857975 | -122.431146254215 | (37.7684504857975, -122.431146254215) | |||
7231 | 7231 | 19588 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
12970 | 12970 | 19589 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
6803 | 6803 | 19590 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7407 | 7407 | 19591 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
16521 | 16521 | 19806 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
112719 | 112719 | 21073 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
115970 | 115970 | 21074 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
140920 | 140920 | 21075 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
114646 | 114646 | 21898 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
139049 | 139049 | 21899 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
82063 | 82063 | 21900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
5931 | 5931 | 22784 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1880 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001016.5841 | 2112130.2222 | 37.7795637284835 | -122.440080052813 | (37.7795637284835, -122.440080052813) | |||
8325 | 8325 | 23708 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6003978.3577 | 2111349.4443 | 37.77758807209621 | -122.429778304865 | (37.7775880720962, -122.429778304865) | ||||
2297 | 2297 | 23709 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 20 | 6003970.4427 | 2111382.6873 | 37.7776789009548 | -122.429808057223 | (37.7776789009548, -122.429808057223) | |||
6398 | 6398 | 23727 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003949.8401 | 2111575.542 | 37.7782072655707 | -122.429893088415 | (37.7782072655707, -122.429893088415) | ||
890 | 890 | 23729 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.42991768322901 | (37.7783296231018, -122.429917683229) | ||
6262 | 6262 | 23731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6003929.9014 | 2111682.7982 | 37.7785006353915 | -122.429969716521 | (37.7785006353915, -122.429969716521) | |||
7325 | 7325 | 23732 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6003928.5263 | 2111708.2372 | 37.7785704067109 | -122.429976288631 | (37.7785704067109, -122.429976288631) | |||
125018 | 125018 | 23756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003937.3073429 | 2111811.4900601003 | 37.7788544107823 | -122.42995327885001 | (37.7788544107823, -122.42995327885) | |||
1958 | 1958 | 23757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003900.3372 | 2111922.0621 | 37.7791559204238 | -122.43008906318701 | (37.7791559204238, -122.430089063187) | |||
2284 | 2284 | 23758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003894.1493 | 2111953.6889 | 37.7792424093118 | -122.43011272647199 | (37.7792424093118, -122.430112726472) | |||
8475 | 8475 | 23759 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003889.3366 | 2111985.3157 | 37.7793289760816 | -122.430131632423 | (37.7793289760816, -122.430131632423) | |||
8513 | 8513 | 23760 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003885.2113 | 2112011.4423 | 37.7794004795956 | -122.430147767922 | (37.7794004795956, -122.430147767922) | |||
6949 | 6949 | 23761 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003883.1487 | 2112042.3815 | 37.7794853141392 | -122.430157111124 | (37.7794853141392, -122.430157111124) | |||
1722 | 1722 | 23787 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003801.3315 | 2112607.883 | 37.781033406276705 | -122.430480512141 | (37.7810334062767, -122.430480512141) | ||
7642 | 7642 | 23788 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003799.2688 | 2112646.3852 | 37.7811390068769 | -122.43049039607 | (37.7811390068769, -122.43049039607) | |||
223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
2139 | 2139 | 23790 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003786.8931 | 2112715.8268 | 37.7813289751352 | -122.43053816621901 | (37.7813289751352, -122.430538166219) | |||
5279 | 5279 | 23791 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 6003783.4554 | 2112735.7654 | 37.7813835268154 | -122.430551482109 | (37.7813835268154, -122.430551482109) | |||
6800 | 6800 | 23823 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003765.5794 | 2112902.15 | 37.781839364726 | -122.430625200646 | (37.781839364726, -122.430625200646) | |||
8699 | 8699 | 23824 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003763.5168 | 2112936.527 | 37.78193363853529 | -122.430634790088 | (37.7819336385353, -122.430634790088) | |||
3859 | 3859 | 23825 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003756.6414 | 2112968.1539 | 37.782020088596504 | -122.43066083333599 | (37.7820200885965, -122.430660833336) | |||
7386 | 7386 | 23826 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003751.8286 | 2113008.0312 | 37.78212930904171 | -122.43068032991002 | (37.7821293090417, -122.43068032991) | |||
5117 | 5117 | 23827 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003747.0158 | 2113043.0957 | 37.7822253147353 | -122.430699482992 | (37.7822253147353, -122.430699482992) | |||
6075 | 6075 | 23828 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003742.203 | 2113074.035 | 37.78230999365589 | -122.430718341656 | (37.7823099936559, -122.430718341656) | |||
7438 | 7438 | 23859 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003649.3852 | 2113669.4444 | 37.783939579713504 | -122.431081960003 | (37.7839395797135, -122.431081960003) | |||
139971 | 139971 | 23878 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1500X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 4 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.43111521625299 | (37.7845850728987, -122.431115216253) | |||
94348 | 94348 | 23879 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1500X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 4 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.43111521625299 | (37.7845850728987, -122.431115216253) | |||
8006 | 8006 | 23900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6 | 6003566.3311 | 2114312.7691 | 37.7857012808729 | -122.43141523648701 | (37.7857012808729, -122.431415236487) | |||
7311 | 7311 | 23920 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x12 | 6003521.972999999 | 2114612.7568 | 37.786522457310205 | -122.43159012740699 | (37.7865224573102, -122.431590127407) | |||
1473 | 1473 | 23922 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 12x1 | 6003506.5026 | 2114704.4246 | 37.786773277055204 | -122.431650198179 | (37.7867732770552, -122.431650198179) | ||
125350 | 125350 | 23923 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12x1 | 6003454.884490401 | 2114845.825423 | 37.7871586020093 | -122.43183888463899 | (37.7871586020093, -122.431838884639) | |||
7162 | 7162 | 23924 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x1 | 6003487.1069 | 2114786.6255 | 37.7869978805436 | -122.43172317383998 | (37.7869978805436, -122.43172317384) | |||
116982 | 116982 | 23926 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12x1 | 6003454.884490401 | 2114845.825423 | 37.7871586020093 | -122.43183888463899 | (37.7871586020093, -122.431838884639) | |||
141952 | 141952 | 26685 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/27/1999 12:00:00 AM | 20 | 3 | 6009783.7006387 | 2119558.1544154 | 37.800454241984404 | -122.41027530758998 | (37.8004542419844, -122.41027530759) | ||
22571 | 22571 | 26752 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005515.49515 | 2114435.63395 | 37.7861489132884 | -122.424680422175 | (37.7861489132884, -122.424680422175) | |||
22416 | 22416 | 26753 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005527.1532 | 2114438.07435 | 37.7861562724304 | -122.424640262031 | (37.7861562724304, -122.424640262031) | |||
22634 | 22634 | 26754 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005539.86656 | 2114440.61457 | 37.7861639652384 | -122.424596457885 | (37.7861639652384, -122.424596457885) | |||
22804 | 22804 | 26755 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005555.38127 | 2114442.5721400003 | 37.7861702164197 | -122.424542920326 | (37.7861702164197, -122.424542920326) | |||
22378 | 22378 | 26756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005569.26951 | 2114444.1495 | 37.7861753317646 | -122.424494982868 | (37.7861753317646, -122.424494982868) | |||
22794 | 22794 | 26757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005593.49204 | 2114448.7926 | 37.786189448429205 | -122.42441150958099 | (37.7861894484292, -122.424411509581) | |||
140171 | 140171 | 26758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.786134771520096 | -122.42479560486 | (37.7861347715201, -122.42479560486) | |||
82308 | 82308 | 26759 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.786134771520096 | -122.42479560486 | (37.7861347715201, -122.42479560486) | |||
80959 | 80959 | 27484 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2509 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009754.968576999 | 2102712.0209772997 | 37.754197106715296 | -122.40918532566099 | (37.7541971067153, -122.409185325661) | |||
19343 | 19343 | 28266 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 702 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2002 12:00:00 AM | 12 | 3x3 | 6002735.2568 | 2109243.2194 | 37.7717344296193 | -122.43392801598301 | (37.7717344296193, -122.433928015983) | ||
82790 | 82790 | 28267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
82286 | 82286 | 28268 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
142691 | 142691 | 28269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
117723 | 117723 | 28270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
7873 | 7873 | 28650 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003539.955 | 2114426.6147 | 37.786012377283896 | -122.431514620567 | (37.7860123772839, -122.431514620567) | |||
80400 | 80400 | 28651 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
14038 | 14038 | 28925 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 275 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009577.301419999 | 2110415.03402 | 37.7753378616805 | -122.410343600988 | (37.7753378616805, -122.410343600988) | ||
13622 | 13622 | 28926 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 275 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 6009566.071769999 | 2110427.96033 | 37.775372724794394 | -122.41038336002501 | (37.7753727247944, -122.410383360025) | ||
15497 | 15497 | 28927 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 267 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009498.76471 | 2110500.15224 | 37.775567173522894 | -122.41062129096201 | (37.7755671735229, -122.410621290962) | ||
19955 | 19955 | 29580 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991386.6913 | 2093344.7747799999 | 37.7274308773069 | -122.47202406848 | (37.7274308773069, -122.47202406848) | ||
19813 | 19813 | 29581 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991390.5187800005 | 2093368.54568 | 37.7274963677541 | -122.47201256884199 | (37.7274963677541, -122.472012568842) | ||
140520 | 140520 | 29589 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991336.987432401 | 2093443.9543843998 | 37.7277003234109 | -122.472203119704 | (37.7277003234109, -122.472203119704) | ||
144121 | 144121 | 29639 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
109022 | 109022 | 29640 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
110556 | 110556 | 29641 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
91557 | 91557 | 29978 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658001 | (37.7277012826104, -122.47220652658) | ||
101082 | 101082 | 29979 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658001 | (37.7277012826104, -122.47220652658) | ||
105889 | 105889 | 30047 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
105098 | 105098 | 30048 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
146267 | 146267 | 30049 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
146864 | 146864 | 30369 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1632 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1974 12:00:00 AM | 14 | Permit Number 14152 | 6013068.70069 | 2104759.9070200003 | 37.7600052436607 | -122.39786918403999 | (37.7600052436607, -122.39786918404) | ||
122115 | 122115 | 30568 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2681 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34545 | 6008703.52928477 | 2122408.3500681 | 37.8082195561589 | -122.41421491247101 | (37.8082195561589, -122.414214912471) | ||||
46897 | 46897 | 30588 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 109 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34558 | 6003337.11539 | 2108646.4783400004 | 37.770130061294104 | -122.431803534827 | (37.7701300612941, -122.431803534827) | ||
175774 | 175774 | 31530 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35085 | 6011132.9028199995 | 2101918.55735 | 37.7520955300081 | -122.404364216429 | (37.7520955300081, -122.404364216429) | |
75081 | 75081 | 31663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 154 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35171 | 6007340.50387 | 2096742.6904 | 37.7376711031279 | -122.41711221886699 | (37.7376711031279, -122.417112218867) | |
42659 | 42659 | 31690 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 720 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35194 | 5997967.7593 | 2107982.3411 | 37.7680006769011 | -122.45032811149599 | (37.7680006769011, -122.450328111496) | |
168492 | 168492 | 31705 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 456 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35207 | 5997530.3227 | 2107475.8595 | 37.766584963572996 | -122.45180460716401 | (37.766584963573, -122.451804607164) | |
176674 | 176674 | 31878 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3740 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35316 | 5996936.65811 | 2115356.47325 | 37.7881890469296 | -122.454427304671 | (37.7881890469296, -122.454427304671) | ||
50522 | 50522 | 31991 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 215 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35392 | 5994587.26751 | 2113998.16217 | 37.784324475145795 | -122.462457175798 | (37.7843244751458, -122.462457175798) | |
86218 | 86218 | 32079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3815 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35452 | 6004163.50427612 | 2105375.78416509 | 37.7611963327896 | -122.428711873399 | (37.7611963327896, -122.428711873399) | ||
89931 | 89931 | 32122 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 63 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35484 | 6003895.54546298 | 2106786.63464469 | 37.7650550206105 | -122.429739259442 | (37.7650550206105, -122.429739259442) | ||
64269 | 64269 | 32204 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1639 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 15 | Permit Number 35527 | 6009324.38057 | 2099913.56366 | 37.7464890331489 | -122.41047681846202 | (37.7464890331489, -122.410476818462) | |
85929 | 85929 | 32216 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 519 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | Permit Number 35537 | 6009462.41872105 | 2100262.21191199 | 37.747454081953 | -122.410024104812 | (37.747454081953, -122.410024104812) | ||
164190 | 164190 | 32221 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 615 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 11 | Permit Number 35542 | 6009696.62224 | 2100374.01527 | 37.7477741931343 | -122.409222129314 | (37.7477741931343, -122.409222129314) | |
153154 | 153154 | 32482 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 89 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 7 | 3x3 | Permit Number 36990 | 6000124.50964 | 2105955.15278 | 37.762557717473896 | -122.442722593195 | (37.7625577174739, -122.442722593195) |
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");