trees
11,761 rows where qSpecies_id = 17 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5164 | 34923 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
5249 | 100990 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
5258 | 34916 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
5426 | 102462 | Undocumented 4 | Tree(s) :: 17 | 3354 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007825.6 | 2104471.5 | 37.7589199559787 | -122.415982170306 | (37.7589199559787, -122.415982170306) | 2 | 4 | 7 | 28859 | 19 | |||
5582 | 183333 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
5702 | 121171 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
5929 | 56671 | Permitted Site 7 | Tree(s) :: 17 | 4019 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003016.37543683 | 2102387.64310455 | 37.7529266215546 | -122.432465865209 | (37.7529266215546, -122.432465865209) | 2 | 4 | 5 | 28862 | 22 | |||||
5937 | 105211 | Permitted Site 7 | Tree(s) :: 17 | 223 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 11471 | 6001117 | 2104982 | 37.7599422071638 | -122.439220183407 | (37.7599422071638, -122.439220183407) | 2 | 4 | 5 | 28862 | 3 | |||
5994 | 183334 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
6001 | 262052 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
6074 | 184628 | DPW Maintained 1 | Tree(s) :: 17 | 1796 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984434.1354 | 2102998.0252 | 37.7535313177823 | -122.496770827925 | (37.7535313177823, -122.496770827925) | 1 | 8 | 3 | 56 | 35 | |||
6145 | 117568 | Undocumented 4 | Tree(s) :: 17 | 2636 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990923 | 2095039.4 | 37.7320570487265 | -122.473750606168 | (37.7320570487265, -122.473750606168) | 1 | 8 | 4 | 64 | 40 | |||||
6241 | 261939 | DPW Maintained 1 | Tree(s) :: 17 | 1 Verna St | 4 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
6266 | 112694 | Undocumented 4 | Tree(s) :: 17 | 1x CUMBERLAND ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6005299 | 2104587 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | 2 | 4 | 5 | 28859 | 19 | ||||
6284 | 181791 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
6304 | 105356 | Undocumented 4 | Tree(s) :: 17 | 207-211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006236 | 2101921 | 37.7518273734539 | -122.421298642673 | (37.7518273734539, -122.421298642673) | 2 | 4 | 5 | 28859 | 19 | |||
6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
6380 | 110632 | Undocumented 4 | Tree(s) :: 17 | 1051X Mandalay Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991736.20076 | 2101819.33429 | 37.7507200830769 | -122.47143306251 | (37.7507200830769, -122.47143306251) | 1 | 8 | 4 | 29491 | 12 | |||||
6455 | 117452 | Undocumented 4 | Tree(s) :: 17 | 1530 HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016055 | 2097226 | 37.7394845622146 | -122.387015456594 | (37.7394845622146, -122.387015456594) | 10 | 3 | 8 | 58 | 1 | ||||
6536 | 48473 | Permitted Site 7 | Tree(s) :: 17 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
6662 | 261811 | DPW Maintained 1 | Tree(s) :: 17 | 2371 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5985746 | 2099098 | 37.7428996853912 | -122.491947068435 | (37.7428996853912, -122.491947068435) | 1 | 8 | 3 | 29491 | 35 | ||||
6799 | 34917 | Permitted Site 7 | Tree(s) :: 17 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
6878 | 232398 | DPW Maintained 1 | Tree(s) :: 17 | 141 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 784757 | 6001393.83562 | 2106197.31009 | 37.763294900763 | -122.438349814208 | (37.763294900763, -122.438349814208) | 15 | 5 | 5 | 28862 | 3 | ||
7166 | 48480 | Permitted Site 7 | Tree(s) :: 17 | 1 | Median : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 | ||||||
7347 | 262056 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 7 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
7513 | 45378 | Permitted Site 7 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | ||||||
7539 | 100598 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
7552 | 97352 | Permitted Site 7 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
7609 | 34915 | Permitted Site 7 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
7623 | 100994 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
7626 | 30278 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 128 | |||||||||||||||
7632 | 48474 | Permitted Site 7 | Tree(s) :: 17 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
7660 | 34914 | Permitted Site 7 | Tree(s) :: 17 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
7679 | 48477 | Permitted Site 7 | Tree(s) :: 17 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
7837 | 96135 | DPW Maintained 1 | Tree(s) :: 17 | 1444X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016335.2 | 2096661 | 37.7379486980737 | -122.386007263552 | (37.7379486980737, -122.386007263552) | 10 | 3 | 8 | 58 | 1 | ||||
7919 | 73237 | DPW Maintained 1 | Tree(s) :: 17 | 2609 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000014.0127 | 2114014.6742 | 37.7846808214882 | -122.443683781718 | (37.7846808214882, -122.443683781718) | 15 | 6 | 11 | 29490 | 31 | |||
7931 | 260390 | Undocumented 4 | Tree(s) :: 17 | 501x Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009931 | 2112548 | 37.7812143059327 | -122.409270622322 | (37.7812143059327, -122.409270622322) | 14 | 2 | 9 | 28853 | 34 | ||||
7964 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | 14 | 3 | 8 | 28856 | 29 | ||||
8161 | 262050 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
8193 | 79990 | DPW Maintained 1 | Tree(s) :: 17 | 3655 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981694.1032 | 2096684.9357 | 37.7360364047838 | -122.505778307285 | (37.7360364047838, -122.505778307285) | 1 | 8 | 3 | 29491 | 35 | |||
8241 | 56665 | Permitted Site 7 | Tree(s) :: 17 | 4549 Callan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8260 | 56735 | Permitted Site 7 | Tree(s) :: 17 | 4601 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015154.58866017 | 2096112.48595754 | 37.7363771809952 | -122.390050945039 | (37.7363771809952, -122.390050945039) | 10 | 3 | 8 | 58 | 1 | |||||
8264 | 103300 | Undocumented 4 | Tree(s) :: 17 | 3240 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007996.9 | 2100607.8 | 37.748320741451 | -122.415116245427 | (37.748320741451, -122.415116245427) | 2 | 4 | 7 | 28859 | 19 | ||||
8352 | 84946 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
8600 | 260856 | DPW Maintained 1 | Tree(s) :: 17 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||||
8614 | 255775 | Undocumented 4 | Tree(s) :: 17 | 300 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004016 | 2097157 | 37.7386211197367 | -122.428636146259 | (37.7386211197367, -122.428636146259) | 2 | 7 | 5 | 63 | 7 | ||||
8661 | 34920 | Permitted Site 7 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
8689 | 48479 | Permitted Site 7 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
9162 | 48469 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
9217 | 48476 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
9258 | 109525 | Permitted Site 7 | Tree(s) :: 17 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991168.8 | 2098442.9 | 37.7414164276204 | -122.473148952772 | (37.7414164276204, -122.473148952772) | 1 | 8 | 4 | 29491 | 40 | |||||
9260 | 262526 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
9265 | 261652 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||||
9335 | 112908 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9384 | 111852 | Permitted Site 7 | Tree(s) :: 17 | 187 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000958.85547421 | 2106373.84069392 | 37.7637548596233 | -122.439866921627 | (37.7637548596233, -122.439866921627) | 15 | 5 | 5 | 28862 | 3 | |||||
9479 | 48487 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
9557 | 112910 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9737 | 34922 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
9889 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | |||||
9900 | 88762 | Permitted Site 7 | Tree(s) :: 17 | 3972 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51683 | 6003154 | 2105365 | 37.7611095365426 | -122.432202545498 | (37.7611095365426, -122.432202545498) | 15 | 4 | 5 | 28862 | 3 | |||
9919 | 106007 | Undocumented 4 | Tree(s) :: 17 | 1800X LANE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014836 | 2094060 | 37.7307237967737 | -122.391009037699 | (37.7307237967737, -122.391009037699) | 10 | 3 | 8 | 58 | 1 | ||||
10146 | 78362 | DPW Maintained 1 | Tree(s) :: 17 | 207 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | Permit Number 781699 | 6000993.78153 | 2089200.02562 | 37.7166015883641 | -122.438515563747 | (37.7166015883641, -122.438515563747) | 9 | 7 | 6 | 28861 | 5 | |
10185 | 97351 | Permitted Site 7 | Tree(s) :: 17 | 1 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
10202 | 261492 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
10422 | 56667 | Permitted Site 7 | Tree(s) :: 17 | 495 Callan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10439 | 56506 | Permitted Site 7 | Tree(s) :: 17 | 556 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000140.95591591 | 2095509.77922044 | 37.733878172831 | -122.441915966113 | (37.733878172831, -122.441915966113) | 9 | 7 | 5 | 63 | 40 | |||||
10611 | 49383 | Permitted Site 7 | Tree(s) :: 17 | 522Walbridge Carter St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46344 | 6005268.88409545 | 2086363.71271864 | 37.7090559366076 | -122.423537125807 | (37.7090559366076, -122.423537125807) | 9 | 7 | 8 | 309 | 5 | ||||
10683 | 111476 | Permitted Site 7 | Tree(s) :: 17 | 2x TRAINOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | |||
10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
10729 | 262053 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 4 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
10796 | 56567 | Permitted Site 7 | Tree(s) :: 17 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992136.3013072 | 2094883.62123857 | 37.7316995160329 | -122.469544661545 | (37.7316995160329, -122.469544661545) | 9 | 8 | 4 | 59 | 40 | |||||
10988 | 261428 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
11038 | 262060 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 11 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
11148 | 101952 | Undocumented 4 | Tree(s) :: 17 | 55 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003780.5 | 2096861.5 | 37.7377964134917 | -122.429429325656 | (37.7377964134917, -122.429429325656) | 2 | 7 | 5 | 63 | 7 | |||
11163 | 97769 | Undocumented 4 | Tree(s) :: 17 | 362 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6007113.7 | 2105238.5 | 37.7609859097905 | -122.418498646119 | (37.7609859097905, -122.418498646119) | 2 | 4 | 7 | 28859 | 19 | |||
11169 | 112778 | DPW Maintained 1 | Tree(s) :: 17 | 1899X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||||
11728 | 248542 | DPW Maintained 1 | Tree(s) :: 17 | 258 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998812.5011 | 2107653.6201 | 37.7671464005807 | -122.44738259118 | (37.7671464005807, -122.44738259118) | 15 | 5 | 11 | 29492 | 9 | |||
12044 | 94493 | Permitted Site 7 | Tree(s) :: 17 | 242 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986861.9 | 2114315.4 | 37.7847476191928 | -122.489207219387 | (37.7847476191928, -122.489207219387) | 11 | 6 | 1 | 55 | 33 | |||||
12099 | 102848 | Undocumented 4 | Tree(s) :: 17 | 31 Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
12144 | 111632 | Section 806 (d) 5 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774682 | 5985071 | 2103231.6 | 37.7542099449347 | -122.49458566251 | (37.7542099449347, -122.49458566251) | 1 | 8 | 3 | 56 | 35 | ||
12191 | 113350 | Undocumented 4 | Tree(s) :: 17 | 7802x GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x8 | 5982855 | 2112422 | 37.7793142001238 | -122.502929326548 | (37.7793142001238, -122.502929326548) | 11 | 6 | 2 | 55 | 26 | |||
12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
12274 | 56690 | Permitted Site 7 | Tree(s) :: 17 | 55 Hallam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010204.8585712 | 2110471.70826771 | 37.7755286348545 | -122.408176723323 | (37.7755286348545, -122.408176723323) | 8 | 2 | 9 | 28853 | 34 | |||||
12315 | 56545 | Permitted Site 7 | Tree(s) :: 17 | 99 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006997.81069025 | 2098938.41719823 | 37.7436807955871 | -122.418452724226 | (37.7436807955871, -122.418452724226) | 2 | 7 | 7 | 28859 | 2 | |||||
12345 | 107864 | Permitted Site 7 | Tree(s) :: 17 | 362 BRANNAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014441.4 | 2112297.4 | 37.7807778793576 | -122.393649202889 | (37.7807778793576, -122.393649202889) | 6 | 2 | 9 | 28856 | 6 | |||||
12355 | 34918 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
12566 | 56696 | Permitted Site 7 | Tree(s) :: 17 | 1831 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5983776.96653861 | 2102691.49481904 | 37.7526511432753 | -122.499020778367 | (37.7526511432753, -122.499020778367) | 1 | 8 | 3 | 56 | 35 | |||||
12610 | 262055 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 6 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
12696 | 100611 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
12743 | 105305 | Permitted Site 7 | Tree(s) :: 17 | 2200 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770181 | 6003396.4 | 2107048 | 37.7657443893248 | -122.431484339518 | (37.7657443893248, -122.431484339518) | 15 | 5 | 5 | 28862 | 3 | |||
12745 | 48470 | Permitted Site 7 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
12824 | 71999 | DPW Maintained 1 | Tree(s) :: 17 | 1919 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987523.8589 | 2102195.0257 | 37.7515070489426 | -122.486027091209 | (37.7515070489426, -122.486027091209) | 1 | 8 | 3 | 29491 | 35 | |||
12827 | 261426 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
12859 | 97357 | Permitted Site 7 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
12879 | 261642 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||||
13070 | 181793 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13071 | 115457 | Permitted Site 7 | Tree(s) :: 17 | 476 FAIR OAKS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005502 | 2100939 | 37.7490896185955 | -122.423767101444 | (37.7490896185955, -122.423767101444) | 2 | 4 | 5 | 28859 | 19 | ||||
13206 | 181790 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13334 | 106393 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 |
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) );