Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
155380 | 155380 | 250984 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 165 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5981096.44332 | 2112928.00583 | 37.7806000288029 | -122.509050381992 | (37.7806000288029, -122.509050381992) | |||
156198 | 156198 | 186879 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 2700 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985177.7993 | 2096457.4623 | 37.7356162487584 | -122.49371718453101 | (37.7356162487584, -122.493717184531) | |||
184722 | 184722 | 186854 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 2700 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985211.9517 | 2096276.1566 | 37.7351204295726 | -122.493585753219 | (37.7351204295726, -122.493585753219) | |||
11722 | 11722 | 86184 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 1707 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988709.6107 | 2103691.4443 | 37.7556848454942 | -122.482036276815 | (37.7556848454942, -122.482036276815) | ||
26112 | 26112 | 120763 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1914 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5989528.9744 | 2113375.1209299997 | 37.782321194501904 | -122.47991129443899 | (37.7823211945019, -122.479911294439) | |||
74917 | 74917 | 217761 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 460 West Portal Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991726.04685 | 2096477.6292400002 | 37.736052541987206 | -122.471079064459 | (37.7360525419872, -122.471079064459) | |||
43241 | 43241 | 217760 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 460 West Portal Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991734.77197 | 2096495.4361599998 | 37.736101939940205 | -122.471050195332 | (37.7361019399402, -122.471050195332) | |||
39527 | 39527 | 206980 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 401 Victoria St | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5993229.06721 | 2089889.6330900001 | 37.718050339540206 | -122.465404139084 | (37.7180503395402, -122.465404139084) | |||
59991 | 59991 | 123555 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 101 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994248.76997 | 2114782.67993 | 37.7864590494309 | -122.463685208724 | (37.7864590494309, -122.463685208724) | |||
181164 | 181164 | 123556 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 101 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994248.60901 | 2114775.00999 | 37.7864379805878 | -122.46368520872 | (37.7864379805878, -122.46368520872) | |||
153236 | 153236 | 206976 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 758 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994474.73977 | 2089943.06008 | 37.718268800134204 | -122.461102290543 | (37.7182688001342, -122.461102290543) | |||
44195 | 44195 | 206966 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 701 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994703.93987 | 2091218.5245700001 | 37.7217841079442 | -122.460402414748 | (37.7217841079442, -122.460402414748) | |||
188816 | 188816 | 206967 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 701 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994707.069490001 | 2091218.5281099998 | 37.7217842976985 | -122.46039159679701 | (37.7217842976985, -122.460391596797) | |||
24788 | 24788 | 206973 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 395 Faxon Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994731.32919 | 2091112.5453299999 | 37.721494689904 | -122.46030006290701 | (37.721494689904, -122.460300062907) | |||
55254 | 55254 | 206971 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 395 Faxon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994732.68246 | 2091163.36914 | 37.7216343177559 | -122.46029906557 | (37.7216343177559, -122.46029906557) | |||
179555 | 179555 | 206972 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 395 Faxon Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994732.3997 | 2091149.8719400002 | 37.721597241413 | -122.46029906555799 | (37.721597241413, -122.460299065558) | |||
65113 | 65113 | 206970 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 395 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994732.76669 | 2091167.3894599997 | 37.7216453614367 | -122.46029906555201 | (37.7216453614367, -122.460299065552) | |||
134905 | 134905 | 206969 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 395 Faxon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994733.36792 | 2091182.3162099998 | 37.721686381300394 | -122.460298068228 | (37.7216863813004, -122.460298068228) | |||
71696 | 71696 | 206968 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 395 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994733.59655 | 2091193.22902 | 37.7217163584134 | -122.460298068196 | (37.7217163584134, -122.460298068196) | |||
184987 | 184987 | 206982 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 425 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5995074.1246 | 2100289.40208 | 37.746711806014105 | -122.459779506518 | (37.7467118060141, -122.459779506518) | |||
62143 | 62143 | 206981 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 425 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5995081.28449 | 2100295.43266 | 37.746728776220706 | -122.45975518525199 | (37.7467287762207, -122.459755185252) | |||
147078 | 147078 | 206974 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 146 Miramar Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5995372.5326 | 2090893.02232 | 37.7209287951196 | -122.458067733342 | (37.7209287951196, -122.458067733342) | |||
24025 | 24025 | 206975 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1050 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5995957.75422 | 2090863.3039900002 | 37.7208808036758 | -122.45604266244699 | (37.7208808036758, -122.456042662447) | |||
181682 | 181682 | 206977 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 1x Minerva St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5996177.78414 | 2089001.8318599998 | 37.7157822655174 | -122.455147642762 | (37.7157822655174, -122.455147642762) | |||
69874 | 69874 | 206963 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 452 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5997448.902290001 | 2097287.5268099997 | 37.7386056696229 | -122.451351336401 | (37.7386056696229, -122.451351336401) | |||
178656 | 178656 | 206964 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 481 Flood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997573.15769 | 2094088.10013 | 37.7298279240054 | -122.45069111173201 | (37.7298279240054, -122.450691111732) | |||
176839 | 176839 | 206978 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 323 Tara St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5997663.37631 | 2090063.53352 | 37.7187825720371 | -122.45008925483101 | (37.7187825720371, -122.450089254831) | |||
136487 | 136487 | 206979 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 323 Tara St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5997666.46898 | 2090072.1702400001 | 37.718806463439 | -122.45007918692 | (37.718806463439, -122.45007918692) | |||
3071 | 3071 | 206965 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 428 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2009 12:00:00 AM | 1 | Width 2ft | Permit Number 52108 | 5997891.77547 | 2094116.71223 | 37.7299247189373 | -122.449591679718 | (37.7299247189373, -122.449591679718) | |
186728 | 186728 | 206983 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 495 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 5998187.12093 | 2095228.0370599998 | 37.7329930456965 | -122.448650649802 | (37.7329930456965, -122.448650649802) | |||
141231 | 141231 | 105891 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | Permit Number 771559 | 5999444.5 | 2109060.1 | 37.771044333973705 | -122.445297745357 | (37.7710443339737, -122.445297745357) | |||
33847 | 33847 | 176866 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 205 Seneca Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999819.10608 | 2090379.3923 | 37.7197729711124 | -122.442660448227 | (37.7197729711124, -122.442660448227) | |||
153420 | 153420 | 129363 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 2936 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001041.88573 | 2118458.1197099998 | 37.7969399387778 | -122.44044648643299 | (37.7969399387778, -122.440446486433) | |||
123977 | 123977 | 227062 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000725.1637 | 2102600.6737 | 37.7533813599857 | -122.440404564513 | (37.7533813599857, -122.440404564513) | |||
75740 | 75740 | 65848 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 60 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 9 | Permit Number 28839 | 6001380.15928 | 2121427.38257 | 37.8051120044819 | -122.43948894135599 | (37.8051120044819, -122.439488941356) | |
68137 | 68137 | 139627 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1911 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001197.3517 | 2112443.2085 | 37.7804333986461 | -122.439477144015 | (37.7804333986461, -122.439477144015) | |||
30147 | 30147 | 227061 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 800 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001153.3216699995 | 2102624.46205 | 37.75347104667021 | -122.438925612327 | (37.7534710466702, -122.438925612327) | |||
115318 | 115318 | 121613 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 800X Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001168.0 | 2102650.0 | 37.7535420028484 | -122.43887668159701 | (37.7535420028484, -122.438876681597) | ||||
65370 | 65370 | 227064 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 4441 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001211.68109 | 2104631.03803 | 37.7589839384659 | -122.438867577298 | (37.7589839384659, -122.438867577298) | |||
41666 | 41666 | 176867 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 692 London St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000958.88586 | 2089823.00585 | 37.7183101671468 | -122.43868079437901 | (37.7183101671468, -122.438680794379) | |||
185781 | 185781 | 227059 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 675 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001568.11505 | 2099383.94342 | 37.744596945010294 | -122.43725915959699 | (37.7445969450103, -122.437259159597) | |||
168715 | 168715 | 69350 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 3445 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 1 | Permit Number 33441 | 6002188.2032699995 | 2120049.04507 | 37.8013734076063 | -122.43659389422 | (37.8013734076063, -122.43659389422) | |
147149 | 147149 | 227065 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 278 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002058.8176 | 2104239.30428 | 37.757956492708296 | -122.43590975565 | (37.7579564927083, -122.43590975565) | |||
36088 | 36088 | 176871 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 466 Paris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6001962.84798 | 2090902.89386 | 37.721332361375204 | -122.43528772696399 | (37.7213323613752, -122.435287726964) | |||
52999 | 52999 | 176870 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 466 Paris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6001967.43122 | 2090909.7813400002 | 37.721351533129 | -122.435272376418 | (37.721351533129, -122.435272376418) | |||
134020 | 134020 | 176869 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 466 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6001971.78547 | 2090916.90643 | 37.7213713443005 | -122.435257834404 | (37.7213713443005, -122.435257834404) | |||
149133 | 149133 | 176868 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 466 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6001976.13517 | 2090923.7987400002 | 37.7213905160501 | -122.435243291469 | (37.7213905160501, -122.435243291469) | |||
176238 | 176238 | 227073 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 110 Henry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002808.43426 | 2107410.93837 | 37.7667075878083 | -122.433543924419 | (37.7667075878083, -122.433543924419) | |||
71634 | 71634 | 227060 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1590 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003308.34856 | 2098978.33105 | 37.7435820007231 | -122.431212834906 | (37.7435820007231, -122.431212834906) | |||
17231 | 17231 | 30 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 750 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1X1 | 6003777.42436 | 2107761.72523 | 37.7677256941011 | -122.430217381651 | (37.7677256941011, -122.430217381651) | |||
30485 | 30485 | 227075 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1720 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003949.62803 | 2098226.14791 | 37.741552998869295 | -122.42894183272301 | (37.7415529988693, -122.428941832723) | |||
67903 | 67903 | 227072 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 3600 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004257.64843 | 2103674.51976 | 37.75653039189 | -122.428265016426 | (37.75653039189, -122.428265016426) | |||
143727 | 143727 | 227071 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 3600 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004281.06062 | 2103673.66097 | 37.7565293585559 | -122.428183987515 | (37.7565293585559, -122.428183987515) | |||
149825 | 149825 | 227070 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 3600 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004299.63219 | 2103676.28895 | 37.75653762513971 | -122.428119947672 | (37.7565376251397, -122.428119947672) | |||
158758 | 158758 | 227066 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 880 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004322.18511 | 2103780.44049 | 37.7568248766824 | -122.42804937340401 | (37.7568248766824, -122.428049373404) | |||
148590 | 148590 | 227067 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 880 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004324.426109999 | 2103760.8259900003 | 37.75677114668179 | -122.428040225476 | (37.7567711466818, -122.428040225476) | |||
177767 | 177767 | 227068 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 880 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004327.06054 | 2103741.95573 | 37.7567194824462 | -122.428029769971 | (37.7567194824462, -122.428029769971) | |||
45749 | 45749 | 227069 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 880 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004326.63425 | 2103721.26686 | 37.7566626515725 | -122.42802976997 | (37.7566626515725, -122.42802976997) | |||
184574 | 184574 | 227074 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 22 Whitney St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6004252.810959999 | 2098130.67002 | 37.741307994779206 | -122.42788672741301 | (37.7413079947792, -122.427886727413) | |||
160027 | 160027 | 227050 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 295 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004692.50509 | 2109376.8502700003 | 37.772212224749204 | -122.42716728596001 | (37.7722122247492, -122.42716728596) | |||
86081 | 86081 | 97440 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1900 Pacific Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/11/2011 12:00:00 AM | Permit Number 768364 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||
155764 | 155764 | 227052 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 16 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005980.22404 | 2105419.0145400004 | 37.761417684710494 | -122.422431677274 | (37.7614176847105, -122.422431677274) | |||
61195 | 61195 | 227053 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 16 Lapidge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005980.85073 | 2105411.52348 | 37.7613971513711 | -122.422428977523 | (37.7613971513711, -122.422428977523) | |||
183140 | 183140 | 227054 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 16 Lapidge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005981.42855 | 2105394.22422 | 37.761349684260104 | -122.422425749859 | (37.7613496842601, -122.422425749859) | |||
41562 | 41562 | 227057 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 36 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006024.56272 | 2102894.52743 | 37.754488532433705 | -122.422098977597 | (37.7544885324337, -122.422098977597) | |||
144619 | 144619 | 84291 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 36 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50593 | 6006036.40406363 | 2102899.92286598 | 37.7545040149209 | -122.422058410345 | (37.7545040149209, -122.422058410345) | ||
36144 | 36144 | 227058 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 267 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006192.47769 | 2101670.77232 | 37.7511378518545 | -122.421431380271 | (37.7511378518545, -122.421431380271) | |||
37883 | 37883 | 129365 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 950 O'Farrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006602.5479999995 | 2113943.17336 | 37.7848580713737 | -122.420884524127 | (37.7848580713737, -122.420884524127) | |||
33399 | 33399 | 129364 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 950 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006675.50355 | 2113954.0414400003 | 37.784892024402 | -122.420632892917 | (37.784892024402, -122.420632892917) | |||
174246 | 174246 | 129366 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1515 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007909.93455 | 2117647.30937 | 37.795102326163395 | -122.416623869891 | (37.7951023261634, -122.416623869891) | |||
30219 | 30219 | 129367 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1515 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007911.49286 | 2117626.11429 | 37.795044217366 | -122.41661697571001 | (37.795044217366, -122.41661697571) | |||
178261 | 178261 | 129368 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008451.9659400005 | 2122064.5899 | 37.8072615442584 | -122.41506116833901 | (37.8072615442584, -122.415061168339) | |||
167108 | 167108 | 129369 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008462.41761 | 2122065.39822 | 37.807264351026 | -122.415025055184 | (37.807264351026, -122.415025055184) | |||
146879 | 146879 | 129370 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008475.09899 | 2122066.50156 | 37.8072680931263 | -122.41498124649598 | (37.8072680931263, -122.414981246496) | |||
167524 | 167524 | 129371 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008483.18114 | 2122068.5506 | 37.8072741734254 | -122.414953421476 | (37.8072741734254, -122.414953421476) | |||
66352 | 66352 | 176873 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 34 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008389.4363 | 2086207.95793 | 37.7088039104301 | -122.412740993025 | (37.7088039104301, -122.412740993025) | |||
56476 | 56476 | 227063 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 310 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008808.10283 | 2097327.49228 | 37.739359293383 | -122.412079324914 | (37.739359293383, -122.412079324914) | |||
181800 | 181800 | 55612 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 620 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1973 12:00:00 AM | 5 | Permit Number 11589 | 6008867.71291 | 2091224.31143 | 37.722604610692294 | -122.41144215434099 | (37.7226046106923, -122.411442154341) | ||
160526 | 160526 | 227051 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 2770 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009518.98331 | 2103379.9588200003 | 37.7560178907361 | -122.410048575691 | (37.7560178907361, -122.410048575691) | |||
179378 | 179378 | 227055 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1523 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009607.86585 | 2100388.33634 | 37.7478085427258 | -122.40953005626899 | (37.7478085427258, -122.409530056269) | |||
8459 | 8459 | 13033 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 468 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6010099.3086 | 2120611.2701 | 37.803363523958296 | -122.40925752960301 | (37.8033635239583, -122.409257529603) | |||
34023 | 34023 | 143013 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 460 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010152.8638 | 2120618.4108 | 37.8033861308221 | -122.409072703167 | (37.8033861308221, -122.409072703167) | |||
26903 | 26903 | 227056 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 643 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009797.85422 | 2100427.8774599996 | 37.7479277577665 | -122.408875872347 | (37.7479277577665, -122.408875872347) | |||
147129 | 147129 | 42951 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 454 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 2 | Permit Number 42844 | 6010612.89233 | 2106188.0109099997 | 37.7637894226584 | -122.406463315032 | (37.7637894226584, -122.406463315032) | |
149047 | 149047 | 191214 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 536 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011191.48896 | 2105828.9698400004 | 37.762835928147396 | -122.404436841187 | (37.7628359281474, -122.404436841187) | |||
153179 | 153179 | 191216 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 2095 Bancroft Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011626.75031 | 2094136.85513 | 37.7307562213185 | -122.40210937955798 | (37.7307562213185, -122.402109379558) | |||
23291 | 23291 | 27166 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 1950 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 5 | 2X3 | 6011856.11621 | 2095630.9787 | 37.7348715720666 | -122.401421384693 | (37.7348715720666, -122.401421384693) | ||
70508 | 70508 | 191215 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 695 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6012749.19171 | 2104260.69013 | 37.758616704812496 | -122.398939180317 | (37.7586167048125, -122.398939180317) | |||
61414 | 61414 | 97784 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1616 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 56445 | 6013108.29452 | 2104759.9427900002 | 37.760007546818 | -122.39773224963699 | (37.760007546818, -122.397732249637) | |
152236 | 152236 | 97783 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1616 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 56445 | 6013126.61766 | 2104759.99043 | 37.7600086979704 | -122.397668881632 | (37.7600086979704, -122.397668881632) | |
151843 | 151843 | 97782 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1616 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 56445 | 6013154.51165 | 2104761.54844 | 37.760014529165296 | -122.39757251837099 | (37.7600145291653, -122.397572518371) | |
33833 | 33833 | 201361 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 225 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 6013041.33854 | 2092709.54059 | 37.726915962381 | -122.397118848181 | (37.726915962381, -122.397118848181) | |||
130828 | 130828 | 176872 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 154 Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013005.3096 | 2086655.27968 | 37.7102901669233 | -122.39681913291 | (37.7102901669233, -122.39681913291) | |||
128846 | 128846 | 108824 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 146-150X Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | |
31194 | 31194 | 68287 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 92 Diana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1993 12:00:00 AM | 8 | Permit Number 32096 | 6013263.65718 | 2093846.48043 | 37.7300501410779 | -122.396429949508 | (37.7300501410779, -122.396429949508) | ||
37798 | 37798 | 191217 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 2 Bridgeview Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6014080.31435 | 2095351.02168 | 37.7342267167801 | -122.39371190868499 | (37.7342267167801, -122.393711908685) | ||||
157973 | 157973 | 199667 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1913 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015175.9259 | 2093373.705 | 37.7288582250507 | -122.389785932946 | (37.7288582250507, -122.389785932946) | |||
16585 | 16585 | 11460 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 10 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2013 12:00:00 AM | 6 | 3X3 | 6016801.30429 | 2095509.33551 | 37.73481224287921 | -122.384315510452 | (37.7348122428792, -122.384315510452) | ||
15998 | 15998 | 39986 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1418 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 18 | 3x3 | Permit Number 41244 | 6017089.673880001 | 2093785.22875 | 37.7300941278447 | -122.383198540784 | (37.7300941278447, -122.383198540784) |
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");