trees

292 rows where Supervisor Districts = 9 and qSpecies_id = 53 sorted by rowid descending

✎ 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)
190383 17316 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
190135 15260 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
189650 15279 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1551 MISSION ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007345 2109715.7 37.7732922684508 -122.418016080506 (37.7732922684508, -122.418016080506) 8 2 9 28853 19
189496 255885 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
189256 91128 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
188426 148686 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 13 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010834.41502 2110868.71034 37.7766539412504 -122.406026899245 (37.7766539412504, -122.406026899245) 14 2 9 28853 34
188290 100708 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
187881 94217 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 2 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
187641 17308 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
187371 89021 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51766 6007445.1 2110006.7 37.7740969185595 -122.417690449841 (37.7740969185595, -122.417690449841) 8 2 9 28853 19
186730 120142 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
186566 15267 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1531 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6007476.41024 2109891.28194 37.7737817698767 -122.417573960108 (37.7737817698767, -122.417573960108) 8 2 9 28853 19
186477 113509 Undocumented 4 Ficus nitida :: Laurel Fig 53 318 TURK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008412 2113183 37.7828726439691 -122.414570576408 (37.7828726439691, -122.414570576408) 7 10 9 28852 36
186352 255883 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
186181 251369 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390 06th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
185458 91127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
185238 15310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1650 Mission St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6006887.5781181 2109042.9003069 37.7714191656036 -122.41955062575 (37.7714191656036, -122.41955062575) 8 2 9 28853 19
185169 15159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 13 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7 Private   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
183245 120146 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
183049 111628 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
183025 26841 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 779930 6006975.88726 2110943.04151 37.7766414730488 -122.419379980819 (37.7766414730488, -122.419379980819) 7 9 9 28852 36
182867 120141 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
182731 40355 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 9 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
182718 100710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
182282 32648 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
182181 111804 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
181935 17311 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 77 Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006769.4589066 2109244.8738273 37.7719670827617 -122.419973541884 (37.7719670827617, -122.419973541884) 8 2 9 28853 19
180877 10578 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1005X HARRISON ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x7   6011386 2111037 37.7771468605476 -122.404130641378 (37.7771468605476, -122.404130641378) 14 2 9 28853 34
180679 120134 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
179551 120145 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
177980 27711 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
177069 49259 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
176242 41192 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
176043 111207 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
175879 15105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014344.93761 2116565.97781 37.7924930511311 -122.394281863407 (37.7924930511311, -122.394281863407) 12 2 9 28855 6
175687 17314 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
174749 100263 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
174050 49256 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
173835 17323 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
173445 15262 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007448.14843 2109975.86864 37.774012434525 -122.417677719037 (37.774012434525, -122.417677719037) 8 2 9 28853 19
173344 111211 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
173264 111594 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
172671 49251 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
172014 101769 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
170953 101768 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
170512 94219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 4 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
170466 114281 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
168941 120136 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
168885 48703 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
167657 100264 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
167163 17304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
167113 111806 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
165827 41193 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
165688 120662 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
165464 148687 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 14 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010830.11496 2110873.17046 37.7766659471997 -122.406042088772 (37.7766659471997, -122.406042088772) 14 2 9 28853 34
163880 15107 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014322.84653 2116550.95179 37.7924505652168 -122.394357247259 (37.7924505652168, -122.394357247259) 12 2 9 28855 6
162257 97610 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
162113 108325 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
159363 58908 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 353 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1980 12:00:00 AM 13 3x3 Permit Number 780019 6009109.47745 2109280.29041 37.7721958858688 -122.411881715065 (37.7721958858688, -122.411881715065) 8 2 9 28853 34
158317 111591 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
157267 17313 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
156885 111208 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
156641 15249 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007741.56076 2110251.13936 37.7747847690696 -122.416682257719 (37.7747847690696, -122.416682257719) 8 2 9 28853 34
156149 49237 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 18 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
156118 41200 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
155474 17322 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
155305 102600 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
154414 148689 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 16 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010821.9718 2110882.95558 37.7766923594104 -122.406070948019 (37.7766923594104, -122.406070948019) 14 2 9 28853 34
154035 99243 Undocumented 4 Ficus nitida :: Laurel Fig 53 570 Ellis St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     9 4x4   6008204 2113818 37.784604512923 -122.41533513918 (37.784604512923, -122.41533513918) 7 10 9 28858 36
153446 44127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1455 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2000 12:00:00 AM     Permit Number 43631 6007204.94423628 2110535.86362082 37.7755363583765 -122.418558723581 (37.7755363583765, -122.418558723581) 8 2 9 28853 34
153427 40357 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 10 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
152554 111794 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
152130 101760 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
151649 49289 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
150564 102603 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
150162 111596 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
150160 148684 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 11 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010855.51157 2110848.16765 37.7765987157057 -122.405952472245 (37.7765987157057, -122.405952472245) 14 2 9 28853 34
148917 19373 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     35 4X4   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
148648 101767 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
148523 15253 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007637.14046 2110148.71 37.7744976489686 -122.417036210851 (37.7744976489686, -122.417036210851) 8 2 9 28853 34
148003 95416 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created recoard for tree on 2/28/2011. Tree approx. 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
147296 49297 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
147048 47565 Permitted Site 7 Ficus nitida :: Laurel Fig 53 920 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45425 6011901.71412119 2111593.71793264 37.7787042813354 -122.402385767126 (37.7787042813354, -122.402385767126) 14 2 9 28856 34
145766 101765 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
145539 48701 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
144365 111593 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
144032 49294 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
143636 15150 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 3x3   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143433 15157 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 11 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
141769 15252 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007671.66057 2110183.15551 37.7745941699553 -122.416919239811 (37.7745941699553, -122.416919239811) 8 2 9 28853 34
140527 15263 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2008 12:00:00 AM 12 3x3 Permit Number 51766 6007587.5132074 2110099.4827033 37.7743596907053 -122.417204392502 (37.7743596907053, -122.417204392502) 8 2 9 28853 19
138240 108324 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
138208 95414 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Creating record for 3 ficus trees at this address on 2/28/2011. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
136842 49263 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 17 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
135837 124730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
135772 100261 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
135359 120138 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
134743 107366 Undocumented 4 Ficus nitida :: Laurel Fig 53 851 POST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008079.7 2114773.8 37.7872219209064 -122.415832880524 (37.7872219209064, -122.415832880524) 13 1 9 28858 36
134382 111810 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
132203 48698 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6

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