1,914 rows where qSpecies_id = 45

View and edit SQL

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)
87 259654 DPW Maintained 1 :: 45 101x Cora St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 DPW Maintained 1 :: 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 DPW Maintained 1 :: 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
113 182915 DPW Maintained 1 :: 45 2711 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981812.2124 2096648.8938 37.7359443944789 -122.505367292654 (37.7359443944789, -122.505367292654) 1 8 3 29491 35
119 184195 DPW Maintained 1 :: 45 1459 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984624.9154 2105245.6219 37.759713770345 -122.49627690204 (37.759713770345, -122.49627690204) 1 8 3 56 35
120 141225 DPW Maintained 1 :: 45 3 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5996479.075 2114520.1031 37.7858663452689 -122.455949967769 (37.7858663452689, -122.455949967769) 11 6 1 54 31
132 182257 DPW Maintained 1 :: 45 1439 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985240.365 2105399.9729 37.7601736080068 -122.494159774452 (37.7601736080068, -122.494159774452) 1 8 3 56 35
141 254165 DPW Maintained 1 :: 45 579 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983759 2111886 37.7778955894485 -122.499762435435 (37.7778955894485, -122.499762435435) 11 6 2 55 26
142 186181 DPW Maintained 1 :: 45 1700 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984741.0761 2103142.2522 37.75394530503 -122.495720014116 (37.75394530503, -122.495720014116) 1 8 3 56 35
144 108797 Undocumented 4 :: 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
146 190658 DPW Maintained 1 :: 45 1461 Fairfax Ave 4 : Tree Private 2     7 Width 3ft   6016241.73559 2097685.48667 37.7407565574799 -122.386401828788 (37.7407565574799, -122.386401828788) 10 3 8 58 1
149 244279 Undocumented 4 :: 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
155 142339 DPW Maintained 1 :: 45 516 Central Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999737.6235 2110265.9409 37.7743719952599 -122.444370497086 (37.7743719952599, -122.444370497086) 15 5 11 29492 16
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
175 184150 DPW Maintained 1 :: 45 1585 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982480.9001 2104357.3743 37.7571490682193 -122.503626084685 (37.7571490682193, -122.503626084685) 1 8 3 56 35
179 113995 DPW Maintained 1 :: 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
185 184541 DPW Maintained 1 :: 45 1706 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984416.199 2103539.5001 37.7550170068332 -122.496872815694 (37.7550170068332, -122.496872815694) 1 8 3 56 35
192 137920 DPW Maintained 1 :: 45 2028 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6002940.7431 2115305.2702 37.7883909617368 -122.433650548643 (37.7883909617368, -122.433650548643) 13 9 1 29490 27
212 138278 DPW Maintained 1 :: 45 2181 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001737.3169 2113910.2795 37.7844923181381 -122.437714255164 (37.7844923181381, -122.437714255164) 13 6 11 29490 13
214 138888 DPW Maintained 1 :: 45 675 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004166.2354 2110619.5066 37.7755944800015 -122.429076315191 (37.7755944800015, -122.429076315191) 7 9 11 28852 10
217 105438 Undocumented 4 :: 45 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002483 2102334 37.7527490702591 -122.434306541099 (37.7527490702591, -122.434306541099) 2 4 5 28862 22
218 181787 DPW Maintained 1 :: 45 2915 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986983.636 2098224.4165 37.740573320949 -122.487603561386 (37.740573320949, -122.487603561386) 1 8 3 29491 35
221 182334 DPW Maintained 1 :: 45 1507 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985257.4301 2104914.9526 37.758842875608 -122.494065007935 (37.758842875608, -122.494065007935) 1 8 3 56 35
224 183657 DPW Maintained 1 :: 45 1490 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981573.7378 2104946.7308 37.7587138957913 -122.506807059304 (37.7587138957913, -122.506807059304) 1 8 3 56 35
229 121402 Undocumented 4 :: 45 346X Duncan St 1 Back Yard : Yard Tree Private 2       3x3   6004011 2099874 37.7460810947058 -122.428847079389 (37.7460810947058, -122.428847079389) 2 7 5 63 22
232 228435 DPW Maintained 1 :: 45 178 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004070 2107898 37.7681164387884 -122.429215116616 (37.7681164387884, -122.429215116616) 7 9 5 28862 3
234 183167 DPW Maintained 1 :: 45 2422 45th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982411.0498 2098597.3573 37.7413295619026 -122.503441142831 (37.7413295619026, -122.503441142831) 1 8 3 29491 35
235 184469 DPW Maintained 1 :: 45 2182 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981423.7042 2100234.3036 37.7457660664858 -122.506976375045 (37.7457660664858, -122.506976375045) 1 8 3 29491 35
242 184584 DPW Maintained 1 :: 45 1750 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984424.998 2103256.5795 37.7542407008981 -122.496821507327 (37.7542407008981, -122.496821507327) 1 8 3 56 35
244 200570 DPW Maintained 1 :: 45 1445 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6016341.8296 2095299.657 37.7342110910182 -122.385889477594 (37.7342110910182, -122.385889477594) 10 3 8 58 1
253 200884 DPW Maintained 1 :: 45 1200 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012817.0471 2107089.1245 37.7663867409086 -122.39890301604 (37.7663867409086, -122.39890301604) 14 3 8 28856 20
257 115298 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
258 139105 DPW Maintained 1 :: 45 1310 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999792.0294 2113376.32 37.7829154028675 -122.444405875371 (37.7829154028675, -122.444405875371) 15 6 1 29490 31
262 141330 DPW Maintained 1 :: 45 1314 HAYES ST 2 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   6001510.5734 2110463.2514 37.7750147569158 -122.438251682494 (37.7750147569158, -122.438251682494) 15 5 11 29492 10
268 247892 DPW Maintained 1 :: 45 1283 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000447.0072 2109223.9761 37.7715514711219 -122.441841814274 (37.7715514711219, -122.441841814274) 15 5 11 29492 9
270 182815 DPW Maintained 1 :: 45 2111 Noriega St 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987460.7639 2102999.1421 37.7537112584365 -122.486304306666 (37.7537112584365, -122.486304306666) 1 8 3 56 35
276 182945 DPW Maintained 1 :: 45 2691 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981809.5051 2096798.8146 37.7363558765881 -122.50538776138 (37.7363558765881, -122.50538776138) 1 8 3 29491 35
279 182423 DPW Maintained 1 :: 45 1539 25th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988365.4024 2104835.4768 37.7588060244513 -122.483310502266 (37.7588060244513, -122.483310502266) 1 8 3 56 35
295 200164 DPW Maintained 1 :: 45 1027 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555) 10 3 8 58 1
296 185842 DPW Maintained 1 :: 45 2000 35th Ave 8 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985421.3197 2101412.6246 37.7492360339251 -122.493240190301 (37.7492360339251, -122.493240190301) 1 8 3 29491 35
299 116945 Undocumented 4 :: 45 3676 23RD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
301 108803 Undocumented 4 :: 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
302 184152 DPW Maintained 1 :: 45 1585 44th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982483.9557 2104316.7349 37.7570376635662 -122.503612507973 (37.7570376635662, -122.503612507973) 1 8 3 56 35
314 184219 DPW Maintained 1 :: 45 3439 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984114.8945 2104934.4274 37.7588294281219 -122.498017803137 (37.7588294281219, -122.498017803137) 1 8 3 56 35
316 245380 DPW Maintained 1 :: 45 3620 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005334.5439 2097112.3285 37.7385729952273 -122.424074069598 (37.7385729952273, -122.424074069598) 2 7 5 28859 2
320 228444 DPW Maintained 1 :: 45 399 Haight St 1 : Tree Private 2     4 Width 3ft   6004268.91864 2109406.82097 37.7722705538615 -122.428634644993 (37.7722705538615, -122.428634644993) 7 9 11 28852 10
325 248307 DPW Maintained 1 :: 45 1323 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999369.7066 2108379.5015 37.7691713129844 -122.445507509409 (37.7691713129844, -122.445507509409) 15 5 11 29492 9
326 228441 DPW Maintained 1 :: 45 419 Haight St 1 : Tree DPW 1   04/08/2008 12:00:00 AM 6 Width 3ft   6004104.36681 2109385.12417 37.7722016657998 -122.429202297052 (37.7722016657998, -122.429202297052) 7 9 11 29492 10
327 182422 DPW Maintained 1 :: 45 1534 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987477.4649 2104817.3887 37.7587046434176 -122.486380033207 (37.7587046434176, -122.486380033207) 1 8 3 56 35
351 182685 DPW Maintained 1 :: 45 1709 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985611.9744 2103558.0646 37.7551379747053 -122.492738908785 (37.7551379747053, -122.492738908785) 1 8 3 56 35
354 141882 DPW Maintained 1 :: 45 1160 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6003839.6945 2112655.4467 37.7811661774464 -122.430351190021 (37.7811661774464, -122.430351190021) 7 9 11 29490 41
360 181895 DPW Maintained 1 :: 45 2366 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5986431.1624 2099136.6325 37.7430457847891 -122.489580839702 (37.7430457847891, -122.489580839702) 1 8 3 29491 35
365 184621 DPW Maintained 1 :: 45 3100x Noriega St 1 Median : Cutout Tree DPW 1     0 Width 0ft   5984373.2194 2102928.6488 37.7533372599652 -122.496976365214 (37.7533372599652, -122.496976365214) 1 8 3 56 35
367 183862 DPW Maintained 1 :: 45 2239 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986357.5018 2099996.4101 37.7454022028518 -122.489898755555 (37.7454022028518, -122.489898755555) 1 8 3 29491 35
370 183768 DPW Maintained 1 :: 45 2295 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5987606.9921 2099698.5467 37.744657229257 -122.485556419265 (37.744657229257, -122.485556419265) 1 8 3 29491 35
373 200940 DPW Maintained 1 :: 45 1515 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008432.2434 2109068.8895 37.7715774111529 -122.414209373869 (37.7715774111529, -122.414209373869) 8 2 9 28853 19
375 115067 DPW Maintained 1 :: 45 70 Coral Rd 7 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
377 142111 DPW Maintained 1 :: 45 36 HEMWAY TER 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5998636.7696 2110968.1942 37.7762373313333 -122.448229118378 (37.7762373313333, -122.448229118378) 15 6 2 29492 16
378 182780 DPW Maintained 1 :: 45 1743 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985620.0055 2103342.2275 37.7545458149545 -122.492695239531 (37.7545458149545, -122.492695239531) 1 8 3 56 35
380 116339 Undocumented 4 :: 45 1400X Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
386 143336 DPW Maintained 1 :: 45 1858 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004106.6848 2118733.7418 37.797870758582 -122.429861223474 (37.797870758582, -122.429861223474) 13 9 1 57 17
388 109369 DPW Maintained 1 :: 45 2061 Hyde St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.7999925365465 -122.419347645872 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
391 104857 DPW Maintained 1 :: 45 2555 46th Ave   Sidewalk: Curb side : Cutout Landscaping Private 2           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124) 1 8 3 29491 35
392 108811 Undocumented 4 :: 45 301-399 University St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
396 182481 DPW Maintained 1 :: 45 1556 36th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5985002.9582 2104611.8375 37.7579957124827 -122.494922727233 (37.7579957124827, -122.494922727233) 1 8 3 56 35
397 253904 DPW Maintained 1 :: 45 3637 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997456 2115038 37.7873443747179 -122.4526074861 (37.7873443747179, -122.4526074861) 11 6 1 54 31
401 183745 DPW Maintained 1 :: 45 2267 32nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5986363.4761 2099812.4858 37.7448975449574 -122.489864573201 (37.7448975449574, -122.489864573201) 1 8 3 29491 35
402 183817 DPW Maintained 1 :: 45 2133 Rivera St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5986490.2175 2100252.0265 37.7461118053863 -122.489458644673 (37.7461118053863, -122.489458644673) 1 8 3 29491 35
404 182349 DPW Maintained 1 :: 45 3125 Kirkham St 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985217.5678 2104973.2387 37.759000580496 -122.494207164319 (37.759000580496, -122.494207164319) 1 8 3 56 35
410 183338 DPW Maintained 1 :: 45 1200 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980889.0479 2106803.3028 37.7637711641625 -122.509312865514 (37.7637711641625, -122.509312865514) 1 8 3 56 35
423 140125 DPW Maintained 1 :: 45 1321 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001271.8045 2112891.6174 37.7816688523257 -122.439251726799 (37.7816688523257, -122.439251726799) 15 5 11 29490 41
426 183962 DPW Maintained 1 :: 45 2158 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5989481.017 2100669.218 37.7474314478739 -122.479147472521 (37.7474314478739, -122.479147472521) 1 8 3 29491 35
427 114621 Undocumented 4 :: 45 2400X Post St 6 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
435 108949 Permitted Site 7 :: 45 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003932.1 2088992 37.7161971007686 -122.428344449747 (37.7161971007686, -122.428344449747) 9 7 6 28861 5
446 182929 DPW Maintained 1 :: 45 2635 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981797.6603 2097141.2975 37.73729554361 -122.505454091008 (37.73729554361, -122.505454091008) 1 8 3 29491 35
452 182004 DPW Maintained 1 :: 45 3220 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5986004.751 2098249.2905 37.7405844772428 -122.490989950641 (37.7405844772428, -122.490989950641) 1 8 3 29491 35
460 182240 DPW Maintained 1 :: 45 1427 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985548.7085 2105482.2958 37.7604176820805 -122.49309944026 (37.7604176820805, -122.49309944026) 1 8 3 56 35
466 116275 Undocumented 4 :: 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
468 121614 Undocumented 4 :: 45 800X Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001168 2102650 37.7535420028484 -122.438876681597 (37.7535420028484, -122.438876681597) 2 4 5 28862 22
484 182121 DPW Maintained 1 :: 45 2516 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988187.7408 2098326.2815 37.7409231701359 -122.483447748483 (37.7409231701359, -122.483447748483) 1 8 3 29491 35
519 259637 DPW Maintained 1 :: 45 95 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3     6010745.67067 2087724.79538 37.7131008096728 -122.404704194453 (37.7131008096728, -122.404704194453) 9 7 8 309 39
532 261313 Permitted Site 7 :: 45 2700 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x40   6000687.88763 2117206.96839 37.7934844433083 -122.441581569821 (37.7934844433083, -122.441581569821) 13 9 1 57 27
534 183705 Undocumented 4 :: 45 3628 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5983226.2116 2105643.5823 37.7607244242532 -122.501143681764 (37.7607244242532, -122.501143681764) 1 8 3 56 35
570 259611 DPW Maintained 1 :: 45 1420 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3     6008434.50928 2087674.99824 37.7128346308013 -122.412688855365 (37.7128346308013, -122.412688855365) 9 7 8 309 39
610 182578 DPW Maintained 1 :: 45 2451 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5988885.5665 2098636.2758 37.7418149236633 -122.481057645938 (37.7418149236633, -122.481057645938) 1 8 3 29491 35
644 182239 DPW Maintained 1 :: 45 1434 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985592.8101 2105449.5872 37.7603304525285 -122.492944506053 (37.7603304525285, -122.492944506053) 1 8 3 56 35
740 105361 Permitted Site 7 :: 45 850 Guerrero St 3 Sidewalk: Property side : Cutout Tree Private 2       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602) 2 4 5 28859 19
758 228462 DPW Maintained 1 :: 45 227 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007175.76045 2107902.73822 37.7683047783783 -122.418472926402 (37.7683047783783, -122.418472926402) 8 4 7 28853 19
771 182161 DPW Maintained 1 :: 45 1634 21st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5989670.2283 2104207.7015 37.757158173162 -122.478751948653 (37.757158173162, -122.478751948653) 1 8 3 56 35
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
905 181988 DPW Maintained 1 :: 45 2838 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987152.1701 2098289.7319 37.740762487887 -122.487025638785 (37.740762487887, -122.487025638785) 1 8 3 29491 35
956 183992 DPW Maintained 1 :: 45 1686 35th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985337.681 2103759.2633 37.7556743678806 -122.493702306752 (37.7556743678806, -122.493702306752) 1 8 3 56 35
1022 182384 DPW Maintained 1 :: 45 1539 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985884.4808 2104746.0177 37.7584156979157 -122.49188396911 (37.7584156979157, -122.49188396911) 1 8 3 56 35
1289 190652 DPW Maintained 1 :: 45 310 Arkansas St 1 : Tree Private 2     8 Width 3ft   6012893.9262 2105541.86403 37.7621425904374 -122.398528520183 (37.7621425904374, -122.398528520183) 10 3 8 28856 29
1416 109762 DPW Maintained 1 :: 45 1801 Scott St 1 Sidewalk: Property side : Cutout Landscaping Private 2       1.5x6.5   6001511.7 2114646.3 37.7865004107291 -122.438547564751 (37.7865004107291, -122.438547564751) 13 6 1 29490 27
1432 228461 Planning Code 138.1 required 2 :: 45 1813 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft Permit Number 782329 6005355.14245 2107219.1964 37.7663252752163 -122.424721643507 (37.7663252752163, -122.424721643507) 8 4 5 28853 19
1482 29956 DPW Maintained 1 :: 45 600 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2007 12:00:00 AM 3 3x3   6003212.3178 2109308.4177 37.7719405092432 -122.432282489737 (37.7719405092432, -122.432282489737) 15 5 11 29492 9
1503 33210 Permitted Site 7 :: 45 80 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.7446507048802 -122.454762009134 (37.7446507048802, -122.454762009134) 1 5 4 59 40

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