1,985 rows where qSpecies_id = 83 sorted by TreeID

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)
98774 100361 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1135 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6007562.69285 2118825.76087 37.7983185248271 -122.417908959744 (37.7983185248271, -122.417908959744) 5 1 10 28858 32
59153 100410 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
191489 100411 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
149657 100412 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
137622 100413 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
130051 100414 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
115665 100415 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
60277 101046 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1050 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3 Permit Number 774347 6012049.48691 2119300.00717 37.7998721792109 -122.402416569092 (37.7998721792109, -122.402416569092) 3 1 10 28860 6
68810 101047 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1050 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2014 12:00:00 AM 3 3x3 Permit Number 774347 6012043 2119296 37.799860814363 -122.402438734441 (37.799860814363, -122.402438734441) 3 1 10 28860 6
142718 101280 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 2201 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988947 2106461 37.7633031017087 -122.481418135942 (37.7633031017087, -122.481418135942) 1 8 3 56 35
57088 101338 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 600 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1993 12:00:00 AM 3   Permit Number 32655 6008893.4466 2120790.6495 37.8037884230366 -122.413443168222 (37.8037884230366, -122.413443168222) 3 1 10 308 23
165958 101777 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1700 Yosemite Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014038.07825 2093123.59043 37.7281082970403 -122.393702081811 (37.7281082970403, -122.393702081811) 10 3 8 58 1
73569 102063 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 284 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769726 6006232.8 2098354.9 37.7420354927882 -122.421056527741 (37.7420354927882, -122.421056527741) 2 7 7 28859 2
108602 102143 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 442 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003585 2105673 37.7619796582202 -122.430733882468 (37.7619796582202, -122.430733882468) 15 4 5 28862 3
138349 102144 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 0X Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003601 2105679 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901) 15 4 5 28862 3
59761 102145 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 0X Ford St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003601 2105679 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901) 15 4 5 28862 3
98802 102146 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 0X Ford St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003601 2105679 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901) 15 4 5 28862 3
162075 102168 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 235 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769763 6002117.1 2104495.4 37.75866298043 -122.435726513037 (37.75866298043, -122.435726513037) 2 4 5 28862 3
95737 102169 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 235 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769763 6002117.1 2104495.4 37.75866298043 -122.435726513037 (37.75866298043, -122.435726513037) 2 4 5 28862 3
44923 102179 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 4354 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6002056 2104132 37.7576617009806 -122.435911822312 (37.7576617009806, -122.435911822312) 2 4 5 28862 3
104496 10234 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 47 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/29/2011 12:00:00 AM 3 4x4   6005872.37024 2109570.63288 37.7728109564944 -122.423099801515 (37.7728109564944, -122.423099801515) 7 9 11 28852 10
19495 102487 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2001 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5999337.8085 2111150.0142 37.7767766147896 -122.445817121147 (37.7767766147896, -122.445817121147) 15 5 11 29492 16
11540 102493 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2001 McAllister St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5999461.6709 2111166.2585 37.7768282889466 -122.445389813922 (37.7768282889466, -122.445389813922) 15 5 11 29492 16
105776 102622 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 719 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2014 12:00:00 AM 1   Permit Number 772854 5992851.12865 2110544.54919 37.774741661803 -122.468212234444 (37.774741661803, -122.468212234444) 11 6 2 54 11
80812 102673 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 616 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997561 2108438 37.7692285123205 -122.451767914676 (37.7692285123205, -122.451767914676) 15 5 11 29492 9
183951 102763 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 50X Hill Point Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2013 12:00:00 AM   3x3 Permit Number 769605 5996378.1 2106680.6 37.7643353262738 -122.455732428347 (37.7643353262738, -122.455732428347) 15 5 11 29492 12
146180 102862 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2750X Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       2x2 Permit Number 769980 6000834.2 2116922.3 37.792711153164 -122.441054886769 (37.792711153164, -122.441054886769) 13 6 1 29490 27
34605 10379 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1316 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/1990 12:00:00 AM 18 3X3   5999827.9509 2108872.87214 37.7705521343685 -122.44395792635 (37.7705521343685, -122.44395792635) 15 5 11 29492 9
83164 10381 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1324 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 2X3   5999783.9663 2108832.8405 37.7704397084666 -122.44410719204 (37.7704397084666, -122.44410719204) 15 5 11 29492 9
49749 104043 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1405 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2018 12:00:00 AM 3 3x3 Permit Number 782596 6006090.81059 2119657.40346 37.8005190588724 -122.423061266572 (37.8005190588724, -122.423061266572) 13 9 1 28858 32
114679 10408 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1391 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   5999500.983 2108743.0478 37.7701770128525 -122.445079572577 (37.7701770128525, -122.445079572577) 15 5 11 29492 9
22548 10416 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1399 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   5999442.73592 2108734.00442 37.7701488573322 -122.445280397708 (37.7701488573322, -122.445280397708) 15 5 11 29492 9
160200 10423 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1401 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5999371.8264 2108722.9096 37.7701143458549 -122.44552487423 (37.7701143458549, -122.44552487423) 15 5 11 29492 9
172182 10442 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1500 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5998947.4848 2108705.37768 37.7700419732298 -122.446991399363 (37.7700419732298, -122.446991399363) 15 5 11 29492 9
149929 10443 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1501 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   5998901.98983 2108638.08127 37.7698545950424 -122.447143921289 (37.7698545950424, -122.447143921289) 15 5 11 29492 9
60316 10444 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1508 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/1999 12:00:00 AM 6 3x3   5998873.5099 2108710.5533 37.7700519575457 -122.447247648975 (37.7700519575457, -122.447247648975) 15 5 11 29492 9
168518 104495 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 31 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2013 12:00:00 AM   3x3 Permit Number 769504 6005718.7 2099293 37.7445823088547 -122.422900781394 (37.7445823088547, -122.422900781394) 2 7 5 28859 22
169541 10455 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1555 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   5998706.29238 2108552.28682 37.7696078418555 -122.447814653926 (37.7696078418555, -122.447814653926) 15 5 11 29492 9
138552 10459 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1569 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/1994 12:00:00 AM 25 3X3   5998651.396 2108625.3987 37.7698054506603 -122.448009802562 (37.7698054506603, -122.448009802562) 15 5 11 29492 9
136154 10478 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1653 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   5998139.6149 2108553.6282 37.7695791194599 -122.449774859218 (37.7695791194599, -122.449774859218) 15 5 11 29492 9
86813 104872 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1753 Noe St 1 Hanging basket : Yard Tree Private 2   11/22/2013 12:00:00 AM     Permit Number 770054 6003434.1 2098036.1 37.7410019772539 -122.430710793678 (37.7410019772539, -122.430710793678) 2 7 5 63 7
156061 105537 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2192 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6002561.80287 2118173.8704 37.796245890587 -122.435166876954 (37.796245890587, -122.435166876954) 13 9 1 57 17
166128 10610 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 29 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 6 3X3   6016939.38433 2095525.04578 37.7348630141201 -122.383839208838 (37.7348630141201, -122.383839208838) 10 3 8 58 1
611 10613 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 34 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1993 12:00:00 AM 18 3X3   6016953.5018076 2095595.9312574 37.7350584319022 -122.383795333225 (37.7350584319022, -122.383795333225) 10 3 8 58 1
82901 10614 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 37 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2001 12:00:00 AM 3 3X3   6016916.49156 2095577.99474 37.7350071358711 -122.383922043589 (37.7350071358711, -122.383922043589) 10 3 8 58 1
80387 10617 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 74 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1992 12:00:00 AM 6 3X3   6016731.0735863 2095616.8317798 37.7351035225916 -122.384565809833 (37.7351035225916, -122.384565809833) 10 3 8 58 1
135047 106644 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3294 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2014 12:00:00 AM   3X3 Permit Number 772448 6007856.1 2100992.4 37.7493688530402 -122.415630356523 (37.7493688530402, -122.415630356523) 2 4 7 28859 19
160028 106724 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 421 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     8     6006940.66037 2092543.63058 37.7261189013498 -122.418197053944 (37.7261189013498, -122.418197053944) 9 3 7 309 28
16463 106806 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 167 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4     5996526.1156 2113255.0824 37.7823956347772 -122.455695748043 (37.7823956347772, -122.455695748043) 11 6 1 54 31
155605 106807 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 167 Commonwealth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2     5996526.1156 2113238.8382 37.7823510325114 -122.455694573485 (37.7823510325114, -122.455694573485) 11 6 1 54 31
170535 107696 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2401 MORAGA ST 4 Sidewalk: Property side : Yard Tree Private 2     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884) 1 8 3 56 35
32162 107809 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 174 14TH ST   Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773719 6007550.6 2107982.4 37.7685446055333 -122.417182034417 (37.7685446055333, -122.417182034417) 8 4 7 28853 19
18871 108376 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 995X Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2015 12:00:00 AM 3   Permit Number 775198 6003269.72698 2111024.20368 37.7766548889563 -122.432206462364 (37.7766548889563, -122.432206462364) 15 9 11 29492 10
143035 108403 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 301-307 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773735 6007391.32185 2107918.98153 37.7683615114513 -122.417728469751 (37.7683615114513, -122.417728469751) 8 4 7 28853 19
74916 108404 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 181-199 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773735 6007385 2107936 37.7684078844101 -122.41775154294 (37.7684078844101, -122.41775154294) 8 4 7 28853 19
22366 108443 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 559 05th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773772 5994363.45802 2111716.68858 37.7780472719646 -122.463065881676 (37.7780472719646, -122.463065881676) 11 6 2 54 11
143232 108630 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1469-1471 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772871 6002136.63529 2111543.96358 37.7780177097963 -122.436163356374 (37.7780177097963, -122.436163356374) 15 5 11 29492 41
51623 109438 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 940 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3     6003118.8 2111045.9 37.7767059032045 -122.432730112861 (37.7767059032045, -122.432730112861) 15 9 11 29492 10
56169 109439 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 800x STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 3.5x6.5   6003118 2111045 37.7767033866571 -122.432732815988 (37.7767033866571, -122.432732815988) 15 9 11 29492 10
88877 109440 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 800x STEINER ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 6.5x3.5   6003118 2111045 37.7767033866571 -122.432732815988 (37.7767033866571, -122.432732815988) 15 9 11 29492 10
122316 110361 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1155 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     9     6008381.52689 2115877.48528 37.790269335319 -122.414866763697 (37.790269335319, -122.414866763697) 5 1 10 28858 21
21998 110495 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 230 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003598.79471 2092490.01573 37.7257830144685 -122.429745863482 (37.7257830144685, -122.429745863482) 9 7 6 28861 5
179734 110496 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 234 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003585.89382 2092469.97138 37.7257272466074 -122.429789031845 (37.7257272466074, -122.429789031845) 9 7 6 28861 5
32470 110524 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 995X Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2015 12:00:00 AM 3   Permit Number 775198 6003269.72698 2111024.20368 37.7766548889563 -122.432206462364 (37.7766548889563, -122.432206462364) 15 9 11 29492 10
189548 110940 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1944X FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 3X3   6003020 2115096 37.7878208557656 -122.433361372735 (37.7878208557656, -122.433361372735) 13 9 11 29490 27
70363 111480 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
111847 111483 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
88746 111484 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
149949 111485 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
145895 111487 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
112393 111488 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
168471 111489 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1745 FOLSOM ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
109327 11173 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2717 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6006873.7712695 2121594.1615237 37.8058810553361 -122.420489453273 (37.8058810553361, -122.420489453273) 5 1 1 28858 32
77057 111740 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 498x 11th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5992531.49665 2112146.31797 37.7791212195041 -122.469434516342 (37.7791212195041, -122.469434516342) 11 6 2 54 11
60043 111861 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
51808 111862 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
132862 111863 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
35271 111866 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3399x 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004303 2106535 37.7643871563547 -122.428312038708 (37.7643871563547, -122.428312038708) 8 4 5 28862 3
173748 111867 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3399x 16TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004303 2106535 37.7643871563547 -122.428312038708 (37.7643871563547, -122.428312038708) 8 4 5 28862 3
26224 111868 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3399x 16TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004303 2106535 37.7643871563547 -122.428312038708 (37.7643871563547, -122.428312038708) 8 4 5 28862 3
28645 111869 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3399x 16TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004303 2106535 37.7643871563547 -122.428312038708 (37.7643871563547, -122.428312038708) 8 4 5 28862 3
87366 111870 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3399x 16TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004303 2106535 37.7643871563547 -122.428312038708 (37.7643871563547, -122.428312038708) 8 4 5 28862 3
59486 111906 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
183996 111907 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
118803 111908 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
191471 111909 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
151327 111910 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
172801 112080 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1901x SANTIAGO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5986971 2099566 37.7442562155119 -122.487745790198 (37.7442562155119, -122.487745790198) 1 8 3 29491 35
173228 112082 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1901x SANTIAGO ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5986971 2099566 37.7442562155119 -122.487745790198 (37.7442562155119, -122.487745790198) 1 8 3 29491 35
134947 112164 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 701 MISSION ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011822 2114512 37.7867127527861 -122.4028668317 (37.7867127527861, -122.4028668317) 12 2 9 28853 6
62572 112504 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 601 WILLOW ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/14/2016 10:27:00 AM 3 2x2   6004423 2113018 37.7821946822097 -122.42835909049 (37.7821946822097, -122.42835909049) 7 9 11 29490 41
90740 112843 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1415 EVANS AVE 1 Front Yard : Yard Tree Private 2           6016481 2097724 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432) 10 3 8 58 1
128079 112864 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
149307 112865 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
1477 112866 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
119482 112867 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
100392 112868 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
122755 112869 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
174369 113164 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3902 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5996104.12061 2115248.79576 37.7878456121944 -122.457299932451 (37.7878456121944, -122.457299932451) 11 6 1 54 31
142431 113165 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3902 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5996094.44333 2115248.19615 37.787843410013 -122.457333370439 (37.787843410013, -122.457333370439) 11 6 1 54 31

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