trees
1,381 rows where qSpecies_id = 54 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2145 | 140433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 15 | Width 0ft | 6003251.7396 | 2112391.1099 | 37.7804070531695 | -122.432366335522 | (37.7804070531695, -122.432366335522) | 15 | 9 | 11 | 29490 | 41 | |||
28390 | 140425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.7803005084328 | -122.43321309579 | (37.7803005084328, -122.43321309579) | 15 | 9 | 11 | 29490 | 41 | |||
61153 | 140429 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 15 | Width 0ft | 6003096.7102 | 2112369.578 | 37.7803391401181 | -122.432901115602 | (37.7803391401181, -122.432901115602) | 15 | 9 | 11 | 29490 | 41 | |||
76752 | 140427 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | 15 | 9 | 11 | 29490 | 41 | |||
81097 | 140426 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.433141244136 | (37.7803076012967, -122.433141244136) | 15 | 9 | 11 | 29490 | 41 | |||
102758 | 140424 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | 15 | 9 | 11 | 29490 | 41 | |||
105583 | 140431 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003184.2731 | 2112381.0617 | 37.7803756375453 | -122.432599015585 | (37.7803756375453, -122.432599015585) | 15 | 9 | 11 | 29490 | 41 | |||
138318 | 140434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 13 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003279.731 | 2112394.6985 | 37.7804184937232 | -122.432269756603 | (37.7804184937232, -122.432269756603) | 15 | 9 | 11 | 29490 | 41 | |||
179204 | 140428 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.432970381874 | (37.7803281468599, -122.432970381874) | 15 | 9 | 11 | 29490 | 41 | |||
191153 | 140423 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.433383957928 | (37.7802799627924, -122.433383957928) | 15 | 9 | 11 | 29490 | 41 | |||
191363 | 140422 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.433470553427 | (37.7802667133087, -122.433470553427) | 15 | 9 | 11 | 29490 | 41 | |||
55400 | 18519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.8003409270103 | -122.410812809398 | (37.8003409270103, -122.410812809398) | 3 | 1 | 10 | 308 | 4 | |||
4591 | 113471 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
15342 | 113473 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
33807 | 113465 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | |||
39581 | 142525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | 3 | 1 | 10 | 308 | 23 | |||
43317 | 113469 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
65054 | 113474 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
67077 | 113468 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
83117 | 113466 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
91889 | 113472 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 29 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
143625 | 113475 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 32 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
147121 | 113467 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
188448 | 113470 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
311 | 138787 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000799 | 2114887 | 37.7871207435599 | -122.441030597921 | (37.7871207435599, -122.441030597921) | 13 | 6 | 1 | 29490 | 27 | |||
581 | 248465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.7677969745346 | -122.453160476336 | (37.7677969745346, -122.453160476336) | 15 | 5 | 11 | 29492 | 9 | |||
1388 | 49516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 46422 | 6002507.7627 | 2114881.9371 | 37.7872040200664 | -122.435118299397 | (37.7872040200664, -122.435118299397) | 13 | 9 | 11 | 29490 | 27 | |||
1614 | 140208 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
2251 | 143510 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2026 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 14 | Width 0ft | Permit Number 48982 | 6003323.1573 | 2118630.9053 | 37.797543994409 | -122.432565097779 | (37.797543994409, -122.432565097779) | 13 | 9 | 1 | 57 | 17 | |
2413 | 201183 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013416.1569 | 2113924.2034 | 37.7851876840649 | -122.397310155353 | (37.7851876840649, -122.397310155353) | 6 | 2 | 9 | 28855 | 6 | |||
2553 | 140071 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
2761 | 199857 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.393250745752 | (37.725186191812, -122.393250745752) | 10 | 3 | 8 | 58 | 1 | |||
3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
3502 | 138641 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2760 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2020 12:00:00 AM | 3 | Width 0ft | 6000298.8786 | 2114459.033 | 37.7859171589985 | -122.442730161492 | (37.7859171589985, -122.442730161492) | 13 | 6 | 1 | 29490 | 27 | ||
3546 | 138584 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2702 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000961.2488 | 2114897.5694 | 37.7871590042849 | -122.440470012407 | (37.7871590042849, -122.440470012407) | 13 | 6 | 1 | 29490 | 27 | |||
3763 | 73629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 5x7 | 6005222.8265 | 2111323.2215 | 37.7775864626885 | -122.425471398253 | (37.7775864626885, -122.425471398253) | 7 | 9 | 11 | 28852 | 10 | ||
4593 | 4724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.415647128831 | (37.8042017393393, -122.415647128831) | 5 | 1 | 10 | 308 | 23 | |||
4913 | 64501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | 15 | 5 | 11 | 29492 | 10 | |
5364 | 245472 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | 10 | 4 | 7 | 28859 | 19 | |||
6447 | 38608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.389473352601 | (37.7313671428977, -122.389473352601) | 10 | 3 | 8 | 58 | 1 | |
6485 | 71703 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6005189.8095 | 2111320.4314 | 37.7775769362179 | -122.425585416633 | (37.7775769362179, -122.425585416633) | 7 | 9 | 11 | 28852 | 10 | |||
6549 | 142706 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 567 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008189.6261 | 2121340.372 | 37.8052582795068 | -122.415917737693 | (37.8052582795068, -122.415917737693) | 5 | 1 | 10 | 308 | 23 | |||
6605 | 528 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | 2 | 4 | 7 | 28859 | 19 | |||
6829 | 62365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2132 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 14 | 6x4 | Permit Number 22511 | 6002365.7866 | 2114401.6807 | 37.7858772955002 | -122.43557513482 | (37.7858772955002, -122.43557513482) | 13 | 6 | 1 | 29490 | 27 | |
7218 | 182129 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2650 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987716.6576 | 2098310.3756 | 37.7408520674665 | -122.485075392772 | (37.7408520674665, -122.485075392772) | 1 | 8 | 3 | 29491 | 35 | |||
7238 | 17116 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.7714069348749 | -122.450369559944 | (37.7714069348749, -122.450369559944) | 15 | 5 | 11 | 29492 | 9 | |||
7583 | 142470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | 3 | 1 | 10 | 308 | 23 | |||
7684 | 245413 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | 10 | 4 | 7 | 28859 | 19 | |||
7692 | 199749 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1555 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014744.6664 | 2092522.7122 | 37.7264976449454 | -122.391217378098 | (37.7264976449454, -122.391217378098) | 10 | 3 | 8 | 58 | 1 | |||
7836 | 72023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.407543551006 | (37.7919886256319, -122.407543551006) | 5 | 1 | 10 | 28857 | 21 | |||
7900 | 138130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003041.4675 | 2114785.2401 | 37.7869688058807 | -122.433264885414 | (37.7869688058807, -122.433264885414) | 13 | 9 | 11 | 29490 | 27 | |||
8024 | 59162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1981 12:00:00 AM | 16 | 3x3 | Permit Number 19443 | 6005553.1697 | 2111320.8777 | 37.7775986862615 | -122.424328461999 | (37.7775986862615, -122.424328461999) | 7 | 9 | 11 | 28852 | 10 |
8143 | 142468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1455 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010964.6624 | 2119932.1708 | 37.8015473270449 | -122.406215050843 | (37.8015473270449, -122.406215050843) | 3 | 1 | 10 | 308 | 23 | |||
8308 | 143512 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2030 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 16 | Width 0ft | Permit Number 48982 | 6003288.5063 | 2118622.406 | 37.7975186924595 | -122.432684391924 | (37.7975186924595, -122.432684391924) | 13 | 9 | 1 | 57 | 17 | |
8710 | 140706 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6002658.7155 | 2110338.0026 | 37.7747360892866 | -122.434271058386 | (37.7747360892866, -122.434271058386) | 15 | 5 | 11 | 29492 | 10 | |||
8783 | 7166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.431408122706 | (37.7764540897977, -122.431408122706) | 15 | 9 | 11 | 29492 | 10 | |||
8916 | 140525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1190 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6003468.9224 | 2111772.2595 | 37.7787201566355 | -122.431570805288 | (37.7787201566355, -122.431570805288) | 15 | 9 | 11 | 29490 | 41 | |||
9445 | 32298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.7661430585802 | -122.40291664053 | (37.7661430585802, -122.40291664053) | 8 | 3 | 8 | 28853 | 20 | |
9567 | 143511 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2026 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 14 | Width 0ft | Permit Number 48982 | 6003307.4663 | 2118627.6363 | 37.7975341287535 | -122.432619159147 | (37.7975341287535, -122.432619159147) | 13 | 9 | 1 | 57 | 17 | |
10282 | 18081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2967 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999746.4018 | 2114674.089 | 37.7864761362834 | -122.444657035366 | (37.7864761362834, -122.444657035366) | 15 | 6 | 1 | 29490 | 31 | |||
10375 | 138610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1716 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000062.7737 | 2114910.7976 | 37.7871441247685 | -122.443579481437 | (37.7871441247685, -122.443579481437) | 13 | 6 | 1 | 29490 | 27 | |||
10837 | 70252 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.439451594404 | (37.7750685309709, -122.439451594404) | 15 | 5 | 11 | 29492 | 10 | |||
11090 | 38646 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 209 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.424621959344 | (37.7437522091261, -122.424621959344) | 2 | 7 | 5 | 63 | 22 | |||
11382 | 140207 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
11526 | 66368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | 15 | 6 | 1 | 54 | 31 | |
11591 | 246388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.7685701345672 | -122.451204446298 | (37.7685701345672, -122.451204446298) | 15 | 5 | 11 | 29492 | 9 | |||
11850 | 66378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 624 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 8 | Permit Number 29503 | 6003604.7588 | 2110527.1817 | 37.7753091794017 | -122.431012007993 | (37.7753091794017, -122.431012007993) | 7 | 9 | 11 | 29492 | 10 | |
12129 | 57526 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.425022615137 | (37.7775297860553, -122.425022615137) | 7 | 9 | 11 | 28852 | 10 | |
12468 | 9697 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 423 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005890.102 | 2111192.506 | 37.7772652286056 | -122.423153770988 | (37.7772652286056, -122.423153770988) | 7 | 9 | 11 | 28852 | 10 | |||
12978 | 7162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.431375949555 | (37.7762857300682, -122.431375949555) | 15 | 9 | 11 | 29492 | 10 | |||
13226 | 141684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998631.8104 | 2111816.1017 | 37.7785651829019 | -122.448307345965 | (37.7785651829019, -122.448307345965) | 15 | 6 | 2 | 54 | 16 | |||
13248 | 138690 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2838 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999904.6577 | 2114405.5136 | 37.7857477274076 | -122.444090205696 | (37.7857477274076, -122.444090205696) | 15 | 6 | 1 | 29490 | 31 | |||
13607 | 140513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1060 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003397.5169 | 2112023.698 | 37.7794064966556 | -122.431835782497 | (37.7794064966556, -122.431835782497) | 15 | 9 | 11 | 29490 | 41 | |||
13989 | 137919 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1963 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004551.2938 | 2115340.9969 | 37.788580310137 | -122.428080846949 | (37.788580310137, -122.428080846949) | 13 | 9 | 11 | 28858 | 27 | |||
14187 | 201882 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | 6 | 2 | 9 | 28856 | 6 | |||
14249 | 245420 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2855 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6009712.0846 | 2102179.2059 | 37.7527317128259 | -122.409296032004 | (37.7527317128259, -122.409296032004) | 2 | 4 | 7 | 28859 | 19 | |||
14320 | 143346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1910 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003772.2749 | 2118686.9893 | 37.7977234452078 | -122.431015036831 | (37.7977234452078, -122.431015036831) | 13 | 9 | 1 | 57 | 17 | |||
14805 | 143525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1957 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003628.1215 | 2118621.4061 | 37.7975352014281 | -122.43150916251 | (37.7975352014281, -122.43150916251) | 13 | 9 | 1 | 57 | 17 | |||
15279 | 248611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953 | (37.7667562259025, -122.45125791953) | 15 | 5 | 11 | 29492 | 9 | |||
15508 | 244193 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998442.5226 | 2108797.178 | 37.7702651709945 | -122.448744661621 | (37.7702651709945, -122.448744661621) | 15 | 5 | 11 | 29492 | 9 | |||
16062 | 247337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003076.0904 | 2109591.4739 | 37.7727099867472 | -122.432773934025 | (37.7727099867472, -122.432773934025) | 15 | 5 | 11 | 29492 | 9 | |||
16127 | 246164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.7683928596779 | -122.452566262235 | (37.7683928596779, -122.452566262235) | 15 | 5 | 11 | 29492 | 9 | |||
16546 | 143187 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010390.2098 | 2121342.6183 | 37.8053879184635 | -122.408302464879 | (37.8053879184635, -122.408302464879) | 3 | 1 | 10 | 308 | 23 | |||
16609 | 141535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996788.0463 | 2111499.0832 | 37.777589151551 | -122.454662685268 | (37.777589151551, -122.454662685268) | 15 | 6 | 2 | 54 | 16 | |||
16934 | 143369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1763 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004565.1185 | 2118753.222 | 37.7979501963148 | -122.428276302626 | (37.7979501963148, -122.428276302626) | 13 | 9 | 1 | 57 | 17 | |||
17155 | 140539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003373.4703 | 2111871.9826 | 37.7789885607925 | -122.43190813363 | (37.7789885607925, -122.43190813363) | 15 | 9 | 11 | 29490 | 41 | |||
17314 | 71305 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001154.5387 | 2110263.7555 | 37.7744467352044 | -122.439468977163 | (37.7744467352044, -122.439468977163) | 15 | 5 | 11 | 29492 | 10 | |||
17483 | 247328 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | Permit Number 785235 | 6003691.2873 | 2110070.3794 | 37.7740598153428 | -122.430680081912 | (37.7740598153428, -122.430680081912) | 7 | 9 | 11 | 29492 | 10 | ||
17669 | 64062 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1990 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | 3 | 1 | 10 | 308 | 23 | |
17983 | 107661 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | 15 | 5 | 5 | 28862 | 3 | |||
18163 | 140072 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
18387 | 245411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | 2 | 4 | 7 | 28859 | 19 | |||
18641 | 59622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | 15 | 5 | 11 | 29492 | 10 | |
18647 | 138987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.431524537427 | (37.7757340330654, -122.431524537427) | 15 | 9 | 11 | 29492 | 10 | |||
18863 | 138123 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003035.9259 | 2114580.1998 | 37.7864055028496 | -122.433269401448 | (37.7864055028496, -122.433269401448) | 13 | 9 | 11 | 29490 | 27 | |||
19361 | 61824 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | 7 | 9 | 11 | 28852 | 10 | ||
19779 | 140264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997701.9343 | 2110276.144 | 37.7742836533846 | -122.451413027686 | (37.7742836533846, -122.451413027686) | 15 | 5 | 2 | 29492 | 16 | |||
20537 | 141610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | |||
20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 3 | 1 | 10 | 308 | 23 | ||
21039 | 97936 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.410321003577 | (37.8057498158932, -122.410321003577) | 3 | 1 | 10 | 308 | 23 |
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) );