trees
11,635 rows where qSpecies_id = 27 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194516 | 265149 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194515 | 265162 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1699 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006124 | 2116197 | 37.791019535338 | -122.422700369292 | (37.791019535338, -122.422700369292) | 13 | 9 | 1 | 28858 | 27 | ||||
194514 | 265151 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194513 | 265163 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1699 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006124 | 2116197 | 37.791019535338 | -122.422700369292 | (37.791019535338, -122.422700369292) | 13 | 9 | 1 | 28858 | 27 | ||||
194509 | 134259 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1625 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6006170.6591 | 2116000.96505 | 37.7904839045708 | -122.422524994529 | (37.7904839045708, -122.422524994529) | 13 | 9 | 1 | 28858 | 27 | |||
194506 | 134257 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1625 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 4ft | 6006160.66305 | 2116055.60858 | 37.7906333781701 | -122.422563464854 | (37.7906333781701, -122.422563464854) | 13 | 9 | 1 | 28858 | 27 | |||
194505 | 134258 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1625 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6006165.05583 | 2116021.37931 | 37.7905396409395 | -122.422545832742 | (37.7905396409395, -122.422545832742) | 13 | 9 | 1 | 28858 | 27 | |||
194503 | 265148 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194498 | 265150 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194487 | 265122 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2100x Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6006061 | 2117676 | 37.7950769441166 | -122.423023514153 | (37.7950769441166, -122.423023514153) | 13 | 9 | 10 | 28858 | 32 | ||||
194484 | 27260 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6006404.26283 | 2115076.39725 | 37.7879584463594 | -122.421651043279 | (37.7879584463594, -122.421651043279) | 13 | 9 | 10 | 28858 | 21 | |||
194482 | 265119 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6006128.11756 | 2117026.5772 | 37.7932975792601 | -122.422745102704 | (37.7932975792601, -122.422745102704) | 13 | 9 | 10 | 28858 | 32 | ||||
194474 | 265121 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2100x Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6006061 | 2117676 | 37.7950769441166 | -122.423023514153 | (37.7950769441166, -122.423023514153) | 13 | 9 | 10 | 28858 | 32 | ||||
194468 | 265112 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006404.26283 | 2115076.39725 | 37.7879584463594 | -122.421651043279 | (37.7879584463594, -122.421651043279) | 13 | 9 | 10 | 28858 | 21 | ||||
194444 | 4138 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3550 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006105.41199 | 2100602.05875 | 37.7481984995675 | -122.421656565093 | (37.7481984995675, -122.421656565093) | 2 | 4 | 5 | 28859 | 19 | |||
194378 | 162678 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 208 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996153.38061 | 2090571.45956 | 37.7200906944144 | -122.455345364123 | (37.7200906944144, -122.455345364123) | 9 | 8 | 6 | 28861 | 24 | ||
194316 | 221734 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 203 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 780527 | 5997194 | 2107012 | 37.7652920558138 | -122.452934396642 | (37.7652920558138, -122.452934396642) | 15 | 5 | 11 | 29492 | 12 | |
194304 | 264984 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 94X Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780527 | 5998136 | 2107256 | 37.7660159557417 | -122.449693840282 | (37.7660159557417, -122.449693840282) | 15 | 5 | 11 | 29492 | 9 | |
194302 | 155102 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5997966.99634 | 2107143.35929 | 37.7656970025444 | -122.450270266774 | (37.7656970025444, -122.450270266774) | 15 | 5 | 11 | 29492 | 9 | |
194300 | 155101 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5997940.66985 | 2107138.81946 | 37.7656830306656 | -122.45036099667 | (37.7656830306656, -122.45036099667) | 15 | 5 | 11 | 29492 | 9 | |
194299 | 264985 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 94X Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780527 | 5998136 | 2107256 | 37.7660159557417 | -122.449693840282 | (37.7660159557417, -122.449693840282) | 15 | 5 | 11 | 29492 | 9 | |
194281 | 178533 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1985 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 2ft | Permit Number 785142 | 6000911.61584 | 2090780.99233 | 37.7209378926573 | -122.438912801483 | (37.7209378926573, -122.438912801483) | 9 | 7 | 6 | 28861 | 25 | ||
194221 | 245448 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2798 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008224.8425 | 2106829.96 | 37.7654181818347 | -122.414768309334 | (37.7654181818347, -122.414768309334) | 8 | 4 | 7 | 28853 | 19 | |||
194215 | 14371 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2324 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002694.0419 | 2106348.375 | 37.7637835565652 | -122.433863631274 | (37.7637835565652, -122.433863631274) | 15 | 4 | 5 | 28862 | 3 | |||
194192 | 247717 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 Broderick St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6001409.94207 | 2108737.73214 | 37.770271188299 | -122.438476132074 | (37.770271188299, -122.438476132074) | 15 | 5 | 11 | 29492 | 9 | |||
194151 | 133725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2051 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6001873.13899 | 2115655.22417 | 37.7892912110583 | -122.437369349937 | (37.7892912110583, -122.437369349937) | 13 | 6 | 1 | 29490 | 27 | |||
194136 | 134134 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2419 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003125.09984 | 2117121.48667 | 37.7933882866937 | -122.433142524625 | (37.7933882866937, -122.433142524625) | 13 | 9 | 1 | 29490 | 27 | |||
194123 | 246410 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2168 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003733.2857 | 2107342.3599 | 37.7665717184097 | -122.430340128044 | (37.7665717184097, -122.430340128044) | 7 | 4 | 5 | 28862 | 3 | |||
194116 | 972 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1599 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6001888.30681 | 2092957.56794 | 37.7269697994111 | -122.435692320241 | (37.7269697994111, -122.435692320241) | 9 | 7 | 6 | 28861 | 25 | |||
194114 | 107973 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2750 JACKSON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096.4 | 2116670.4 | 37.7920344322485 | -122.440129594684 | (37.7920344322485, -122.440129594684) | 13 | 6 | 1 | 29490 | 27 | ||||
194104 | 238730 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Appleton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6005725.63877 | 2096998.88108 | 37.738283567534 | -122.42271378923 | (37.738283567534, -122.42271378923) | 2 | 7 | 7 | 28859 | 2 | |||
194089 | 234639 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1111 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003850.26859 | 2101800.93285 | 37.7513629044954 | -122.429540266785 | (37.7513629044954, -122.429540266785) | 2 | 4 | 5 | 28862 | 22 | |||
194081 | 133962 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Normandie Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000946.53863 | 2117415.57521 | 37.7940719558207 | -122.44070158991 | (37.7940719558207, -122.44070158991) | 13 | 9 | 1 | 57 | 27 | |||
194078 | 26818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1310 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001324.9368 | 2112970.4697 | 37.7818883840034 | -122.439073567606 | (37.7818883840034, -122.439073567606) | 15 | 5 | 11 | 29490 | 41 | |||
194056 | 256816 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1101 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006375 | 2114401 | 37.786102322085 | -122.421704297146 | (37.786102322085, -122.421704297146) | 13 | 9 | 11 | 28858 | 41 | ||||
194053 | 133460 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3440 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997933.6832 | 2114835.72029 | 37.7868163262648 | -122.450940218515 | (37.7868163262648, -122.450940218515) | 11 | 6 | 1 | 54 | 31 | |||
194034 | 245922 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1828 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005467.5256 | 2109000.5126 | 37.7712226895032 | -122.424459647028 | (37.7712226895032, -122.424459647028) | 7 | 2 | 5 | 28852 | 10 | |||
194025 | 13640 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 579 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012428.77503 | 2115545.54355 | 37.7895844826841 | -122.400840161846 | (37.7895844826841, -122.400840161846) | 12 | 2 | 9 | 28855 | 6 | |||
194018 | 133936 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2565 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000691.28172 | 2117104.37718 | 37.7932029480955 | -122.441562460547 | (37.7932029480955, -122.441562460547) | 13 | 6 | 1 | 29490 | 27 | |||
194005 | 134727 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2550 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005831.56603 | 2119154.3396 | 37.7991231410717 | -122.423922566181 | (37.7991231410717, -122.423922566181) | 13 | 9 | 1 | 28858 | 32 | |||
193993 | 24013 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 393 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 5991924.8305 | 2096676.2373 | 37.7366093650749 | -122.470406255119 | (37.7366093650749, -122.470406255119) | 1 | 8 | 4 | 59 | 40 | |||
193970 | 235338 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3125 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6008837.66692 | 2100528.02506 | 37.7481489100535 | -122.412203246977 | (37.7481489100535, -122.412203246977) | 2 | 4 | 7 | 28859 | 2 | |||
193958 | 33625 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 395 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37727 | 6004659.53448336 | 2109979.61228939 | 37.7738653980353 | -122.427324279619 | (37.7738653980353, -122.427324279619) | 7 | 9 | 11 | 28852 | 10 | |||
193955 | 93226 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 746 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4.5 | 5998618.6 | 2107971.8 | 37.7680089598714 | -122.44807617536 | (37.7680089598714, -122.44807617536) | 15 | 5 | 11 | 29492 | 9 | ||||
193924 | 14229 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004655.4793 | 2108222.1981 | 37.7690397355533 | -122.427213099786 | (37.7690397355533, -122.427213099786) | 7 | 4 | 5 | 28862 | 3 | |||
193918 | 212767 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992888.80318 | 2097843.20156 | 37.7398692449767 | -122.46715823707 | (37.7398692449767, -122.46715823707) | 1 | 8 | 4 | 59 | 40 | |||
193869 | 135259 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1180 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012589.31222 | 2120161.05025 | 37.8022665162374 | -122.400609079265 | (37.8022665162374, -122.400609079265) | 3 | 1 | 10 | 28860 | 6 | |||
193866 | 134405 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 721 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006588.6112 | 2112939.57666 | 37.7821016547068 | -122.420861464609 | (37.7821016547068, -122.420861464609) | 7 | 9 | 11 | 28852 | 41 | |||
193840 | 2891 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1555 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 65 | 3x3 | 6006907.65741 | 2116020.89539 | 37.7905801778777 | -122.419976436385 | (37.7905801778777, -122.419976436385) | 13 | 9 | 10 | 28858 | 21 | |||
193816 | 226 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | 1 | 8 | 4 | 64 | 35 | |||
193804 | 134404 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 721 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006590.51052 | 2112960.13384 | 37.7821582067655 | -122.420856353743 | (37.7821582067655, -122.420856353743) | 7 | 9 | 11 | 28852 | 41 | |||
193791 | 134110 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2716 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001140.36436 | 2117782.93728 | 37.7950916718842 | -122.440057288627 | (37.7950916718842, -122.440057288627) | 13 | 9 | 1 | 57 | 27 | |||
193775 | 234781 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 630 Grand View Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000033.89679 | 2101328.88084 | 37.7498499408384 | -122.442703791042 | (37.7498499408384, -122.442703791042) | 2 | 4 | 5 | 28862 | 22 | |||
193772 | 123682 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4036 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5995005.86399 | 2114428.75673 | 37.7855308679741 | -122.46104020919 | (37.7855308679741, -122.46104020919) | 11 | 6 | 1 | 54 | 11 | |||
193770 | 24003 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 307 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3x3 | 5992304.2356 | 2097084.7947 | 37.7377530904378 | -122.469124226279 | (37.7377530904378, -122.469124226279) | 1 | 8 | 4 | 59 | 40 | |||
193766 | 211989 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 751 Junipero Serra Blvd | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991413.9184 | 2093039.12628 | 37.7265932181855 | -122.47190767821 | (37.7265932181855, -122.47190767821) | 9 | 8 | 4 | 59 | 40 | |||
193744 | 23969 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 98 West Portal Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5992949.0597 | 2097865.5443 | 37.7399340705835 | -122.466951520918 | (37.7399340705835, -122.466951520918) | 1 | 8 | 4 | 59 | 40 | |||
193742 | 113520 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 201 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6008926.13673 | 2113172.72181 | 37.7828732937156 | -122.412791144592 | (37.7828732937156, -122.412791144592) | 7 | 10 | 9 | 28852 | 36 | ||||
193735 | 21541 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1375 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1994 12:00:00 AM | 6 | 4X4 | 6005996.53712 | 2114852.11511 | 37.7873196237347 | -122.423045755078 | (37.7873196237347, -122.423045755078) | 13 | 9 | 1 | 28858 | 41 | ||
193709 | 134252 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1835 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006062.26705 | 2116813.29184 | 37.7927082355602 | -122.422957784297 | (37.7927082355602, -122.422957784297) | 13 | 9 | 1 | 28858 | 27 | |||
193696 | 134711 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1788 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006208.41346 | 2116652.45655 | 37.792274867547 | -122.422440677717 | (37.792274867547, -122.422440677717) | 13 | 9 | 10 | 28858 | 32 | |||
193636 | 4520 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 37X Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005067.314179 | 2113761.703735 | 37.784273146185 | -122.42618301414 | (37.784273146185, -122.42618301414) | 13 | 9 | 11 | 28858 | 41 | |||
193610 | 248503 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 769 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998578.2628 | 2107821.5389 | 37.767594075062 | -122.448204875608 | (37.767594075062, -122.448204875608) | 15 | 5 | 11 | 29492 | 9 | |||
193606 | 14074 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007538.3610866 | 2110874.6036795 | 37.7764852227054 | -122.417429363009 | (37.7764852227054, -122.417429363009) | 8 | 2 | 9 | 28853 | 34 | |||
193596 | 135438 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013092.14167 | 2117282.31132 | 37.7943902168913 | -122.398666897052 | (37.7943902168913, -122.398666897052) | 3 | 1 | 10 | 28860 | 6 | |||
193586 | 6608 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400X Evans Ave | 3 | Median : Cutout | Tree | DPW 1 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016747.6410828 | 2097755.6169144 | 37.7409771122017 | -122.384657465748 | (37.7409771122017, -122.384657465748) | 10 | 3 | 8 | 58 | 1 | ||
193582 | 13645 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 590 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6012116.841628 | 2115339.7303771 | 37.7890019643739 | -122.401904951476 | (37.7890019643739, -122.401904951476) | 4 | 2 | 10 | 28854 | 6 | |||
193549 | 134224 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1960 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004168.80269 | 2117705.88217 | 37.7950520369835 | -122.429572934657 | (37.7950520369835, -122.429572934657) | 13 | 9 | 1 | 28858 | 27 | |||
193487 | 13912 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1072 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/1991 12:00:00 AM | 12 | 4x4 | 6009268.88359 | 2112623.24078 | 37.7813837816878 | -122.411566544068 | (37.7813837816878, -122.411566544068) | 14 | 2 | 9 | 28852 | 36 | ||
193486 | 134457 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 456 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006975.16614 | 2112267.34083 | 37.7802776389326 | -122.419476450205 | (37.7802776389326, -122.419476450205) | 7 | 9 | 9 | 28852 | 36 | |||
193481 | 25827 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
193461 | 134755 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 899 Beach St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006226.9626 | 2121759.33636 | 37.8062981113431 | -122.42273958359 | (37.8062981113431, -122.42273958359) | 5 | 1 | 1 | 28858 | 32 | |||
193432 | 123666 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4901 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992366.54149 | 2114103.27388 | 37.7844849505213 | -122.470147697835 | (37.7844849505213, -122.470147697835) | 11 | 6 | 2 | 54 | 11 | |||
193391 | 105485 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 833 Jamestown Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | 10 | 3 | 8 | 58 | 1 | ||
193380 | 28215 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
193378 | 3324 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 5233 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 2X2 | 5991368.01055 | 2114064.22096 | 37.7843199449661 | -122.473599389301 | (37.7843199449661, -122.473599389301) | 11 | 6 | 2 | 54 | 26 | |||
193375 | 23979 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 103 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 5992943.4645 | 2097737.8921 | 37.7395832468442 | -122.466961588709 | (37.7395832468442, -122.466961588709) | 1 | 8 | 4 | 59 | 40 | |||
193365 | 25622 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015012.27101 | 2116778.85401 | 37.7931146312154 | -122.391987743488 | (37.7931146312154, -122.391987743488) | 12 | 2 | 9 | 28855 | 6 | ||
193352 | 112858 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2098x ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989583 | 2098399 | 37.7412039444452 | -122.47862882847 | (37.7412039444452, -122.47862882847) | 1 | 8 | 3 | 29491 | 35 | ||||
193305 | 21798 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
193277 | 142750 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 POWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6009582.6329 | 2119935.6915 | 37.8014795926022 | -122.410997766516 | (37.8014795926022, -122.410997766516) | 3 | 1 | 10 | 308 | 23 | |||
193254 | 143203 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1855 KEARNY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010800.6744 | 2121127.7656 | 37.8048209621198 | -122.406866839035 | (37.8048209621198, -122.406866839035) | 3 | 1 | 10 | 308 | 23 | |||
193252 | 195515 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 303 Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015952.79733 | 2115005.90927 | 37.7882987021794 | -122.388609621244 | (37.7882987021794, -122.388609621244) | 6 | 2 | 9 | 28855 | 6 | |||
193242 | 23510 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2642 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/2011 12:00:00 AM | 3 | 3x3 | 6005784.53282 | 2119453.21557 | 37.799941123039 | -122.424106583651 | (37.799941123039, -122.424106583651) | 13 | 9 | 1 | 28858 | 32 | ||
193236 | 14189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1859 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005466.0919 | 2108863.1381 | 37.7708454112193 | -122.424454833335 | (37.7708454112193, -122.424454833335) | 8 | 2 | 5 | 28853 | 19 | |||
193231 | 3392 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 6235 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5988206.6436 | 2113951.80198 | 37.7838276839578 | -122.484528228961 | (37.7838276839578, -122.484528228961) | 11 | 6 | 2 | 55 | 26 | |||
193225 | 135378 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 311 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012816.35741 | 2117528.49318 | 37.7950508049038 | -122.399638442787 | (37.7950508049038, -122.399638442787) | 3 | 1 | 10 | 28860 | 6 | |||
193217 | 134412 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 711 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6006189.27423 | 2112557.91921 | 37.7810311997601 | -122.422215867875 | (37.7810311997601, -122.422215867875) | 7 | 9 | 11 | 28852 | 41 | |||
193208 | 133301 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2510 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000925.18567 | 2117944.29284 | 37.7955224597554 | -122.440813417912 | (37.7955224597554, -122.440813417912) | 13 | 9 | 1 | 57 | 17 | |||
193184 | 140981 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1220 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999925.7455 | 2113068.0979 | 37.7820767329324 | -122.443921122302 | (37.7820767329324, -122.443921122302) | 15 | 5 | 1 | 29490 | 16 | |||
193170 | 123657 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4355 Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994074.55534 | 2114168.11557 | 37.784761582785 | -122.464243309528 | (37.784761582785, -122.464243309528) | 11 | 6 | 2 | 54 | 11 | |||
193150 | 135386 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 301 Front St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012946.15671 | 2117447.11768 | 37.794834601581 | -122.399183599853 | (37.794834601581, -122.399183599853) | 3 | 1 | 10 | 28860 | 6 | |||
193138 | 2940 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1915 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6005167.0236 | 2115779.1152 | 37.7898180902332 | -122.425981713655 | (37.7898180902332, -122.425981713655) | 13 | 9 | 1 | 28858 | 27 | |||
193095 | 20228 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1699 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6002579.480222 | 2114044.5496622 | 37.7849088392032 | -122.43481026677 | (37.7849088392032, -122.43481026677) | 13 | 9 | 11 | 29490 | 13 | |||
193075 | 244912 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 15 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000361.6563 | 2108969.1093 | 37.7708468072136 | -122.442118749033 | (37.7708468072136, -122.442118749033) | 15 | 5 | 11 | 29492 | 9 | |||
193062 | 195421 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 617 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6013071.91105 | 2114384.10292 | 37.7864312896259 | -122.398533430477 | (37.7864312896259, -122.398533430477) | 6 | 2 | 9 | 28855 | 6 | |||
193040 | 13513 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6013355.3549 | 2116409.75999 | 37.7920090576222 | -122.397694911604 | (37.7920090576222, -122.397694911604) | 12 | 2 | 9 | 28855 | 6 | |||
193032 | 13631 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 575 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6012490.62788 | 2115586.35746 | 37.7896999978968 | -122.40062902442 | (37.7896999978968, -122.40062902442) | 12 | 2 | 9 | 28855 | 6 | |||
193002 | 49026 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 01st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2003 12:00:00 AM | Permit Number 46205 | 6013823.58160426 | 2115158.37921296 | 37.7885991200294 | -122.395987099577 | (37.7885991200294, -122.395987099577) | 6 | 2 | 9 | 28855 | 6 | |||
192997 | 134408 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 745 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006163.81788 | 2112757.04986 | 37.7815765279676 | -122.422318086618 | (37.7815765279676, -122.422318086618) | 7 | 9 | 11 | 28852 | 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) );