trees
3,587 rows where qSpecies_id = 28 sorted by XCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104092 | 201549 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Innes Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 6ft | 6020789.54938 | 2093251.93298 | 37.7288335625002 | -122.370370588629 | (37.7288335625002, -122.370370588629) | 10 | 3 | 8 | 58 | 1 | |||
100867 | 201545 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Innes Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | 6020633.70615 | 2093371.77747 | 37.7291540781924 | -122.370917639957 | (37.7291540781924, -122.370917639957) | 10 | 3 | 8 | 58 | 1 | ||||
59739 | 201542 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Innes Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 6020585.50312 | 2093400.19609 | 37.7292294638519 | -122.371086248457 | (37.7292294638519, -122.371086248457) | 10 | 3 | 8 | 58 | 1 | ||||
32440 | 201455 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Catalina St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6018178.0225 | 2096034.88004 | 37.7363313120402 | -122.379592166743 | (37.7363313120402, -122.379592166743) | 10 | 3 | 8 | 58 | 1 | |||
31310 | 189515 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018172.45187 | 2096173.93541 | 37.7367128233477 | -122.379621084471 | (37.7367128233477, -122.379621084471) | 10 | 3 | 8 | 58 | 1 | |||
174198 | 189516 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018169.48806 | 2096212.33581 | 37.7368180997786 | -122.379633998737 | (37.7368180997786, -122.379633998737) | 10 | 3 | 8 | 58 | 1 | |||
50281 | 189514 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018158.36109 | 2096173.36001 | 37.7367104662145 | -122.379669762974 | (37.7367104662145, -122.379669762974) | 10 | 3 | 8 | 58 | 1 | |||
179034 | 201456 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Catalina St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6018152.99448 | 2096035.88358 | 37.736332687111 | -122.379678769657 | (37.736332687111, -122.379678769657) | 10 | 3 | 8 | 58 | 1 | |||
128792 | 189517 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018151.68637 | 2096212.97966 | 37.7368188857736 | -122.379695592373 | (37.7368188857736, -122.379695592373) | 10 | 3 | 8 | 58 | 1 | |||
19665 | 189518 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018139.6232 | 2096213.22199 | 37.736818885776 | -122.379737317327 | (37.736818885776, -122.379737317327) | 10 | 3 | 8 | 58 | 1 | |||
21663 | 189513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018133.38456 | 2096174.43393 | 37.7367120373179 | -122.379756193195 | (37.7367120373179, -122.379756193195) | 10 | 3 | 8 | 58 | 1 | |||
47033 | 201457 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Catalina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6018132.65618 | 2096036.7926 | 37.736334061269 | -122.37974915152 | (37.736334061269, -122.37974915152) | 10 | 3 | 8 | 58 | 1 | |||
62238 | 189519 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018116.09419 | 2096214.83904 | 37.7368220280049 | -122.379818780634 | (37.7368220280049, -122.379818780634) | 10 | 3 | 8 | 58 | 1 | |||
46933 | 201458 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Catalina St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6018111.78468 | 2096036.16184 | 37.7363311780414 | -122.37982126995 | (37.7363311780414, -122.37982126995) | 10 | 3 | 8 | 58 | 1 | |||
143727 | 189520 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018095.44922 | 2096216.97069 | 37.7368267422621 | -122.379890308193 | (37.7368267422621, -122.379890308193) | 10 | 3 | 8 | 58 | 1 | |||
133824 | 189512 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018094.93182 | 2096176.92332 | 37.7367167515701 | -122.379889315347 | (37.7367167515701, -122.379889315347) | 10 | 3 | 8 | 58 | 1 | |||
155529 | 201459 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Catalina St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6018080.74427 | 2096037.10445 | 37.7363320539713 | -122.379928656194 | (37.7363320539713, -122.379928656194) | 10 | 3 | 8 | 58 | 1 | |||
174067 | 189511 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018076.84879 | 2096177.85881 | 37.7367183226971 | -122.379951901885 | (37.7367183226971, -122.379951901885) | 10 | 3 | 8 | 58 | 1 | |||
179618 | 189521 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018061.54589 | 2096217.07965 | 37.7368251711525 | -122.380007535722 | (37.7368251711525, -122.380007535722) | 10 | 3 | 8 | 58 | 1 | |||
186994 | 189509 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 12 Ironwood Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018048.65488 | 2096118.91081 | 37.7365549077878 | -122.380045286575 | (37.7365549077878, -122.380045286575) | 10 | 3 | 8 | 58 | 1 | |||
117372 | 189510 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 12 Ironwood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018047.85099 | 2096150.40091 | 37.736641329019 | -122.38005025352 | (37.736641329019, -122.38005025352) | 10 | 3 | 8 | 58 | 1 | |||
118572 | 189508 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 12 Ironwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018046.59252 | 2096102.07056 | 37.7365085540177 | -122.380051247266 | (37.7365085540177, -122.380051247266) | 10 | 3 | 8 | 58 | 1 | |||
54227 | 189507 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 12 Ironwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018046.04082 | 2096060.30667 | 37.7363938482047 | -122.380050253535 | (37.7363938482047, -122.380050253535) | 10 | 3 | 8 | 58 | 1 | |||
85439 | 189503 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Ironwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018009.20898 | 2096118.5269 | 37.7365516774059 | -122.380181642665 | (37.7365516774059, -122.380181642665) | 10 | 3 | 8 | 58 | 1 | |||
62192 | 189504 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Ironwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018008.38101 | 2096102.26614 | 37.7365069828979 | -122.380183375673 | (37.7365069828979, -122.380183375673) | 10 | 3 | 8 | 58 | 1 | |||
76517 | 189502 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Ironwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018008.30098 | 2096155.48748 | 37.7366531137419 | -122.380187349771 | (37.7366531137419, -122.380187349771) | 10 | 3 | 8 | 58 | 1 | |||
132555 | 189505 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Ironwood Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018007.03661 | 2096078.2583 | 37.736440987949 | -122.380186356011 | (37.736440987949, -122.380186356011) | 10 | 3 | 8 | 58 | 1 | |||
181950 | 189506 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Ironwood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018006.17491 | 2096063.96927 | 37.7364017055594 | -122.380188342614 | (37.7364017055594, -122.380188342614) | 10 | 3 | 8 | 58 | 1 | |||
159261 | 189522 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 211 Acacia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018001.89898 | 2096225.38149 | 37.7368446756287 | -122.380214340243 | (37.7368446756287, -122.380214340243) | 10 | 3 | 8 | 58 | 1 | |||
25171 | 189501 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017983.54314 | 2096181.73638 | 37.7367238220386 | -122.380274772865 | (37.7367238220386, -122.380274772865) | 10 | 3 | 8 | 58 | 1 | |||
114721 | 201477 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Catalina St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017976.13147 | 2095993.98649 | 37.7362078890842 | -122.380287354394 | (37.7362078890842, -122.380287354394) | 10 | 3 | 8 | 58 | 1 | |||
58530 | 201460 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6017973.04707 | 2096042.30781 | 37.7363403996791 | -122.380301375718 | (37.7363403996791, -122.380301375718) | 10 | 3 | 8 | 58 | 1 | |||
186024 | 189500 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017962.8634 | 2096182.15193 | 37.7367238220301 | -122.380346301344 | (37.7367238220301, -122.380346301344) | 10 | 3 | 8 | 58 | 1 | |||
74190 | 201476 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Catalina St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017960.44466 | 2095995.06059 | 37.736209972812 | -122.380341665339 | (37.736209972812, -122.380341665339) | 10 | 3 | 8 | 58 | 1 | |||
121878 | 201461 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017953.45292 | 2096043.24066 | 37.7363418799584 | -122.380369186391 | (37.7363418799584, -122.380369186391) | 10 | 3 | 8 | 58 | 1 | |||
90591 | 189523 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 211 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017947.90713 | 2096226.71896 | 37.7368453690035 | -122.380401108742 | (37.7368453690035, -122.380401108742) | 10 | 3 | 8 | 58 | 1 | |||
172242 | 189499 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017942.78126 | 2096183.7002 | 37.7367269651779 | -122.38041584234 | (37.7367269651779, -122.38041584234) | 10 | 3 | 8 | 58 | 1 | |||
157726 | 201475 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Catalina St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017932.44765 | 2095996.07519 | 37.7362112138727 | -122.38043853402 | (37.7362112138727, -122.38043853402) | 10 | 3 | 8 | 58 | 1 | |||
186154 | 201462 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6017931.88164 | 2096043.57688 | 37.736341612873 | -122.380443791448 | (37.736341612873, -122.380443791448) | 10 | 3 | 8 | 58 | 1 | |||
162008 | 189498 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017927.2772 | 2096184.2977 | 37.7367277502815 | -122.380469488698 | (37.7367277502815, -122.380469488698) | 10 | 3 | 8 | 58 | 1 | |||
103853 | 189524 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 211 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017920.34086 | 2096230.55606 | 37.7368543838092 | -122.380496685098 | (37.7368543838092, -122.380496685098) | 10 | 3 | 8 | 58 | 1 | |||
116219 | 201474 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Catalina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017913.7738 | 2095996.98532 | 37.7362126824722 | -122.380503161112 | (37.7362126824722, -122.380503161112) | 10 | 3 | 8 | 58 | 1 | |||
24749 | 201463 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6017910.15961 | 2096044.43658 | 37.736342774794 | -122.380518954089 | (37.736342774794, -122.380518954089) | 10 | 3 | 8 | 58 | 1 | |||
162509 | 201473 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Catalina St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017891.6083 | 2095998.1068 | 37.736214538679 | -122.380579875087 | (37.736214538679, -122.380579875087) | 10 | 3 | 8 | 58 | 1 | |||
183315 | 189525 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017891.20284 | 2096231.89923 | 37.7368564639644 | -122.38059752247 | (37.7368564639644, -122.38059752247) | 10 | 3 | 8 | 58 | 1 | |||
154929 | 201464 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6017881.76944 | 2096045.33861 | 37.7363436849175 | -122.380617174457 | (37.7363436849175, -122.380617174457) | 10 | 3 | 8 | 58 | 1 | |||
164944 | 201472 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Catalina St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6017871.79142 | 2095999.43852 | 37.7362171017244 | -122.380648483446 | (37.7362171017244, -122.380648483446) | 10 | 3 | 8 | 58 | 1 | |||
126702 | 189526 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017871.68809 | 2096232.54396 | 37.7368571573346 | -122.380665039075 | (37.7368571573346, -122.380665039075) | 10 | 3 | 8 | 58 | 1 | |||
41725 | 201465 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6017857.70241 | 2096046.34832 | 37.7363451292113 | -122.380700455256 | (37.7363451292113, -122.380700455256) | 10 | 3 | 8 | 58 | 1 | |||
97917 | 189497 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017857.1903 | 2096185.42035 | 37.7367269651611 | -122.380711890149 | (37.7367269651611, -122.380711890149) | 10 | 3 | 8 | 58 | 1 | |||
185515 | 189527 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017855.19484 | 2096232.11788 | 37.7368550771857 | -122.380722034501 | (37.7368550771857, -122.380722034501) | 10 | 3 | 8 | 58 | 1 | |||
23098 | 189496 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017841.42794 | 2096187.45373 | 37.736731678516 | -122.380766529361 | (37.736731678516, -122.380766529361) | 10 | 3 | 8 | 58 | 1 | |||
171440 | 189528 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017830.36158 | 2096233.12207 | 37.7368564639597 | -122.380807964714 | (37.7368564639597, -122.380807964714) | 10 | 3 | 8 | 58 | 1 | |||
20216 | 121344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
40258 | 121362 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
45121 | 121357 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
47802 | 121347 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
51784 | 121350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
70298 | 121356 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
78185 | 121361 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
84657 | 121351 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
113761 | 121359 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
120980 | 121346 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
129062 | 121349 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
154868 | 121342 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
160697 | 121360 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
164070 | 121358 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
181181 | 121348 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
42389 | 189495 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017824.48788 | 2096188.08048 | 37.7367324645202 | -122.380825142688 | (37.7367324645202, -122.380825142688) | 10 | 3 | 8 | 58 | 1 | |||
21101 | 189529 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017810.85672 | 2096234.27169 | 37.7368585440828 | -122.380875482215 | (37.7368585440828, -122.380875482215) | 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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 |
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) );