Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20520 | 20520 | 10173 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1037 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005774.28865 | 2102689.4092599996 | 37.75391120633721 | -122.422949914307 | (37.7539112063372, -122.422949914307) | ||
| 17919 | 17919 | 28633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1039 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 3 | 3X3 | 5996629.3483 | 2091727.1978 | 37.7232913778043 | -122.45378352969401 | (37.7232913778043, -122.453783529694) | ||
| 146929 | 146929 | 42195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1045 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42471 | 6010370.94214 | 2109173.76071 | 37.771974069876705 | -122.407510668177 | (37.7719740698767, -122.407510668177) | |
| 8662 | 8662 | 52583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1047 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2006 12:00:00 AM | 4 | 3x3 | Permit Number 48677 | 6009673.58749 | 2117095.63602 | 37.7936865972027 | -122.41048236278499 | (37.7936865972027, -122.410482362785) | |
| 143658 | 143658 | 57355 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1048 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51822 | 6003777.0368564 | 2102155.772975 | 37.7523330655121 | -122.42981881773198 | (37.7523330655121, -122.429818817732) | ||
| 31342 | 31342 | 214854 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992461.71045 | 2106577.38517 | 37.7638263910912 | -122.46927048734501 | (37.7638263910912, -122.469270487345) | |||
| 52787 | 52787 | 68366 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | 6x4 | Permit Number 32187 | 6003399.15519 | 2094463.9674799999 | 37.731191735989206 | -122.43057679118999 | (37.7311917359892, -122.43057679119) |
| 20742 | 20742 | 4833 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | 3 | 3X3 | 6006343.81219 | 2097681.02702 | 37.7401914459849 | -122.420624856565 | (37.7401914459849, -122.420624856565) | ||
| 171154 | 171154 | 241955 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006363.59253 | 2098203.7151099998 | 37.7416277451281 | -122.42059355834299 | (37.7416277451281, -122.420593558343) | |||
| 55091 | 55091 | 241541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004710.348619999 | 2097237.45909 | 37.738881313620794 | -122.42624114523998 | (37.7388813136208, -122.42624114524) | |||
| 179576 | 179576 | 241543 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004772.01507 | 2097243.72781 | 37.7389020115256 | -122.42602837732099 | (37.7389020115256, -122.426028377321) | |||
| 187962 | 187962 | 241542 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004746.05114 | 2097239.88547 | 37.738889993882395 | -122.426117875136 | (37.7388899938824, -122.426117875136) | |||
| 94529 | 94529 | 28487 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1054 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2003 12:00:00 AM | 5 | 3X3 | 6005697.2949219 | 2102826.9691831 | 37.7542845691786 | -122.423225954594 | (37.7542845691786, -122.423225954594) | ||
| 7561 | 7561 | 2191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1059 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1998 12:00:00 AM | 6 | 4X4 | 6000860.0298 | 2112380.5159 | 37.780242057456704 | -122.440639597689 | (37.7802420574567, -122.440639597689) | ||
| 82368 | 82368 | 31007 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34781 | 6001462.17793128 | 2086756.21041895 | 37.7099180463866 | -122.43672172056601 | (37.7099180463866, -122.436721720566) | ||
| 110642 | 110642 | 102285 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6000567.8 | 2102477.2 | 37.7530333697051 | -122.44093990264099 | (37.7530333697051, -122.440939902641) | |||
| 151008 | 151008 | 241463 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000582.9390199995 | 2102474.82919 | 37.7530277222622 | -122.440887379058 | (37.7530277222622, -122.440887379058) | |||
| 27501 | 27501 | 198028 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010225.17287 | 2110701.2793 | 37.7761601208299 | -122.40812264516 | (37.7761601208299, -122.40812264516) | |||
| 186238 | 186238 | 66350 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50525 | 6000670.661119999 | 2093317.15683 | 37.727887909175294 | -122.439927459785 | (37.7278879091753, -122.439927459785) | |
| 83812 | 83812 | 47246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 95926 | 95926 | 47247 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 96087 | 96087 | 47244 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 103547 | 103547 | 47245 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 107163 | 107163 | 47250 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 108910 | 108910 | 47249 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 59879 | 59879 | 139633 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1061 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001386.3726 | 2112101.5074 | 37.779505929770295 | -122.438798740374 | (37.7795059297703, -122.438798740374) | |||
| 18646 | 18646 | 5581 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1061 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005153.1959 | 2102184.2823799998 | 37.752489179437205 | -122.425061862427 | (37.7524891794372, -122.425061862427) | |||
| 104777 | 104777 | 3759 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1062 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012453.5755993 | 2103020.9691678 | 37.755196225865895 | -122.39987450779499 | (37.7551962258659, -122.399874507795) | |||
| 21932 | 21932 | 23051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1062 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1991 12:00:00 AM | 18 | 3x3 | 6006317.26236 | 2103381.75726 | 37.755842857466504 | -122.421121338081 | (37.7558428574665, -122.421121338081) | ||
| 178445 | 178445 | 241705 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1062 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006315.68774 | 2103366.12546 | 37.755799847393604 | -122.42112567373199 | (37.7557998473936, -122.421125673732) | |||
| 4721 | 4721 | 253670 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 4736 | 4736 | 253671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 183271 | 183271 | 34939 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1064 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1997 12:00:00 AM | 6 | Permit Number 38536 | 6011885.96785 | 2103445.77889 | 37.75633099959 | -122.401867334221 | (37.75633099959, -122.401867334221) | ||
| 170830 | 170830 | 214993 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1065 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5995546.00415 | 2098060.57386 | 37.740619122184604 | -122.457986535363 | (37.7406191221846, -122.457986535363) | |||
| 121283 | 121283 | 241696 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1066 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005701.12412 | 2102785.49645 | 37.7541709107695 | -122.423209764426 | (37.7541709107695, -122.423209764426) | |||
| 163939 | 163939 | 46311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1066 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2002 12:00:00 AM | 6 | Permit Number 44566 | 6013661.4196 | 2089907.6052 | 37.7192569100927 | -122.394779083836 | (37.7192569100927, -122.394779083836) | ||
| 44096 | 44096 | 183399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 107 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986713.4642 | 2097150.5234 | 37.7376089337547 | -122.488458793221 | (37.7376089337547, -122.488458793221) | |||
| 176173 | 176173 | 83286 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 107 Venus St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52358 | 6012899.6328300005 | 2094298.4658400002 | 37.731270935689295 | -122.39772012589701 | (37.7312709356893, -122.397720125897) | |
| 23099 | 23099 | 10175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1070 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53293 | 6005702.267530001 | 2102743.9562 | 37.7540569153999 | -122.42320285762301 | (37.7540569153999, -122.423202857623) | |
| 129154 | 129154 | 10176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1070 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2010 12:00:00 AM | 0 | 3x3 | Permit Number 53294 | 6005702.26311 | 2102736.9430799 | 37.7540376587481 | -122.423202374429 | (37.7540376587481, -122.423202374429) | |
| 19164 | 19164 | 5178 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1073X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2000 12:00:00 AM | 4 | 3X3 | 6001809.6544 | 2109757.7772 | 37.77309470688579 | -122.43716657631201 | (37.7730947068858, -122.437166576312) | ||
| 19011 | 19011 | 17022 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1074 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2005 12:00:00 AM | 3 | 3X3 | 6001843.4735 | 2109812.7932 | 37.7732476894572 | -122.43705353153999 | (37.7732476894572, -122.43705353154) | ||
| 147599 | 147599 | 42925 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 108 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 6 | Permit Number 42830 | 5997806.9486 | 2110184.8695 | 37.7740390499347 | -122.45104318248998 | (37.7740390499347, -122.45104318249) | |
| 8323 | 8323 | 8158 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1086 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002587.9005 | 2111305.7426 | 37.7773892425571 | -122.434585232983 | (37.7773892425571, -122.434585232983) | ||
| 70206 | 70206 | 242222 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001082.68293 | 2105706.3502 | 37.7619291426375 | -122.43939079205 | (37.7619291426375, -122.43939079205) | |||
| 161333 | 161333 | 242221 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001083.78441 | 2105686.83006 | 37.7618756078054 | -122.43938558319701 | (37.7618756078054, -122.439385583197) | |||
| 97176 | 97176 | 37167 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39741 | 6005833.27332998 | 2099912.8997159 | 37.7462908767398 | -122.42254864979799 | (37.7462908767398, -122.422548649798) | ||
| 128385 | 128385 | 9995 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 GUERRERO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 12:59:00 PM | 3 | 2X2 | 6005457.0 | 2108414.0 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | ||
| 5142 | 5142 | 241731 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005457.0 | 2108414.0 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | |||
| 156121 | 156121 | 241516 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000619.16522 | 2102442.54897 | 37.7529411517191 | -122.440759786856 | (37.7529411517191, -122.440759786856) | |||
| 74050 | 74050 | 218499 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995770.84161 | 2088680.25095 | 37.7148759242571 | -122.45653097363399 | (37.7148759242571, -122.456530973634) | |||
| 40603 | 40603 | 52369 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1090 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48501 | 6006953.33636 | 2114687.7048400003 | 37.786922138678605 | -122.41972375385099 | (37.7869221386786, -122.419723753851) |
| 180891 | 180891 | 242212 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1095 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001515.91315 | 2107590.51682 | 37.7671272465517 | -122.438027391047 | (37.7671272465517, -122.438027391047) | |||
| 73648 | 73648 | 214856 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1098x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 5991527.67203 | 2105215.05359 | 37.760031771876996 | -122.47240168931002 | (37.760031771877, -122.47240168931) | |||
| 174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
| 118114 | 118114 | 180210 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008343.95421 | 2086916.8221 | 37.7107477527694 | -122.412948271445 | (37.7107477527694, -122.412948271445) | |||
| 12498 | 12498 | 95030 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010891.1447 | 2087063.4869 | 37.7112931195577 | -122.404154871184 | (37.7112931195577, -122.404154871184) | ||||
| 131472 | 131472 | 62172 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 9 | Permit Number 22288 | 6000332.12983 | 2091919.6967900002 | 37.724031528122204 | -122.440997555008 | (37.7240315281222, -122.440997555008) | |
| 130654 | 130654 | 50398 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 5 | Permit Number 47049 | 5987519.13546 | 2095787.0700400001 | 37.7339122247558 | -122.485573207637 | (37.7339122247558, -122.485573207637) | |
| 52249 | 52249 | 242116 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6004100.79809 | 2102964.07193 | 37.7545707934166 | -122.428756816079 | (37.7545707934166, -122.428756816079) | |||
| 134347 | 134347 | 242267 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004285.0543599995 | 2098241.97048 | 37.741615424406596 | -122.427783169555 | (37.7416154244066, -122.427783169555) | |||
| 39105 | 39105 | 241789 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 28th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005121.67425 | 2099630.5033 | 37.745475310148294 | -122.424989187318 | (37.7454753101483, -122.424989187318) | |||
| 153348 | 153348 | 241787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005158.53292 | 2099630.58681 | 37.7454776214087 | -122.424861741691 | (37.7454776214087, -122.424861741691) | |||
| 178869 | 178869 | 241788 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005139.084369999 | 2099630.31349 | 37.7454757724008 | -122.424928972321 | (37.7454757724008, -122.424928972321) | |||
| 30433 | 30433 | 241417 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004524.68295 | 2095964.43408 | 37.7353753785744 | -122.426792456628 | (37.7353753785744, -122.426792456628) | |||
| 18382 | 18382 | 36313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39291 | 5996172.05456486 | 2093809.43581436 | 37.7289824784834 | -122.455514723268 | (37.7289824784834, -122.455514723268) | ||
| 155318 | 155318 | 218685 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996162.281 | 2093855.3929299999 | 37.7291081048575 | -122.45555183136999 | (37.7291081048575, -122.45555183137) | |||
| 21709 | 21709 | 26474 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6001315.30926 | 2098781.76662 | 37.742929135180795 | -122.438090182611 | (37.7429291351808, -122.438090182611) | |||
| 115118 | 115118 | 26476 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/1998 12:00:00 AM | 12 | 3x3 | 6001299.996411799 | 2098760.9069192 | 37.742870988484896 | -122.438141636139 | (37.7428709884849, -122.438141636139) | ||
| 57612 | 57612 | 241464 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000584.64265 | 2102423.42546 | 37.7528866770847 | -122.440877800392 | (37.7528866770847, -122.440877800392) | |||
| 80634 | 80634 | 89346 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | ||||
| 90995 | 90995 | 89345 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | ||||
| 69318 | 69318 | 139598 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000717.0466 | 2112538.0513 | 37.780666466129105 | -122.441145546812 | (37.7806664661291, -122.441145546812) | |||
| 1482 | 1482 | 140438 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003482.3387 | 2112124.8891 | 37.779689150174704 | -122.43154957445299 | (37.7796891501747, -122.431549574453) | |||
| 5307 | 5307 | 8160 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002453.143999999 | 2111285.6659999997 | 37.777326466446 | -122.435049962975 | (37.777326466446, -122.435049962975) | ||
| 46263 | 46263 | 71785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 8 | 6011579.56023 | 2119131.56016 | 37.7993834201653 | -122.404030839573 | (37.7993834201653, -122.404030839573) | ||
| 56759 | 56759 | 31780 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35254 | 5989503.5112 | 2097688.2686 | 37.7392478449055 | -122.47885169937099 | (37.7392478449055, -122.478851699371) | ||
| 17831 | 17831 | 5175 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1101 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2003 12:00:00 AM | 3 | 3X3 | 6001670.2798 | 2109738.9234 | 37.7730350154815 | -122.437647339398 | (37.7730350154815, -122.437647339398) | ||
| 79925 | 79925 | 90898 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1101X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992185.90224 | 2110649.1678400002 | 37.7749904738964 | -122.470520988277 | (37.7749904738964, -122.470520988277) | ||
| 7861 | 7861 | 8161 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1102 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002408.427999999 | 2111279.278 | 37.7773063874437 | -122.43520419289699 | (37.7773063874437, -122.435204192897) | |||
| 57483 | 57483 | 74953 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1104 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1995 12:00:00 AM | 7 | 5989482.2278 | 2097687.6237 | 37.7392448382864 | -122.47892523985901 | (37.7392448382864, -122.478925239859) | ||
| 7243 | 7243 | 116776 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008776.88904 | 2117992.21481 | 37.7960980717264 | -122.41364847189399 | (37.7960980717264, -122.413648471894) | ||
| 7735 | 7735 | 116777 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.796092432072705 | -122.41369458194099 | (37.7960924320727, -122.413694581941) | ||
| 8765 | 8765 | 116774 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008811.215480001 | 2117995.14613 | 37.7961080479024 | -122.413529902601 | (37.7961080479024, -122.413529902601) | ||
| 8943 | 8943 | 116775 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.79610197478279 | -122.413589186808 | (37.7961019747828, -122.413589186808) | ||
| 31081 | 31081 | 31782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35254 | 5989426.762 | 2097686.0113 | 37.739237190033705 | -122.47911689568501 | (37.7392371900337, -122.479116895685) | ||
| 92021 | 92021 | 31781 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35254 | 5989534.8469239995 | 2097688.46988301 | 37.7392502171048 | -122.478743370392 | (37.7392502171048, -122.478743370392) | |||
| 124308 | 124308 | 31783 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35254 | 5989534.8469239995 | 2097688.46988301 | 37.7392502171048 | -122.478743370392 | (37.7392502171048, -122.478743370392) | |||
| 155338 | 155338 | 183528 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989452.5601 | 2097686.3338 | 37.739239573725904 | -122.47902772200199 | (37.7392395737259, -122.479027722002) | |||
| 36103 | 36103 | 217613 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1107 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996473.4973 | 2091771.0541 | 37.7234028603634 | -122.454325440297 | (37.7234028603634, -122.454325440297) | |||
| 151452 | 151452 | 214890 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990833.38242 | 2103802.04247 | 37.756111809625295 | -122.474699747606 | (37.7561118096253, -122.474699747606) | |||
| 93545 | 93545 | 25241 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1109X Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/21/1981 12:00:00 AM | 12 | 3X3 | 5996400.7048 | 2091763.0727 | 37.723376770573104 | -122.45457649276501 | (37.7233767705731, -122.454576492765) | ||
| 94810 | 94810 | 19513 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000731.993932401 | 2112448.8076949 | 37.780422277373795 | -122.44108743241699 | (37.7804222773738, -122.441087432417) | |||
| 169917 | 169917 | 198135 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6013464.34426 | 2095584.8175599999 | 37.7348344237609 | -122.395857906032 | (37.7348344237609, -122.395857906032) | |||
| 40128 | 40128 | 218674 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996129.26759 | 2093829.69076 | 37.729035638381504 | -122.455664103641 | (37.7290356383815, -122.455664103641) | |||
| 99418 | 99418 | 36314 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39292 | 5996120.05843519 | 2093810.07024261 | 37.728981236660296 | -122.455694522542 | (37.7289812366603, -122.455694522542) | ||
| 156958 | 156958 | 241413 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004028.8473 | 2095144.40035 | 37.733095704182894 | -122.42844831444401 | (37.7330957041829, -122.428448314444) | |||
| 60121 | 60121 | 242287 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003600.6951 | 2097712.9056599997 | 37.7401239968303 | -122.430111718502 | (37.7401239968303, -122.430111718502) | |||
| 134046 | 134046 | 218498 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995727.386530001 | 2088681.89983 | 37.714877956732 | -122.456681290835 | (37.714877956732, -122.456681290835) | |||
| 62613 | 62613 | 124218 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Stanyan Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996498.54048 | 2112224.17385 | 37.7795634500868 | -122.45571660326999 | (37.7795634500868, -122.45571660327) |
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");