trees
1,985 rows where qSpecies_id = 83 sorted by TreeID
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );