trees
556 rows where qSpecies_id = 71 sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120124 | 139240 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1401 WEBSTER ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | Permit Number 781890 | 6003672.6557 | 2113192.6384 | 37.7826317085064 | -122.430967411723 | (37.7826317085064, -122.430967411723) | 15 | 9 | 11 | 29490 | 41 | ||
104067 | 255325 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 42 Lippard Ave | 1 | Front Yard : Yard | Tree | Private 2 | Width 0ft | Permit Number 781812 | 6002006.02273 | 2095939.48888 | 37.7351641583954 | -122.435498605394 | (37.7351641583954, -122.435498605394) | 2 | 7 | 5 | 63 | 7 | |||
108353 | 145278 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2017 12:00:00 AM | 0 | Width 3ft | Permit Number 779614 | 5992589.96157 | 2110455.11477 | 37.7744810119102 | -122.469109146279 | (37.7744810119102, -122.469109146279) | 11 | 6 | 2 | 54 | 11 | |
45567 | 14354 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778955 | 6002931.2163471 | 2106726.8081779 | 37.7648360983599 | -122.433070358007 | (37.7648360983599, -122.433070358007) | 15 | 5 | 5 | 28862 | 3 | |
140460 | 246969 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299 Noe St | 1 | : | Tree | Private 2 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | 15 | 5 | 5 | 28862 | 3 | |
3580 | 56277 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778721 | 6005870.9645754 | 2104060.4446756 | 37.7576812057902 | -122.422713011346 | (37.7576812057902, -122.422713011346) | 2 | 4 | 5 | 28859 | 19 | ||
127860 | 50999 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3000X Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2010 12:00:00 AM | 3 | 3x3 | Permit Number 774202 | 5999788.70466 | 2116412.94537 | 37.7912529948724 | -122.444635704772 | (37.7912529948724, -122.444635704772) | 13 | 6 | 1 | 29490 | 27 | |
175258 | 51000 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3000X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2010 12:00:00 AM | 3 | 3x3 | Permit Number 774202 | 5999777.56327 | 2116411.25364 | 37.7912477140612 | -122.444674131902 | (37.7912477140612, -122.444674131902) | 13 | 6 | 1 | 29490 | 27 | |
140429 | 54987 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 634 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 774084 | 5990988.52251 | 2111051.18052 | 37.7760249826043 | -122.474692288357 | (37.7760249826043, -122.474692288357) | 11 | 6 | 2 | 54 | 26 | ||
21172 | 107389 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 773951 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | ||||
56357 | 107390 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 773951 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | ||||
110198 | 107387 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 773951 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | ||||
160207 | 107388 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 773951 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | ||||
100806 | 107500 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1101x PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | Permit Number 773474 | 6001297 | 2109248 | 37.7716658315653 | -122.438903370258 | (37.7716658315653, -122.438903370258) | 15 | 5 | 11 | 29492 | 9 | ||
87062 | 104651 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 21 Beaver St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770906 | 6002646.8 | 2106754 | 37.7648946232156 | -122.434056023873 | (37.7648946232156, -122.434056023873) | 15 | 5 | 5 | 28862 | 3 | |||||
91566 | 104328 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 21 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770906 | 6002767 | 2106786 | 37.76498930837 | -122.433642570245 | (37.76498930837, -122.433642570245) | 15 | 5 | 5 | 28862 | 3 | |||
88725 | 30368 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 406 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1956 12:00:00 AM | 43 | Permit Number 56 | 6012907.77426 | 2105144.73435 | 37.761052931381 | -122.398452757696 | (37.761052931381, -122.398452757696) | 10 | 3 | 8 | 28856 | 29 | ||
89678 | 52015 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
112905 | 52013 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
142263 | 52016 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
108279 | 51601 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1250 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47896 | 6000577.00438268 | 2109291.24211111 | 37.7717435732091 | -122.44139697552 | (37.7717435732091, -122.44139697552) | 15 | 5 | 11 | 29492 | 9 | |||
88413 | 50967 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 225 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1974 12:00:00 AM | Permit Number 47461 | 6010511.43889259 | 2088929.82162599 | 37.7163964722207 | -122.405598602601 | (37.7163964722207, -122.405598602601) | 9 | 7 | 8 | 309 | 39 | |||
112967 | 49702 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1260@ BAKER Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | Permit Number 46521 | 6000531.35028078 | 2109284.92106254 | 37.7717236162704 | -122.441554441885 | (37.7717236162704, -122.441554441885) | 15 | 5 | 11 | 29492 | 9 | |||
46459 | 225887 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 42143 | 6001804.96273 | 2096660.33983 | 37.7371320270083 | -122.436245312495 | (37.7371320270083, -122.436245312495) | 2 | 7 | 5 | 63 | 7 | |
6463 | 40381 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | Permit Number 41493 | 6002951.47000009 | 2101559.64792523 | 37.7506494618032 | -122.432631180412 | (37.7506494618032, -122.432631180412) | 2 | 4 | 5 | 28862 | 22 | |||
121238 | 33805 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 751 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/1996 12:00:00 AM | 3x3 | Permit Number 37823 | 5997939.03141438 | 2107846.29922309 | 37.7676254964359 | -122.450417669384 | (37.7676254964359, -122.450417669384) | 15 | 5 | 11 | 29492 | 9 | ||
37708 | 68776 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 499 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | 16 | Permit Number 32706 | 5983126.84332 | 2112651.33679 | 37.7799598652159 | -122.502005896932 | (37.7799598652159, -122.502005896932) | 11 | 6 | 2 | 55 | 26 | |
134575 | 54586 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 163 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1987 12:00:00 AM | 5x4 | Permit Number 24629 | 6000291.49375014 | 2109442.50729731 | 37.7721426401996 | -122.442395433804 | (37.7721426401996, -122.442395433804) | 15 | 5 | 11 | 29492 | 9 | ||
16143 | 225872 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 918 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1983 12:00:00 AM | 17 | Width 3ft | Permit Number 20345 | 6009124.648 | 2103673.1383 | 37.7568007856426 | -122.411433035206 | (37.7568007856426, -122.411433035206) | 2 | 4 | 7 | 28859 | 19 | |
110744 | 60698 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 918 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | 15 | Permit Number 20345 | 6009112.76031538 | 2103802.68080771 | 37.7571558133036 | -122.411483299228 | (37.7571558133036, -122.411483299228) | 2 | 4 | 7 | 28859 | 19 | |
102445 | 60678 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1160 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1983 12:00:00 AM | 6x5 | Permit Number 20316 | 6001007.89737324 | 2109351.27378976 | 37.7719329428525 | -122.439910797466 | (37.7719329428525, -122.439910797466) | 15 | 5 | 11 | 29492 | 9 | |
105657 | 59133 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 24 | Permit Number 18438 | 5992594.65054267 | 2110474.91091897 | 37.7745356377316 | -122.469094367405 | (37.7745356377316, -122.469094367405) | 11 | 6 | 2 | 54 | 11 | ||
14510 | 225860 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1979 12:00:00 AM | 32 | Width 4ft | Permit Number 17861 | 5997829.91039 | 2105879.41446 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | 15 | 5 | 11 | 29492 | 9 | |
56398 | 58361 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1978 12:00:00 AM | 13 | Permit Number 17389 | 5997651.60838 | 2114939.03748 | 37.7870838556688 | -122.451923583106 | (37.7870838556688, -122.451923583106) | 11 | 6 | 1 | 54 | 31 | ||
170598 | 58360 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 457 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1978 12:00:00 AM | 16 | Permit Number 17388 | 5997662.21392 | 2114878.66722 | 37.7869187023848 | -122.45188253355 | (37.7869187023848, -122.45188253355) | 11 | 6 | 1 | 54 | 31 | ||
54077 | 57851 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1977 12:00:00 AM | 20 | Permit Number 16792 | 6003796.0811 | 2112295.2301 | 37.78017464182 | -122.430476360985 | (37.78017464182, -122.430476360985) | 15 | 9 | 11 | 29490 | 41 | ||
150620 | 57220 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2525 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1975 12:00:00 AM | 8 | Permit Number 14507 | 5986650.329 | 2105697.8423 | 37.7610738801184 | -122.489305344609 | (37.7610738801184, -122.489305344609) | 1 | 8 | 3 | 56 | 35 | ||
140838 | 57085 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 725 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 15 | Permit Number 14352 | 6011859.01316 | 2104976.52396 | 37.7605325827245 | -122.402068163608 | (37.7605325827245, -122.402068163608) | 10 | 3 | 8 | 28856 | 29 | ||
63458 | 56276 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 24 | Permit Number 12402 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | ||
58993 | 56273 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 28 | Permit Number 12399 | 6006031.13656237 | 2104069.3331134 | 37.7577146469635 | -122.422159701591 | (37.7577146469635, -122.422159701591) | 2 | 4 | 5 | 28859 | 19 | ||
133475 | 56271 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 30 | Permit Number 12397 | 6006068.09932512 | 2104071.38429116 | 37.7577223637877 | -122.422032014666 | (37.7577223637877, -122.422032014666) | 2 | 4 | 5 | 28859 | 19 | ||
32190 | 56267 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.421648953731 | (37.7577455134305, -122.421648953731) | 2 | 4 | 5 | 28859 | 19 | |
167843 | 228132 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 236 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 23 | Width 3ft | Permit Number 12386 | 5997539.90606 | 2106468.8722 | 37.7638205814857 | -122.451698812867 | (37.7638205814857, -122.451698812867) | 15 | 5 | 11 | 29492 | 9 | |
50087 | 54991 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 646 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 13 | 3x3 | Permit Number 10869 | 5990991.81393 | 2111001.00614 | 37.7758874082105 | -122.474677239765 | (37.7758874082105, -122.474677239765) | 11 | 6 | 2 | 54 | 26 | |
166986 | 54990 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 643 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 11 | Permit Number 10868 | 5990941.26745 | 2111008.08375 | 37.7759039123762 | -122.474852607991 | (37.7759039123762, -122.474852607991) | 11 | 6 | 2 | 54 | 26 | ||
76455 | 54989 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 639 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 8 | Permit Number 10867 | 5990941.20394 | 2111018.63383 | 37.7759328763268 | -122.474853597928 | (37.7759328763268, -122.474853597928) | 11 | 6 | 2 | 54 | 26 | ||
183 | 253381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
2056 | 5946 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.430845511676 | (37.7815635260957, -122.430845511676) | 15 | 9 | 11 | 29490 | 41 | |||
3605 | 141795 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1280 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6003792.0243 | 2113029.1397 | 37.7821895448546 | -122.43054277764 | (37.7821895448546, -122.43054277764) | 7 | 9 | 11 | 29490 | 41 | |||
6835 | 4820 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 398X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 4x4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.421804144483 | (37.7406342583881, -122.421804144483) | 2 | 7 | 7 | 28859 | 2 | |||
7697 | 23847 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1370 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003735.9392 | 2113413.2165 | 37.7832409463281 | -122.430764223956 | (37.7832409463281, -122.430764223956) | 7 | 9 | 11 | 29490 | 41 | |||
9711 | 128841 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011188.37532 | 2121452.80256 | 37.8057351195451 | -122.405548058817 | (37.8057351195451, -122.405548058817) | 3 | 1 | 10 | 308 | 23 | |||
11408 | 138096 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1710 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003559.9046 | 2114643.6489 | 37.7866094291115 | -122.431461099658 | (37.7866094291115, -122.431461099658) | 13 | 9 | 11 | 29490 | 27 | |||
13690 | 225828 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011100.13283 | 2102409.04918 | 37.7534404813975 | -122.404512064091 | (37.7534404813975, -122.404512064091) | 10 | 4 | 8 | 28859 | 19 | |||
13993 | 139261 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 702 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004039.451 | 2111223.3243 | 37.7772452370478 | -122.429557965765 | (37.7772452370478, -122.429557965765) | 7 | 9 | 11 | 28852 | 10 | |||
14178 | 225841 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1201 Utah St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6010865.97168 | 2102677.80317 | 37.7541653313745 | -122.405340772261 | (37.7541653313745, -122.405340772261) | 10 | 4 | 8 | 28859 | 19 | |||
14713 | 246262 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2298 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002931.9657 | 2106660.3089 | 37.7646535499952 | -122.433063014632 | (37.7646535499952, -122.433063014632) | 15 | 5 | 5 | 28862 | 3 | |||
14955 | 139262 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004035.029 | 2111258.7004 | 37.7773421207118 | -122.429575786462 | (37.7773421207118, -122.429575786462) | 7 | 9 | 11 | 28852 | 10 | |||
16382 | 2685 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6003437.92088 | 2114825.67122 | 37.7871023020297 | -122.431896135366 | (37.7871023020297, -122.431896135366) | 13 | 9 | 11 | 29490 | 27 | |||
16419 | 260956 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 53 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9x9 | 6005953 | 2103995 | 37.7575061380505 | -122.422424648788 | (37.7575061380505, -122.422424648788) | 2 | 4 | 5 | 28859 | 19 | ||||
16668 | 251641 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1785 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003432 | 2114811 | 37.7870616829204 | -122.431915572303 | (37.7870616829204, -122.431915572303) | 13 | 9 | 11 | 29490 | 27 | ||||
17334 | 248431 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 721 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 5997917.0355 | 2108037.1532 | 37.7681482738929 | -122.450507510702 | (37.7681482738929, -122.450507510702) | 15 | 5 | 11 | 29492 | 9 | |||
17910 | 211714 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 100 Tara St | 3 | Unaccepted Street : Yard | Tree | Private 2 | 13 | Width 0ft | 5998092.2362 | 2090928.90604 | 37.7211832160136 | -122.44866915786 | (37.7211832160136, -122.44866915786) | 9 | 8 | 6 | 28861 | 24 | |||
18178 | 192378 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 9ft | 6015920.68395 | 2106620.64032 | 37.7652728345979 | -122.388135317012 | (37.7652728345979, -122.388135317012) | 14 | 3 | 9 | 310 | 29 | |||
18781 | 103292 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011032.30685 | 2121439.6325 | 37.8056902298748 | -122.406087231156 | (37.8056902298748, -122.406087231156) | 3 | 1 | 10 | 308 | 23 | |||
19018 | 28638 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
19884 | 109998 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
20329 | 225847 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 7ft | 6006004.32173 | 2104059.75576 | 37.7576868372893 | -122.422251758015 | (37.7576868372893, -122.422251758015) | 2 | 4 | 5 | 28859 | 19 | |||
20644 | 14589 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1221 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999408.7715 | 2108648.7165 | 37.7699127394546 | -122.445391746523 | (37.7699127394546, -122.445391746523) | 15 | 5 | 11 | 29492 | 9 | |||
20980 | 140249 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5999170.7375 | 2110360.1102 | 37.7745981999883 | -122.446338229944 | (37.7745981999883, -122.446338229944) | 15 | 5 | 11 | 29492 | 16 | |||
21155 | 128837 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6001930.71219 | 2116056.5883 | 37.7903965264241 | -122.437198903224 | (37.7903965264241, -122.437198903224) | 13 | 6 | 1 | 29490 | 27 | |||
21645 | 192374 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 6015916.946 | 2106720.28142 | 37.7655462204113 | -122.388155200109 | (37.7655462204113, -122.388155200109) | 14 | 3 | 9 | 310 | 29 | |||
21735 | 5942 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1155X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003738.78415 | 2112752.38886 | 37.781426639976 | -122.430707209452 | (37.781426639976, -122.430707209452) | 15 | 9 | 11 | 29490 | 41 | |||
21775 | 176487 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 14 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 6011797.05153 | 2087306.90558 | 37.7120120754601 | -122.401040902239 | (37.7120120754601, -122.401040902239) | 10 | 3 | 8 | 309 | 1 | |||
21857 | 225878 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3336 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006137.18827 | 2103195.79991 | 37.7553221086433 | -122.421730885992 | (37.7553221086433, -122.421730885992) | 2 | 4 | 5 | 28859 | 19 | |||
22108 | 141881 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1160 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6003834.0273 | 2112698.8952 | 37.7812851551878 | -122.430373896592 | (37.7812851551878, -122.430373896592) | 7 | 9 | 11 | 29490 | 41 | |||
22214 | 23712 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6003969.6344427 | 2111125.822349 | 37.7769735674529 | -122.429792527426 | (37.7769735674529, -122.429792527426) | 7 | 9 | 11 | 29492 | 10 | |||
22323 | 247197 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 900 Waller St | 11 | Front Yard : Yard | Tree | Private 2 | 18 | 6001288.44424 | 2108651.52945 | 37.7700275853458 | -122.438890213225 | (37.7700275853458, -122.438890213225) | 15 | 5 | 5 | 29492 | 9 | ||||
23080 | 248433 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 718 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5997964.5796 | 2108003.6906 | 37.7680591152112 | -122.450340648856 | (37.7680591152112, -122.450340648856) | 15 | 5 | 11 | 29492 | 9 | |||
23086 | 23918 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1639 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 4X4 | 6003511.011206 | 2114320.0570948 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | 13 | 9 | 11 | 29490 | 13 | |||
23176 | 169 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 185X Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 6X6 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | 15 | 5 | 5 | 28862 | 3 | |||
23348 | 225822 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011089.51394 | 2102630.04924 | 37.7540467053928 | -122.404564342576 | (37.7540467053928, -122.404564342576) | 10 | 4 | 8 | 28859 | 19 | |||
23680 | 10997 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018318.9881754 | 2094475.1533635 | 37.732056382705 | -122.378996495822 | (37.732056382705, -122.378996495822) | 10 | 3 | 8 | 58 | 1 | |||
24503 | 247010 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6002631.32186 | 2099201.86815 | 37.7441573914612 | -122.433569796116 | (37.7441573914612, -122.433569796116) | 2 | 7 | 5 | 63 | 22 | ||||
24512 | 225862 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 198 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6006460.77519 | 2098675.08466 | 37.7429274966048 | -122.420290980542 | (37.7429274966048, -122.420290980542) | 2 | 7 | 7 | 28859 | 2 | |||
24782 | 225826 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011095.54336 | 2102504.46266 | 37.7537022093019 | -122.404534651466 | (37.7537022093019, -122.404534651466) | 10 | 4 | 8 | 28859 | 19 | |||
24969 | 258214 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6018341.5004 | 2094530.72341 | 37.7322102084437 | -122.378922523056 | (37.7322102084437, -122.378922523056) | 10 | 3 | 8 | 58 | 1 | ||||
25012 | 192386 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 725 Rhode Island St | 2 | : | Tree | Private 2 | 24 | Width 4ft | 6011857.61784 | 2104994.61162 | 37.7605821695415 | -122.402074261034 | (37.7605821695415, -122.402074261034) | 10 | 3 | 8 | 28856 | 29 | |||
25569 | 253379 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 1 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
25654 | 16632 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 150 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002845.7066 | 2107359.01628 | 37.7665671370879 | -122.433411295115 | (37.7665671370879, -122.433411295115) | 15 | 5 | 5 | 28862 | 3 | |||
26326 | 225834 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1201 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010880.09664 | 2102425.66941 | 37.7534738174881 | -122.40527417026 | (37.7534738174881, -122.40527417026) | 10 | 4 | 8 | 28859 | 19 | |||
26497 | 141790 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1280 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6003808.9126 | 2112898.5974 | 37.7818320649833 | -122.430475034423 | (37.7818320649833, -122.430475034423) | 7 | 9 | 11 | 29490 | 41 | |||
26535 | 5944 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003654.4203 | 2112794.2785 | 37.7815368785362 | -122.431002057977 | (37.7815368785362, -122.431002057977) | 15 | 9 | 11 | 29490 | 41 | |||
27542 | 14506 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 6X6 | 5999167.52145 | 2111070.84281 | 37.7765495060171 | -122.446400495731 | (37.7765495060171, -122.446400495731) | 15 | 5 | 11 | 29492 | 16 | |||
28014 | 5941 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1155X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003735.29014 | 2112772.66113 | 37.7814821046204 | -122.430720744107 | (37.7814821046204, -122.430720744107) | 15 | 9 | 11 | 29490 | 41 | |||
28902 | 128835 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6002002.11764 | 2116066.62683 | 37.7904281483977 | -122.436952564533 | (37.7904281483977, -122.436952564533) | 13 | 6 | 1 | 29490 | 27 | |||
29375 | 23140 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.7446440145012 | -122.426661469126 | (37.7446440145012, -122.426661469126) | 2 | 7 | 5 | 63 | 22 | |||
29500 | 23910 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1620 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.78559018383 | -122.431235644012 | (37.78559018383, -122.431235644012) | 13 | 9 | 11 | 29490 | 13 | |||
29522 | 102830 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x12 | 6000750.2 | 2109361.5 | 37.7719463488262 | -122.440802922949 | (37.7719463488262, -122.440802922949) | 15 | 5 | 11 | 29492 | 9 | ||||
29813 | 141878 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1130 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003852.9179 | 2112548.3998 | 37.7808730023316 | -122.4302978041 | (37.7808730023316, -122.4302978041) | 7 | 9 | 11 | 29490 | 41 |
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) );