trees
174 rows where Police Districts = 5 and qSpecies_id = 53 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
130690 | 109005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
140999 | 109004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
141541 | 109003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
138351 | 107659 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1324 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5999078.1 | 2104991.6 | 37.759852333413 | -122.446272413537 | (37.759852333413, -122.446272413537) | 15 | 5 | 5 | 28862 | 3 | |||
135877 | 109331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1325 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
75176 | 173949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999102 | 2105133 | 37.7602419475954 | -122.446199926833 | (37.7602419475954, -122.446199926833) | 15 | 5 | 5 | 28862 | 3 | ||||
66858 | 173948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999106 | 2105162 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | 15 | 5 | 5 | 28862 | 3 | ||||
94921 | 109333 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1317 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||
128105 | 109334 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1313 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999032 | 2105350 | 37.7608337776961 | -122.446457634643 | (37.7608337776961, -122.446457634643) | 15 | 5 | 5 | 28862 | 12 | |||
170556 | 87134 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50103 | 5999603 | 2105413 | 37.7610393570971 | -122.444487333455 | (37.7610393570971, -122.444487333455) | 15 | 5 | 5 | 28862 | 3 | |||
125686 | 121101 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 600x Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998712 | 2105642 | 37.7616172542124 | -122.447585388011 | (37.7616172542124, -122.447585388011) | 15 | 5 | 11 | 29492 | 12 | ||||
81702 | 93042 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110X Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.7619177818182 | -122.440373100603 | (37.7619177818182, -122.440373100603) | 15 | 5 | 5 | 28862 | 3 | |||
153620 | 93043 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.7619177818182 | -122.440373100603 | (37.7619177818182, -122.440373100603) | 15 | 5 | 5 | 28862 | 3 | |||
160630 | 62897 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4123 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1986 12:00:00 AM | 7 | Permit Number 23271 | 6001535.79254212 | 2105815.28492087 | 37.7622540264533 | -122.437831469331 | (37.7622540264533, -122.437831469331) | 15 | 5 | 5 | 28862 | 3 | ||
74570 | 102020 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4149X 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001459 | 2105817 | 37.7622543686513 | -122.438097188092 | (37.7622543686513, -122.438097188092) | 15 | 5 | 5 | 28862 | 3 | |||
43985 | 111817 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6000817 | 2105938 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | 15 | 5 | 5 | 28862 | 3 | |||
129122 | 111818 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 ORD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000817 | 2105938 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | 15 | 5 | 5 | 28862 | 3 | ||||
140944 | 54742 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1374 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 3x3 | Permit Number 10588 | 5993980.75543943 | 2106156.09216002 | 37.7627572927027 | -122.463986029849 | (37.7627572927027, -122.463986029849) | 1 | 5 | 11 | 56 | 12 | ||
13077 | 34262 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3618 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | 14 | 3x3 | Permit Number 38067 | 6002793.22003166 | 2106527.80070587 | 37.7642818435653 | -122.433533428216 | (37.7642818435653, -122.433533428216) | 15 | 5 | 5 | 28862 | 3 | |
79333 | 33008 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1311 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 6x4 | Permit Number 37302 | 5994224.05093468 | 2106581.50911401 | 37.7639393951455 | -122.463175433011 | (37.7639393951455, -122.463175433011) | 1 | 5 | 11 | 56 | 12 | ||
102388 | 113158 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997339 | 2106686 | 37.764405251212 | -122.452409351598 | (37.764405251212, -122.452409351598) | 15 | 5 | 11 | 29492 | 9 | ||||
176337 | 104331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 9 Beaver St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002844 | 2106791 | 37.7650074058753 | -122.433376604069 | (37.7650074058753, -122.433376604069) | 15 | 5 | 5 | 28862 | 3 | ||||
100751 | 116905 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 Beaver St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
139038 | 104320 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778510 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | |
127071 | 104321 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 BEAVER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | Permit Number 778510 | 6002416.6 | 2106828.4 | 37.7650858403074 | -122.434857547122 | (37.7650858403074, -122.434857547122) | 15 | 5 | 5 | 28862 | 3 | ||
49452 | 86740 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1275 02nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | 15 | 5 | 11 | 56 | 12 | |||||
27991 | 97561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994791.4 | 2106981 | 37.7650689602603 | -122.461242116604 | (37.7650689602603, -122.461242116604) | 15 | 5 | 11 | 56 | 12 | ||||
124630 | 54736 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1993 12:00:00 AM | 12 | 5x5 | Permit Number 31998 | 5994208.55249488 | 2107032.01090972 | 37.7651754625969 | -122.463261729084 | (37.7651754625969, -122.463261729084) | 11 | 5 | 11 | 56 | 12 | |
40868 | 173774 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2239 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002625 | 2107043 | 37.7656869095489 | -122.434152085943 | (37.7656869095489, -122.434152085943) | 15 | 5 | 5 | 28862 | 3 | ||||
24756 | 55741 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2289 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/1973 12:00:00 AM | 13 | 3x3 | Permit Number 11768 | 6002326.09413197 | 2107044.17123182 | 37.7656731563843 | -122.435186018715 | (37.7656731563843, -122.435186018715) | 15 | 5 | 5 | 28862 | 3 | |
93895 | 173772 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2235 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002649 | 2107045 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | 15 | 5 | 5 | 28862 | 3 | ||||
123903 | 173773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2235 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002649 | 2107045 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | 15 | 5 | 5 | 28862 | 3 | ||||
143577 | 55394 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2271 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | Permit Number 778438 | 6002436.86184357 | 2107050.31699598 | 37.765696320564 | -122.43480333738 | (37.765696320564, -122.43480333738) | 15 | 5 | 5 | 28862 | 3 | ||
170119 | 103480 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | 11 | 5 | 11 | 56 | 12 | ||
103473 | 55732 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2229 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | 20 | Permit Number 11758 | 6002695.31984114 | 2107064.65711257 | 37.7657503654861 | -122.433910413324 | (37.7657503654861, -122.433910413324) | 15 | 5 | 5 | 28862 | 3 | ||
8384 | 104821 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2173 15TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.432636512343 | (37.7657807169148, -122.432636512343) | 15 | 5 | 5 | 28862 | 3 | |||||
70103 | 121337 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||||
155542 | 54199 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||
156343 | 113279 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5995790.34429445 | 2107089.36315796 | 37.7654239364323 | -122.457794878244 | (37.7654239364323, -122.457794878244) | 15 | 5 | 11 | 56 | 12 | ||||
84466 | 64020 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2344 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 778144 | 6002015 | 2107091 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | 15 | 5 | 5 | 28862 | 3 | ||
187242 | 44341 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2294 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | Permit Number 43725 | 6002286.29088827 | 2107094.04279132 | 37.7658078311453 | -122.435327256937 | (37.7658078311453, -122.435327256937) | 15 | 5 | 5 | 28862 | 3 | |||
79391 | 96083 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2177 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003180 | 2107100 | 37.7658749013738 | -122.432236534109 | (37.7658749013738, -122.432236534109) | 15 | 5 | 5 | 28862 | 3 | |||
180167 | 99046 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2194 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002943 | 2107121 | 37.7659191216839 | -122.43305776744 | (37.7659191216839, -122.43305776744) | 15 | 5 | 5 | 28862 | 3 | ||||
80642 | 55728 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2158 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | 15 | 4x4 | Permit Number 11754 | 6003183.89247133 | 2107143.93253238 | 37.7659957501376 | -122.432226208659 | (37.7659957501376, -122.432226208659) | 15 | 5 | 5 | 28862 | 3 | |
95956 | 58140 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2168 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1978 12:00:00 AM | 16 | 3x3 | Permit Number 17124 | 6003092.5 | 2107149.8 | 37.7660066784939 | -122.432542735552 | (37.7660066784939, -122.432542735552) | 15 | 5 | 5 | 28862 | 3 | |
3159 | 94569 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
96594 | 94566 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
128996 | 94567 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 11 | 56 | 12 | ||||||
19867 | 48735 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 46015 | 6001979.18448022 | 2107865.24554965 | 37.7679079189757 | -122.436444672891 | (37.7679079189757, -122.436444672891) | 15 | 5 | 5 | 29492 | 3 | |||
140272 | 93200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 756 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5998607 | 2107901 | 37.7678138979087 | -122.448111199872 | (37.7678138979087, -122.448111199872) | 15 | 5 | 11 | 29492 | 9 | ||||
192243 | 94600 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1709 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
177966 | 106938 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1607 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
27757 | 16589 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 17 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4X4PL | 6002850.124051 | 2108197.2585517 | 37.768868996076 | -122.433455924251 | (37.768868996076, -122.433455924251) | 15 | 5 | 5 | 28862 | 3 | |||
13231 | 248334 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1569 Waller St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998104.0324 | 2108202.8007 | 37.7686138007777 | -122.449872650062 | (37.7686138007777, -122.449872650062) | 15 | 5 | 11 | 29492 | 9 | |||
107943 | 104241 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1544 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998256.5 | 2108266.6 | 37.768797699923 | -122.44934987666 | (37.768797699923, -122.44934987666) | 15 | 5 | 11 | 29492 | 9 | ||||
38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
105584 | 113009 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
107825 | 113010 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
118914 | 113002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
162574 | 113000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173238 | 113007 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173558 | 113006 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
176974 | 113008 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
97537 | 58524 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1544 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1979 12:00:00 AM | Permit Number 17701 | 5998255.7040764 | 2108272.5838384 | 37.7688140844915 | -122.449353060877 | (37.7688140844915, -122.449353060877) | 15 | 5 | 11 | 29492 | 9 | |||
148453 | 52589 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 774039 | 5997878.20498734 | 2108284.16023065 | 37.7688242695831 | -122.450659631577 | (37.7688242695831, -122.450659631577) | 15 | 5 | 11 | 29492 | 9 | |||
8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
32698 | 58520 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1979 12:00:00 AM | 7x7 | Permit Number 17697 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | 15 | 5 | 11 | 29492 | 9 | ||
105056 | 116231 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | 15 | 5 | 11 | 29492 | 9 | ||||
134924 | 116232 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x7 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | 15 | 5 | 11 | 29492 | 9 | ||||
28579 | 116510 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
115400 | 58777 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | 3x3 | Permit Number 18128 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||
132056 | 116509 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||
165112 | 116511 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
95195 | 58514 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1460 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1979 12:00:00 AM | 3x3 | Permit Number 17691 | 5998731.52150291 | 2108338.88905051 | 37.7690233477366 | -122.447712023248 | (37.7690233477366, -122.447712023248) | 15 | 5 | 11 | 29492 | 9 | ||
131379 | 50854 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47369 | 5999134.27629696 | 2108342.5104784 | 37.7690563017942 | -122.446319185318 | (37.7690563017942, -122.446319185318) | 15 | 5 | 11 | 29492 | 9 | |||
52375 | 120531 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
122156 | 120530 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
152847 | 120532 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
162862 | 58508 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | 3x3 | Permit Number 17683 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||
92694 | 112578 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660x Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999086 | 2108401 | 37.7692141419233 | -122.446490377962 | (37.7692141419233, -122.446490377962) | 15 | 5 | 11 | 29492 | 9 | ||||
180149 | 112971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5997795 | 2108483 | 37.7693654697431 | -122.450961770246 | (37.7693654697431, -122.450961770246) | 15 | 5 | 11 | 29492 | 9 | |||
105646 | 10464 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1584 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998533.97425 | 2108659.62994 | 37.7698927281656 | -122.448418425141 | (37.7698927281656, -122.448418425141) | 15 | 5 | 11 | 29492 | 9 | |||
130761 | 10462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1576 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998589.8073 | 2108666.88124 | 37.7699158304312 | -122.448225822875 | (37.7699158304312, -122.448225822875) | 15 | 5 | 11 | 29492 | 9 | |||
85569 | 48875 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 650 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2002 12:00:00 AM | Permit Number 46082 | 6002579.05689486 | 2108874.6714316 | 37.7707136224387 | -122.434441965818 | (37.7707136224387, -122.434441965818) | 15 | 5 | 11 | 29492 | 9 | |||
20084 | 115908 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
35050 | 115907 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
74559 | 115904 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
106362 | 115905 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
151430 | 115906 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
53774 | 20090 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2075X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.453459178714 | (37.7709958615587, -122.453459178714) | 15 | 5 | 11 | 29492 | 9 |
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) );