trees
3,965 rows where qSpecies_id = 70 sorted by Police Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▲ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56861 | 27271 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2134 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6006018.78384 | 2117780.42149 | 37.7953612769429 | -122.42317701472 | (37.7953612769429, -122.42317701472) | 13 | 9 | 10 | 28858 | 32 | |||
| 56945 | 105384 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2853 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x3 | 5999429.08796 | 2117689.01477 | 37.7947362166568 | -122.445971784396 | (37.7947362166568, -122.445971784396) | 13 | 9 | 1 | 57 | 27 | |||
| 57110 | 125268 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | 5 | 9 | 1 | 28858 | 32 | |||
| 57419 | 124968 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2822 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2017 12:00:00 AM | 3 | Width 3ft | 6001569.39846 | 2118152.80963 | 37.7961316595979 | -122.438599283427 | (37.7961316595979, -122.438599283427) | 13 | 9 | 1 | 57 | 17 | ||
| 57608 | 110848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | 13 | 9 | 1 | 57 | 27 | ||
| 57619 | 125200 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2105 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003810.25178 | 2115708.07465 | 37.7895462587878 | -122.430670943933 | (37.7895462587878, -122.430670943933) | 13 | 9 | 1 | 29490 | 27 | |||
| 58146 | 249566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Franklin St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6005942.16382 | 2114329.62673 | 37.7858819315591 | -122.423196721549 | (37.7858819315591, -122.423196721549) | 13 | 9 | 1 | 28858 | 41 | |||
| 58263 | 124975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2725 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999845.54791 | 2118442.88149 | 37.7968299067374 | -122.444584990207 | (37.7968299067374, -122.444584990207) | 13 | 9 | 1 | 57 | 17 | |||
| 58780 | 125024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1436 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002311.60856 | 2121606.01355 | 37.8056554441143 | -122.436278347281 | (37.8056554441143, -122.436278347281) | 13 | 9 | 1 | 57 | 17 | |||
| 59082 | 125194 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003493.7526 | 2118004.10332 | 37.7958326305325 | -122.431930012777 | (37.7958326305325, -122.431930012777) | 13 | 9 | 1 | 57 | 17 | |||
| 59113 | 124973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2815 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999464.00903 | 2118379.34034 | 37.796633661183 | -122.445900626411 | (37.796633661183, -122.445900626411) | 13 | 9 | 1 | 57 | 17 | |||
| 59139 | 143116 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1675X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6004308.6038 | 2119731.9537 | 37.8006230239013 | -122.429233742323 | (37.8006230239013, -122.429233742323) | 13 | 9 | 1 | 57 | 17 | |||
| 59144 | 52034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | 13 | 9 | 1 | 57 | 17 | |||
| 59159 | 5912 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1245 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004490.90647 | 2112892.55275 | 37.7818540774754 | -122.428115221825 | (37.7818540774754, -122.428115221825) | 7 | 9 | 11 | 29490 | 41 | |||
| 59414 | 124798 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2898 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999291.31462 | 2118062.1382 | 37.7957528462763 | -122.446475353448 | (37.7957528462763, -122.446475353448) | 13 | 9 | 1 | 57 | 17 | |||
| 59777 | 113939 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003181 | 2119826 | 37.8008173514055 | -122.433142433403 | (37.8008173514055, -122.433142433403) | 13 | 9 | 1 | 57 | 17 | |||||
| 60172 | 125222 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2333 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004568.52845 | 2117246.30976 | 37.7938127927678 | -122.428157055498 | (37.7938127927678, -122.428157055498) | 13 | 9 | 1 | 28858 | 27 | |||
| 60280 | 124994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 251 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000770.74081 | 2121498.43749 | 37.8052724003766 | -122.441603002893 | (37.8052724003766, -122.441603002893) | 13 | 9 | 1 | 57 | 17 | |||
| 60454 | 125226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Octavia St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6004632.7666 | 2117104.31504 | 37.7934265456543 | -122.427924662605 | (37.7934265456543, -122.427924662605) | 13 | 9 | 1 | 28858 | 27 | |||
| 60876 | 125035 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1467 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002202.71085 | 2121546.35864 | 37.8054854596596 | -122.436650930122 | (37.8054854596596, -122.436650930122) | 13 | 9 | 1 | 57 | 17 | |||
| 61043 | 68013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.95817 | 2120820.40604 | 37.8033370269329 | -122.446024564694 | (37.8033370269329, -122.446024564694) | 13 | 9 | 1 | 57 | 17 | ||
| 61054 | 95204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2780 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000344.57367 | 2117164.06236 | 37.7933470689532 | -122.442766376677 | (37.7933470689532, -122.442766376677) | 13 | 9 | 1 | 57 | 27 | |||
| 61088 | 6963 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004011.7809 | 2110463.0214 | 37.7751560657789 | -122.429599448016 | (37.7751560657789, -122.429599448016) | 7 | 9 | 11 | 29492 | 10 | |||
| 61143 | 140355 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1314 ELLIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6004287.9942 | 2113284.5981 | 37.7829190539607 | -122.428845162049 | (37.7829190539607, -122.428845162049) | 7 | 9 | 11 | 29490 | 41 | |||
| 61199 | 125005 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3768 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002044.39034 | 2121704.85565 | 37.8059116519779 | -122.43721017441 | (37.8059116519779, -122.43721017441) | 13 | 9 | 1 | 57 | 17 | |||
| 61209 | 105786 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3230 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6x4 | 5999056.8 | 2119897.7 | 37.8007794095396 | -122.447418998501 | (37.8007794095396, -122.447418998501) | 13 | 9 | 1 | 57 | 17 | |||
| 61324 | 142463 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 606 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6004567.4577 | 2110568.8808 | 37.7754781775528 | -122.427684781191 | (37.7754781775528, -122.427684781191) | 7 | 9 | 11 | 28852 | 10 | |||
| 61549 | 124993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 259 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000738.67207 | 2121522.9779 | 37.8053379546353 | -122.4417157428 | (37.8053379546353, -122.4417157428) | 13 | 9 | 1 | 57 | 17 | |||
| 62044 | 125038 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1455 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002263.62804 | 2121555.92749 | 37.8055151948229 | -122.436440803513 | (37.8055151948229, -122.436440803513) | 13 | 9 | 1 | 57 | 17 | |||
| 62189 | 124823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Cervantes Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6000834.31444 | 2121522.83872 | 37.8053430214345 | -122.441384750901 | (37.8053430214345, -122.441384750901) | 13 | 9 | 1 | 57 | 17 | |||
| 62749 | 17866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X3 | 6003789.962559 | 2115237.891116 | 37.7882541043801 | -122.430707576303 | (37.7882541043801, -122.430707576303) | 13 | 9 | 11 | 29490 | 27 | |||
| 63300 | 125208 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2006 Washington St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6004975.93089 | 2116805.94473 | 37.7926267039054 | -122.426716030424 | (37.7926267039054, -122.426716030424) | 13 | 9 | 1 | 28858 | 27 | |||
| 63607 | 125152 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 45 Normandie Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000897.77841 | 2117454.70297 | 37.7941766135133 | -122.440873113113 | (37.7941766135133, -122.440873113113) | 13 | 9 | 1 | 57 | 27 | |||
| 63703 | 86887 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Casa Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.438963625045 | (37.8057359986938, -122.438963625045) | 13 | 9 | 1 | 57 | 17 | ||||
| 63986 | 6255 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1315 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 3X3 | 6004589.0866 | 2113270.6263 | 37.7828977279802 | -122.427802511173 | (37.7828977279802, -122.427802511173) | 7 | 9 | 11 | 29490 | 41 | |||
| 64037 | 125004 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3768 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002047.18275 | 2121687.67631 | 37.8058646408085 | -122.437199280038 | (37.8058646408085, -122.437199280038) | 13 | 9 | 1 | 57 | 17 | |||
| 64043 | 125039 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1449 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002279.25009 | 2121557.58939 | 37.8055206456272 | -122.43638686036 | (37.8055206456272, -122.43638686036) | 13 | 9 | 1 | 57 | 17 | |||
| 64098 | 124873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1825 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003120.45934 | 2119937.01258 | 37.8011187286059 | -122.433359866463 | (37.8011187286059, -122.433359866463) | 13 | 9 | 1 | 57 | 17 | |||
| 64476 | 46252 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2683 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 17 | Permit Number 44537 | 6000224.48541 | 2117800.1223 | 37.7950866752742 | -122.443227593983 | (37.7950866752742, -122.443227593983) | 13 | 9 | 1 | 57 | 27 | ||
| 64900 | 124820 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 290 Cervantes Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6000687.14631 | 2121612.80249 | 37.8055816529379 | -122.44190050493 | (37.8055816529379, -122.44190050493) | 13 | 9 | 1 | 57 | 17 | |||
| 65102 | 124801 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2898 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | Permit Number 780062 | 5999229.08983 | 2118053.40815 | 37.7957253216105 | -122.446690033314 | (37.7957253216105, -122.446690033314) | 13 | 9 | 1 | 57 | 17 | ||
| 65182 | 124770 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2942 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999497.98221 | 2118973.17981 | 37.7982661258265 | -122.445825801913 | (37.7982661258265, -122.445825801913) | 13 | 9 | 1 | 57 | 17 | |||
| 65882 | 22610 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
| 65995 | 23479 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2418 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4x6 | 6005891.15748 | 2118710.22844 | 37.7979070885885 | -122.423684765642 | (37.7979070885885, -122.423684765642) | 13 | 9 | 10 | 28858 | 32 | |||
| 66241 | 96357 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | ||||
| 66355 | 124812 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3434 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/22/2019 12:00:00 AM | 3 | Width 3ft | 5999269.00527 | 2120608.31767 | 37.8027426982766 | -122.446735842084 | (37.8027426982766, -122.446735842084) | 13 | 9 | 1 | 57 | 17 | ||
| 66383 | 23516 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2656 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/1994 12:00:00 AM | 30 | 5x5 | 6005775.26266 | 2119527.50037 | 37.8001445667692 | -122.424143947809 | (37.8001445667692, -122.424143947809) | 13 | 9 | 1 | 28858 | 32 | ||
| 66679 | 125129 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2853 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999410.3646 | 2117686.30601 | 37.7947277099622 | -122.446036374589 | (37.7947277099622, -122.446036374589) | 13 | 9 | 1 | 57 | 27 | |||
| 66735 | 125042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002587.96608 | 2121001.45923 | 37.8040111956201 | -122.435278703153 | (37.8040111956201, -122.435278703153) | 13 | 9 | 1 | 57 | 17 | |||
| 67303 | 109049 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
| 67363 | 125056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3051 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005083.26804 | 2120476.13845 | 37.8027101877925 | -122.426606107185 | (37.8027101877925, -122.426606107185) | 13 | 9 | 1 | 57 | 17 | |||
| 67590 | 10261 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X4 | 6005221.62679 | 2109603.34443 | 37.772864030808 | -122.425353127526 | (37.772864030808, -122.425353127526) | 7 | 9 | 11 | 28852 | 10 | |||
| 67682 | 99604 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 67999 | 125180 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Broadway | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6002052.24268 | 2117347.57467 | 37.7939481488482 | -122.436870874613 | (37.7939481488482, -122.436870874613) | 13 | 9 | 1 | 29490 | 27 | |||
| 68058 | 112042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2418 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 17 | 3x3 | Permit Number 776583 | 6002409.60423 | 2117108.01013 | 37.7933106707057 | -122.435617223266 | (37.7933106707057, -122.435617223266) | 13 | 9 | 1 | 29490 | 27 | |
| 68094 | 18688 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 180X Richardson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 5999258.68256 | 2119699.59295 | 37.8002469952063 | -122.446706141286 | (37.8002469952063, -122.446706141286) | 13 | 9 | 1 | 57 | 17 | |||
| 68110 | 17867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2126 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003744.3566 | 2115283.9831 | 37.7883780774332 | -122.430868655963 | (37.7883780774332, -122.430868655963) | 13 | 9 | 1 | 29490 | 27 | |||
| 68346 | 117640 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3839 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6000083.60438 | 2121466.9257 | 37.8051467048289 | -122.443978652001 | (37.8051467048289, -122.443978652001) | 13 | 9 | 1 | 57 | 17 | |||
| 68844 | 125131 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2757 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999870.98459 | 2117748.83201 | 37.7949256822337 | -122.444447068403 | (37.7949256822337, -122.444447068403) | 13 | 9 | 1 | 57 | 27 | |||
| 68899 | 17832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1977 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004499.0246 | 2115333.9095 | 37.7885578925396 | -122.428261185185 | (37.7885578925396, -122.428261185185) | 13 | 9 | 11 | 28858 | 27 | |||
| 69030 | 124848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 170 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001909.64403 | 2121706.81926 | 37.8059093829805 | -122.4376766249 | (37.8059093829805, -122.4376766249) | 13 | 9 | 1 | 57 | 17 | |||
| 69214 | 101006 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
| 69659 | 99601 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 69691 | 17840 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2017 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004165.4355 | 2115291.459 | 37.7884224532463 | -122.429412324105 | (37.7884224532463, -122.429412324105) | 13 | 9 | 11 | 29490 | 27 | |||
| 69907 | 22615 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
| 69992 | 112618 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | 13 | 9 | 1 | 29490 | 27 | |
| 70175 | 13127 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | 13 | 9 | 1 | 57 | 17 | |||
| 70360 | 124816 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3766 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999641.32764 | 2121440.48851 | 37.8050488765594 | -122.445507296223 | (37.8050488765594, -122.445507296223) | 13 | 9 | 1 | 57 | 17 | |||
| 70903 | 125015 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 675 Marina Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5999793.58079 | 2121546.81135 | 37.8053495010477 | -122.444988056449 | (37.8053495010477, -122.444988056449) | 13 | 9 | 1 | 57 | 17 | |||
| 70953 | 125232 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2330 Octavia St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004617.17505 | 2117205.89536 | 37.7937045773601 | -122.427985852464 | (37.7937045773601, -122.427985852464) | 13 | 9 | 1 | 28858 | 27 | |||
| 71424 | 88458 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 19 | 3x3 | Permit Number 51419 | 5999585.28862 | 2118036.11604 | 37.7956981827846 | -122.445456281295 | (37.7956981827846, -122.445456281295) | 13 | 9 | 1 | 57 | 17 | |
| 71589 | 124778 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000979.24454 | 2118899.59733 | 37.7981485529825 | -122.440694922327 | (37.7981485529825, -122.440694922327) | 13 | 9 | 1 | 57 | 17 | |||
| 71652 | 173717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 614 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004584 | 2110624 | 37.7756304570983 | -122.427631485331 | (37.7756304570983, -122.427631485331) | 7 | 9 | 11 | 28852 | 10 | ||||
| 71781 | 9934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2336 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005029.63249 | 2117730.67065 | 37.7951688031463 | -122.426596098652 | (37.7951688031463, -122.426596098652) | 13 | 9 | 1 | 28858 | 27 | |||
| 72159 | 18271 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1949 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002897.9436 | 2114073.452 | 37.7850062731935 | -122.433710553674 | (37.7850062731935, -122.433710553674) | 13 | 9 | 11 | 29490 | 13 | |||
| 72702 | 124962 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3146 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5999034.70467 | 2119643.30002 | 37.8000796330268 | -122.447477135274 | (37.8000796330268, -122.447477135274) | 13 | 9 | 1 | 57 | 17 | |||
| 72731 | 23482 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2450 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6005868.84657 | 2118854.8733 | 37.7983029872579 | -122.423772257989 | (37.7983029872579, -122.423772257989) | 13 | 9 | 10 | 28858 | 32 | |||
| 72737 | 107590 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2760 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6000109.34681 | 2118076.29285 | 37.7958384005634 | -122.443645838983 | (37.7958384005634, -122.443645838983) | 13 | 9 | 1 | 57 | 17 | |||
| 73188 | 255598 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
| 73191 | 125234 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2330 Octavia St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 6004612.95687 | 2117230.04971 | 37.7937706604294 | -122.428002169785 | (37.7937706604294, -122.428002169785) | 13 | 9 | 1 | 28858 | 27 | |||
| 73268 | 124854 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55 Casa Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001534.02589 | 2121572.74926 | 37.8055198982766 | -122.438966893034 | (37.8055198982766, -122.438966893034) | 13 | 9 | 1 | 57 | 17 | |||
| 73425 | 125001 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001511.47441 | 2120975.96758 | 37.8038800115288 | -122.439002139235 | (37.8038800115288, -122.439002139235) | 13 | 9 | 1 | 57 | 17 | |||
| 73449 | 125062 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 6004572.76191 | 2110559.01794 | 37.7754513965874 | -122.427665729797 | (37.7754513965874, -122.427665729797) | 7 | 9 | 11 | 28852 | 10 | |||
| 73721 | 245834 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 451 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6005238.2394 | 2110581.29 | 37.7755501705578 | -122.425365268748 | (37.7755501705578, -122.425365268748) | 7 | 9 | 11 | 28852 | 10 | |||
| 73722 | 125000 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 145 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001202.99473 | 2121192.09668 | 37.8044558879034 | -122.440085156821 | (37.8044558879034, -122.440085156821) | 13 | 9 | 1 | 57 | 17 | |||
| 73763 | 125197 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2105 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003801.82703 | 2115762.87441 | 37.7896962477432 | -122.43070400478 | (37.7896962477432, -122.43070400478) | 13 | 9 | 1 | 29490 | 27 | |||
| 73770 | 110847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.441103181276 | (37.7945324365719, -122.441103181276) | 13 | 9 | 1 | 57 | 27 | |
| 73787 | 116455 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2728 GREEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | Permit Number 778010 | 5999979 | 2117809 | 37.7950970500966 | -122.444077646155 | (37.7950970500966, -122.444077646155) | 13 | 9 | 1 | 57 | 17 | ||
| 73923 | 249543 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1031 Franklin St | 4 | : | Tree | Private 2 | 20 | Width 4ft | 6006034.95999 | 2113672.91543 | 37.7840840006086 | -122.422828983387 | (37.7840840006086, -122.422828983387) | 7 | 9 | 11 | 28858 | 41 | |||
| 74168 | 124838 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6001766.13786 | 2121465.01579 | 37.8052372944152 | -122.438155916785 | (37.8052372944152, -122.438155916785) | 13 | 9 | 1 | 57 | 17 | |||
| 74818 | 124787 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1650 Green St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005166.63704 | 2118533.31507 | 37.7973804051442 | -122.426179211596 | (37.7973804051442, -122.426179211596) | 13 | 9 | 1 | 57 | 17 | |||
| 74953 | 124829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 22 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001801.25075 | 2121238.5185 | 37.8046173899385 | -122.43801817032 | (37.8046173899385, -122.43801817032) | 13 | 9 | 1 | 57 | 17 | |||
| 75041 | 125238 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007174.46526 | 2113971.94732 | 37.7849692977471 | -122.418907913185 | (37.7849692977471, -122.418907913185) | 7 | 9 | 9 | 28858 | 36 | |||
| 75091 | 125018 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 137 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002823.9951 | 2121486.12437 | 37.8053553592351 | -122.434496584369 | (37.8053553592351, -122.434496584369) | 13 | 9 | 1 | 57 | 17 | |||
| 75101 | 124983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3851 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000562.86837 | 2121578.96302 | 37.8054816564034 | -122.442328154142 | (37.8054816564034, -122.442328154142) | 13 | 9 | 1 | 57 | 17 | |||
| 75102 | 55233 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1983 12:00:00 AM | 24 | 4x5 | Permit Number 20974 | 6001057.82109 | 2118342.00896 | 37.7966220365405 | -122.440383014983 | (37.7966220365405, -122.440383014983) | 13 | 9 | 1 | 57 | 17 | |
| 75315 | 125175 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2655 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6002133.26854 | 2117296.67064 | 37.7938129843468 | -122.43658687231 | (37.7938129843468, -122.43658687231) | 13 | 9 | 1 | 29490 | 27 | |||
| 75565 | 125132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2731 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999973.04689 | 2117760.51196 | 37.794963575153 | -122.444094758959 | (37.794963575153, -122.444094758959) | 13 | 9 | 1 | 57 | 27 | |||
| 75702 | 6256 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1315 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6004614.9344 | 2113276.215 | 37.7829145353129 | -122.427713486832 | (37.7829145353129, -122.427713486832) | 7 | 9 | 11 | 29490 | 41 | |||
| 76018 | 125059 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3027 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005095.64842 | 2120394.27764 | 37.802486118995 | -122.426557432296 | (37.802486118995, -122.426557432296) | 13 | 9 | 1 | 57 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );