trees
3,587 rows where qSpecies_id = 28 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181703 | 121352 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
181845 | 121355 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
20983 | 26458 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017771.22225 | 2096841.34416 | 37.7385232566369 | -122.381054711725 | (37.7385232566369, -122.381054711725) | 10 | 3 | 8 | 58 | 1 | |||
123433 | 26457 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017757.31102 | 2096823.45757 | 37.7384733757484 | -122.381101567303 | (37.7384733757484, -122.381101567303) | 10 | 3 | 8 | 58 | 1 | ||
37800 | 26456 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017743.98861 | 2096808.93299 | 37.7384327587528 | -122.381146620635 | (37.7384327587528, -122.381146620635) | 10 | 3 | 8 | 58 | 1 | ||
33489 | 201470 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Catalina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017720.50763 | 2095978.01132 | 37.7361499169812 | -122.381170049779 | (37.7361499169812, -122.381170049779) | 10 | 3 | 8 | 58 | 1 | |||
116671 | 11881 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017730.14032 | 2096877.36865 | 37.7386199049771 | -122.381199258841 | (37.7386199049771, -122.381199258841) | 10 | 3 | 8 | 58 | 1 | |||
152578 | 26455 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017718.24501 | 2096772.85897 | 37.7383322855952 | -122.381233122826 | (37.7383322855952, -122.381233122826) | 10 | 3 | 8 | 58 | 1 | ||
156137 | 11882 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2002 12:00:00 AM | 6 | 3X3 | 6017717.79122 | 2096860.52824 | 37.7385729828683 | -122.381240785954 | (37.7385729828683, -122.381240785954) | 10 | 3 | 8 | 58 | 1 | ||
109529 | 201466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Catalina St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017699.90999 | 2096021.8364 | 37.7362691149141 | -122.38124431128 | (37.7362691149141, -122.38124431128) | 10 | 3 | 8 | 58 | 1 | |||
62464 | 201469 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Catalina St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017698.8541 | 2095974.10398 | 37.7361379928748 | -122.381244644042 | (37.7361379928748, -122.381244644042) | 10 | 3 | 8 | 58 | 1 | |||
165171 | 201468 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Catalina St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017677.66407 | 2095970.41595 | 37.7361266964906 | -122.381317651001 | (37.7361266964906, -122.381317651001) | 10 | 3 | 8 | 58 | 1 | |||
151011 | 189459 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Keith St | 5 | : | Tree | Private 2 | 12 | Width 3ft | 6017678.6985 | 2096804.16511 | 37.7384160628385 | -122.381372033003 | (37.7384160628385, -122.381372033003) | 10 | 3 | 8 | 58 | 1 | |||
171567 | 201467 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Catalina St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 6017657.01116 | 2096011.92919 | 37.7362395434261 | -122.381391943098 | (37.7362395434261, -122.381391943098) | 10 | 3 | 8 | 58 | 1 | |||
5281 | 189460 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Keith St | 6 | : | Tree | Private 2 | 23 | Width 3ft | 6017666.55512 | 2096787.33958 | 37.7383691928822 | -122.38141284964 | (37.7383691928822, -122.38141284964) | 10 | 3 | 8 | 58 | 1 | |||
110542 | 189461 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Keith St | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6017639.17726 | 2096752.78415 | 37.7382727990439 | -122.381505107496 | (37.7382727990439, -122.381505107496) | 10 | 3 | 8 | 58 | 1 | |||
3464 | 26465 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
26716 | 26466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
61046 | 26470 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
61110 | 26471 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
181411 | 26472 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
181641 | 26469 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
121873 | 26462 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017579.0331604 | 2096478.0920021 | 37.7375152284127 | -122.381693959087 | (37.7375152284127, -122.381693959087) | 10 | 3 | 8 | 58 | 1 | |||
134131 | 26460 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6017579.0331604 | 2096478.0920021 | 37.7375152284127 | -122.381693959087 | (37.7375152284127, -122.381693959087) | 10 | 3 | 8 | 58 | 1 | |||
137773 | 26459 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017579.0331604 | 2096478.0920021 | 37.7375152284127 | -122.381693959087 | (37.7375152284127, -122.381693959087) | 10 | 3 | 8 | 58 | 1 | |||
138870 | 26461 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017579.0331604 | 2096478.0920021 | 37.7375152284127 | -122.381693959087 | (37.7375152284127, -122.381693959087) | 10 | 3 | 8 | 58 | 1 | |||
74693 | 189490 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6017365.32139 | 2095872.25334 | 37.7358399134893 | -122.382390730173 | (37.7358399134893, -122.382390730173) | 10 | 3 | 8 | 58 | 1 | |||
34548 | 3784 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 35 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/2014 10:43:00 AM | 3 | 3X4 | 6017319.3126468 | 2095790.6090322 | 37.7356131929747 | -122.382544123056 | (37.7356131929747, -122.382544123056) | 10 | 3 | 8 | 58 | 1 | ||
69561 | 107165 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1298X HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | |||
165893 | 17261 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/1993 12:00:00 AM | 24 | 3X3 | 6017260.6217082 | 2094327.801916 | 37.7315933721704 | -122.382645286292 | (37.7315933721704, -122.382645286292) | 10 | 3 | 8 | 58 | 1 | ||
51176 | 14889 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | 10 | 3 | 8 | 58 | 1 | |||
64122 | 14888 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | 10 | 3 | 8 | 58 | 1 | |||
165983 | 14892 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | 10 | 3 | 8 | 58 | 1 | |||
51553 | 189489 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 Cashmere St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 4ft | 6017243.61446 | 2095819.28747 | 37.7356877562737 | -122.382807838415 | (37.7356877562737, -122.382807838415) | 10 | 3 | 8 | 58 | 1 | |||
36856 | 27673 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 39 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017176.7218855 | 2094308.8587774 | 37.7315367226818 | -122.382934029479 | (37.7315367226818, -122.382934029479) | 10 | 3 | 8 | 58 | 1 | |||
63058 | 3790 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 65 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017205.1322018 | 2095813.5833836 | 37.7356699677948 | -122.382940490937 | (37.7356699677948, -122.382940490937) | 10 | 3 | 8 | 58 | 1 | |||
161795 | 189488 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6017158.86023 | 2095829.45331 | 37.7357109866645 | -122.3831015768 | (37.7357109866645, -122.3831015768) | 10 | 3 | 8 | 58 | 1 | |||
166866 | 189393 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 24th St | 15 | : Yard | Tree | Private 2 | 10 | 6017282.75412 | 2102644.41979 | 37.7544303427117 | -122.383147413432 | (37.7544303427117, -122.383147413432) | 10 | 3 | 8 | 28856 | 29 | ||||
93634 | 3795 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 85 Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017127.2120173 | 2095821.2433114 | 37.7356866947795 | -122.383210426751 | (37.7356866947795, -122.383210426751) | 10 | 3 | 8 | 58 | 1 | |||
118105 | 14875 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017137.53448 | 2098765.92965 | 37.7437727810994 | -122.383379656173 | (37.7437727810994, -122.383379656173) | 10 | 3 | 8 | 58 | 1 | |||
123278 | 14876 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6017126.29262 | 2098751.68022 | 37.7437330337612 | -122.383417536507 | (37.7437330337612, -122.383417536507) | 10 | 3 | 8 | 58 | 1 | |||
132640 | 14894 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6017116.82626 | 2098595.36732 | 37.7433033071087 | -122.383439390019 | (37.7433033071087, -122.383439390019) | 10 | 3 | 8 | 58 | 1 | ||
39682 | 14902 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017111.44356 | 2098535.62444 | 37.7431389677975 | -122.383453844133 | (37.7431389677975, -122.383453844133) | 10 | 3 | 8 | 58 | 1 | |||
77138 | 14903 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017111.44356 | 2098535.62444 | 37.7431389677975 | -122.383453844133 | (37.7431389677975, -122.383453844133) | 10 | 3 | 8 | 58 | 1 | |||
99257 | 14906 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017111.44356 | 2098535.62444 | 37.7431389677975 | -122.383453844133 | (37.7431389677975, -122.383453844133) | 10 | 3 | 8 | 58 | 1 | |||
184140 | 14905 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017111.44356 | 2098535.62444 | 37.7431389677975 | -122.383453844133 | (37.7431389677975, -122.383453844133) | 10 | 3 | 8 | 58 | 1 | |||
87423 | 189449 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6017097.47113 | 2098554.8475 | 37.7431909781764 | -122.383503495486 | (37.7431909781764, -122.383503495486) | 10 | 3 | 8 | 58 | 1 | |||
52772 | 14952 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 255 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017079.55386 | 2097902.22905 | 37.741398029861 | -122.38352002608 | (37.741398029861, -122.38352002608) | 10 | 3 | 8 | 58 | 1 | |||
169057 | 14953 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 255 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017079.55386 | 2097902.22905 | 37.741398029861 | -122.38352002608 | (37.741398029861, -122.38352002608) | 10 | 3 | 8 | 58 | 1 | |||
32193 | 189448 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 5 | : | Tree | Private 2 | 27 | Width 4ft | 6017089.46767 | 2098534.02953 | 37.7431333739056 | -122.383529720639 | (37.7431333739056, -122.383529720639) | 10 | 3 | 8 | 58 | 1 | |||
110854 | 14890 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017084.25273 | 2098515.6728 | 37.7430826818183 | -122.383546475015 | (37.7430826818183, -122.383546475015) | 10 | 3 | 8 | 58 | 1 | |||
130168 | 189447 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 2 | : | Tree | Private 2 | 20 | Width 3ft | 6017073.30854 | 2098474.35419 | 37.7429686244012 | -122.383581441523 | (37.7429686244012, -122.383581441523) | 10 | 3 | 8 | 58 | 1 | |||
21966 | 14887 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.383596739007 | (37.7429202372855, -122.383596739007) | 10 | 3 | 8 | 58 | 1 | ||
128398 | 14885 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Mendell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | |||
113859 | 14904 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6017055.38768 | 2098389.95887 | 37.7427359014434 | -122.383637533158 | (37.7427359014434, -122.383637533158) | 10 | 3 | 8 | 58 | 1 | |||
23920 | 189446 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 3 | : | Tree | Private 2 | 28 | Width 4ft | 6017051.6761 | 2098373.04051 | 37.7426892419063 | -122.383649189252 | (37.7426892419063, -122.383649189252) | 10 | 3 | 8 | 58 | 1 | |||
177679 | 189445 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 2 | : | Tree | Private 2 | 18 | Width 3ft | 6017048.16269 | 2098355.48866 | 37.7426408538865 | -122.383660116015 | (37.7426408538865, -122.383660116015) | 10 | 3 | 8 | 58 | 1 | |||
104994 | 14880 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6017048.75198 | 2098616.89656 | 37.7433586594768 | -122.383676274149 | (37.7433586594768, -122.383676274149) | 10 | 3 | 8 | 58 | 1 | |||
53239 | 14886 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6017031.41664 | 2098528.69249 | 37.7431155108007 | -122.383730076065 | (37.7431155108007, -122.383730076065) | 10 | 3 | 8 | 58 | 1 | ||
133620 | 14883 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Mendell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017019.70543 | 2098544.01606 | 37.7431569388511 | -122.383771637374 | (37.7431569388511, -122.383771637374) | 10 | 3 | 8 | 58 | 1 | ||
16946 | 189444 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 7 | : | Tree | Private 2 | 18 | Width 4ft | 6017009.92172 | 2098163.28563 | 37.7421109895326 | -122.383778964147 | (37.7421109895326, -122.383778964147) | 10 | 3 | 8 | 58 | 1 | |||
183041 | 189443 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6017001.71377 | 2098118.43003 | 37.7419873714259 | -122.383804222493 | (37.7419873714259, -122.383804222493) | 10 | 3 | 8 | 58 | 1 | |||
22384 | 14951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017001.18429 | 2098171.14482 | 37.7421320862857 | -122.383809722815 | (37.7421320862857, -122.383809722815) | 10 | 3 | 8 | 58 | 1 | |||
155559 | 14950 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017001.18429 | 2098171.14482 | 37.7421320862857 | -122.383809722815 | (37.7421320862857, -122.383809722815) | 10 | 3 | 8 | 58 | 1 | |||
107687 | 189442 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 5 | : | Tree | Private 2 | 18 | Width 4ft | 6016996.79512 | 2098099.65565 | 37.7419355488861 | -122.383819922865 | (37.7419355488861, -122.383819922865) | 10 | 3 | 8 | 58 | 1 | |||
78806 | 14898 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 156 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6016999.92257 | 2098400.892 | 37.7427628556857 | -122.383830078634 | (37.7427628556857, -122.383830078634) | 10 | 3 | 8 | 58 | 1 | |||
83810 | 189450 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6017000.35659 | 2098477.76011 | 37.7429739438981 | -122.383833928896 | (37.7429739438981, -122.383833928896) | 10 | 3 | 8 | 58 | 1 | |||
58792 | 189441 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 4 | : | Tree | Private 2 | 14 | Width 3ft | 6016991.41888 | 2098078.56472 | 37.7418773402717 | -122.383837044168 | (37.7418773402717, -122.383837044168) | 10 | 3 | 8 | 58 | 1 | |||
24726 | 14899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 160 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6016997.24223 | 2098390.01536 | 37.7427328424729 | -122.383838589425 | (37.7427328424729, -122.383838589425) | 10 | 3 | 8 | 58 | 1 | |||
39734 | 189451 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6016996.37271 | 2098457.91162 | 37.742919223749 | -122.383846322475 | (37.742919223749, -122.383846322475) | 10 | 3 | 8 | 58 | 1 | |||
145346 | 189452 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016993.56497 | 2098437.14661 | 37.7428620520374 | -122.383854585431 | (37.7428620520374, -122.383854585431) | 10 | 3 | 8 | 58 | 1 | |||
184686 | 189453 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6016986.81524 | 2098398.61469 | 37.7427558780826 | -122.383875241966 | (37.7427558780826, -122.383875241966) | 10 | 3 | 8 | 58 | 1 | |||
89664 | 14921 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 180 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016983.57246 | 2098334.54451 | 37.7425797751121 | -122.383881994477 | (37.7425797751121, -122.383881994477) | 10 | 3 | 8 | 58 | 1 | |||
149550 | 14922 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 184 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016980.7581 | 2098323.12404 | 37.742548261239 | -122.383890930774 | (37.742548261239, -122.383890930774) | 10 | 3 | 8 | 58 | 1 | |||
77103 | 189454 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 6 | : | Tree | Private 2 | 18 | Width 3ft | 6016981.34424 | 2098379.09321 | 37.7427019736207 | -122.383892800328 | (37.7427019736207, -122.383892800328) | 10 | 3 | 8 | 58 | 1 | |||
154244 | 189440 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 2 | : | Tree | Private 2 | 15 | Width 3ft | 6016970.91119 | 2098020.16133 | 37.741715842721 | -122.383903888062 | (37.741715842721, -122.383903888062) | 10 | 3 | 8 | 58 | 1 | |||
110568 | 14954 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 275 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.383922171933 | (37.7417352694795, -122.383922171933) | 10 | 3 | 8 | 58 | 1 | |||
174107 | 14955 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 275 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.383922171933 | (37.7417352694795, -122.383922171933) | 10 | 3 | 8 | 58 | 1 | |||
115329 | 189439 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6016963.00829 | 2098000.26729 | 37.7416607808307 | -122.383929828997 | (37.7416607808307, -122.383929828997) | 10 | 3 | 8 | 58 | 1 | |||
71355 | 14939 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016963.53103 | 2098247.48496 | 37.7423396193305 | -122.383945231762 | (37.7423396193305, -122.383945231762) | 10 | 3 | 8 | 58 | 1 | |||
189081 | 14949 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016963.53103 | 2098247.48496 | 37.7423396193305 | -122.383945231762 | (37.7423396193305, -122.383945231762) | 10 | 3 | 8 | 58 | 1 | |||
186014 | 189438 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 10 | : | Tree | Private 2 | 16 | Width 4ft | 6016944.89383 | 2097963.47475 | 37.7415587545458 | -122.383989901933 | (37.7415587545458, -122.383989901933) | 10 | 3 | 8 | 58 | 1 | |||
21189 | 14933 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | 10 | 3 | 8 | 58 | 1 | |||
142597 | 189437 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 9 | : | Tree | Private 2 | 13 | Width 4ft | 6016936.32054 | 2097949.49231 | 37.7415198876289 | -122.384018572307 | (37.7415198876289, -122.384018572307) | 10 | 3 | 8 | 58 | 1 | |||
44960 | 14934 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016937.56123 | 2098168.30957 | 37.7421207840608 | -122.384029516163 | (37.7421207840608, -122.384029516163) | 10 | 3 | 8 | 58 | 1 | |||
160213 | 14935 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/1989 12:00:00 AM | 12 | 3X3 | 6016933.70411 | 2098147.37147 | 37.7420630790432 | -122.384041395297 | (37.7420630790432, -122.384041395297) | 10 | 3 | 8 | 58 | 1 | ||
66857 | 14936 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016920.64099 | 2098083.60989 | 37.7418872804668 | -122.384082124712 | (37.7418872804668, -122.384082124712) | 10 | 3 | 8 | 58 | 1 | |||
75491 | 14937 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016913.42346 | 2098066.40482 | 37.7418396397975 | -122.384105882978 | (37.7418396397975, -122.384105882978) | 10 | 3 | 8 | 58 | 1 | |||
27332 | 14938 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016907.69513 | 2098053.92414 | 37.741805053675 | -122.384124820925 | (37.741805053675, -122.384124820925) | 10 | 3 | 8 | 58 | 1 | |||
152439 | 14940 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016890.87226 | 2098016.163 | 37.7417004391255 | -122.384180360341 | (37.7417004391255, -122.384180360341) | 10 | 3 | 8 | 58 | 1 | |||
131988 | 14959 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 325 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6016888.48059 | 2097899.84949 | 37.7413809335659 | -122.384180531751 | (37.7413809335659, -122.384180531751) | 10 | 3 | 8 | 58 | 1 | |||
184688 | 14958 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 325 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016888.48059 | 2097899.84949 | 37.7413809335659 | -122.384180531751 | (37.7413809335659, -122.384180531751) | 10 | 3 | 8 | 58 | 1 | ||
150470 | 189436 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 5 | : | Tree | Private 2 | 8 | Width 3ft | 6016883.04052 | 2097872.31866 | 37.7413050387037 | -122.384197424971 | (37.7413050387037, -122.384197424971) | 10 | 3 | 8 | 58 | 1 | |||
115248 | 189435 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 4 | : | Tree | Private 2 | 17 | Width 3ft | 6016869.31993 | 2097857.65317 | 37.7412640116175 | -122.384243845296 | (37.7412640116175, -122.384243845296) | 10 | 3 | 8 | 58 | 1 | |||
64296 | 14942 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016868.17311 | 2097974.63279 | 37.7415851505377 | -122.384255955554 | (37.7415851505377, -122.384255955554) | 10 | 3 | 8 | 58 | 1 | |||
11953 | 189434 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 3 | : | Tree | Private 2 | 12 | Width 3ft | 6016859.57023 | 2097844.08748 | 37.7412262239015 | -122.384276612087 | (37.7412262239015, -122.384276612087) | 10 | 3 | 8 | 58 | 1 | |||
123949 | 14943 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016856.6474 | 2097956.20405 | 37.7415339116704 | -122.384294524771 | (37.7415339116704, -122.384294524771) | 10 | 3 | 8 | 58 | 1 | |||
105106 | 189485 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10x Garlington Ct | 2 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016768.74499 | 2094679.89439 | 37.7325329624249 | -122.384370330438 | (37.7325329624249, -122.384370330438) | 10 | 3 | 8 | 58 | 1 | |||
30405 | 189433 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016822.99867 | 2097792.72493 | 37.7410831705501 | -122.384399488272 | (37.7410831705501, -122.384399488272) | 10 | 3 | 8 | 58 | 1 | |||
104736 | 14946 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016823.8175 | 2097912.19413 | 37.741411254039 | -122.384404975929 | (37.741411254039, -122.384404975929) | 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) );