Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6305 | 6305 | 52146 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2005 12:00:00 AM | Permit Number 48337 | ||||||||
| 9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 9603 | 9603 | 19972 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 36 | ||||||||
| 11507 | 11507 | 30593 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 13405 | 13405 | 30592 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 180005 | 180005 | 72279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | ||
| 45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
| 109406 | 109406 | 63194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 420 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 23734 | 5984095.68800959 | 2112985.55374836 | 37.78093439601071 | -122.498678978522 | (37.7809343960107, -122.498678978522) | ||
| 135259 | 135259 | 69460 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 446 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 3 | Permit Number 33570 | 5985026.614630001 | 2112867.05169 | 37.7806635770894 | -122.495449750327 | (37.7806635770894, -122.495449750327) | |
| 109207 | 109207 | 21209 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2392X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 125824 | 125824 | 21211 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 143816 | 143816 | 21208 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2392X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 91492 | 91492 | 24700 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6940 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5985447.12642 | 2112543.37928 | 37.77979947939 | -122.493971158415 | (37.77979947939, -122.493971158415) | ||
| 69129 | 69129 | 69449 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 7 | Permit Number 33559 | 5985596.63224 | 2112961.6611 | 37.7809567074922 | -122.493484787172 | (37.7809567074922, -122.493484787172) | |
| 169324 | 169324 | 118185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985597.25903 | 2112945.4232900003 | 37.7809121598048 | -122.493481422073 | (37.7809121598048, -122.493481422073) | |||
| 72842 | 72842 | 69456 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 5 | Permit Number 33566 | 5985607.3929 | 2112736.22477 | 37.7803383536355 | -122.493430946652 | (37.7803383536355, -122.493430946652) | |
| 70320 | 70320 | 181741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985810.6327 | 2106942.082 | 37.7644411641486 | -122.492301073815 | (37.7644411641486, -122.492301073815) | |||
| 146269 | 146269 | 24686 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.77976647962429 | -122.49010635929599 | (37.7797664796243, -122.490106359296) | ||
| 53492 | 53492 | 75980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1989 12:00:00 AM | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.48982895296699 | (37.7797135654944, -122.489828952967) | ||
| 2715 | 2715 | 253166 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.48968039586501 | (37.742306656921, -122.489680395865) | |
| 121744 | 121744 | 107696 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 MORAGA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 166878 | 166878 | 182744 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1769 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986859.8585 | 2103239.7166 | 37.754336768117206 | -122.488400024275 | (37.7543367681172, -122.488400024275) | |||
| 181096 | 181096 | 182748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1789 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986861.6929 | 2103148.806 | 37.754087259353206 | -122.488386999785 | (37.7540872593532, -122.488386999785) | |||
| 65500 | 65500 | 182749 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986862.6162 | 2103130.8030000003 | 37.754037881879 | -122.488382483852 | (37.754037881879, -122.488382483852) | |||
| 35976 | 35976 | 181801 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986905.9682 | 2099586.0566 | 37.744307492185 | -122.487972126615 | (37.744307492185, -122.487972126615) | |||
| 72832 | 72832 | 181803 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1915 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986942.1793 | 2099588.0871 | 37.7443151796952 | -122.487847067129 | (37.7443151796952, -122.487847067129) | |||
| 141691 | 141691 | 112080 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901x SANTIAGO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5986971.0 | 2099566.0 | 37.744256215511896 | -122.487745790198 | (37.7442562155119, -122.487745790198) | |||
| 144808 | 144808 | 112082 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901x SANTIAGO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5986971.0 | 2099566.0 | 37.744256215511896 | -122.487745790198 | (37.7442562155119, -122.487745790198) | |||
| 123759 | 123759 | 38869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | ||
| 120653 | 120653 | 93044 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 155 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5987698.59819 | 2114939.90173 | 37.7865111255347 | -122.486358421479 | (37.7865111255347, -122.486358421479) | ||||
| 126891 | 126891 | 120181 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987742.587230001 | 2115005.98358 | 37.7866951312776 | -122.486211085191 | (37.7866951312776, -122.486211085191) | |||
| 50738 | 50738 | 120183 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987744.35264 | 2114901.48572 | 37.7864083129421 | -122.486197303246 | (37.7864083129421, -122.486197303246) | |||
| 82718 | 82718 | 90488 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 125 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 6 | 3x3 | 5987997.512680001 | 2115126.89685 | 37.7870419790043 | -122.485337990995 | (37.7870419790043, -122.485337990995) | ||
| 51338 | 51338 | 182788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1781 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988111.6274 | 2103184.2484 | 37.754257425098096 | -122.484067075117 | (37.7542574250981, -122.484067075117) | |||
| 74587 | 74587 | 182789 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1785 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988112.4655 | 2103151.9819 | 37.7541688787672 | -122.484061810783 | (37.7541688787672, -122.484061810783) | |||
| 188071 | 188071 | 182790 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988113.3036 | 2103133.9629 | 37.754119452236 | -122.48405759118499 | (37.754119452236, -122.484057591185) | |||
| 172764 | 172764 | 120258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5988366.4287 | 2115019.00218 | 37.7867672160285 | -122.48405372444599 | (37.7867672160285, -122.484053724446) | |||
| 49709 | 49709 | 120248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.786334585774604 | -122.484046777757 | (37.7863345857746, -122.484046777757) | |||
| 176550 | 176550 | 120252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | |||
| 44437 | 44437 | 120251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.48404399839899 | (37.7864004688283, -122.484043998399) | |||
| 63345 | 63345 | 120250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | |||
| 77045 | 77045 | 120249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.786310429345704 | -122.48404330399599 | (37.7863104293457, -122.484043303996) | |||
| 22887 | 22887 | 120259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | |||
| 185841 | 185841 | 120256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.48404121988199 | (37.7866145875471, -122.484041219882) | |||
| 49555 | 49555 | 120257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988368.87318 | 2114954.3645200003 | 37.786589881739104 | -122.484040525506 | (37.7865898817391, -122.484040525506) | |||
| 153635 | 153635 | 120255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988367.99594 | 2114912.99225 | 37.7864762341937 | -122.484040525506 | (37.7864762341937, -122.484040525506) | |||
| 47047 | 47047 | 120253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988369.64092 | 2114933.75275 | 37.7865333323848 | -122.48403635730499 | (37.7865333323848, -122.484036357305) | |||
| 28239 | 28239 | 120254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988369.36546 | 2114920.76145 | 37.7864976459369 | -122.4840363573 | (37.7864976459369, -122.4840363573) | |||
| 39057 | 39057 | 120310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988691.601840001 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | |||
| 154275 | 154275 | 120315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 206 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5988712.81851 | 2113914.04057 | 37.7837534650339 | -122.48277430520001 | (37.7837534650339, -122.4827743052) | |||
| 110346 | 110346 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 138436 | 138436 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 75524 | 75524 | 120438 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5988956.31634 | 2114501.1697400003 | 37.7853797200377 | -122.48197492857099 | (37.7853797200377, -122.481974928571) | |||
| 156985 | 156985 | 65109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 5 | Permit Number 27078 | 5988958.234730001 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | |
| 175706 | 175706 | 64667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 155 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 7 | Permit Number 27077 | 5988959.0752 | 2114316.0403299998 | 37.784871567471704 | -122.48195181759701 | (37.7848715674717, -122.481951817597) | |
| 135886 | 135886 | 65108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 183 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 6 | Permit Number 27075 | 5988968.22756 | 2114128.63613 | 37.7843575407485 | -122.481906421224 | (37.7843575407485, -122.481906421224) | |
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 93217 | 93217 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 51119 | 51119 | 182028 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2209 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988891.7451 | 2106459.406 | 37.7632955122177 | -122.481609125496 | (37.7632955122177, -122.481609125496) | |||
| 139387 | 139387 | 3372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 5951 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989085.57316 | 2113985.01381 | 37.7839700180526 | -122.48148992901301 | (37.7839700180526, -122.481489929013) | |||
| 114129 | 114129 | 101280 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2201 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988947.0 | 2106461.0 | 37.7633031017087 | -122.48141813594201 | (37.7633031017087, -122.481418135942) | ||||
| 73312 | 73312 | 120776 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989252.7771 | 2114825.68271 | 37.7862879782034 | -122.48097304382 | (37.7862879782034, -122.48097304382) | |||
| 149008 | 149008 | 120775 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989253.50277 | 2114844.1258799997 | 37.7863386601165 | -122.48097188408 | (37.7863386601165, -122.48097188408) | |||
| 28532 | 28532 | 120778 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989252.84217 | 2114809.1452099998 | 37.7862425746859 | -122.480971607416 | (37.7862425746859, -122.480971607416) | |||
| 69793 | 69793 | 120774 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989253.85466 | 2114850.93568 | 37.7863573783569 | -122.48097116542499 | (37.7863573783569, -122.480971165425) | |||
| 170056 | 170056 | 120777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5989253.41901 | 2114816.7810299997 | 37.786263574020204 | -122.480970171004 | (37.7862635740202, -122.480970171004) | |||
| 70653 | 70653 | 65118 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 127 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 4 | Permit Number 27088 | 5989266.29156 | 2114491.8349900004 | 37.7853721122289 | -122.480901836159 | (37.7853721122289, -122.480901836159) | |
| 155477 | 155477 | 65116 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 3 | Permit Number 27086 | 5989313.29751 | 2114460.89745 | 37.7852898986689 | -122.480736945877 | (37.7852898986689, -122.480736945877) | |
| 161956 | 161956 | 65112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 367 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 9 | Permit Number 27081 | 5989323.93516 | 2112879.29731 | 37.78094788727989 | -122.48058432391001 | (37.7809478872799, -122.48058432391) | |
| 46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
| 27910 | 27910 | 183007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2440 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.7088 | 2098739.1145 | 37.742135877465294 | -122.478768805014 | (37.7421358774653, -122.478768805014) | |||
| 43050 | 43050 | 83178 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 743 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51518 | 5990037.32656 | 2110290.0684599997 | 37.7738800155956 | -122.477927036337 | (37.7738800155956, -122.477927036337) | |
| 157386 | 157386 | 49548 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2434@ TARAVAL 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | 1 | Permit Number 46439 | 5989857.9655 | 2098790.1552 | 37.742293916006 | -122.47770669165199 | (37.742293916006, -122.477706691652) | ||
| 63407 | 63407 | 49549 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2434@ TARAVAL 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | 3 | Permit Number 46439 | 5989858.6972 | 2098774.0563 | 37.7422497550695 | -122.47770298517 | (37.7422497550695, -122.47770298517) | ||
| 39644 | 39644 | 121918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 434 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5990628.47281 | 2112418.69115 | 37.7797589204997 | -122.47603768167 | (37.7797589204997, -122.47603768167) | |||
| 176231 | 176231 | 43755 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 264 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43391 | 5990896.100380001 | 2113625.86147 | 37.783088990728004 | -122.47520000357201 | (37.783088990728, -122.475200003572) | |
| 127900 | 127900 | 69289 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33361 | 5990665.04614057 | 2102443.50433652 | 37.7523718663796 | -122.47518273070699 | (37.7523718663796, -122.475182730707) | ||
| 137292 | 137292 | 56158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 447 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 8 | Permit Number 12266 | 5990893.795580001 | 2112339.9216299998 | 37.779558022090605 | -122.475114071606 | (37.7795580220906, -122.475114071606) | ||
| 73880 | 73880 | 122099 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 451 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990895.26927 | 2112314.80254 | 37.7794891374062 | -122.47510713931001 | (37.7794891374062, -122.47510713931) | |||
| 174380 | 174380 | 56156 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 12 | Permit Number 12264 | 5990899.19855 | 2112188.99411 | 37.779143929860204 | -122.475084359841 | (37.7791439298602, -122.475084359841) | ||
| 20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 99727 | 99727 | 112868 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 107775 | 107775 | 112864 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | |||
| 109062 | 109062 | 112867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 109983 | 109983 | 112869 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 114300 | 114300 | 112865 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 169460 | 169460 | 56218 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 475 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12339 | 5990899.771790001 | 2112161.89837 | 37.779069565646 | -122.475080398267 | (37.779069565646, -122.475080398267) | ||
| 162268 | 162268 | 56219 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12340 | 5990900.9414099995 | 2112135.93012 | 37.7789983317715 | -122.475074455932 | (37.7789983317715, -122.475074455932) | ||
| 31313 | 31313 | 56220 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 483 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 10 | Permit Number 12342 | 5990901.62894 | 2112114.24855 | 37.7789388399986 | -122.475070494342 | (37.7789388399986, -122.475070494342) | ||
| 34193 | 34193 | 122096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990911.764769999 | 2111862.01127 | 37.778246853274105 | -122.475017013162 | (37.7782468532741, -122.475017013162) | |||
| 135724 | 135724 | 56157 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 474 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 9 | Permit Number 12265 | 5990948.43736 | 2112161.09667 | 37.7790701847482 | -122.474911987504 | (37.7790701847482, -122.474911987504) | ||
| 173179 | 173179 | 122094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 695 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990954.58445 | 2110703.0239 | 37.775067073184296 | -122.474784270445 | (37.7750670731843, -122.474784270445) | |||
| 109609 | 109609 | 60149 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19680 | 5990880.97000409 | 2103694.68949662 | 37.755819804064394 | -122.474527341121 | (37.7558198040644, -122.474527341121) | ||
| 128046 | 128046 | 60143 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1610 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19673 | 5990907.91625844 | 2104426.54438296 | 37.7578308453136 | -122.474487560238 | (37.7578308453136, -122.474487560238) | ||
| 100811 | 100811 | 60145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1622 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19675 | 5990910.59858922 | 2104348.57566212 | 37.757616919266 | -122.474472593844 | (37.757616919266, -122.474472593844) | ||
| 96854 | 96854 | 60150 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19681 | 5990891.54356846 | 2103381.184277 | 37.754959614042 | -122.474467896907 | (37.754959614042, -122.474467896907) | ||
| 45337 | 45337 | 213911 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990895.24857 | 2103389.01356 | 37.754981325851205 | -122.474455655417 | (37.7549813258512, -122.474455655417) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");