Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134524 | 134524 | 180080 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000250.536280001 | 2090007.01678 | 37.7187750968802 | -122.441142448362 | (37.7187750968802, -122.441142448362) | |||
43625 | 43625 | 180079 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000270.676519999 | 2090025.31664 | 37.71882649133779 | -122.44107414397699 | (37.7188264913378, -122.441074143977) | |||
159126 | 159126 | 180078 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000292.29675 | 2090045.26571 | 37.7188824984081 | -122.44100084202101 | (37.7188824984081, -122.441000842021) | |||
92247 | 92247 | 10776 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
51011 | 51011 | 180077 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000313.69602 | 2090066.17904 | 37.718941140487104 | -122.44092837286199 | (37.7189411404871, -122.440928372862) | |||
166549 | 166549 | 180076 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000336.55563 | 2090087.7823400002 | 37.7190017601923 | -122.440850905243 | (37.7190017601923, -122.440850905243) | |||
55694 | 55694 | 180075 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000353.03268 | 2090103.7584400002 | 37.7190465653394 | -122.44079509604401 | (37.7190465653394, -122.440795096044) | |||
64280 | 64280 | 180074 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000367.52322 | 2090116.8961 | 37.719083463616 | -122.44074594986401 | (37.719083463616, -122.440745949864) | |||
113326 | 113326 | 10773 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
134500 | 134500 | 180073 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6000381.06487 | 2090130.7736900002 | 37.719122339514605 | -122.44070013662201 | (37.7191223395146, -122.440700136622) | |||
181268 | 181268 | 180072 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000400.98899 | 2090150.2778599998 | 37.719177028168296 | -122.440632664989 | (37.7191770281683, -122.440632664989) | |||
33919 | 33919 | 180071 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000421.866669999 | 2090169.28245 | 37.719230399348795 | -122.440561861357 | (37.7192303993488, -122.440561861357) | |||
177174 | 177174 | 180070 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000442.5181599995 | 2090189.01132 | 37.7192857463155 | -122.440491891393 | (37.7192857463155, -122.440491891393) | |||
49881 | 49881 | 180069 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000467.5949099995 | 2090212.96823 | 37.719352954453605 | -122.440406927962 | (37.7193529544536, -122.440406927962) | |||
177704 | 177704 | 180068 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000492.17507 | 2090236.21555 | 37.71941818588179 | -122.440323630039 | (37.7194181858818, -122.440323630039) | |||
158230 | 158230 | 180067 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000510.614080001 | 2090253.83095 | 37.7194676036275 | -122.440261155949 | (37.7194676036275, -122.440261155949) | |||
185396 | 185396 | 180066 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000525.601009999 | 2090267.6783099999 | 37.7195064786158 | -122.440210344258 | (37.7195064786158, -122.440210344258) | |||
9380 | 9380 | 12155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016212.874009999 | 2095683.59001 | 37.7352581567374 | -122.38636208157301 | (37.7352581567374, -122.386362081573) | ||
164187 | 164187 | 180357 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999341.076309999 | 2091752.71105 | 37.7235165268451 | -122.444411466031 | (37.7235165268451, -122.444411466031) | |||
132991 | 132991 | 198232 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017137.151430001 | 2094557.735 | 37.7322179011369 | -122.383088149026 | (37.7322179011369, -122.383088149026) | |||
149228 | 149228 | 180065 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000553.61296 | 2090293.7338400001 | 37.7195796159879 | -122.440115384832 | (37.7195796159879, -122.440115384832) | |||
169933 | 169933 | 180356 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999377.8425199995 | 2091805.58177 | 37.723663795345296 | -122.444288169859 | (37.7236637953453, -122.444288169859) | |||
68749 | 68749 | 185181 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985173.8643 | 2097833.419 | 37.739394027632606 | -122.493832155461 | (37.7393940276326, -122.493832155461) | |||
171350 | 171350 | 180355 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999392.39561 | 2091826.25637 | 37.7237213933189 | -122.44423934748501 | (37.7237213933189, -122.444239347485) | |||
46125 | 46125 | 198231 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017152.36813 | 2094550.1406599998 | 37.732197889407395 | -122.38303501258001 | (37.7321978894074, -122.38303501258) | |||
65498 | 65498 | 180064 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000583.15456 | 2090323.8373900002 | 37.7196639553094 | -122.44001542788601 | (37.7196639553094, -122.440015427886) | |||
153426 | 153426 | 180354 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999408.912140001 | 2091849.27395 | 37.723785536569295 | -122.44418390605699 | (37.7237855365693, -122.444183906057) | |||
176679 | 176679 | 180039 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6001024.8340300005 | 2091089.76883 | 37.7217921640611 | -122.43854355335199 | (37.7217921640611, -122.438543553352) | |||
14023 | 14023 | 12151 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016216.53352 | 2095682.69567 | 37.735255903626104 | -122.386349366854 | (37.7352559036261, -122.386349366854) | ||
46043 | 46043 | 180353 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999435.7952 | 2091887.33185 | 37.723891568433 | -122.44409370946899 | (37.723891568433, -122.444093709469) | |||
160948 | 160948 | 185179 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985165.2317 | 2097818.1461 | 37.7393515872788 | -122.49386087752701 | (37.7393515872788, -122.493860877527) | |||
187581 | 187581 | 180063 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000614.24594 | 2090358.9478799999 | 37.7197621306905 | -122.439910472497 | (37.7197621306905, -122.439910472497) | |||
45088 | 45088 | 198230 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017163.23576 | 2094544.6383099998 | 37.7321833815383 | -122.38299705756201 | (37.7321833815383, -122.382997057562) | |||
112713 | 112713 | 12048 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250X La Salle Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
131878 | 131878 | 180038 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001039.13004 | 2091116.8282599999 | 37.7218672763459 | -122.438496073645 | (37.7218672763459, -122.438496073645) | |||
169011 | 169011 | 180352 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999449.4457 | 2091910.6474400002 | 37.723956366384 | -122.44404819656799 | (37.723956366384, -122.444048196568) | |||
28953 | 28953 | 180351 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999465.90272 | 2091930.8056400002 | 37.724012654949206 | -122.443992755163 | (37.7240126549492, -122.443992755163) | |||
29276 | 29276 | 180062 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000649.61116 | 2090402.60873 | 37.7198840266041 | -122.439791356397 | (37.7198840266041, -122.439791356397) | |||
47302 | 47302 | 185177 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985174.5283 | 2097805.5293 | 37.7393174888485 | -122.49382780495 | (37.7393174888485, -122.49382780495) | |||
184447 | 184447 | 180037 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001052.1769900005 | 2091141.7538400001 | 37.7219364584926 | -122.438452758712 | (37.7219364584926, -122.438452758712) | |||
15788 | 15788 | 12148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016263.135559999 | 2095630.9008799999 | 37.735116265005296 | -122.38618463531701 | (37.7351162650053, -122.386184635317) | |||
42646 | 42646 | 180350 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999481.21796 | 2091953.60977 | 37.724076143470796 | -122.44394145063801 | (37.7240761434708, -122.443941450638) | |||
43357 | 43357 | 180061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000666.70399 | 2090425.0511 | 37.7199466212073 | -122.43973388071001 | (37.7199466212073, -122.43973388071) | |||
23262 | 23262 | 12147 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1992 12:00:00 AM | 2 | 3X3 | 6016278.18677 | 2095613.26708 | 37.7350686791819 | -122.38613136847499 | (37.7350686791819, -122.386131368475) | ||
59485 | 59485 | 180349 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999494.33024 | 2091974.07592 | 37.7241330867549 | -122.44389759340099 | (37.7241330867549, -122.443897593401) | |||
59645 | 59645 | 121791 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6016249.369659999 | 2101966.17171 | 37.752510857603504 | -122.38667386380699 | (37.7525108576035, -122.386673863807) | |||
62404 | 62404 | 180036 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001074.7596 | 2091184.9588099997 | 37.7220563740814 | -122.43837779032101 | (37.7220563740814, -122.438377790321) | |||
117964 | 117964 | 26533 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
183918 | 183918 | 180060 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000687.072369999 | 2090454.3849400003 | 37.7200283246365 | -122.439665576299 | (37.7200283246365, -122.439665576299) | |||
16569 | 16569 | 12146 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2016 08:19:00 AM | 3 | 3X3 | 6016292.37085 | 2095595.08218 | 37.735019532132505 | -122.386081061301 | (37.7350195321325, -122.386081061301) | ||
33036 | 33036 | 180348 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999510.53335 | 2091993.5241 | 37.7241874112135 | -122.443842978489 | (37.7241874112135, -122.443842978489) | |||
34075 | 34075 | 198202 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017386.73333 | 2094343.85008 | 37.731644403447106 | -122.38221040528 | (37.7316444034471, -122.38221040528) | |||
57797 | 57797 | 121790 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6016249.74624 | 2101942.17011 | 37.7524449750798 | -122.386670887967 | (37.7524449750798, -122.386670887967) | |||
101882 | 101882 | 88685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
176650 | 176650 | 180059 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000706.97869 | 2090484.68802 | 37.7201126630403 | -122.439598938365 | (37.7201126630403, -122.439598938365) | |||
185409 | 185409 | 180035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001087.26718 | 2091207.92549 | 37.722120146807896 | -122.43833619936399 | (37.7221201468079, -122.438336199364) | |||
30468 | 30468 | 180034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001097.83369 | 2091228.63345 | 37.7221776071819 | -122.43830115639601 | (37.7221776071819, -122.438301156396) | |||
33314 | 33314 | 180058 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000718.4568 | 2090503.6472599998 | 37.7201653741024 | -122.43956062093599 | (37.7201653741024, -122.439560620936) | |||
50436 | 50436 | 198220 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017527.033969999 | 2094259.97838 | 37.7314218563182 | -122.38171952203501 | (37.7314218563182, -122.381719522035) | |||
90977 | 90977 | 36211 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
101128 | 101128 | 88684 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
111656 | 111656 | 11998 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
163800 | 163800 | 121789 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016253.07311 | 2101915.10952 | 37.7523708565434 | -122.38665749616301 | (37.7523708565434, -122.386657496163) | |||
169679 | 169679 | 180347 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999525.409630001 | 2092018.2442599998 | 37.7242561356068 | -122.44379332872101 | (37.7242561356068, -122.443793328721) | |||
184132 | 184132 | 198229 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017254.927490001 | 2094491.22957 | 37.732041797678704 | -122.38267634045401 | (37.7320417976787, -122.382676340454) | |||
39693 | 39693 | 198201 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017349.13992 | 2094376.34522 | 37.731731552271796 | -122.38234263442101 | (37.7317315522718, -122.382342634421) | |||
46615 | 46615 | 180033 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001110.15786 | 2091253.57403 | 37.722246789330896 | -122.43826034064699 | (37.7222467893309, -122.438260340647) | |||
47519 | 47519 | 121788 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016251.70345 | 2101889.85791 | 37.75230144507611 | -122.386660472017 | (37.7523014450761, -122.386660472017) | |||
51994 | 51994 | 180057 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000730.46127 | 2090524.7556599998 | 37.7202240162157 | -122.439520637988 | (37.7202240162157, -122.439520637988) | |||
62432 | 62432 | 218769 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999558.6619 | 2092063.3212599999 | 37.7243818032662 | -122.443681617625 | (37.7243818032662, -122.443681617625) | |||
64074 | 64074 | 198219 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017539.02456 | 2094243.4713299999 | 37.73137719328629 | -122.381676920275 | (37.7313771932863, -122.381676920275) | |||
79293 | 79293 | 36208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
117263 | 117263 | 11997 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
141518 | 141518 | 88683 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
14039 | 14039 | 12143 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/2015 10:50:00 AM | 3 | 3X3 | 6016355.37955 | 2095493.80594 | 37.734744934934895 | -122.385856158845 | (37.7347449349349, -122.385856158845) | ||
18717 | 18717 | 12041 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250X La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
36438 | 36438 | 198228 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017291.3126300005 | 2094471.7306099997 | 37.731990267431605 | -122.382549191609 | (37.7319902674316, -122.382549191609) | |||
37415 | 37415 | 198218 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017554.24593 | 2094216.62614 | 37.7313043221245 | -122.38162243033999 | (37.7313043221245, -122.38162243034) | |||
45858 | 45858 | 121787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016254.17853 | 2101863.2429 | 37.7522285028495 | -122.38665005696699 | (37.7522285028495, -122.386650056967) | |||
56209 | 56209 | 180346 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999574.72961 | 2092087.77825 | 37.7244498729372 | -122.443627830084 | (37.7244498729372, -122.443627830084) | |||
57669 | 57669 | 180056 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000745.033480001 | 2090553.4894299998 | 37.7203037419912 | -122.439472325501 | (37.7203037419912, -122.439472325501) | |||
87278 | 87278 | 36215 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
87367 | 87367 | 88682 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
94343 | 94343 | 11996 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
113718 | 113718 | 10816 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1139X Hudson Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2016 12:00:00 AM | 3 | 3X4 | 6017660.0560099995 | 2094705.99201 | 37.7326538662851 | -122.381290636609 | (37.7326538662851, -122.381290636609) | ||
170774 | 170774 | 180032 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001123.43555 | 2091278.0147099998 | 37.722314653084396 | -122.438216192941 | (37.7223146530844, -122.438216192941) | |||
179780 | 179780 | 180159 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 579 Madrid St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 6002542.18491 | 2090728.5143 | 37.7208864370415 | -122.43327267002199 | (37.7208864370415, -122.433272670022) | |||
29679 | 29679 | 121786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016255.4069300005 | 2101838.7957200003 | 37.752161444010795 | -122.38664410433998 | (37.7521614440108, -122.38664410434) | |||
46925 | 46925 | 180031 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001136.72316 | 2091302.93534 | 37.7223838352188 | -122.438172045228 | (37.7223838352188, -122.438172045228) | |||
56812 | 56812 | 180158 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 579 Madrid St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6002520.13209 | 2090692.25327 | 37.7207856212475 | -122.433346310091 | (37.7207856212475, -122.433346310091) | |||
65830 | 65830 | 198227 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017315.6556400005 | 2094453.93145 | 37.7319427391711 | -122.38246379378401 | (37.7319427391711, -122.382463793784) | |||
77166 | 77166 | 77218 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
111470 | 111470 | 36207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
112380 | 112380 | 12040 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250X La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2011 12:00:00 AM | 0 | 3x3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
116237 | 116237 | 88681 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
138238 | 138238 | 30544 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 10 | Permit Number 34540 | 6011720.93771 | 2086611.92604 | 37.7100995538248 | -122.401255168406 | (37.7100995538248, -122.401255168406) | ||
152702 | 152702 | 180345 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999591.211180001 | 2092109.1279 | 37.72450943414721 | -122.44357238867599 | (37.7245094341472, -122.443572388676) | |||
42531 | 42531 | 180157 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 579 Madrid St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6002506.03817 | 2090671.0585599998 | 37.720726625705105 | -122.433393514622 | (37.7207266257051, -122.433393514622) | |||
51587 | 51587 | 121785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016256.95276 | 2101808.77188 | 37.7520790904017 | -122.38663666516099 | (37.7520790904017, -122.386636665161) | |||
52126 | 52126 | 180030 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001150.53734 | 2091330.00448 | 37.72245894660539 | -122.438126231036 | (37.7224589466054, -122.438126231036) |
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");