trees
8,659 rows where qSpecies_id = 11 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3644 | 123178 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 755 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 5992851.1981 | 2110319.16368 | 37.7741228178256 | -122.46819559495 | (37.7741228178256, -122.46819559495) | 11 | 6 | 2 | 54 | 11 | |||
| 33140 | 208175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000x Lawton St | 3 | Median : Yard | Tree | DPW 1 | 1 | Width 9ft | 5991060.8036 | 2104516.28775 | 37.7580861138029 | -122.473965364836 | (37.7580861138029, -122.473965364836) | 1 | 8 | 4 | 56 | 12 | |||
| 46330 | 217728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 3 | Median : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995225.13962 | 2107407.04812 | 37.766263730121 | -122.459772791289 | (37.766263730121, -122.459772791289) | 15 | 5 | 11 | 29492 | 8 | |||
| 66494 | 228917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6002641.22231 | 2108269.24913 | 37.7690548102697 | -122.434183647259 | (37.7690548102697, -122.434183647259) | 15 | 5 | 5 | 28862 | 3 | |||
| 105734 | 228915 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6002590.64519 | 2108266.76384 | 37.76904511557 | -122.434358412533 | (37.76904511557, -122.434358412533) | 15 | 5 | 5 | 28862 | 3 | |||
| 134701 | 228912 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6002507.65455 | 2108261.418 | 37.7690257261844 | -122.43464508942 | (37.7690257261844, -122.43464508942) | 15 | 5 | 5 | 28862 | 3 | |||
| 169728 | 228916 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6002616.34038 | 2108266.23267 | 37.7690451155718 | -122.434269496565 | (37.7690451155718, -122.434269496565) | 15 | 5 | 5 | 28862 | 3 | |||
| 173194 | 129893 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 5996283.0892 | 2114624.04425 | 37.7861404893398 | -122.456635539617 | (37.7861404893398, -122.456635539617) | 11 | 6 | 1 | 54 | 31 | |||
| 1197 | 200396 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 2 | Width 8ft | 6011323 | 2110932 | 37.776855034552 | -122.404341187165 | (37.776855034552, -122.404341187165) | 14 | 2 | 9 | 28853 | 34 | ||
| 3244 | 208266 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | 9 | 7 | 4 | 59 | 40 | |||
| 4648 | 200397 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 8ft | 6011323 | 2110932 | 37.776855034552 | -122.404341187165 | (37.776855034552, -122.404341187165) | 14 | 2 | 9 | 28853 | 34 | |||
| 14254 | 215913 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 45 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 8ft | 5992854.98914 | 2096471.13815 | 37.7360999515525 | -122.467175416836 | (37.7360999515525, -122.467175416836) | 1 | 8 | 4 | 59 | 40 | |||
| 29515 | 217725 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 5995229.43414 | 2107380.16691 | 37.766190168267 | -122.459755990171 | (37.766190168267, -122.459755990171) | 15 | 5 | 11 | 29492 | 8 | |||
| 33234 | 208271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | 9 | 7 | 4 | 59 | 40 | |||
| 54831 | 201047 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6014994.68358 | 2104372.25303 | 37.759047900964 | -122.391180985336 | (37.759047900964, -122.391180985336) | 10 | 3 | 8 | 28856 | 29 | |||
| 61774 | 208267 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 5996171.15306 | 2098570.80404 | 37.7420559870035 | -122.455861898701 | (37.7420559870035, -122.455861898701) | 9 | 7 | 4 | 59 | 40 | |||
| 72880 | 208203 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 8 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992810.27043 | 2096776.25182 | 37.7369351357583 | -122.467352205537 | (37.7369351357583, -122.467352205537) | 1 | 8 | 4 | 59 | 40 | |||
| 73817 | 208264 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996224.40551 | 2098673.0355 | 37.7423397455987 | -122.455685157643 | (37.7423397455987, -122.455685157643) | 9 | 7 | 4 | 59 | 40 | |||
| 82528 | 208269 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 7 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996138.33351 | 2098519.81732 | 37.7419141063617 | -122.455971692433 | (37.7419141063617, -122.455971692433) | 9 | 7 | 4 | 59 | 40 | |||
| 89885 | 208265 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5996197.71475 | 2098618.83624 | 37.7421893960176 | -122.455773528635 | (37.7421893960176, -122.455773528635) | 9 | 7 | 4 | 59 | 40 | |||
| 92233 | 208206 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 San Benito Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992824.47991 | 2096396.07045 | 37.7358920732564 | -122.46727544212 | (37.7358920732564, -122.46727544212) | 1 | 8 | 4 | 59 | 40 | |||
| 95029 | 208207 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 75 San Benito Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992862.53617 | 2096286.06157 | 37.7355922132098 | -122.46713587182 | (37.7355922132098, -122.46713587182) | 1 | 8 | 4 | 59 | 40 | |||
| 115303 | 217726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 3 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 5995207.72446 | 2107378.38914 | 37.7661840384968 | -122.459830950441 | (37.7661840384968, -122.459830950441) | 15 | 5 | 11 | 29492 | 8 | |||
| 119509 | 208309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 4 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6002006.71588 | 2095443.86594 | 37.7338033312475 | -122.435460765528 | (37.7338033312475, -122.435460765528) | 9 | 7 | 5 | 63 | 40 | |||
| 144790 | 208270 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 8 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5996116.90771 | 2098495.20016 | 37.7418452839221 | -122.456043996142 | (37.7418452839221, -122.456043996142) | 9 | 7 | 4 | 59 | 40 | |||
| 150182 | 200451 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 8ft | 6014956.18254 | 2103836.35499 | 37.7575743033202 | -122.391276680392 | (37.7575743033202, -122.391276680392) | 10 | 3 | 8 | 28856 | 29 | |||
| 155609 | 200449 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1150x Tennessee St | 2 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6015546.92386 | 2103710.0991 | 37.7572603985698 | -122.389224824085 | (37.7572603985698, -122.389224824085) | 10 | 3 | 8 | 28856 | 29 | |||
| 158759 | 200450 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 8ft | 6014955.45065 | 2103853.57451 | 37.7576215438129 | -122.391280415259 | (37.7576215438129, -122.391280415259) | 10 | 3 | 8 | 28856 | 29 | |||
| 159569 | 208204 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 20 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 5992810.89937 | 2096694.1655 | 37.7367097836138 | -122.467344063976 | (37.7367097836138, -122.467344063976) | 1 | 8 | 4 | 59 | 40 | |||
| 159773 | 192724 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900 Kirkwood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6019533.42418 | 2093575.80573 | 37.729653833243 | -122.37473558218 | (37.729653833243, -122.37473558218) | 10 | 3 | 8 | 58 | 1 | |||
| 164093 | 208205 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 San Benito Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992824.24376 | 2096416.84523 | 37.7359491019705 | -122.467277768674 | (37.7359491019705, -122.467277768674) | 1 | 8 | 4 | 59 | 40 | |||
| 171698 | 208272 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 10 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5996077.78984 | 2098457.84211 | 37.741740462546 | -122.456176551714 | (37.741740462546, -122.456176551714) | 9 | 7 | 4 | 59 | 40 | |||
| 176121 | 208308 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 3 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6002022.61443 | 2095440.5497 | 37.733795128547 | -122.435405562425 | (37.733795128547, -122.435405562425) | 9 | 7 | 5 | 63 | 40 | |||
| 186426 | 208268 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 6 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996154.348 | 2098544.93343 | 37.741983988173 | -122.455918135114 | (37.741983988173, -122.455918135114) | 9 | 7 | 4 | 59 | 40 | |||
| 188247 | 208310 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 5 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6001987.84098 | 2095447.80908 | 37.7338130862007 | -122.435526303593 | (37.7338130862007, -122.435526303593) | 9 | 7 | 5 | 63 | 40 | |||
| 21632 | 228907 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 4 | Back Yard : Yard | Tree | Private 2 | 11 | Width 7ft | 6002320.43591 | 2108252.4902 | 37.7689905824786 | -122.435292027503 | (37.7689905824786, -122.435292027503) | 15 | 5 | 5 | 28862 | 3 | |||
| 5124 | 208248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993720.3367 | 2097534.6228 | 37.739069929337 | -122.464260768027 | (37.739069929337, -122.464260768027) | 1 | 8 | 4 | 59 | 40 | |||
| 8861 | 208247 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993716.65368 | 2097514.87622 | 37.7390154978753 | -122.464272068903 | (37.7390154978753, -122.464272068903) | 1 | 8 | 4 | 59 | 40 | |||
| 9232 | 228951 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 118 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6005386.85226 | 2102866.95811 | 37.7543768447429 | -122.424302388563 | (37.7543768447429, -122.424302388563) | 2 | 4 | 5 | 28859 | 19 | |||
| 10513 | 208259 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 7 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | Permit Number 784463 | 5993794.93642 | 2097790.46819 | 37.7397767164315 | -122.464021405387 | (37.7397767164315, -122.464021405387) | 1 | 8 | 4 | 59 | 40 | ||
| 15953 | 201070 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1251 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6013524.95 | 2106139.60488 | 37.7638189896873 | -122.39638793316 | (37.7638189896873, -122.39638793316) | 14 | 3 | 8 | 28856 | 29 | |||
| 27058 | 129862 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6000214.38483 | 2120902.15861 | 37.8036034654848 | -122.443485478179 | (37.8036034654848, -122.443485478179) | 13 | 9 | 1 | 57 | 17 | |||
| 27629 | 208201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 109 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992876.13857 | 2095935.50628 | 37.7346304611167 | -122.467063364902 | (37.7346304611167, -122.467063364902) | 9 | 8 | 4 | 59 | 40 | |||
| 28599 | 202485 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015591.97779 | 2114203.68942 | 37.7860759863606 | -122.389801952302 | (37.7860759863606, -122.389801952302) | 6 | 2 | 9 | 28855 | 6 | |||
| 35548 | 208246 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 75 San Lorenzo Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993711.81296 | 2097482.43127 | 37.7389261331305 | -122.464286450858 | (37.7389261331305, -122.464286450858) | 1 | 8 | 4 | 59 | 40 | |||
| 37969 | 208256 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993762.65186 | 2097710.37243 | 37.7395549328226 | -122.464127217798 | (37.7395549328226, -122.464127217798) | 1 | 8 | 4 | 59 | 40 | |||
| 38918 | 228998 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2953 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009706.73596 | 2101591.75349 | 37.751118399502 | -122.409273076799 | (37.751118399502, -122.409273076799) | 2 | 4 | 7 | 28859 | 19 | |||
| 40730 | 228984 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2689 Bryant St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6009821.74177 | 2101696.3293 | 37.7514119840826 | -122.408882750359 | (37.7514119840826, -122.408882750359) | 2 | 4 | 7 | 28859 | 19 | |||
| 40888 | 246923 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 411 Frederick St | 1 | : | Tree | Private 2 | 15 | Width 6ft | 5997906.77047 | 2107481.56832 | 37.7666221917918 | -122.450502958247 | (37.7666221917918, -122.450502958247) | 15 | 5 | 11 | 29492 | 9 | |||
| 42874 | 202428 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 120 Brannan St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6015665.9659 | 2113447.78913 | 37.7840045581087 | -122.389493161996 | (37.7840045581087, -122.389493161996) | 6 | 2 | 9 | 28856 | 6 | |||
| 48515 | 124258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5994743.00178 | 2114922.14665 | 37.7868704533367 | -122.461985420107 | (37.7868704533367, -122.461985420107) | 11 | 6 | 1 | 54 | 11 | |||
| 48880 | 124086 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3542 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5992325.66786 | 2110027.51638 | 37.7732916673988 | -122.469992239894 | (37.7732916673988, -122.469992239894) | 11 | 6 | 2 | 54 | 11 | |||
| 48942 | 130255 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2320 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6007588.34652 | 2120300.03904 | 37.8023679660663 | -122.417924753627 | (37.8023679660663, -122.417924753627) | 5 | 1 | 1 | 308 | 32 | |||
| 49961 | 177169 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Morse St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001283.26601 | 2088090.37173 | 37.7135711887396 | -122.437435547228 | (37.7135711887396, -122.437435547228) | 9 | 7 | 6 | 28861 | 5 | |||
| 50514 | 208252 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993745.99761 | 2097653.0262 | 37.739396514526 | -122.464180638441 | (37.739396514526, -122.464180638441) | 1 | 8 | 4 | 59 | 40 | |||
| 57962 | 228902 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 121 Scott St | 1 | : | Tree | Private 2 | 14 | Width 6ft | 6002319.8368 | 2108939.85369 | 37.7708778790509 | -122.435343274489 | (37.7708778790509, -122.435343274489) | 15 | 5 | 11 | 29492 | 9 | |||
| 61722 | 202354 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 395 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6014956.09306 | 2115317.40015 | 37.7890986976923 | -122.392079873898 | (37.7890986976923, -122.392079873898) | 6 | 2 | 9 | 28855 | 6 | |||
| 64994 | 208464 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 262 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6000330.97278 | 2094966.82003 | 37.7323981594491 | -122.441220078747 | (37.7323981594491, -122.441220078747) | 9 | 7 | 5 | 63 | 40 | |||
| 70474 | 208230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 18 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993408.84143 | 2097416.32422 | 37.7387271518268 | -122.465329177018 | (37.7387271518268, -122.465329177018) | 1 | 8 | 4 | 59 | 40 | |||
| 75163 | 177163 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 189 Velasco Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 6ft | 6007991.76144 | 2086069.61091 | 37.7084017093473 | -122.41410563508 | (37.7084017093473, -122.41410563508) | 9 | 7 | 8 | 309 | 39 | |||
| 76862 | 208197 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 171 San Benito Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992886.88118 | 2095580.71887 | 37.7336569234134 | -122.467000439332 | (37.7336569234134, -122.467000439332) | 9 | 8 | 4 | 59 | 40 | |||
| 78877 | 208258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 7 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993787.50997 | 2097777.84211 | 37.7397416203682 | -122.46404616639 | (37.7397416203682, -122.46404616639) | 1 | 8 | 4 | 59 | 40 | |||
| 83294 | 208236 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993530.69837 | 2097432.08854 | 37.7387774635008 | -122.464909001172 | (37.7387774635008, -122.464909001172) | 1 | 8 | 4 | 59 | 40 | |||
| 83331 | 208226 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993327.66494 | 2097365.60548 | 37.7385832090507 | -122.465606161009 | (37.7385832090507, -122.465606161009) | 1 | 8 | 4 | 59 | 40 | |||
| 85189 | 208241 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993632.94814 | 2097391.47717 | 37.7386718498284 | -122.464552524274 | (37.7386718498284, -122.464552524274) | 1 | 8 | 4 | 59 | 40 | |||
| 87549 | 208235 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993511.134 | 2097434.27461 | 37.7387823378375 | -122.464976803755 | (37.7387823378375, -122.464976803755) | 1 | 8 | 4 | 59 | 40 | |||
| 89682 | 192634 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 6 | Median : Cutout | Tree | DPW 1 | 16 | Width 6ft | 6016723.45145 | 2094514.52474 | 37.7320763855997 | -122.38451540818 | (37.7320763855997, -122.38451540818) | 10 | 3 | 8 | 58 | 1 | |||
| 90804 | 202422 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 120 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015901.40825 | 2113673.21446 | 37.7846365764686 | -122.388694351787 | (37.7846365764686, -122.388694351787) | 6 | 2 | 9 | 28856 | 6 | |||
| 91229 | 208304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 6002256.90022 | 2095383.64067 | 37.7336521723072 | -122.434591499705 | (37.7336521723072, -122.434591499705) | 9 | 7 | 5 | 63 | 40 | |||
| 91705 | 208198 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 155 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992885.77964 | 2095618.50159 | 37.7337606017701 | -122.467006993572 | (37.7337606017701, -122.467006993572) | 9 | 8 | 4 | 59 | 40 | |||
| 92056 | 208231 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 18 Santa Monica Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993425.01092 | 2097422.17694 | 37.7387441544197 | -122.465273696018 | (37.7387441544197, -122.465273696018) | 1 | 8 | 4 | 59 | 40 | |||
| 92649 | 192631 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Garlington Ct | 1 | : | Tree | Private 2 | 15 | Width 6ft | 6016783.64783 | 2094408.52472 | 37.7317886592161 | -122.38429991441 | (37.7317886592161, -122.38429991441) | 10 | 3 | 8 | 58 | 1 | |||
| 94029 | 228901 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135 Scott St | 1 | : | Tree | Private 2 | 12 | Width 6ft | 6002314.12723 | 2108991.34813 | 37.7710189458042 | -122.435366708107 | (37.7710189458042, -122.435366708107) | 15 | 5 | 11 | 29492 | 9 | |||
| 96822 | 202352 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 395 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6014910.84304 | 2115264.5164 | 37.7889509786636 | -122.392232734374 | (37.7889509786636, -122.392232734374) | 6 | 2 | 9 | 28855 | 6 | |||
| 98551 | 208243 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 56 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993682.57508 | 2097363.51049 | 37.7385979210626 | -122.464378909273 | (37.7385979210626, -122.464378909273) | 1 | 8 | 4 | 59 | 40 | |||
| 101524 | 208251 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 45 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993740.8112 | 2097632.42389 | 37.7393396468031 | -122.464197075333 | (37.7393396468031, -122.464197075333) | 1 | 8 | 4 | 59 | 40 | |||
| 103787 | 202486 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 6015605.55295 | 2114216.90424 | 37.7861130240416 | -122.389755908832 | (37.7861130240416, -122.389755908832) | 6 | 2 | 9 | 28855 | 6 | |||
| 106156 | 202350 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 395 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6014856.64051 | 2115212.62768 | 37.7888054944207 | -122.392416638537 | (37.7888054944207, -122.392416638537) | 6 | 2 | 9 | 28855 | 6 | |||
| 115118 | 208199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 141 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5992881.4565 | 2095737.53516 | 37.7340871887565 | -122.467030590916 | (37.7340871887565, -122.467030590916) | 9 | 8 | 4 | 59 | 40 | |||
| 115624 | 208255 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993760.41778 | 2097703.02233 | 37.7395346225236 | -122.464134408774 | (37.7395346225236, -122.464134408774) | 1 | 8 | 4 | 59 | 40 | |||
| 115985 | 208254 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993757.51512 | 2097692.13582 | 37.7395045635922 | -122.464143654725 | (37.7395045635922, -122.464143654725) | 1 | 8 | 4 | 59 | 40 | |||
| 117318 | 202483 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 6015577.75199 | 2114193.56391 | 37.786047395123 | -122.389850462652 | (37.786047395123, -122.389850462652) | 6 | 2 | 9 | 28855 | 6 | |||
| 117641 | 208303 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 4 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 6002276.07122 | 2095379.68472 | 37.7336423984691 | -122.434524937286 | (37.7336423984691, -122.434524937286) | 9 | 7 | 5 | 63 | 40 | |||
| 119660 | 202426 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 120 Brannan St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6015680.38434 | 2113465.2753 | 37.784053370599 | -122.38944450058 | (37.784053370599, -122.38944450058) | 6 | 2 | 9 | 28856 | 6 | |||
| 119965 | 192633 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 4 | Median : Cutout | Tree | DPW 1 | 17 | Width 6ft | 6016736.26235 | 2094477.02504 | 37.7319741272952 | -122.384468506713 | (37.7319741272952, -122.384468506713) | 10 | 3 | 8 | 58 | 1 | |||
| 125132 | 192632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 6ft | 6016758.25797 | 2094440.43595 | 37.7318748772053 | -122.384389914969 | (37.7318748772053, -122.384389914969) | 10 | 3 | 8 | 58 | 1 | |||
| 127614 | 208301 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 6002317.80033 | 2095368.99319 | 37.7336154107143 | -122.434379903628 | (37.7336154107143, -122.434379903628) | 9 | 7 | 5 | 63 | 40 | |||
| 128284 | 246924 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Frederick St | 1 | : | Tree | Private 2 | 11 | Width 6ft | 5997929.70146 | 2107483.75186 | 37.7666294996706 | -122.450423801741 | (37.7666294996706, -122.450423801741) | 15 | 5 | 11 | 29492 | 9 | |||
| 140050 | 208229 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 18 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993384.23458 | 2097404.68896 | 37.7386937851969 | -122.465413410213 | (37.7386937851969, -122.465413410213) | 1 | 8 | 4 | 59 | 40 | |||
| 140177 | 208200 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 141 San Benito Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992880.92249 | 2095766.24379 | 37.7341659846737 | -122.467034523631 | (37.7341659846737, -122.467034523631) | 9 | 8 | 4 | 59 | 40 | |||
| 141076 | 208249 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993722.3546 | 2097545.82364 | 37.7391008003548 | -122.464254604065 | (37.7391008003548, -122.464254604065) | 1 | 8 | 4 | 59 | 40 | |||
| 150917 | 208227 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993339.02056 | 2097373.97973 | 37.7386068576137 | -122.46556750724 | (37.7386068576137, -122.46556750724) | 1 | 8 | 4 | 59 | 40 | |||
| 151343 | 208232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 24 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993461.46144 | 2097431.76732 | 37.738772589195 | -122.465148364701 | (37.738772589195, -122.465148364701) | 1 | 8 | 4 | 59 | 40 | |||
| 152927 | 208250 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 55 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993729.31252 | 2097594.20118 | 37.7392340340357 | -122.464234058156 | (37.7392340340357, -122.464234058156) | 1 | 8 | 4 | 59 | 40 | |||
| 157459 | 208253 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993753.67803 | 2097679.19793 | 37.7394688182264 | -122.46415598261 | (37.7394688182264, -122.46415598261) | 1 | 8 | 4 | 59 | 40 | |||
| 158099 | 208233 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 24 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993476.65157 | 2097433.51929 | 37.7387782755959 | -122.465095972005 | (37.7387782755959, -122.465095972005) | 1 | 8 | 4 | 59 | 40 | |||
| 166410 | 208300 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 6002335.89975 | 2095363.88492 | 37.7336024119263 | -122.434316963673 | (37.7336024119263, -122.434316963673) | 9 | 7 | 5 | 63 | 40 | |||
| 168730 | 208302 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 3 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 6002298.45936 | 2095373.74983 | 37.7336273734974 | -122.434447110867 | (37.7336273734974, -122.434447110867) | 9 | 7 | 5 | 63 | 40 | |||
| 170487 | 202427 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 120 Brannan St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015675.3599 | 2113457.56551 | 37.7840319226843 | -122.389461344871 | (37.7840319226843, -122.389461344871) | 6 | 2 | 9 | 28856 | 6 | |||
| 171465 | 201071 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1251 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6013560.95994 | 2106139.46793 | 37.7638206174505 | -122.39626337525 | (37.7638206174505, -122.39626337525) | 14 | 3 | 8 | 28856 | 29 |
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) );