trees
420 rows where qSpecies_id = 116 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
7744 | 225194 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778605 | 6007219.63733 | 2103836.19178 | 37.7571414587344 | -122.418032839538 | (37.7571414587344, -122.418032839538) | 2 | 4 | 7 | 28859 | 19 | ||
8894 | 63236 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 3634 20th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | 2 | 4 | 5 | 28859 | 19 | |
9271 | 225190 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
11289 | 34055 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
11511 | 225198 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007149.23047 | 2103831.77129 | 37.7571253581517 | -122.418276020715 | (37.7571253581517, -122.418276020715) | 2 | 4 | 7 | 28859 | 19 | ||
11548 | 225197 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | 2 | 4 | 7 | 28859 | 19 | ||
12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
13706 | 225187 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
13922 | 34080 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
21506 | 241185 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3781 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005371.27672 | 2100474.34138 | 37.7478063924621 | -122.424186102634 | (37.7478063924621, -122.424186102634) | 2 | 4 | 5 | 28859 | 22 | |||
24606 | 241219 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6003095.93223 | 2100399.37123 | 37.7474718059861 | -122.432048772745 | (37.7474718059861, -122.432048772745) | 2 | 4 | 5 | 63 | 22 | |||
28781 | 241208 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009151.46118 | 2106358.27771 | 37.7641750708383 | -122.411530008229 | (37.7641750708383, -122.411530008229) | 8 | 4 | 7 | 28859 | 19 | |||
29945 | 241206 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2387 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008217.68506 | 2104568.2265 | 37.759207580982 | -122.414632997525 | (37.759207580982, -122.414632997525) | 2 | 4 | 7 | 28859 | 19 | |||
29995 | 117607 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
30821 | 108222 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
31308 | 44007 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 3 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
33838 | 241222 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009029.52417 | 2106399.69099 | 37.7642819417697 | -122.411954681586 | (37.7642819417697, -122.411954681586) | 8 | 4 | 7 | 28859 | 19 | |||
34216 | 34084 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
34621 | 241182 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009519.86871 | 2101254.76714 | 37.7501826387226 | -122.409895500292 | (37.7501826387226, -122.409895500292) | 2 | 4 | 7 | 28859 | 19 | |||
36520 | 241186 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6006573.70754 | 2106363.42565 | 37.7640442779462 | -122.420446098324 | (37.7640442779462, -122.420446098324) | 8 | 4 | 7 | 28859 | 19 | |||
40188 | 64622 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 350 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25527 | 6006698.09280064 | 2104074.24597744 | 37.7577657327882 | -122.419853436478 | (37.7577657327882, -122.419853436478) | 2 | 4 | 7 | 28859 | 19 | ||
42038 | 241214 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009008.65245 | 2106350.93983 | 37.7641469112767 | -122.412023425759 | (37.7641469112767, -122.412023425759) | 8 | 4 | 7 | 28859 | 19 | |||
45490 | 34052 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
45906 | 34053 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
48136 | 44006 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 4 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
49594 | 241189 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 415 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007440.26209 | 2107242.97401 | 37.7665081073951 | -122.41751127324 | (37.7665081073951, -122.41751127324) | 8 | 4 | 7 | 28853 | 19 | |||
53304 | 241211 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009079.81613 | 2106354.44033 | 37.7641605153159 | -122.411777537601 | (37.7641605153159, -122.411777537601) | 8 | 4 | 7 | 28859 | 19 | |||
60510 | 34081 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 |
64512 | 100205 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091 | 2104064 | 37.7575337303282 | -122.432327515179 | (37.7575337303282, -122.432327515179) | 2 | 4 | 5 | 28862 | 3 | |
64915 | 34083 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
68364 | 241215 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008984.20306 | 2106349.91543 | 37.7641427267158 | -122.412107917041 | (37.7641427267158, -122.412107917041) | 8 | 4 | 7 | 28859 | 19 | |||
69699 | 31970 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35371 | 6009512.01927897 | 2101306.3823382 | 37.7503239226813 | -122.409926287411 | (37.7503239226813, -122.409926287411) | 2 | 4 | 7 | 28859 | 19 | |||
70721 | 241207 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007609.4952 | 2103000.12596 | 37.7548677477628 | -122.416625332187 | (37.7548677477628, -122.416625332187) | 2 | 4 | 7 | 28859 | 19 | |||
76957 | 241198 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.7546903196133 | -122.426677105059 | (37.7546903196133, -122.426677105059) | 2 | 4 | 5 | 28862 | 22 | |||
78460 | 67800 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31444 | 6001831.31402978 | 2100620.67337741 | 37.7480076719463 | -122.436437569325 | (37.7480076719463, -122.436437569325) | 2 | 4 | 5 | 28862 | 22 | ||
80961 | 241221 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009078.922 | 2106403.19833 | 37.764294343423 | -122.411784075669 | (37.764294343423, -122.411784075669) | 8 | 4 | 7 | 28859 | 19 | |||
81340 | 41897 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2500 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42262 | 6001987.05760353 | 2105790.14936536 | 37.762210660505 | -122.436268917311 | (37.762210660505, -122.436268917311) | 15 | 4 | 5 | 28862 | 3 | ||
81429 | 39859 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
87387 | 241193 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.76354 | 2105082.07302 | 37.7607268479899 | -122.407987146983 | (37.7607268479899, -122.407987146983) | 10 | 4 | 8 | 28859 | 19 | |||
88237 | 67807 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | 2 | 4 | 5 | 28862 | 22 | ||
88243 | 241217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6003092.5802 | 2100398.11558 | 37.7474681682247 | -122.432060274186 | (37.7474681682247, -122.432060274186) | 2 | 4 | 5 | 63 | 22 | |||
91363 | 241216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000321.631 | 2101619.05614 | 37.7506630907493 | -122.441729618453 | (37.7506630907493, -122.441729618453) | 2 | 4 | 5 | 28862 | 22 | |||
96325 | 241195 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.31923 | 2105113.84294 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | 10 | 4 | 8 | 28859 | 19 | |||
96948 | 37726 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40090 | 6010246.00158069 | 2101670.73784629 | 37.7513654710612 | -122.407413798897 | (37.7513654710612, -122.407413798897) | 2 | 4 | 7 | 28859 | 19 | ||
97236 | 47561 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
97320 | 34082 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
99771 | 241212 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009052.89196 | 2106353.81264 | 37.7641572813666 | -122.411870616529 | (37.7641572813666, -122.411870616529) | 8 | 4 | 7 | 28859 | 19 | |||
100358 | 4167 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3781 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/1993 12:00:00 AM | 12 | 3X3 | 6005338.8489102 | 2100470.98597 | 37.7477953482432 | -122.424297997893 | (37.7477953482432, -122.424297997893) | 2 | 4 | 5 | 28859 | 22 | ||
102795 | 34050 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
104413 | 241223 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009004.56515 | 2106399.07167 | 37.7642788409211 | -122.412040964327 | (37.7642788409211, -122.412040964327) | 8 | 4 | 7 | 28859 | 19 | |||
104918 | 241194 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010150.13435 | 2105098.12881 | 37.7607709543248 | -122.4079869968 | (37.7607709543248, -122.4079869968) | 10 | 4 | 8 | 28859 | 19 | |||
106666 | 108225 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
108025 | 241204 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2399 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008220.32471 | 2104519.20022 | 37.7590731143473 | -122.414620398932 | (37.7590731143473, -122.414620398932) | 2 | 4 | 7 | 28859 | 19 | |||
109210 | 34079 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
110288 | 241190 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010222.30692 | 2101664.86224 | 37.7513480117 | -122.407495323966 | (37.7513480117, -122.407495323966) | 2 | 4 | 7 | 28859 | 19 | |||
110485 | 44261 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
110492 | 4166 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3771 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/18/1999 12:00:00 AM | 3 | 3X3 | 6005390.77926 | 2100476.44824 | 37.747813278574 | -122.424118813557 | (37.747813278574, -122.424118813557) | 2 | 4 | 5 | 28859 | 22 | ||
112460 | 85491 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400 24th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641 | 2101716 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | 2 | 4 | 5 | 28862 | 22 | |||
112628 | 83941 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 60 13th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.414608304259 | (37.7696248364946, -122.414608304259) | 8 | 4 | 9 | 28853 | 19 | ||
113741 | 117606 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
114315 | 108221 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
116024 | 39860 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
121022 | 241220 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009102.18096 | 2106403.85246 | 37.7642974442959 | -122.411703675409 | (37.7642974442959, -122.411703675409) | 8 | 4 | 7 | 28859 | 19 | |||
122148 | 44008 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 2 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
123956 | 44009 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 1 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
129179 | 241191 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3630 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006057.85457 | 2104359.21039 | 37.7585120893797 | -122.422087892569 | (37.7585120893797, -122.422087892569) | 2 | 4 | 5 | 28859 | 19 | |||
129342 | 44264 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
129697 | 98644 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008222 | 2104509 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | 2 | 4 | 7 | 28859 | 19 | |||
129962 | 34076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
130221 | 241187 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Hoff St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6006570.58835 | 2106391.73918 | 37.7641218444722 | -122.420458896575 | (37.7641218444722, -122.420458896575) | 8 | 4 | 7 | 28859 | 19 | |||
130858 | 241218 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6003089.92025 | 2100398.1705 | 37.7474681682179 | -122.432069476034 | (37.7474681682179, -122.432069476034) | 2 | 4 | 5 | 63 | 22 | |||
133818 | 52311 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
135898 | 34049 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
136772 | 34047 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
138796 | 241213 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009032.16938 | 2106352.76347 | 37.7641532379917 | -122.411942216073 | (37.7641532379917, -122.411942216073) | 8 | 4 | 7 | 28859 | 19 | |||
139845 | 107411 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 3634 20th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006068 | 2104353 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | 2 | 4 | 5 | 28859 | 19 | ||||
142362 | 52312 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
142402 | 99104 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006000.9 | 2104423 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | 2 | 4 | 5 | 28859 | 19 | ||||
142699 | 52313 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
146756 | 44262 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
147565 | 47560 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
149786 | 34054 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
153681 | 241192 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3630 20th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6006049.00576 | 2104357.91631 | 37.7585080370469 | -122.422118403835 | (37.7585080370469, -122.422118403835) | 2 | 4 | 5 | 28859 | 19 | |||
157346 | 39861 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
158584 | 108224 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
159322 | 108227 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
160298 | 34051 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
161154 | 241188 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 419 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007442.12211 | 2107229.45736 | 37.7664710984984 | -122.417503881697 | (37.7664710984984, -122.417503881697) | 8 | 4 | 7 | 28853 | 19 | |||
163325 | 34077 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
163922 | 241209 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009128.3617 | 2106356.68814 | 37.7641694105262 | -122.411609790669 | (37.7641694105262, -122.411609790669) | 8 | 4 | 7 | 28859 | 19 | |||
164100 | 621 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3151 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 18 | 3X3 | 6007979.07595 | 2102079.24238 | 37.7523599891254 | -122.415282029241 | (37.7523599891254, -122.415282029241) | 2 | 4 | 7 | 28859 | 19 | ||
164496 | 108220 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
166497 | 44263 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
169340 | 255617 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 350 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006699 | 2104069 | 37.7577513796565 | -122.419849926759 | (37.7577513796565, -122.419849926759) | 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) );