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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183692 | 183692 | 181692 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1363 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985221.299 | 2105936.0122 | 37.7616443068738 | -122.494265225231 | (37.7616443068738, -122.494265225231) | |||
| 183632 | 183632 | 218457 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5997390.35227 | 2093833.6961700001 | 37.7291189254921 | -122.451304747028 | (37.7291189254921, -122.451304747028) | |||
| 183630 | 183630 | 43206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 319 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2012 12:00:00 AM | 2 | Permit Number 769205 | 6009005.72494 | 2094379.66487 | 37.731276282173205 | -122.41118785664801 | (37.7312762821732, -122.411187856648) | |
| 183619 | 183619 | 218592 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3656 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5990548.88588 | 2092187.93065 | 37.7242059561335 | -122.474835931037 | (37.7242059561335, -122.474835931037) | |||
| 183605 | 183605 | 180302 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001751.00394 | 2092763.61834 | 37.726429457948896 | -122.436153099585 | (37.7264294579489, -122.436153099585) | |||
| 183586 | 183586 | 180171 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997361.4678 | 2086623.37535 | 37.709319409930394 | -122.450884905728 | (37.7093194099304, -122.450884905728) | |||
| 183557 | 183557 | 31444 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 604 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 8 | Permit Number 35019 | 6002350.077740001 | 2104629.5175099997 | 37.7590444655614 | -122.434930362454 | (37.7590444655614, -122.434930362454) | |
| 183505 | 183505 | 242218 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 118 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6001045.95716 | 2105660.24259 | 37.7618004523493 | -122.43951450640199 | (37.7618004523493, -122.439514506402) | |||
| 183486 | 183486 | 136883 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007638.793 | 2116445.85143 | 37.7917881670331 | -122.417476873272 | (37.7917881670331, -122.417476873272) | |||
| 183475 | 183475 | 45495 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3025 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 5 | Permit Number 44270 | 5989986.35534 | 2095106.40385 | 37.7321867315218 | -122.47699365014 | (37.7321867315218, -122.47699365014) | |
| 183452 | 183452 | 242069 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4310 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001816.934640001 | 2101200.92875 | 37.7496000983775 | -122.43652881836701 | (37.7496000983775, -122.436528818367) | |||
| 183350 | 183350 | 218496 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 179 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995216.49308 | 2087735.44702 | 37.7122498724185 | -122.45837867483999 | (37.7122498724185, -122.45837867484) | |||
| 183339 | 183339 | 198067 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015193.89992 | 2105719.5962799997 | 37.762758468654205 | -122.39058614404699 | (37.7627584686542, -122.390586144047) | |||
| 183323 | 183323 | 123870 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 850 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992756.180980001 | 2114853.1118799997 | 37.7865663175005 | -122.46885427474501 | (37.7865663175005, -122.468854274745) | |||
| 183302 | 183302 | 218467 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 272 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996258.74202 | 2091684.0820099998 | 37.723151737549 | -122.455061523696 | (37.723151737549, -122.455061523696) | |||
| 183274 | 183274 | 44828 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 941 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2001 12:00:00 AM | 5 | Permit Number 43920 | 6000915.7002 | 2111960.8729 | 37.779092994614395 | -122.440416903682 | (37.7790929946144, -122.440416903682) | ||
| 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) | ||
| 183242 | 183242 | 242292 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 351 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004196.55481 | 2098362.2247900004 | 37.7419406084852 | -122.42809773892701 | (37.7419406084852, -122.428097738927) | |||
| 183237 | 183237 | 69345 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2226 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 10 | Permit Number 33434 | 5999526.13299 | 2120869.58365 | 37.8034747491173 | -122.445864854104 | (37.8034747491173, -122.445864854104) | ||
| 183231 | 183231 | 139664 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 30 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000764.7641 | 2112199.6295 | 37.7797399640962 | -122.440956184432 | (37.7797399640962, -122.440956184432) | |||
| 183155 | 183155 | 43825 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2547 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43453 | 5985493.9283 | 2097883.1652 | 37.7395493380825 | -122.492729194071 | (37.7395493380825, -122.492729194071) | |
| 183133 | 183133 | 51246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 284 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 1 | Permit Number 47621 | 6001433.6702 | 2120922.8086900003 | 37.803729624187795 | -122.43926757234199 | (37.8037296241878, -122.439267572342) | |
| 183097 | 183097 | 198198 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017190.95158 | 2094477.91802 | 37.7320017122032 | -122.382896595212 | (37.7320017122032, -122.382896595212) | |||
| 183096 | 183096 | 241556 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3750 Market St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000189.8094 | 2102874.5763 | 37.754102932814 | -122.44227558786801 | (37.754102932814, -122.442275587868) | |||
| 183060 | 183060 | 38661 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 821 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 4 | Permit Number 40584 | 6000983.3846 | 2111517.2019 | 37.777878640299605 | -122.440150932531 | (37.7778786402996, -122.440150932531) | |
| 182982 | 182982 | 136871 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 811 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006122.96795 | 2112782.1631400003 | 37.781643178539795 | -122.422461193048 | (37.7816431785398, -122.422461193048) | |||
| 182970 | 182970 | 92749 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52978 | 5982987.8536 | 2098677.8731 | 37.741584528853004 | -122.50145274491001 | (37.741584528853, -122.50145274491) |
| 182962 | 182962 | 245111 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1521 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999734.9952 | 2109465.2082 | 37.7721732365134 | -122.44432203368 | (37.7721732365134, -122.44432203368) | |||
| 182956 | 182956 | 34627 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1486 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45214 | 5988703.4175 | 2105217.3526 | 37.75987421810321 | -122.48216948056101 | (37.7598742181032, -122.482169480561) | |
| 182883 | 182883 | 241421 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1209 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001367.44969 | 2100196.84034 | 37.7468175582003 | -122.43801123563401 | (37.7468175582003, -122.438011235634) | |||
| 182882 | 182882 | 242225 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 87 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001072.636 | 2105858.83519 | 37.7623472572285 | -122.439436471325 | (37.7623472572285, -122.439436471325) | |||
| 182854 | 182854 | 180358 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 952 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998479.18294 | 2089342.08749 | 37.716848296685 | -122.44721745423901 | (37.716848296685, -122.447217454239) | |||
| 182783 | 182783 | 136817 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2800 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6002581.81425 | 2117866.57568 | 37.795403275294206 | -122.435075644338 | (37.7954032752942, -122.435075644338) | |||
| 182778 | 182778 | 241495 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5295 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001868.994659999 | 2098673.36986 | 37.7426629763148 | -122.436167939293 | (37.7426629763148, -122.436167939293) | |||
| 182748 | 182748 | 218486 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 173 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995320.020930001 | 2091066.1408099998 | 37.7214011199376 | -122.458261772876 | (37.7214011199376, -122.458261772876) | |||
| 182729 | 182729 | 138837 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 666 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004066.4292 | 2111036.129 | 37.7767327723898 | -122.42945128666 | (37.7767327723898, -122.42945128666) | |||
| 182724 | 182724 | 241579 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999507.07027 | 2107703.03573 | 37.7673217492226 | -122.444983741515 | (37.7673217492226, -122.444983741515) | |||
| 182723 | 182723 | 242321 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1197 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006210.721030001 | 2102654.46682 | 37.753839879332396 | -122.421438144967 | (37.7538398793324, -122.421438144967) | |||
| 182699 | 182699 | 183915 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2290 24th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988885.3043 | 2099910.1749 | 37.7453127011599 | -122.481151811317 | (37.7453127011599, -122.481151811317) | |||
| 182660 | 182660 | 241735 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 161 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004157.65891 | 2108005.27782 | 37.7684159597574 | -122.42891956279499 | (37.7684159597574, -122.428919562795) | |||
| 182605 | 182605 | 241725 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 351 Mullen Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010636.58313 | 2099701.79823 | 37.745981047492705 | -122.405924429582 | (37.7459810474927, -122.405924429582) | |||
| 182556 | 182556 | 67449 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 701 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1992 12:00:00 AM | 10 | Permit Number 30952 | 5992230.15516 | 2110618.7404099996 | 37.7749094871184 | -122.47036569291299 | (37.7749094871184, -122.470365692913) | |
| 182489 | 182489 | 241555 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 79 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001046.634319999 | 2096276.6851400002 | 37.7360354854382 | -122.43883970728399 | (37.7360354854382, -122.438839707284) | |||
| 182474 | 182474 | 95520 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1214 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767312 | 5985232.1017 | 2106922.0105 | 37.7643522146303 | -122.49430054433998 | (37.7643522146303, -122.49430054434) |
| 182452 | 182452 | 241806 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 157 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004758.57366 | 2102775.5213 | 37.7540902838555 | -122.42646862785101 | (37.7540902838555, -122.426468627851) | |||
| 182417 | 182417 | 218726 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 5995446.39334 | 2099958.3042 | 37.7458240951236 | -122.45846828420099 | (37.7458240951236, -122.458468284201) | |||
| 182381 | 182381 | 245434 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2525 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009030.8024 | 2106823.0735 | 37.7654445244185 | -122.41198018227199 | (37.7654445244185, -122.411980182272) | |||
| 182297 | 182297 | 139751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 CLEARY CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004849.5277 | 2113649.5854 | 37.783952985077 | -122.426928491221 | (37.783952985077, -122.426928491221) | |||
| 182173 | 182173 | 180127 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 850 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002185.62064 | 2088720.52578 | 37.7153527124214 | -122.434361715744 | (37.7153527124214, -122.434361715744) | |||
| 182131 | 182131 | 241650 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Scott St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002438.428230001 | 2108471.60709 | 37.7695989234814 | -122.434899572366 | (37.7695989234814, -122.434899572366) | |||
| 182128 | 182128 | 214933 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993794.553230001 | 2095807.5426900003 | 37.7343320741677 | -122.463878834949 | (37.7343320741677, -122.463878834949) | |||
| 182096 | 182096 | 118080 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7230 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5984526.23316 | 2112508.36467 | 37.77964941454 | -122.49715429910201 | (37.77964941454, -122.497154299102) | |||
| 182094 | 182094 | 202209 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1988 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6012983.51399 | 2093557.8365599997 | 37.7292419905249 | -122.39737821176 | (37.7292419905249, -122.39737821176) | |||
| 182079 | 182079 | 62224 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 355 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 8 | Permit Number 22349 | 6001094.38502 | 2092622.5788200002 | 37.7260048682299 | -122.438412897153 | (37.7260048682299, -122.438412897153) | |
| 182059 | 182059 | 52152 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1790 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48342 | 6014225.18448 | 2096476.0727799998 | 37.73732392526679 | -122.39328974441999 | (37.7373239252668, -122.39328974442) | |
| 181895 | 181895 | 184478 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1538 Rivera St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988305.7926 | 2100367.8892 | 37.7465357567316 | -122.483189186565 | (37.7465357567316, -122.483189186565) | |||
| 181831 | 181831 | 198066 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015198.3548099995 | 2105662.1973200003 | 37.7626011106721 | -122.39056672497699 | (37.7626011106721, -122.390566724977) | |||
| 181824 | 181824 | 218453 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 424 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997305.065140001 | 2093836.77253 | 37.7291224886134 | -122.451599811877 | (37.7291224886134, -122.451599811877) | |||
| 181806 | 181806 | 214852 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1757 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993401.50026 | 2103508.04873 | 37.755453054428 | -122.46579704392299 | (37.755453054428, -122.465797043923) | |||
| 181796 | 181796 | 83445 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 461 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | 6013267.33871 | 2104912.53063 | 37.7604353750024 | -122.397192888438 | (37.7604353750024, -122.397192888438) | ||
| 181766 | 181766 | 241741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 119 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004139.86883 | 2108298.8635 | 37.769221067931795 | -122.42900203153 | (37.7692210679318, -122.42900203153) | |||
| 181737 | 181737 | 248104 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010427.14542 | 2099549.7617900004 | 37.7455518730185 | -122.406637928309 | (37.7455518730185, -122.406637928309) | |||
| 181697 | 181697 | 241764 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 260 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004863.1794300005 | 2099031.0734900003 | 37.7438148082095 | -122.425840362346 | (37.7438148082095, -122.425840362346) | |||
| 181684 | 181684 | 214874 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993750.55927 | 2103772.3418 | 37.756198864003295 | -122.464609090736 | (37.7561988640033, -122.464609090736) | |||
| 181619 | 181619 | 124486 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3058 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996306.12239 | 2111494.87104 | 37.777549932506204 | -122.456329507616 | (37.7775499325062, -122.456329507616) | |||
| 181591 | 181591 | 214942 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 40 San Andreas Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993797.90543 | 2095609.8823900002 | 37.733789541050896 | -122.46385290298599 | (37.7337895410509, -122.463852902986) | |||
| 181575 | 181575 | 46160 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1596 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2006 12:00:00 AM | 3 | Permit Number 48875 | 6007689.62813 | 2109253.52675 | 37.7720426404827 | -122.416791212161 | (37.7720426404827, -122.416791212161) | ||
| 181574 | 181574 | 102134 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | Private 3 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 769373 | 6015285.47231 | 2114577.79035 | 37.787086180420296 | -122.390888542866 | (37.7870861804203, -122.390888542866) |
| 181545 | 181545 | 242011 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3310 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6007422.82685 | 2105020.49495 | 37.7604047162149 | -122.417414058314 | (37.7604047162149, -122.417414058314) | |||
| 181440 | 181440 | 242284 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 54 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002526.79256 | 2096498.53894 | 37.736728744921706 | -122.433738061065 | (37.7367287449217, -122.433738061065) | |||
| 181370 | 181370 | 51684 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1750@ NORIEGA 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 3 | Permit Number 47965 | 5987222.893999999 | 2103313.1311 | 37.754559519848 | -122.48714996321002 | (37.754559519848, -122.48714996321) | ||
| 181353 | 181353 | 241878 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 729 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007940.342680001 | 2097204.70222 | 37.7389734122973 | -122.415070975448 | (37.7389734122973, -122.415070975448) | |||
| 181268 | 181268 | 180072 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000400.98899 | 2090150.2778599998 | 37.719177028168296 | -122.440632664989 | (37.7191770281683, -122.440632664989) | |||
| 181260 | 181260 | 218608 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1930 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990667.07239 | 2102243.7340599997 | 37.75182346710329 | -122.475161141169 | (37.7518234671033, -122.475161141169) | |||
| 181141 | 181141 | 218435 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 234 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999856.58454 | 2094381.78605 | 37.7307647585692 | -122.442818149742 | (37.7307647585692, -122.442818149742) | |||
| 181109 | 181109 | 214971 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5997351.13629 | 2099420.8934400002 | 37.744457776714896 | -122.451843224182 | (37.7444577767149, -122.451843224182) | |||
| 181102 | 181102 | 180251 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003572.96144 | 2094730.3764 | 37.7319330795535 | -122.42999490913799 | (37.7319330795535, -122.429994909138) | |||
| 181044 | 181044 | 66585 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 7 | Permit Number 29775 | 6003192.83799 | 2092777.0979799998 | 37.726548281774704 | -122.431169707032 | (37.7265482817747, -122.431169707032) | |
| 181035 | 181035 | 241824 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 122 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997829.88303 | 2107168.26858 | 37.7657575493995 | -122.450746305816 | (37.7657575493995, -122.450746305816) | |||
| 181021 | 181021 | 33753 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 342 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 5 | Permit Number 37806 | 6006183.48634 | 2111105.86926 | 37.7770438971984 | -122.42213270218001 | (37.7770438971984, -122.42213270218) | ||
| 181006 | 181006 | 179982 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998163.8312800005 | 2086864.4965400002 | 37.710027374234706 | -122.44812917073901 | (37.7100273742347, -122.448129170739) | |||
| 180954 | 180954 | 113962 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011665.9611599995 | 2107258.4956900002 | 37.766787588788 | -122.402896345709 | (37.766787588788, -122.402896345709) | |||
| 180935 | 180935 | 242131 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 24 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002620.01223 | 2105743.08021 | 37.7621173626564 | -122.434076404909 | (37.7621173626564, -122.434076404909) | |||
| 180931 | 180931 | 51971 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2811 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2005 12:00:00 AM | 4 | Permit Number 48190 | 6003473.213380001 | 2118106.92543 | 37.7961137891791 | -122.43200842824601 | (37.7961137891791, -122.432008428246) | ||
| 180913 | 180913 | 218658 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995766.17765 | 2093995.939 | 37.729471272674 | -122.45693134552201 | (37.729471272674, -122.456931345522) | |||
| 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) | |||
| 180839 | 180839 | 241632 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 274 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009056.51649 | 2096102.0338299999 | 37.7360083852658 | -122.41113387755101 | (37.7360083852658, -122.411133877551) | |||
| 180823 | 180823 | 218511 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 318 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5996829.51445 | 2089654.6411099997 | 37.7176120972009 | -122.45294206803001 | (37.7176120972009, -122.45294206803) | |||
| 180804 | 180804 | 218565 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 77 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5990819.815219999 | 2094485.38355 | 37.730529882627394 | -122.474066927066 | (37.7305298826274, -122.474066927066) | |||
| 180795 | 180795 | 136795 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2451 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002224.01425 | 2116607.63023 | 37.7919262138706 | -122.43622355068399 | (37.7919262138706, -122.436223550684) | |||
| 180776 | 180776 | 217583 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 146 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5993540.5614 | 2088547.0452 | 37.714381874779995 | -122.46423003045 | (37.71438187478, -122.46423003045) | |||
| 180763 | 180763 | 218556 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991013.46606 | 2094544.7667599998 | 37.7307041496708 | -122.47340178398198 | (37.7307041496708, -122.473401783982) | |||
| 180739 | 180739 | 180129 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001982.79981 | 2088823.86467 | 37.7156249435034 | -122.43507013959 | (37.7156249435034, -122.43507013959) | |||
| 180727 | 180727 | 241909 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 911 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007603.66883 | 2104334.54869 | 37.758531439178796 | -122.41674001196002 | (37.7585314391788, -122.41674001196) | |||
| 180655 | 180655 | 241597 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 627 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007805.77873 | 2095938.0394 | 37.7354878711743 | -122.41544658630698 | (37.7354878711743, -122.415446586307) | |||
| 180595 | 180595 | 32583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1495 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37056 | 5985870.4662 | 2105106.8812 | 37.7594057102405 | -122.491959005024 | (37.7594057102405, -122.491959005024) | |
| 180593 | 180593 | 198087 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Kansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011707.76666 | 2102610.2798900004 | 37.754026956299896 | -122.402424873429 | (37.7540269562999, -122.402424873429) | |||
| 180590 | 180590 | 241612 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3607 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008506.13516 | 2098054.34493 | 37.7413381238478 | -122.413174782809 | (37.7413381238478, -122.413174782809) | |||
| 180580 | 180580 | 83206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3036-3038 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52341 | 6004708.92286 | 2120041.8538599997 | 37.80149658417171 | -122.42787056837099 | (37.8014965841717, -122.427870568371) | |
| 180570 | 180570 | 180201 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1122 Visitacion Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009202.09699 | 2087389.679 | 37.7120942546224 | -122.410015682991 | (37.7120942546224, -122.410015682991) |
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");