trees
150 rows where Supervisor Districts = 7 and qSpecies_id = 53 sorted by SiteOrder
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8209 | 103628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
19799 | 661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 | |||
24579 | 96732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 514 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007319.4 | 2106562.9 | 37.7646339820142 | -122.417881101898 | (37.7646339820142, -122.417881101898) | 8 | 4 | 7 | 28859 | 19 | |||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
26891 | 601 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6008510.8606794 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | 2 | 4 | 7 | 28859 | 19 | ||||
33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
34217 | 575 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.7524549543286 | -122.41222072227 | (37.7524549543286, -122.41222072227) | 2 | 4 | 7 | 28859 | 19 | |||
41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
43945 | 573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 776380 | 6009007.86528 | 2102243.77418 | 37.7528695228517 | -122.411735919997 | (37.7528695228517, -122.411735919997) | 2 | 4 | 7 | 28859 | 19 | ||
44451 | 96734 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 520 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007401.6 | 2106571.6 | 37.7646624959011 | -122.417597409955 | (37.7646624959011, -122.417597409955) | 8 | 4 | 7 | 28859 | 19 | |||
44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
51940 | 665 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
55414 | 61158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) | 2 | 4 | 7 | 28859 | 19 |
60410 | 111206 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
64328 | 44245 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | 2 | 7 | 7 | 28859 | 2 | |||
64711 | 488 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
70074 | 173891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007185 | 2099410 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | 2 | 7 | 7 | 28859 | 2 | ||||
70728 | 504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | 2 | 4 | 7 | 28859 | 19 | |||
71888 | 102035 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2400 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008197 | 2104472 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | 2 | 4 | 7 | 28859 | 19 | |||
76742 | 594 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008579.28838 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | 2 | 4 | 7 | 28859 | 19 | |||
79797 | 113702 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 14 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
80355 | 588 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | 2 | 4 | 7 | 28859 | 19 | |||
81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
85308 | 631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
86183 | 645 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
89426 | 65007 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1989 12:00:00 AM | 18 | 3x3 | Permit Number 26048 | 6008683.18209706 | 2107760.52572873 | 37.7679990416006 | -122.413248823154 | (37.7679990416006, -122.413248823154) | 8 | 4 | 7 | 28853 | 19 | |
90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
90722 | 56236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 147 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 24 | Permit Number 12362 | 6006719.97734959 | 2102927.77810186 | 37.7546190293471 | -122.419696406291 | (37.7546190293471, -122.419696406291) | 2 | 4 | 7 | 28859 | 19 | ||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
97918 | 102451 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | |||
103831 | 58284 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1978 12:00:00 AM | 4x4 | Permit Number 17298 | 6007189.64621742 | 2107366.09742219 | 37.7668320707182 | -122.418386841574 | (37.7668320707182, -122.418386841574) | 8 | 4 | 7 | 28853 | 19 | ||
106064 | 121117 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
110718 | 113188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x12 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
118796 | 65046 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2498 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1989 12:00:00 AM | 18 | Permit Number 26099 | 6008837.93100399 | 2103923.47328543 | 37.7574720629103 | -122.412442306383 | (37.7574720629103, -122.412442306383) | 2 | 4 | 7 | 28859 | 19 | ||
121361 | 506 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2773 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.7526526827318 | -122.407779587097 | (37.7526526827318, -122.407779587097) | 2 | 4 | 7 | 28859 | 19 | |||
121432 | 624 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3157 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6007970.52254 | 2102065.21548 | 37.752320993709 | -122.415310615518 | (37.752320993709, -122.415310615518) | 2 | 4 | 7 | 28859 | 19 | |||
126549 | 541 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009654.44601 | 2102141.49288 | 37.752624931831 | -122.409492696033 | (37.752624931831, -122.409492696033) | 2 | 4 | 7 | 28859 | 19 | |||
127664 | 499 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2751 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010232.5569 | 2102206.4482 | 37.7528356605554 | -122.407498057365 | (37.7528356605554, -122.407498057365) | 2 | 4 | 7 | 28859 | 19 | |
129162 | 615 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008105.60803 | 2102127.90457 | 37.7525007150423 | -122.414847903135 | (37.7525007150423, -122.414847903135) | 2 | 4 | 7 | 28859 | 19 | |||
132675 | 45428 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | |||
133106 | 18462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | 10 | 4 | 7 | 28859 | 19 | |||
133502 | 583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3032 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008758.82346 | 2102183.24018 | 37.7526893362197 | -122.412592877178 | (37.7526893362197, -122.412592877178) | 2 | 4 | 7 | 28859 | 19 | |||
133761 | 102454 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
135014 | 111218 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
138766 | 635 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3198 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007763.62302 | 2102126.97717 | 37.7524789468036 | -122.416030482711 | (37.7524789468036, -122.416030482711) | 2 | 4 | 7 | 28859 | 19 | |||
140677 | 68840 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1506 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | Permit Number 32793 | 6009553.56622839 | 2100554.07443475 | 37.7482605801949 | -122.4097295193 | (37.7482605801949, -122.4097295193) | 2 | 4 | 7 | 28859 | 2 | |||
141160 | 18451 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396 | (37.7548433927728, -122.40664849396) | 10 | 4 | 7 | 28859 | 19 | |||
142433 | 486 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.406523532023 | (37.7529942564805, -122.406523532023) | 10 | 4 | 7 | 28859 | 19 | |||
142871 | 18385 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 16x5 | 6010402.1602537 | 2104496.7929466 | 37.759133928444 | -122.407072960308 | (37.759133928444, -122.407072960308) | 10 | 4 | 7 | 28859 | 19 | |||
145297 | 511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010123.24297 | 2102258.68458 | 37.7529729707581 | -122.407879770058 | (37.7529729707581, -122.407879770058) | 2 | 4 | 7 | 28859 | 19 | |||
146667 | 15335 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006691.81678 | 2108397.85831 | 37.7696370050813 | -122.420181988192 | (37.7696370050813, -122.420181988192) | 8 | 4 | 7 | 28853 | 19 | |||
148177 | 100480 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 245 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007080 | 2107899 | 37.7682891227663 | -122.418803888241 | (37.7682891227663, -122.418803888241) | 8 | 4 | 7 | 28853 | 19 | |||
151621 | 482 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.7532012773937 | -122.406450377502 | (37.7532012773937, -122.406450377502) | 10 | 4 | 7 | 28859 | 19 | |||
152427 | 112646 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3101 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008718 | 2100791 | 37.7488642652044 | -122.412635640211 | (37.7488642652044, -122.412635640211) | 2 | 4 | 7 | 28859 | 19 | |||
152589 | 510 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2781 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.7526526827318 | -122.407779587097 | (37.7526526827318, -122.407779587097) | 2 | 4 | 7 | 28859 | 19 | |||
156055 | 653 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.7522084236972 | -122.417764377532 | (37.7522084236972, -122.417764377532) | 2 | 4 | 7 | 28859 | 19 | |||
158510 | 18390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | 10 | 4 | 7 | 28859 | 19 | |||
159897 | 617 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3141X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.414962541065 | (37.7523835952977, -122.414962541065) | 2 | 4 | 7 | 28859 | 19 | |||
161467 | 632 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3179 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
164080 | 570 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2972 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6009057.78841 | 2102246.54845 | 37.7528799408325 | -122.411563471864 | (37.7528799408325, -122.411563471864) | 2 | 4 | 7 | 28859 | 19 | |||
165793 | 39111 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | 2 | 4 | 7 | 28859 | 19 | |
169220 | 94550 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2851 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x5 | 6009753.55231 | 2102181.05227 | 37.7527391057434 | -122.40915275887 | (37.7527391057434, -122.40915275887) | 2 | 4 | 7 | 28859 | 19 | |||
169697 | 117565 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
172812 | 18468 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.406456244122 | (37.7528257474783, -122.406456244122) | 10 | 4 | 7 | 28859 | 19 | |||
178044 | 48952 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | 2 | 4 | 7 | 28859 | 19 | |
179971 | 634 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3194 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 6007781.42285 | 2102140.57786 | 37.7525172919755 | -122.415969890792 | (37.7525172919755, -122.415969890792) | 2 | 4 | 7 | 28859 | 19 | |||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
191336 | 505 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.407649581645 | (37.7529538159215, -122.407649581645) | 2 | 4 | 7 | 28859 | 19 | |||
160281 | 103637 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
173070 | 50573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
111853 | 99974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
29987 | 578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008810.60715 | 2102251.62423 | 37.7528800095792 | -122.412418632597 | (37.7528800095792, -122.412418632597) | 2 | 4 | 7 | 28859 | 19 | |||
37666 | 646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
61037 | 111219 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
64233 | 121118 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
70053 | 15430 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006871.65728 | 2105982.3734 | 37.7630147835921 | -122.419388541195 | (37.7630147835921, -122.419388541195) | 8 | 4 | 7 | 28859 | 19 | |||
76306 | 108943 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
78654 | 96735 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 520 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3.5 | 6007401.6 | 2106571.6 | 37.7646624959011 | -122.417597409955 | (37.7646624959011, -122.417597409955) | 8 | 4 | 7 | 28859 | 19 | |||
79982 | 628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007874.17365 | 2102144.23632 | 37.7525325514911 | -122.41564940087 | (37.7525325514911, -122.41564940087) | 2 | 4 | 7 | 28859 | 19 | |||
79996 | 96733 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 514 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3.5 | 6007319.4 | 2106562.9 | 37.7646339820142 | -122.417881101898 | (37.7646339820142, -122.417881101898) | 8 | 4 | 7 | 28859 | 19 | |||
80775 | 15434 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2137 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006871.30054 | 2105936.92899 | 37.7628899837695 | -122.419386550959 | (37.7628899837695, -122.419386550959) | 8 | 4 | 7 | 28859 | 19 | |||
99014 | 117566 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
99827 | 109850 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3250x 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
106094 | 117567 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2498 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008843 | 2103923 | 37.7574710478396 | -122.41242474225 | (37.7574710478396, -122.41242474225) | 2 | 4 | 7 | 28859 | 19 | |||
112964 | 103629 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
115602 | 550 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2899 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009498.42946 | 2102171.88233 | 37.7526996313063 | -122.410034375932 | (37.7526996313063, -122.410034375932) | 2 | 4 | 7 | 28859 | 19 | |||
119605 | 102455 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
127611 | 618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3141X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.414962541065 | (37.7523835952977, -122.414962541065) | 2 | 4 | 7 | 28859 | 19 | |||
133311 | 26518 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2881 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009034.88918 | 2101730.9691 | 37.7514629908808 | -122.411606237117 | (37.7514629908808, -122.411606237117) | 2 | 4 | 7 | 28859 | 19 | |||
137374 | 585 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3035 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 122 | 3x3 | 6008718 | 2102146 | 37.7525847918351 | -122.412731419953 | (37.7525847918351, -122.412731419953) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );