trees
8,659 rows where qSpecies_id = 11 sorted by PlantDate
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 255229 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
105 | 70839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 939 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010931.16123 | 2112337.60471 | 37.780692593337 | -122.405795716794 | (37.780692593337, -122.405795716794) | 14 | 2 | 9 | 28853 | 34 | |||
134 | 257900 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5701x 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014158 | 2092336 | 37.7259523956068 | -122.393232416121 | (37.7259523956068, -122.393232416121) | 10 | 3 | 8 | 58 | 1 | ||||
240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
254 | 130309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013009.60555 | 2119229.44522 | 37.7997319839043 | -122.399089221411 | (37.7997319839043, -122.399089221411) | 3 | 1 | 10 | 28860 | 6 | |||
418 | 191568 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6015230.3015 | 2097471.78413 | 37.7401137346697 | -122.389884091895 | (37.7401137346697, -122.389884091895) | 10 | 3 | 8 | 58 | 1 | |||
441 | 200380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 199x Shipley St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6011866.27149 | 2112076.32254 | 37.7800274232626 | -122.402542323073 | (37.7800274232626, -122.402542323073) | 6 | 2 | 9 | 28856 | 34 | |||
490 | 201018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2427 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6015837.6438 | 2104277.44784 | 37.7588343299688 | -122.388258987278 | (37.7588343299688, -122.388258987278) | 10 | 3 | 8 | 28856 | 29 | |||
506 | 264804 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
516 | 228148 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 330 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006164.28194 | 2098136.5344 | 37.7414320472565 | -122.421277938832 | (37.7414320472565, -122.421277938832) | 2 | 7 | 7 | 28859 | 2 | |||
547 | 228103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
572 | 130258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007346.42047 | 2122267.68592 | 37.8077570059352 | -122.418901572974 | (37.8077570059352, -122.418901572974) | 5 | 1 | 10 | 308 | 23 | |||
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
707 | 27746 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1399 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | |||
714 | 129877 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000546.03686 | 2121364.03146 | 37.8048905527229 | -122.442370961862 | (37.8048905527229, -122.442370961862) | 13 | 9 | 1 | 57 | 17 | |||
773 | 229088 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Putnam St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009105.76853 | 2096334.59005 | 37.7366496963122 | -122.410980013421 | (37.7366496963122, -122.410980013421) | 10 | 7 | 7 | 28859 | 2 | |||
986 | 208414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 37 San Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993601.90689 | 2097555.83156 | 37.7391213363856 | -122.464671780704 | (37.7391213363856, -122.464671780704) | 1 | 8 | 4 | 59 | 40 | |||
1023 | 228184 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776221 | 6006352.00962 | 2102676.26299 | 37.7539076917969 | -122.420951082919 | (37.7539076917969, -122.420951082919) | 2 | 4 | 5 | 28859 | 19 | ||
1107 | 258138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | |||
1150 | 97170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 289 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||
1205 | 71779 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1062 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6007509.77749 | 2115111.57122 | 37.7881173017281 | -122.417828646693 | (37.7881173017281, -122.417828646693) | 13 | 1 | 10 | 28858 | 21 | |||
1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1393 | 255136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
1679 | 262328 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1693 | 70072 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 460-462 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6014075.24964 | 2112803.80145 | 37.7821479895867 | -122.394951382198 | (37.7821479895867, -122.394951382198) | 6 | 2 | 9 | 28856 | 6 | |||
1736 | 255231 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1754 | 72457 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6013447.28917 | 2112118.8251 | 37.7802322636443 | -122.397075813805 | (37.7802322636443, -122.397075813805) | 6 | 2 | 9 | 28856 | 34 | |||
1791 | 202438 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015393.28137 | 2113192.42013 | 37.7832882498865 | -122.390418710082 | (37.7832882498865, -122.390418710082) | 6 | 2 | 9 | 28856 | 6 | |||
1849 | 208186 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1331 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993614.60334 | 2106421.09061 | 37.7634638006461 | -122.465271659973 | (37.7634638006461, -122.465271659973) | 1 | 8 | 11 | 56 | 12 | |||
1865 | 250727 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986989.77084 | 2114474.42914 | 37.7851917306499 | -122.488776528028 | (37.7851917306499, -122.488776528028) | 11 | 6 | 1 | 55 | 33 | |||
1893 | 202466 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6015364.08596 | 2113980.86874 | 37.7854515313193 | -122.390574827864 | (37.7854515313193, -122.390574827864) | 6 | 2 | 9 | 28856 | 6 | |||
1906 | 208208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 17 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5992145.29638 | 2096590.12464 | 37.7363856661623 | -122.469637749802 | (37.7363856661623, -122.469637749802) | 1 | 8 | 4 | 59 | 40 | |||
2023 | 264805 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
2134 | 83455 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015476.55407 | 2105691.51602 | 37.7626970431542 | -122.389606573684 | (37.7626970431542, -122.389606573684) | 10 | 3 | 8 | 28856 | 29 | |||
2207 | 26390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1615X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6007069.43005 | 2109322.62762 | 37.7721974718223 | -122.418941432593 | (37.7721974718223, -122.418941432593) | 8 | 2 | 9 | 28853 | 19 | |||
2242 | 122950 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 09th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
2281 | 202367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6015662.52454 | 2115317.40495 | 37.7891379072269 | -122.389635690147 | (37.7891379072269, -122.389635690147) | 6 | 2 | 9 | 28855 | 6 | |||
2379 | 27111 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 497 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x4 | 6004667.95957 | 2093529.09628 | 37.7286965849625 | -122.426123777405 | (37.7286965849625, -122.426123777405) | 9 | 7 | 6 | 28861 | 5 | |||
2514 | 130116 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008620.49903 | 2113131.73284 | 37.782743588087 | -122.413845626693 | (37.782743588087, -122.413845626693) | 7 | 10 | 9 | 28852 | 36 | |||
2585 | 29556 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3030 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406 | 37.7201955090298 | -122.392114704117 | (37.7201955090298, -122.392114704117) | 10 | 3 | 8 | 58 | 1 | |||
2709 | 140325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1455 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004557.9993 | 2113847.3125 | 37.7844794061151 | -122.427951167196 | (37.7844794061151, -122.427951167196) | 13 | 9 | 11 | 29490 | 41 | |||
2747 | 129970 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 245 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009400.62978 | 2113906.25304 | 37.7849140164063 | -122.411201422913 | (37.7849140164063, -122.411201422913) | 14 | 10 | 9 | 28852 | 36 | |||
2919 | 208356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4998 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990631.22914 | 2093445.14336 | 37.7276627189546 | -122.474642998593 | (37.7276627189546, -122.474642998593) | 9 | 8 | 4 | 64 | 40 | |||
2941 | 261590 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 299x 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006795 | 2107850 | 37.7681385292637 | -122.41978620049 | (37.7681385292637, -122.41978620049) | 8 | 4 | 7 | 28853 | 19 | ||||
2944 | 97145 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2001X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
2952 | 23021 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 873 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006311.34363 | 2104526.62224 | 37.7589860572745 | -122.42122309997 | (37.7589860572745, -122.42122309997) | 2 | 4 | 7 | 28859 | 19 | |||
2995 | 202498 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015682.27104 | 2112499.834 | 37.7814025909853 | -122.389370531319 | (37.7814025909853, -122.389370531319) | 6 | 2 | 9 | 28856 | 20 | |||
3004 | 202458 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015309.25216 | 2113889.9179 | 37.7851987588479 | -122.390758179856 | (37.7851987588479, -122.390758179856) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
3261 | 177171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012633.43776 | 2088096.17328 | 37.7142258700001 | -122.398205432431 | (37.7142258700001, -122.398205432431) | 10 | 3 | 8 | 309 | 1 | |||
3397 | 228679 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 190 Storrie St | 18 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000815.50706 | 2105314.68104 | 37.7608385069212 | -122.440286756929 | (37.7608385069212, -122.440286756929) | 15 | 4 | 5 | 28862 | 3 | |||
3403 | 228171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Powhattan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6008190.97242 | 2098122.00574 | 37.7415062071578 | -122.414269294615 | (37.7415062071578, -122.414269294615) | 2 | 7 | 7 | 28859 | 2 | |||
3437 | 79 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 899 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3X3 | 6002864.3199934 | 2107660.1796498 | 37.7673951141913 | -122.433368437593 | (37.7673951141913, -122.433368437593) | 15 | 5 | 5 | 28862 | 3 | |||
3455 | 122949 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
3504 | 202818 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014769.41047 | 2108724.81118 | 37.7709865710896 | -122.392264508307 | (37.7709865710896, -122.392264508307) | 14 | 3 | 9 | 310 | 20 | |||
3513 | 117891 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5982566.38409 | 2112290.68382 | 37.7789366773187 | -122.503918023894 | (37.7789366773187, -122.503918023894) | 11 | 6 | 2 | 55 | 26 | |||
3570 | 228639 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 393 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002974.70416 | 2105985.24173 | 37.7628024032403 | -122.432866963362 | (37.7628024032403, -122.432866963362) | 15 | 4 | 5 | 28862 | 3 | |||
3575 | 130205 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1033 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009172.7127 | 2117683.88931 | 37.7952737045641 | -122.412257035446 | (37.7952737045641, -122.412257035446) | 3 | 1 | 10 | 28857 | 21 | |||
3586 | 217748 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 611 Frederick St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5996609.14457 | 2107297.9343 | 37.766043624629 | -122.45497792451 | (37.766043624629, -122.45497792451) | 15 | 5 | 11 | 29492 | 12 | |||
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 | |||
3675 | 192590 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008004 | 2110521 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | 8 | 2 | 9 | 28853 | 34 | |||
3699 | 228559 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006186 | 2105451 | 37.7615171153003 | -122.421722254672 | (37.7615171153003, -122.421722254672) | 2 | 4 | 5 | 28859 | 19 | |||
3821 | 130402 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 537 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011944.02835 | 2117720.9303 | 37.7955305266544 | -122.402670389235 | (37.7955305266544, -122.402670389235) | 3 | 1 | 10 | 28860 | 4 | |||
3877 | 228942 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009177.01611 | 2108023.17078 | 37.7687479166233 | -122.411559257765 | (37.7687479166233, -122.411559257765) | 8 | 4 | 7 | 28853 | 19 | |||
3927 | 228050 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008750.70184 | 2106410.9206 | 37.7642971286338 | -122.412919846582 | (37.7642971286338, -122.412919846582) | 8 | 4 | 7 | 28859 | 19 | |||
4141 | 192575 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 218 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009254.82168 | 2110652.88864 | 37.7759728720816 | -122.411475945469 | (37.7759728720816, -122.411475945469) | 8 | 2 | 9 | 28853 | 34 | |||
4191 | 252955 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998847 | 2112431 | 37.7802658347108 | -122.44760720085 | (37.7802658347108, -122.44760720085) | 15 | 6 | 2 | 54 | 16 | ||||
4296 | 11415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1486 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016124.41895 | 2096811.69386 | 37.7383508053301 | -122.386746549719 | (37.7383508053301, -122.386746549719) | 10 | 3 | 8 | 58 | 1 | |||
4300 | 72086 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 287 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 5988351.63673 | 2114094.10602 | 37.7842268528731 | -122.484037051708 | (37.7842268528731, -122.484037051708) | 11 | 6 | 2 | 55 | 26 | |||
4357 | 76336 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015855.31224 | 2112664.17743 | 37.7818634332888 | -122.388783363957 | (37.7818634332888, -122.388783363957) | 6 | 2 | 9 | 28856 | 6 | |||
4364 | 228727 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004008.60516 | 2106001.5865 | 37.7629058684239 | -122.429292229258 | (37.7629058684239, -122.429292229258) | 8 | 4 | 5 | 28862 | 3 | |||
4374 | 228170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007791.31905 | 2097714.0061 | 37.7403634727908 | -122.415622282361 | (37.7403634727908, -122.415622282361) | 2 | 7 | 7 | 28859 | 2 | |||
4395 | 255228 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
4412 | 192661 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016830.36497 | 2095845.83394 | 37.735737807149 | -122.384238463729 | (37.735737807149, -122.384238463729) | 10 | 3 | 8 | 58 | 1 | |||
4482 | 73980 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 769778 | 6007997.42322 | 2113875.47963 | 37.7847507256189 | -122.416053899389 | (37.7847507256189, -122.416053899389) | 7 | 10 | 9 | 28858 | 36 | ||
4517 | 200485 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2701 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015936.93033 | 2102883.91485 | 37.7550134846985 | -122.387818371631 | (37.7550134846985, -122.387818371631) | 10 | 3 | 8 | 28856 | 29 | |||
4532 | 70356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.421362640608 | (37.7943758388735, -122.421362640608) | 13 | 9 | 10 | 28858 | 32 | |||
4571 | 192526 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1064 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009654 | 2112066 | 37.7798753251135 | -122.410194868954 | (37.7798753251135, -122.410194868954) | 14 | 2 | 9 | 28853 | 34 | |||
4610 | 229157 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3195 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008470.80971 | 2100938.6622 | 37.7492558360924 | -122.413500868897 | (37.7492558360924, -122.413500868897) | 2 | 4 | 7 | 28859 | 19 | |||
4632 | 143126 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2055 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002559.0217 | 2119480.0502 | 37.7998321621177 | -122.435269976592 | (37.7998321621177, -122.435269976592) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
4667 | 75958 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2650 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009941.91637 | 2105516.75655 | 37.7619087513959 | -122.408736667189 | (37.7619087513959, -122.408736667189) | 8 | 4 | 8 | 28859 | 19 | |||
4682 | 75924 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6007948.10688 | 2114213.26854 | 37.7856754391124 | -122.416248450599 | (37.7856754391124, -122.416248450599) | 13 | 10 | 9 | 28858 | 36 | |||
4689 | 100758 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
4694 | 229096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 411X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008233.66043 | 2096096.60482 | 37.735947297932 | -122.413978446675 | (37.735947297932, -122.413978446675) | 2 | 7 | 7 | 28859 | 2 | |||
4756 | 80808 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6015600.52909 | 2102412.11891 | 37.7536993917283 | -122.388948815828 | (37.7536993917283, -122.388948815828) | 10 | 3 | 8 | 28856 | 29 | |||
4834 | 255234 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
4960 | 76355 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6015869.61058 | 2112665.8481 | 37.7818688130373 | -122.388734014567 | (37.7818688130373, -122.388734014567) | 6 | 2 | 9 | 28856 | 6 | |||
4968 | 228582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3380 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007681.5536 | 2104447.74743 | 37.7588466371903 | -122.41647866898 | (37.7588466371903, -122.41647866898) | 2 | 4 | 7 | 28859 | 19 | |||
4997 | 255137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
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 | |||
5131 | 172199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003534.5249 | 2091291.61932 | 37.7224888445726 | -122.429882596429 | (37.7224888445726, -122.429882596429) | 9 | 7 | 6 | 28861 | 5 | |||
5225 | 76274 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6013063.67102 | 2119100.92888 | 37.7993821215331 | -122.398893108952 | (37.7993821215331, -122.398893108952) | 3 | 1 | 10 | 28860 | 6 | |||
5327 | 208187 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 614 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992619.53239 | 2105964.8476 | 37.7621536431042 | -122.468680060852 | (37.7621536431042, -122.468680060852) | 1 | 8 | 11 | 56 | 12 | |||
5351 | 108330 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 86 11TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
5377 | 208380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2153 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990986.04746 | 2100741.87447 | 37.747718234628 | -122.473948530418 | (37.747718234628, -122.473948530418) | 1 | 8 | 4 | 29491 | 40 | |||
5378 | 76652 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 148X Paris St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6002965.38435 | 2092499.73249 | 37.7257738062998 | -122.43193620819 | (37.7257738062998, -122.43193620819) | 9 | 7 | 6 | 28861 | 5 | ||
5405 | 76328 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013055.77037 | 2119154.19347 | 37.7995279331128 | -122.398924188599 | (37.7995279331128, -122.398924188599) | 3 | 1 | 10 | 28860 | 6 | |||
5555 | 256038 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6015087 | 2093984 | 37.7305290408635 | -122.390135976897 | (37.7305290408635, -122.390135976897) | 10 | 3 | 8 | 58 | 1 |
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) );