891 rows where qSpecies_id = 75 sorted by rowid descending

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)
194152 88171 DPW Maintained 1 Acer rubrum :: Red Maple 75 360 Clementina St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 2 3x3 Permit Number 51186 6011722.12263 2112583.00982 37.78141062014 -122.403076651689 (37.78141062014, -122.403076651689) 6 2 9 28853 34
193868 115735 Significant Tree 6 Acer rubrum :: Red Maple 75 57 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776554 5993777.6 2097002.8 37.7376129769989 -122.464024183823 (37.7376129769989, -122.464024183823) 1 8 4 59 40
193594 256211 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 5 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
193577 189079 DPW Maintained 1 Acer rubrum :: Red Maple 75 1047 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010221.55971 2109034.74016 37.771583988945 -122.408017589961 (37.771583988945, -122.408017589961) 14 2 9 28853 34
193555 123077 DPW Maintained 1 Acer rubrum :: Red Maple 75 723 12th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992233.23043 2110491.18489 37.774559431962 -122.470345763786 (37.774559431962, -122.470345763786) 11 6 2 54 11
192417 28679 Permitted Site 7 Acer rubrum :: Red Maple 75 3125X San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 2X3   6011481.7390123 2092091.2460015 37.7251313079457 -122.402466923949 (37.7251313079457, -122.402466923949) 10 3 7 309 28
192151 220471 DPW Maintained 1 Acer rubrum :: Red Maple 75 100 Alemany Blvd 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009494.82238 2095997.42417 37.7357457202871 -122.4096110906 (37.7357457202871, -122.4096110906) 10 7 7 28859 2
192107 187922 DPW Maintained 1 Acer rubrum :: Red Maple 75 48 Minna St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013074.69793 2115022.06537 37.7881831410762 -122.398568572402 (37.7881831410762, -122.398568572402) 12 2 9 28855 6
191487 53153 Permitted Site 7 Acer rubrum :: Red Maple 75 1397@ JENNINGS Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49077 6016165.18448304 2093562.93446239 37.7294326204666 -122.386379154297 (37.7294326204666, -122.386379154297) 10 3 8 58 1
191156 112596 DPW Maintained 1 Acer rubrum :: Red Maple 75 1200x Divisadero St 6 Median : Cutout Tree DPW 1     3 3x3   6001324.7675 2112728.8365 37.7812249111251 -122.439056830439 (37.7812249111251, -122.439056830439) 15 5 11 29490 41
191096 29063 Permitted Site 7 Acer rubrum :: Red Maple 75 1000X McAllister St 2 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   12/15/2005 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
191014 122700 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 2895 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.76794 37.7253343641976 -122.402569107292 (37.7253343641976, -122.402569107292) 10 3 7 309 28
190700 22539 Permitted Site 7 Acer rubrum :: Red Maple 75 1441X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2006 12:00:00 AM 3 3X6   6002335.85354 2093628.68187 37.728837937275 -122.434193118021 (37.728837937275, -122.434193118021) 9 7 6 28861 25
190666 86614 DPW Maintained 1 Acer rubrum :: Red Maple 75 1070 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/03/2011 12:00:00 AM 3 3x3   6010177 2109056 37.7716398686135 -122.4081732249 (37.7716398686135, -122.4081732249) 14 2 9 28853 34
190387 203403 DPW Maintained 1 Acer rubrum :: Red Maple 75 155 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 8ft   5994381.0014 2096518.06805 37.736316779897 -122.461902813967 (37.736316779897, -122.461902813967) 9 8 4 59 40
190217 175130 DPW Maintained 1 Acer rubrum :: Red Maple 75 10 Watt Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000121.60352 2086651.00774 37.7095529054216 -122.441347441633 (37.7095529054216, -122.441347441633) 9 7 6 28861 5
189983 1004 Permitted Site 7 Acer rubrum :: Red Maple 75 1810X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2006 12:00:00 AM 3 3X3   6001283.16417 2091702.46996 37.7234891944335 -122.437694433548 (37.7234891944335, -122.437694433548) 9 7 6 28861 25
189869 187863 DPW Maintained 1 Acer rubrum :: Red Maple 75 1000 22nd St 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6014779.35542 2103919.85891 37.7577937720836 -122.391894064084 (37.7577937720836, -122.391894064084) 10 3 8 28856 29
189796 30769 DPW Maintained 1 Acer rubrum :: Red Maple 75 1642 Wallace Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 7   Permit Number 34649 6014556.9626 2093085.2912 37.7280319553097 -122.391905589486 (37.7280319553097, -122.391905589486) 10 3 8 58 1
189783 2366 DPW Maintained 1 Acer rubrum :: Red Maple 75 2500 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6009707.81579 2102741.7783 37.7542761719147 -122.409350492245 (37.7542761719147, -122.409350492245) 2 4 7 28859 19
189291 256552 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 1 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:54:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
188501 187955 DPW Maintained 1 Acer rubrum :: Red Maple 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6014803.46542 2114565.35002 37.7870252657357 -122.392555322966 (37.7870252657357, -122.392555322966) 6 2 9 28855 6
188463 115734 Significant Tree 6 Acer rubrum :: Red Maple 75 55 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 776555 5993732.7 2097034 37.7376960566374 -122.464181687663 (37.7376960566374, -122.464181687663) 1 8 4 59 40
188009 187883 DPW Maintained 1 Acer rubrum :: Red Maple 75 1600 Indiana St 20 : Tree Private 2     3 Width 3ft   6015144.84488 2100499.87807 37.7484235126495 -122.390391088302 (37.7484235126495, -122.390391088302) 10 3 8 58 1
187666 220431 DPW Maintained 1 Acer rubrum :: Red Maple 75 1650 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006511.20977 2099774.83296 37.7459499992956 -122.420194625406 (37.7459499992956, -122.420194625406) 2 7 7 28859 2
187602 220482 DPW Maintained 1 Acer rubrum :: Red Maple 75 3135 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008165.93149 2102089.85128 37.7523996186474 -122.41463660112 (37.7523996186474, -122.41463660112) 2 4 7 28859 19
187396 189067 DPW Maintained 1 Acer rubrum :: Red Maple 75 521 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6013772.20207 2112425.85547 37.7810933806993 -122.395973304322 (37.7810933806993, -122.395973304322) 6 2 9 28856 34
186559 251267 DPW Maintained 1 Acer rubrum :: Red Maple 75 1174 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009753 2108692 37.7706166587255 -122.409614176745 (37.7706166587255, -122.409614176745) 8 2 9 28853 34
186343 141990 DPW Maintained 1 Acer rubrum :: Red Maple 75 780 FULTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004028.4702 2111508.2869 37.7780270522314 -122.429616280333 (37.7780270522314, -122.429616280333) 7 9 11 28852 41
186332 121541 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
186328 247510 DPW Maintained 1 Acer rubrum :: Red Maple 75 400x Divisadero St 7 Median : Cutout Tree DPW 1     3 Width 0ft   6001703.2636 2110010.3317 37.7737821102395 -122.437552684593 (37.7737821102395, -122.437552684593) 15 5 11 29492 10
186116 187908 DPW Maintained 1 Acer rubrum :: Red Maple 75 167 Jessie St 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012100.15122 2114661.96833 37.7871400579 -122.401915035175 (37.7871400579, -122.401915035175) 12 2 9 28855 6
185836 52844 DPW Maintained 1 Acer rubrum :: Red Maple 75 50 Lansing St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2006 12:00:00 AM 5 3x3 Permit Number 48860 6014342.2793 2114200.39615 37.7859975636787 -122.394125376504 (37.7859975636787, -122.394125376504) 6 2 9 28855 6
185429 28680 DPW Maintained 1 Acer rubrum :: Red Maple 75 3125X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   07/23/2014 12:00:00 AM 3 2x3   6011481.7390123 2092091.2460015 37.7251313079457 -122.402466923949 (37.7251313079457, -122.402466923949) 10 3 7 309 28
185419 220426 DPW Maintained 1 Acer rubrum :: Red Maple 75 1501 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009442.98316 2107699.97849 37.7678754204423 -122.410616467889 (37.7678754204423, -122.410616467889) 8 4 8 28853 19
185403 24865 DPW Maintained 1 Acer rubrum :: Red Maple 75 2658 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/11/2000 12:00:00 AM 8 3X3   6011093.9148591 2093183.5451124 37.7281088761684 -122.403884427694 (37.7281088761684, -122.403884427694) 10 3 7 309 28
185206 247517 DPW Maintained 1 Acer rubrum :: Red Maple 75 250x Divisadero St 2 Median : Cutout Tree DPW 1     3 Width 0ft   6001820.5087 2109214.383 37.771603298669 -122.437090117747 (37.771603298669, -122.437090117747) 15 5 11 29492 9
184236 100774 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
183937 220478 DPW Maintained 1 Acer rubrum :: Red Maple 75 211 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6008820.95976 2097493.32849 37.7398153647742 -122.412046587806 (37.7398153647742, -122.412046587806) 10 7 7 28859 2
183750 203414 DPW Maintained 1 Acer rubrum :: Red Maple 75 95 Yerba Buena Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993945.56402 2096868.34313 37.7372534705646 -122.463433702031 (37.7372534705646, -122.463433702031) 1 8 4 59 40
183637 220465 DPW Maintained 1 Acer rubrum :: Red Maple 75 1900 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009493.16635 2105815.19005 37.7627030371354 -122.410309795471 (37.7627030371354, -122.410309795471) 8 4 7 28859 19
183604 189082 DPW Maintained 1 Acer rubrum :: Red Maple 75 320 Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011829.14154 2112689.69375 37.7817095251229 -122.402713920937 (37.7817095251229, -122.402713920937) 6 2 9 28853 34
183217 28142 DPW Maintained 1 Acer rubrum :: Red Maple 75 515 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/2005 12:00:00 AM 3 3X3   6007045.3834675 2097893.0996556 37.7408132650395 -122.418214132589 (37.7408132650395, -122.418214132589) 2 7 7 28859 2
182793 861 DPW Maintained 1 Acer rubrum :: Red Maple 75 400X Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/2013 12:00:00 AM 3 4x4   6008036.03862 2095018.0701 37.7329747750588 -122.414585408098 (37.7329747750588, -122.414585408098) 2 7 7 28859 2
182498 96284 DPW Maintained 1 Acer rubrum :: Red Maple 75 3237 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM 1 2x2 Permit Number 58767 6011926.62111 2090638.16357 37.7211662664813 -122.400826962515 (37.7211662664813, -122.400826962515) 10 7 8 309 28
182457 115738 Significant Tree 6 Acer rubrum :: Red Maple 75 95x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
182365 187869 DPW Maintained 1 Acer rubrum :: Red Maple 75 1600 Indiana St 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 7ft   6015103.96021 2100930.78351 37.7496044205169 -122.390562573713 (37.7496044205169, -122.390562573713) 10 3 8 58 1
181942 203404 DPW Maintained 1 Acer rubrum :: Red Maple 75 155 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 8ft   5994396.0657 2096501.56524 37.7362723344984 -122.461849534529 (37.7362723344984, -122.461849534529) 9 8 4 59 40
181572 255557 Undocumented 4 Acer rubrum :: Red Maple 75 100x Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013542 2115679 37.7900129533755 -122.396997853926 (37.7900129533755, -122.396997853926) 12 2 9 28855 6
180842 140747 DPW Maintained 1 Acer rubrum :: Red Maple 75 1300x DIVISADERO ST 7 Median : Cutout Tree DPW 1     3 Width 0ft   6001275.0195 2113083.841 37.7821968322814 -122.439254386463 (37.7821968322814, -122.439254386463) 15 5 11 29490 41
180731 189077 DPW Maintained 1 Acer rubrum :: Red Maple 75 1047 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010192.31636 2109010.06883 37.7715146098343 -122.408117004595 (37.7715146098343, -122.408117004595) 14 2 9 28853 34
180466 220498 DPW Maintained 1 Acer rubrum :: Red Maple 75 217 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM 8 Width 3ft Permit Number 11470 6001117.07632 2105053.576 37.7601387417168 -122.43922504972 (37.7601387417168, -122.43922504972) 2 4 5 28862 3
180160 24873 DPW Maintained 1 Acer rubrum :: Red Maple 75 2585 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2015 12:00:00 AM 5 3x3   6011029.3172 2093570.939 37.7291689698102 -122.404134997931 (37.7291689698102, -122.404134997931) 10 3 7 309 28
180115 9750 DPW Maintained 1 Acer rubrum :: Red Maple 75 688X McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/25/2006 12:00:00 AM 3 3x3   6005981.3683502 2112123.5425617 37.7798267784404 -122.422904237561 (37.7798267784404, -122.422904237561) 7 9 11 28852 41
180085 14857 DPW Maintained 1 Acer rubrum :: Red Maple 75 1365 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/1992 12:00:00 AM 3 3x3   6002635.4903 2111607.9304 37.7782216761893 -122.434442215691 (37.7782216761893, -122.434442215691) 15 5 11 29492 41
180032 187926 DPW Maintained 1 Acer rubrum :: Red Maple 75 11 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013589.1856 2115211.48481 37.788731892112 -122.396801804765 (37.788731892112, -122.396801804765) 12 2 9 28855 6
179843 49216 Permitted Site 7 Acer rubrum :: Red Maple 75 500 Howard St 28 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
179788 187861 DPW Maintained 1 Acer rubrum :: Red Maple 75 1000 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6014851.37518 2103923.26798 37.7578071306235 -122.391645226173 (37.7578071306235, -122.391645226173) 10 3 8 28856 29
179773 220441 DPW Maintained 1 Acer rubrum :: Red Maple 75 2601 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009797.09758 2102115.80725 37.7525623968437 -122.408997567676 (37.7525623968437, -122.408997567676) 2 4 7 28859 19
179722 8242 Permitted Site 7 Acer rubrum :: Red Maple 75 1500X Galvez Ave 21 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 3 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 10 3 8 58 1
179705 255411 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
179388 220462 DPW Maintained 1 Acer rubrum :: Red Maple 75 1890 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009480.11253 2106070.95534 37.7634045784729 -122.410373004307 (37.7634045784729, -122.410373004307) 8 4 7 28859 19
179132 115753 Significant Tree 6 Acer rubrum :: Red Maple 75 135x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776552 5994185.89401 2096656.23912 37.7366849291808 -122.46258739592 (37.7366849291808, -122.46258739592) 9 8 4 59 40
179049 24854 DPW Maintained 1 Acer rubrum :: Red Maple 75 2442 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/11/2015 12:00:00 AM 5 3x3   6010724.9783872 2094386.6708818 37.7313917885461 -122.405244548084 (37.7313917885461, -122.405244548084) 10 3 7 309 28
178881 187889 DPW Maintained 1 Acer rubrum :: Red Maple 75 1799 Indiana St 3 : Tree Private 2     3 Width 5ft   6015203.04299 2100298.1861 37.7478729368857 -122.390175750107 (37.7478729368857, -122.390175750107)   3 8 58 1
178516 220411 DPW Maintained 1 Acer rubrum :: Red Maple 75 1504 Bryant St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009388.71104 2107693.51126 37.7678546200096 -122.410803732829 (37.7678546200096, -122.410803732829) 8 4 7 28853 19
178431 220458 DPW Maintained 1 Acer rubrum :: Red Maple 75 1801 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009537.43524 2106105.46914 37.7635025587051 -122.410177179658 (37.7635025587051, -122.410177179658) 8 4 8 28859 19
178413 203410 DPW Maintained 1 Acer rubrum :: Red Maple 75 1945 08th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   5993793.04129 2102233.18002 37.7519751701323 -122.464350430425 (37.7519751701323, -122.464350430425) 1 8 4 29491 12
178102 255413 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
177710 112594 DPW Maintained 1 Acer rubrum :: Red Maple 75 1200M Divisadero St 4 Median : Cutout Tree DPW 1     3 3x3   6001343.2115 2112635.4321 37.7809694958311 -122.438986327521 (37.7809694958311, -122.438986327521) 15 5 11 29490 41
177362 220422 DPW Maintained 1 Acer rubrum :: Red Maple 75 1601 Bryant St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009459.04708 2107423.88753 37.7671182389304 -122.410541405965 (37.7671182389304, -122.410541405965) 8 4 8 28853 19
177311 115751 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
177290 203400 DPW Maintained 1 Acer rubrum :: Red Maple 75 34 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993596.06359 2097068.49274 37.7377828888614 -122.464656605522 (37.7377828888614, -122.464656605522) 1 8 4 59 40
177261 189091 DPW Maintained 1 Acer rubrum :: Red Maple 75 1433 Galvez Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6016333.58663 2097354.23847 37.739852101202 -122.38606115391 (37.739852101202, -122.38606115391) 10 3 8 58 1
176971 256553 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 2 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
176779 86687 DPW Maintained 1 Acer rubrum :: Red Maple 75 833 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2007 12:00:00 AM 3 3x3   6011571.17232 2110322.10121 37.7751942579517 -122.403439761046 (37.7751942579517, -122.403439761046) 14 2 9 28853 34
176715 187873 DPW Maintained 1 Acer rubrum :: Red Maple 75 1600 Indiana St 9 : Tree Private 2     3 Width 3ft   6015126.80958 2100859.52415 37.7494100248665 -122.390478580644 (37.7494100248665, -122.390478580644) 10 3 8 58 1
176375 88169 DPW Maintained 1 Acer rubrum :: Red Maple 75 360 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 2 3x3 Permit Number 51186 6011742.09911 2112601.7739 37.7814632574728 -122.403008862566 (37.7814632574728, -122.403008862566) 6 2 9 28853 34
176012 189078 DPW Maintained 1 Acer rubrum :: Red Maple 75 1047 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010207.59565 2109022.90661 37.7715507149119 -122.40806505798 (37.7715507149119, -122.40806505798) 14 2 9 28853 34
175886 2424 DPW Maintained 1 Acer rubrum :: Red Maple 75 2843 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/27/1994 12:00:00 AM 3 3X3   6009873.38674 2100822.77631 37.7490162935621 -122.408642536922 (37.7490162935621, -122.408642536922) 2 4 7 28859 19
175776 256557 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 6 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:44:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
175632 88151 Permitted Site 7 Acer rubrum :: Red Maple 75 300X Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 770961 6012270 2112782 37.7819875812332 -122.401195237476 (37.7819875812332, -122.401195237476) 6 2 9 28856 34
175622 92757 Permitted Site 7 Acer rubrum :: Red Maple 75 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5
175588 220496 DPW Maintained 1 Acer rubrum :: Red Maple 75 3953 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003484.16047 2101832.5449 37.7514289677954 -122.430808566285 (37.7514289677954, -122.430808566285) 2 4 5 28862 22
175063 87445 DPW Maintained 1 Acer rubrum :: Red Maple 75 2413X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM   3x3   5999221.04782 2088973.52313 37.7158786645875 -122.444626724129 (37.7158786645875, -122.444626724129) 9 7 6 28861 25
173811 220425 DPW Maintained 1 Acer rubrum :: Red Maple 75 1525 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009445.91202 2107658.57784 37.7677619080162 -122.410603413314 (37.7677619080162, -122.410603413314) 8 4 8 28853 19
173673 92758 Permitted Site 7 Acer rubrum :: Red Maple 75 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5
173604 137750 DPW Maintained 1 Acer rubrum :: Red Maple 75 1000x DIVISADERO ST 7 Median : Cutout Tree DPW 1     3 Width 0ft   6001422.0638 2112046.2398 37.779356209409 -122.43867130831 (37.779356209409, -122.43867130831) 15 5 11 29490 41
172496 28285 DPW Maintained 1 Acer rubrum :: Red Maple 75 1010 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/28/2003 12:00:00 AM 3 3x3   6004371.7708 2102969.95862 37.7546022894831 -122.427820139789 (37.7546022894831, -122.427820139789) 2 4 5 28862 22
172484 256197 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 2 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
172086 247518 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Divisadero St 7 Median : Cutout Tree DPW 1     3 Width 0ft   6001762.8451 2109678.405 37.7728741096846 -122.437322810858 (37.7728741096846, -122.437322810858) 15 5 11 29492 9
171416 189068 DPW Maintained 1 Acer rubrum :: Red Maple 75 521 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013786.48532 2112440.07138 37.7811332089813 -122.395924887534 (37.7811332089813, -122.395924887534) 6 2 9 28856 34
170997 141591 DPW Maintained 1 Acer rubrum :: Red Maple 75 700x DIVISADERO ST 7 Median : Cutout Tree DPW 1     2 Width 0ft   6001556.326 2111042.9577 37.776609086888 -122.438134950627 (37.776609086888, -122.438134950627) 15 5 11 29492 10
170916 220428 DPW Maintained 1 Acer rubrum :: Red Maple 75 1401 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009431.86283 2107936.52181 37.7685242902996 -122.410671638589 (37.7685242902996, -122.410671638589) 8 4 8 28853 19
170785 57791 DPW Maintained 1 Acer rubrum :: Red Maple 75 360 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/1977 12:00:00 AM 2   Permit Number 16718 6011755.44922 2112615.88032 37.7815027359001 -122.402963669841 (37.7815027359001, -122.402963669841) 6 2 9 28853 34
170547 220427 DPW Maintained 1 Acer rubrum :: Red Maple 75 1501 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009439.69021 2107723.53455 37.7679399153267 -122.410629521551 (37.7679399153267, -122.410629521551) 8 4 8 28853 19
170529 187887 DPW Maintained 1 Acer rubrum :: Red Maple 75 1798 Indiana St 3 : Tree Private 2     3 Width 5ft   6015168.3741 2100272.0996 37.7477993858291 -122.390293812223 (37.7477993858291, -122.390293812223)   3 8 58 1
170084 220412 DPW Maintained 1 Acer rubrum :: Red Maple 75 1650 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009419.37169 2107143.66771 37.766346595437 -122.410658846644 (37.766346595437, -122.410658846644) 8 4 7 28853 19
169897 137762 DPW Maintained 1 Acer rubrum :: Red Maple 75 1000x DIVISADERO ST 2 Median : Cutout Tree DPW 1     3 Width 0ft   6001439.6617 2111903.7642 37.7789660085719 -122.438600218498 (37.7789660085719, -122.438600218498) 15 5 11 29490 41
169594 175140 DPW Maintained 1 Acer rubrum :: Red Maple 75 199 Hamilton St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6009153.39783 2093543.69822 37.7289891767022 -122.41061831061 (37.7289891767022, -122.41061831061) 9 3 7 309 28

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