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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170938 | 170938 | 138862 | Undocumented 2 | :: 54 | 700 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003135.5469 | 2110682.6881 | 37.775709563203 | -122.43264622938 | (37.775709563203, -122.43264622938) | |||
87071 | 87071 | 115068 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
98812 | 98812 | 115061 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
106237 | 106237 | 115066 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
110696 | 110696 | 115065 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
113187 | 113187 | 115067 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
117492 | 117492 | 115069 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
120235 | 120235 | 115062 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
144770 | 144770 | 115064 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
146223 | 146223 | 115063 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
37254 | 37254 | 140262 | Undocumented 2 | :: 54 | 70 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997786.9682 | 2110316.587 | 37.7743995682404 | -122.451121798449 | (37.7743995682404, -122.451121798449) | |||
130182 | 130182 | 139584 | Undocumented 2 | :: 54 | 7 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000723.8996 | 2112182.6238 | 37.7796909432582 | -122.441096331817 | (37.7796909432582, -122.441096331817) | |||
41104 | 41104 | 140367 | Undocumented 2 | :: 54 | 690 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004237.6574 | 2113081.116 | 37.782357493618605 | -122.429004794114 | (37.7823574936186, -122.429004794114) | |||
159432 | 159432 | 138887 | Undocumented 2 | :: 54 | 679 LINDEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004146.8152 | 2110617.8324 | 37.77558878373161 | -122.42914337499501 | (37.7755887837316, -122.429143374995) | |||
85490 | 85490 | 52296 | Permitted Site 1 | :: 54 | 677DIAMOND ST Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48457 | 6002165.96993722 | 2099704.44459938 | 37.7455109340163 | -122.435214819168 | (37.7455109340163, -122.435214819168) | ||
156518 | 156518 | 138888 | Undocumented 2 | :: 54 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | |||
116859 | 116859 | 45263 | Permitted Site 1 | :: 54 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | ||
102661 | 102661 | 117259 | Permitted Site 1 | :: 54 | 670 Eddy St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6007197.5 | 2113350.2 | 37.7832634280904 | -122.418784110751 | (37.7832634280904, -122.418784110751) | ||||
51812 | 51812 | 140046 | Undocumented 2 | :: 54 | 666 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005395.2334 | 2111605.7927 | 37.7783720737797 | -122.424895092854 | (37.7783720737797, -122.424895092854) | |||
5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
43147 | 43147 | 138988 | Undocumented 2 | :: 54 | 661 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003478.1301 | 2110687.6732 | 37.775742673405205 | -122.43146150530701 | (37.7757426734052, -122.431461505307) | |||
71705 | 71705 | 138962 | Undocumented 2 | :: 54 | 659 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004224.8748 | 2110974.4556 | 37.7765724019201 | -122.42889877832899 | (37.7765724019201, -122.428898778329) | |||
181992 | 181992 | 138928 | Undocumented 2 | :: 54 | 658 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004198.4672 | 2110994.6791 | 37.7766264359363 | -122.428991572071 | (37.7766264359363, -122.428991572071) | |||
5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
68816 | 68816 | 140401 | Undocumented 2 | :: 54 | 650 WILLOW ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004290.5512 | 2113088.0425 | 37.7823795059387 | -122.428822298842 | (37.7823795059387, -122.428822298842) | |||
172823 | 172823 | 140400 | Undocumented 2 | :: 54 | 650 WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004364.2248 | 2113098.7472 | 37.782413067955495 | -122.428568183869 | (37.7824130679555, -122.428568183869) | |||
105108 | 105108 | 104859 | Permitted Site 1 | :: 54 | 650 Fillmore St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.43103844044701 | (37.775386259915, -122.431038440447) | ||||||
128256 | 128256 | 37520 | Permitted Site 1 | :: 54 | 649 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39973 | 6008796.59183246 | 2114756.17350418 | 37.787213798801396 | -122.41335133309099 | (37.7872137988014, -122.413351333091) | ||
80004 | 80004 | 35095 | Permitted Site 1 | :: 54 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.718911055862606 | -122.43365900206499 | (37.7189110558626, -122.433659002065) | ||
69253 | 69253 | 217580 | Undocumented 2 | :: 54 | 646 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5992252.7325 | 2088559.8349 | 37.714342679649 | -122.468682167409 | (37.714342679649, -122.468682167409) | |||
91751 | 91751 | 121132 | Undocumented 2 | :: 54 | 645 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002309.0 | 2100005.0 | 37.7463443097186 | -122.434741732797 | (37.7463443097186, -122.434741732797) | |||
162078 | 162078 | 143072 | Undocumented 2 | :: 54 | 644 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009782.3270000005 | 2120221.5354 | 37.8022756451991 | -122.410326926401 | (37.8022756451991, -122.410326926401) | |||
36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
50533 | 50533 | 247288 | Undocumented 2 | :: 54 | 638 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997017.3270000005 | 2108860.304 | 37.770356897849105 | -122.453678939083 | (37.7703568978491, -122.453678939083) | |||
52776 | 52776 | 247289 | Undocumented 2 | :: 54 | 636 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997016.0452 | 2108877.8212 | 37.7704049220759 | -122.45368463790199 | (37.7704049220759, -122.453684637902) | |||
74231 | 74231 | 246137 | Undocumented 2 | :: 54 | 636 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5997583.3178 | 2108295.6178 | 37.7688388454445 | -122.451680446787 | (37.7688388454445, -122.451680446787) | |||
57505 | 57505 | 142224 | Undocumented 2 | :: 54 | 633 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004805.4597 | 2110871.2494 | 37.7763218676751 | -122.426883014235 | (37.7763218676751, -122.426883014235) | |||
183282 | 183282 | 138897 | Undocumented 2 | :: 54 | 620 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004450.0046 | 2110683.2919 | 37.7757856778871 | -122.428099234722 | (37.7757856778871, -122.428099234722) | |||
54627 | 54627 | 36527 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
123158 | 123158 | 36526 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
143390 | 143390 | 36528 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
93044 | 93044 | 118345 | Undocumented 2 | :: 54 | 619 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5985338.0 | 2111651.0 | 37.777342876553895 | -122.494282873873 | (37.7773428765539, -122.494282873873) | ||||
57686 | 57686 | 137730 | Undocumented 2 | :: 54 | 618 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000121.5934 | 2111015.3224 | 37.7764515064845 | -122.443096107731 | (37.7764515064845, -122.443096107731) | |||
179274 | 179274 | 137729 | Undocumented 2 | :: 54 | 618 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000125.9929 | 2110987.9102 | 37.7763764904093 | -122.443078919527 | (37.7763764904093, -122.443078919527) | |||
166008 | 166008 | 140222 | Undocumented 2 | :: 54 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003683.3616 | 2110416.1551 | 37.7750087812949 | -122.43073217817499 | (37.7750087812949, -122.430732178175) | |||
51515 | 51515 | 120669 | Undocumented 2 | :: 54 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974.0 | 2096001.0 | 37.7352743855737 | -122.43907108078899 | (37.7352743855737, -122.439071080789) | ||
5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
88984 | 88984 | 109756 | Permitted Site 1 | :: 54 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
118010 | 118010 | 109755 | Permitted Site 1 | :: 54 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
121197 | 121197 | 109754 | Permitted Site 1 | :: 54 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
109418 | 109418 | 119124 | Undocumented 2 | :: 54 | 601 46th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.50718822030198 | (37.7768923962204, -122.507188220302) | ||||
46286 | 46286 | 138648 | Undocumented 2 | :: 54 | 600 PRESIDIO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999215.949 | 2114570.5132 | 37.786161460452796 | -122.446484808381 | (37.7861614604528, -122.446484808381) | |||
165689 | 165689 | 140263 | Undocumented 2 | :: 54 | 60 Cole St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997782.8203 | 2110340.7836 | 37.7744657683679 | -122.451137892048 | (37.7744657683679, -122.451137892048) | |||
24662 | 24662 | 124715 | Undocumented 2 | :: 54 | 599X 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002687.0 | 2100013.0 | 37.7463877287793 | -122.433435226166 | (37.7463877287793, -122.433435226166) | ||||
33830 | 33830 | 244279 | Undocumented 2 | :: 54 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004230.7823 | 2110095.8419999997 | 37.7741602789386 | -122.42881569121799 | (37.7741602789386, -122.428815691218) | |||
127642 | 127642 | 36507 | Permitted Site 1 | :: 54 | 584 Anderson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) | ||
33727 | 33727 | 140005 | Undocumented 2 | :: 54 | 580 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005138.6408 | 2111659.5949 | 37.7785053047816 | -122.425786573599 | (37.7785053047816, -122.425786573599) | |||
103132 | 103132 | 113996 | Undocumented 2 | :: 54 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
108795 | 108795 | 113997 | Undocumented 2 | :: 54 | 58 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
145300 | 145300 | 34738 | Permitted Site 1 | :: 54 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38388 | 6007301.38154642 | 2103961.93369164 | 37.7574913175401 | -122.417759048452 | (37.7574913175401, -122.417759048452) | ||
81521 | 81521 | 34737 | Permitted Site 1 | :: 54 | 575 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38387 | 6007300.76294173 | 2103973.10640079 | 37.757521960416604 | -122.41776197976499 | (37.7575219604166, -122.417761979765) | ||
143116 | 143116 | 37316 | Permitted Site 1 | :: 54 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39831 | 6002632.74186614 | 2103295.45378084 | 37.755397491549 | -122.433857422868 | (37.755397491549, -122.433857422868) | ||
84755 | 84755 | 34736 | Permitted Site 1 | :: 54 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38386 | 6007298.90712997 | 2104006.62448648 | 37.7576138889301 | -122.417770773708 | (37.7576138889301, -122.417770773708) | ||
110326 | 110326 | 37315 | Permitted Site 1 | :: 54 | 561 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39830 | 6002709.44183784 | 2103247.60813838 | 37.7552704710237 | -122.43358875215 | (37.7552704710237, -122.43358875215) | ||
76884 | 76884 | 142080 | Undocumented 2 | :: 54 | 560 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000142.3776 | 2110889.4402 | 37.7761070510385 | -122.44301516716001 | (37.7761070510385, -122.44301516716) | |||
3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
41875 | 41875 | 142271 | Undocumented 2 | :: 54 | 556 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004757.9319 | 2110570.0874 | 37.775492263035204 | -122.427025971185 | (37.7754922630352, -122.427025971185) | |||
33983 | 33983 | 142497 | Undocumented 2 | :: 54 | 555 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009877.0468 | 2119393.2664 | 37.8000067321588 | -122.40994064461901 | (37.8000067321588, -122.409940644619) | |||
95413 | 95413 | 118419 | Undocumented 2 | :: 54 | 5507 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5981562.4785 | 2111629.449 | 37.7770620385939 | -122.507341801673 | (37.7770620385939, -122.507341801673) | ||||
185215 | 185215 | 142228 | Undocumented 2 | :: 54 | 550 LINDEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004723.2776 | 2110721.3880000003 | 37.775905737853705 | -122.42715662811001 | (37.7759057378537, -122.42715662811) | |||
27363 | 27363 | 141421 | Undocumented 2 | :: 54 | 550 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004561.2684 | 2111044.0972 | 37.7767826552211 | -122.42774005835501 | (37.7767826552211, -122.427740058355) | |||
174091 | 174091 | 141420 | Undocumented 2 | :: 54 | 550 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004578.5445 | 2111046.5078 | 37.7767902513835 | -122.427680466931 | (37.7767902513835, -122.427680466931) | |||
1988 | 1988 | 252845 | DPW Maintained 3 | :: 54 | 544 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2014 12:00:00 AM | 3x3 | 5993963.0 | 2110797.0 | 37.7754989773977 | -122.46438440768401 | (37.7754989773977, -122.464384407684) | |||
96301 | 96301 | 101476 | Significant Tree 6 | :: 54 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089.0 | 2095440.1 | 37.7336838892166 | -122.44209059296301 | (37.7336838892166, -122.442090592963) | ||
92236 | 92236 | 43021 | Permitted Site 1 | :: 54 | 537 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | |||
111037 | 111037 | 43020 | Permitted Site 1 | :: 54 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | ||
44559 | 44559 | 141411 | Undocumented 2 | :: 54 | 530 IVY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004748.0909 | 2111070.6139 | 37.776866029844996 | -122.42709567230601 | (37.776866029845, -122.427095672306) | |||
51927 | 51927 | 141418 | Undocumented 2 | :: 54 | 530 IVY ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004607.07 | 2111051.7308 | 37.776806205978 | -122.42758216085 | (37.776806205978, -122.42758216085) | |||
73962 | 73962 | 141419 | Undocumented 2 | :: 54 | 530 IVY ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004593.8117 | 2111048.5166 | 37.7767966306404 | -122.42762779625099 | (37.7767966306404, -122.427627796251) | |||
157274 | 157274 | 141409 | Undocumented 2 | :: 54 | 530 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004778.2236 | 2111075.0334 | 37.7768798686174 | -122.426991748962 | (37.7768798686174, -122.426991748962) | |||
172733 | 172733 | 140806 | Undocumented 2 | :: 54 | 530 EUCLID AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996678.7438 | 2113864.2417 | 37.7840769823676 | -122.45521175977501 | (37.7840769823676, -122.455211759775) | |||
28948 | 28948 | 141597 | Undocumented 2 | :: 54 | 529 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999089.4212 | 2110974.3283 | 37.7762800409646 | -122.44666372012199 | (37.7762800409646, -122.446663720122) | |||
49493 | 49493 | 141641 | Undocumented 2 | :: 54 | 529 MASONIC AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999097.1169 | 2110918.0537 | 37.776125964947205 | -122.44663304885401 | (37.7761259649472, -122.446633048854) | |||
136951 | 136951 | 141563 | Undocumented 2 | :: 54 | 526 LYON ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6000158.036 | 2110749.7189 | 37.7757243046253 | -122.442950964672 | (37.7757243046253, -122.442950964672) | |||
81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
141475 | 141475 | 104153 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
85374 | 85374 | 114726 | Significant Tree 6 | :: 54 | 520 Townsend St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
97519 | 97519 | 114725 | Significant Tree 6 | :: 54 | 520 Townsend St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) |
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");