trees

194 rows where Supervisor Districts = 1 and qSpecies_id = 53 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
20994 100049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 768990 6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
85651 100050 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
187091 100051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
179011 100052 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
122731 100106 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114077 100108 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
147848 101072 Undocumented 4 Ficus nitida :: Laurel Fig 53 1828 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004239 2118751 37.7979256371892 -122.429404607028 (37.7979256371892, -122.429404607028) 13 9 1 57 17
15062 102786 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3345 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4.5x6 Permit Number 772480 6003174.4 2119873.2 37.8009465759098 -122.433168646536 (37.8009465759098, -122.433168646536) 13 9 1 57 17
65947 103484 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 9x6   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
100883 103485 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 9x9   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
14328 104230 Undocumented 4 Ficus nitida :: Laurel Fig 53 409 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       14x8   5998587.6 2115205.6 37.787869332154 -122.448704479556 (37.787869332154, -122.448704479556) 13 6 1 54 31
104082 105456 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003203 2116540 37.7917960919718 -122.432831424804 (37.7917960919718, -122.432831424804) 13 9 1 29490 27
179087 105657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
177832 106521 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
72126 106522 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 2 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
172909 106523 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 3 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
193427 106524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 4 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
52557 106525 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 5 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
83449 106526 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 6 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
90878 106915 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772728 5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
119477 106916 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2015 12:00:00 AM 3     5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
186717 107211 Undocumented 4 Ficus nitida :: Laurel Fig 53 2255 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003966.3 2116269.9 37.7910977281266 -122.430171131086 (37.7910977281266, -122.430171131086) 13 9 1 29490 27
105203 107284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2260 JACKSON ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6003354.3 2116979.4 37.7930111519645 -122.432339323402 (37.7930111519645, -122.432339323402) 13 9 1 29490 27
39370 107630 Undocumented 4 Ficus nitida :: Laurel Fig 53 2164 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001495 2119755 37.8005266206576 -122.438971595662 (37.8005266206576, -122.438971595662) 13 9 1 57 17
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
127089 108101 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 3 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
48110 108103 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 5 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
193965 108150 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
177091 108561 Undocumented 4 Ficus nitida :: Laurel Fig 53 141 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995170 2114629.2 37.7860906748156 -122.460486880145 (37.7860906748156, -122.460486880145) 11 6 1 54 11
156467 109326 Undocumented 4 Ficus nitida :: Laurel Fig 53 1624 VALLEJO ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005582.1 2118270.7 37.7966828044962 -122.424722909098 (37.7966828044962, -122.424722909098) 13 9 1 57 17
131050 110659 Undocumented 4 Ficus nitida :: Laurel Fig 53 2393 FILBERT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001559 2118656 37.7975126970015 -122.438671337949 (37.7975126970015, -122.438671337949) 13 9 1 57 17
148171 110926 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2970 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 775246 5999959.8 2116452.8 37.79137218692 -122.444046586367 (37.79137218692, -122.444046586367) 13 6 1 29490 27
47028 110967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2439 WASHINGTON ST   Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003043 2116458 37.7915618650441 -122.433379161821 (37.7915618650441, -122.433379161821) 13 9 1 29490 27
90875 110969 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2475 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6002881.27515757 2116466.21692287 37.7915752502174 -122.433939314763 (37.7915752502174, -122.433939314763) 13 9 1 29490 27
55261 11108 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2022 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007226.47271 2119353.11491 37.799747578786 -122.419109811467 (37.799747578786, -122.419109811467) 5 1 1 28858 32
36964 11109 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2022 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6007225.09879 2119363.63368 37.7997763833106 -122.419115312272 (37.7997763833106, -122.419115312272) 5 1 1 28858 32
155310 11113 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2037 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6007192.03327 2119340.88684 37.7997120641075 -122.41922811701 (37.7997120641075, -122.41922811701) 5 1 1 28858 32
41017 11117 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2054 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6007235.1189832 2119374.3616564 37.7998064039059 -122.419081399975 (37.7998064039059, -122.419081399975) 5 1 1 28858 32
28739 11129 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
58920 11130 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
48350 111430 Undocumented 4 Ficus nitida :: Laurel Fig 53 500X PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999200 2114887 37.7870295394193 -122.446562765799 (37.7870295394193, -122.446562765799) 15 6 1 29490 31
53504 11175 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
135761 11176 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
45310 11177 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
180816 113763 Undocumented 4 Ficus nitida :: Laurel Fig 53 1730 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000110 2114968 37.7873038809733 -122.443420199664 (37.7873038809733, -122.443420199664) 13 6 1 29490 27
94683 113767 Undocumented 4 Ficus nitida :: Laurel Fig 53 1730 BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6000110 2114968 37.7873038809733 -122.443420199664 (37.7873038809733, -122.443420199664) 13 6 1 29490 27
38651 113775 Undocumented 4 Ficus nitida :: Laurel Fig 53 1712 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6000121 2114885 37.7870766118482 -122.443376178084 (37.7870766118482, -122.443376178084) 13 6 1 29490 27
117710 11445 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2191X Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6005072.64937 2117089.85961 37.7934117301419 -122.426401604865 (37.7934117301419, -122.426401604865) 13 9 1 28858 27
51742 11446 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2191X Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005072.64937 2117089.85961 37.7934117301419 -122.426401604865 (37.7934117301419, -122.426401604865) 13 9 1 28858 27
107421 116493 Undocumented 4 Ficus nitida :: Laurel Fig 53 1946 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999967 2115587 37.7889953375883 -122.443959439893 (37.7889953375883, -122.443959439893) 13 6 1 29490 27
155737 117286 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3500 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6002513 2120207 37.8018255621759 -122.435481260672 (37.8018255621759, -122.435481260672) 13 9 1 57 17
122122 127204 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 46 Presidio Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 4ft Permit Number 781066 5998981 2116428 37.7912482078936 -122.447431413946 (37.7912482078936, -122.447431413946) 13 6 1 29490 31
59694 127215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 4 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999937.99418 2117121.61309 37.7932073277938 -122.44417011406 (37.7932073277938, -122.44417011406) 13 9 1 57 27
147341 127216 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 5 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999932.8876 2117120.87416 37.7932050075595 -122.444187729973 (37.7932050075595, -122.444187729973) 13 9 1 57 27
109441 127217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 6 Front Yard : Yard Tree Private 2     7 Width 4ft Permit Number 782825 5999928.92975 2117120.95639 37.7932050075467 -122.444201430254 (37.7932050075467, -122.444201430254) 13 9 1 57 27
76207 127218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 7 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999923.49955 2117118.25276 37.7931972742965 -122.44422002466 (37.7931972742965, -122.44422002466) 13 9 1 57 27
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
175212 13101 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005049.00181 2119804.80205 37.800864933484 -122.426676850993 (37.800864933484, -122.426676850993) 13 9 1 57 17
115585 13186 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2051X Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002574.7502816 2119473.5963948 37.7998153348368 -122.435215088035 (37.7998153348368, -122.435215088035) 13 9 1 57 17
135783 13192 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002431.86629 2119459.61132 37.7997688205881 -122.435708517981 (37.7997688205881, -122.435708517981) 13 9 1 57 17
57812 13193 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002451.4681 2119463.3271 37.7997801365268 -122.435640954547 (37.7997801365268, -122.435640954547) 13 9 1 57 17
186277 13199 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
55002 13200 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
120658 13201 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
115478 13204 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2150 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6001979.60867 2119494.8171 37.7998397874351 -122.437276016047 (37.7998397874351, -122.437276016047) 13 9 1 57 17
90065 13211 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2190 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6001897.52108 2119466.22991 37.7997566277665 -122.437558020868 (37.7997566277665, -122.437558020868) 13 9 1 57 17
193344 13225 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2265 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001602.67751 2119341.9386 37.799398588794 -122.438569375951 (37.799398588794, -122.438569375951) 13 9 1 57 17
41634 13254 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2408 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1993 12:00:00 AM 45 3X3   6000832.23006 2119380.36917 37.7994602521243 -122.441238147567 (37.7994602521243, -122.441238147567) 13 9 1 57 17
77847 13285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2576 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1993 12:00:00 AM 3 3X3   6000068.81033 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799) 13 9 1 57 17
23488 1442 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 144 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   5995540.31731 2115189.6989 37.7876509503315 -122.459246293031 (37.7876509503315, -122.459246293031) 11 6 1 54 31
77688 1668 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
120455 1669 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     13 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
79887 16728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1519 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   5999136.4110982 2112734.4359693 37.7811155269813 -122.446627836224 (37.7811155269813, -122.446627836224) 15 5 1 54 16
177292 16729 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1519 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5999136.4110982 2112734.4359693 37.7811155269813 -122.446627836224 (37.7811155269813, -122.446627836224) 15 5 1 54 16
57729 16813 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2097X O'Farrell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5999009.37837 2112716.355 37.7810586242256 -122.447066002739 (37.7810586242256, -122.447066002739) 15 5 1 54 16
152976 17360 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2298X Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   6005094.42253 2117295.11988 37.7939765536908 -122.426340889125 (37.7939765536908, -122.426340889125) 13 9 1 28858 27
183120 17367 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2308X Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005067.32521 2117488.78546 37.794506778582 -122.426448444628 (37.794506778582, -122.426448444628) 13 9 1 28858 27
38327 17368 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2308X Gough St 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005067.32521 2117488.78546 37.794506778582 -122.426448444628 (37.794506778582, -122.426448444628) 13 9 1 28858 27
184329 173906 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1           6005854.79213 2118988.36383 37.7986687249765 -122.423830387644 (37.7986687249765, -122.423830387644) 13 9 1 28858 32
158341 1760 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3041X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005500.29496 2120778.87447 37.8035649903432 -122.425184535531 (37.8035649903432, -122.425184535531) 13 9 1 28858 17
63549 18006 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2700X Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001006.5406952 2114902.0443839 37.7871738702805 -122.440313633737 (37.7871738702805, -122.440313633737) 13 6 1 29490 27
37406 18007 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700X Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x4   6001006.5406952 2114902.0443839 37.7871738702805 -122.440313633737 (37.7871738702805, -122.440313633737) 13 6 1 29490 27
184950 18016 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2714 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000941.6382972 2114893.0059573 37.7871453575959 -122.440537532879 (37.7871453575959, -122.440537532879) 13 6 1 29490 27
164308 18035 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2807 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000503.4629009 2114781.5023211 37.7868142369045 -122.442045513134 (37.7868142369045, -122.442045513134) 13 6 1 29490 27
110876 18083 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2973 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999723.95099 2114672.94601 37.7864717167835 -122.444734627115 (37.7864717167835, -122.444734627115) 15 6 1 29490 31
105287 18158 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1380X Post St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005557.7830834 2114491.983444 37.7863060232386 -122.424538126694 (37.7863060232386, -122.424538126694) 13 9 1 28858 41
134352 18684 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 165X Richardson Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5999250.42609 2119592.62258 37.7999528116563 -122.446727010779 (37.7999528116563, -122.446727010779) 13 9 1 57 17
107261 18696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 3 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
171543 18697 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 4 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
37162 18698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 5 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
40606 18940 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2770 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6001564.88968 2115697.48907 37.7893897308811 -122.438438883241 (37.7893897308811, -122.438438883241) 13 6 1 29490 27
60447 20241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801X Steiner St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);