3,587 rows where qSpecies_id = 28 sorted by PlantDate descending

View and edit SQL

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)
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
165448 1764 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2000X Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/30/1992 12:00:00 AM 12 3X3   6012375.8565272 2088505.2474917 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859) 10 7 8 309 39
185735 92211 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 300x Miramar Ave 5 Median : Cutout Tree Private 2   12/29/2010 12:00:00 AM   2x2 Permit Number 54064 5995384.3 2092126.4 37.7243160320082 -122.458116274775 (37.7243160320082, -122.458116274775) 9 8 4 28861 24
177425 63201 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 434 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1986 12:00:00 AM 17   Permit Number 23742 5984713.13689 2112937.02697 37.7808373486479 -122.496539369055 (37.7808373486479, -122.496539369055) 11 6 2 55 26
182735 63191 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 480 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1986 12:00:00 AM 14 4x9 Permit Number 23731 5984103.00663 2112603.98729 37.7798871547077 -122.498625465556 (37.7798871547077, -122.498625465556) 11 6 2 55 26
20135 248904 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 4109 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1976 12:00:00 AM 28 Width 5ft Permit Number 16599 6001658.90013 2103489.46423 37.7558748868343 -122.437239147875 (37.7558748868343, -122.437239147875) 2 4 5 28862 22
53982 57695 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 4109 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1976 12:00:00 AM 30 6x6 Permit Number 16599 6001771.77462005 2103491.48426394 37.7558868491952 -122.436848936392 (37.7558868491952, -122.436848936392) 2 4 5 28862 22
59385 46423 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 179 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1969 12:00:00 AM     Permit Number 44645 5999395.58867085 2107159.64271916 37.7658233652373 -122.445330264611 (37.7658233652373, -122.445330264611) 15 5 5 29492 9
127875 12553 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 280X Lake St 9 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/1992 12:00:00 AM 24 3X3   5994647.05266 2114915.6366 37.7868470540675 -122.462316907107 (37.7868470540675, -122.462316907107) 11 6 1 54 11
182506 30320 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 867 25th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/13/1955 12:00:00 AM     Permit Number 14 5988182.28713273 2110079.61323567 37.77319432354 -122.484328404455 (37.77319432354, -122.484328404455) 11 6 2 55 26
122589 6169 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1075 Ellis St 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2009 12:00:00 AM 3 3x3   6005763.6544 2113429.69831 37.7834008746955 -122.423750304634 (37.7834008746955, -122.423750304634) 7 9 11 28858 41
85829 87052 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 511 Euclid Ave   Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM   3x3 Permit Number 50168 5996764.3 2113789 37.7838752968943 -122.454910329525 (37.7838752968943, -122.454910329525) 11 6 1 54 31
50543 11666 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 700X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1   12/08/1992 12:00:00 AM 12 4X4   5991320.9947906 2093088.5989831 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363) 9 8 4 64 40
95752 62433 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 4392 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1985 12:00:00 AM     Permit Number 770962 6000030.87492783 2105785.85783865 37.7620875372244 -122.443034282049 (37.7620875372244, -122.443034282049) 15 5 5 28862 3
183413 45817 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1168 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2001 12:00:00 AM     Permit Number 44444 6015539.10076278 2103555.89602939 37.7568365560705 -122.389241112249 (37.7568365560705, -122.389241112249) 10 3 8 28856 29
105886 33710 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 107 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37778 6003699.03578605 2108805.33287927 37.7705867464666 -122.430562993164 (37.7705867464666, -122.430562993164) 15 9 11 29492 10
156344 33715 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 184 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1996 12:00:00 AM     Permit Number 37783 6003401.63659312 2108816.63624682 37.7706009305559 -122.431592506668 (37.7706009305559, -122.431592506668) 15 9 11 29492 10
2152 33675 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 469 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 13   Permit Number 37757 6005116.23557125 2111084.96150687 37.7769262359606 -122.425823168919 (37.7769262359606, -122.425823168919) 7 9 11 28852 10
29506 33680 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 419 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 13   Permit Number 37760 6005344.46198727 2111116.85391927 37.7770266994083 -122.425035932953 (37.7770266994083, -122.425035932953) 7 9 11 28852 10
84823 33683 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 400 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37762 6005419.42693285 2111179.83479418 37.7772038638652 -122.4247810873 (37.7772038638652, -122.4247810873) 7 9 11 28852 10
113345 33684 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 400 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37762 6005419.42693285 2111179.83479418 37.7772038638652 -122.4247810873 (37.7772038638652, -122.4247810873) 7 9 11 28852 10
177146 33677 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 455 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 773435 6005180.13897934 2111093.89138396 37.776954366261 -122.425602743023 (37.776954366261, -122.425602743023) 7 9 11 28852 10
190002 33685 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 400 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37762 6005419.42693285 2111179.83479418 37.7772038638652 -122.4247810873 (37.7772038638652, -122.4247810873) 7 9 11 28852 10
150996 2048 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 701X Bosworth St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/27/2000 12:00:00 AM 3 3X3   6001958.68142 2095417.21372 37.7337274221844 -122.435624928664 (37.7337274221844, -122.435624928664) 9 7 5 63 40
152374 33561 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 270 PROSPECT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   11/26/1996 12:00:00 AM     Permit Number 37668 6006489 2098160 37.74151478014 -122.420156839009 (37.74151478014, -122.420156839009) 2 7 7 28859 2
10872 33492 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 25 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37604 6007009.01726732 2099597.28801828 37.7454905378147 -122.418460683772 (37.7454905378147, -122.418460683772) 2 7 7 28859 2
18302 33467 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 72 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37623 6006783.56593714 2099291.50343979 37.7446382277934 -122.419218573599 (37.7446382277934, -122.419218573599) 2 7 7 28859 2
22660 33533 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 185 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37643 6007275.34853053 2097937.54990535 37.7409482571652 -122.417422147014 (37.7409482571652, -122.417422147014) 2 7 7 28859 2
33171 33502 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 155 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37596 6006575.63931047 2098797.68147059 37.7432705917121 -122.419902509091 (37.7432705917121, -122.419902509091) 2 7 7 28859 2
43222 33511 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 30 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37606 6006939.76943127 2099579.03687854 37.7454365257217 -122.418698838359 (37.7454365257217, -122.418698838359) 2 7 7 28859 2
47971 33532 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 179 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM 16 5x5 Permit Number 37642 6007307.15222384 2097996.82035732 37.7411127900368 -122.417316380484 (37.7411127900368, -122.417316380484) 2 7 7 28859 2
54221 33464 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 52 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37617 6006854.98101405 2099423.3660818 37.7450043146116 -122.418980984578 (37.7450043146116, -122.418980984578) 2 7 7 28859 2
67088 33493 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 7 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37621 6007079.73577518 2099722.81418474 37.7458391853073 -122.418225047767 (37.7458391853073, -122.418225047767) 2 7 7 28859 2
82080 33466 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 60 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37619 6006826.41498367 2099370.6210257 37.7448578799465 -122.419076020466 (37.7448578799465, -122.419076020466) 2 7 7 28859 2
82202 33528 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 183 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37638 6007285.94975907 2097957.3067179 37.7410031014535 -122.417386891564 (37.7410031014535, -122.417386891564) 2 7 7 28859 2
121374 33515 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 65 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37620 6006865.28384578 2099333.19830806 37.7447573143397 -122.418938965199 (37.7447573143397, -122.418938965199) 2 7 7 28859 2
132902 33489 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 41 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37615 6006958.13481375 2099504.24101761 37.7452321871095 -122.41863003057 (37.7452321871095, -122.41863003057) 2 7 7 28859 2
136578 33523 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 180 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37633 6007234.13744004 2097970.72636993 37.7410370335385 -122.417566990918 (37.7410370335385, -122.417566990918) 2 7 7 28859 2
148674 33531 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 177 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37641 6007317.75345238 2098016.57716988 37.741167634292 -122.417281124878 (37.741167634292, -122.417281124878) 2 7 7 28859 2
159403 33503 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 161 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM   3x3 Permit Number 37597 6006560.16848411 2098769.04119675 37.7431910803563 -122.41995397132 (37.7431910803563, -122.41995397132) 2 7 7 28859 2
169169 33542 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 213 BOCANA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37650 6007149 2097726 37.7403602783661 -122.417844022689 (37.7403602783661, -122.417844022689) 2 7 7 28859 2
179716 33536 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 187 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37646 6007264.74730199 2097917.79309279 37.7408934128659 -122.417457402411 (37.7408934128659, -122.417457402411) 2 7 7 28859 2
53453 52252 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 237 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2005 12:00:00 AM     Permit Number 48419 6006717.04487845 2104738.84078637 37.7595916236736 -122.419835049965 (37.7595916236736, -122.419835049965) 2 4 7 28859 19
24682 50574 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2295 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
121795 50567 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2295 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
158590 50572 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2295 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
37225 41146 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1534 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1999 12:00:00 AM     Permit Number 41879 5998316.1437305 2108281.00611102 37.7688406669583 -122.449144612222 (37.7688406669583, -122.449144612222) 15 5 11 29492 9
86541 57655 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 101 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1976 12:00:00 AM 20 6x8 Permit Number 16555 6006226.5518322 2097569.54766444 37.7398787392856 -122.421022382943 (37.7398787392856, -122.421022382943) 2 7 7 28859 2
95798 19460 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1700X Sloat Blvd 6 Median : Cutout Tree DPW 1   11/13/2007 12:00:00 AM 3 20   5985858.9484667 2095882.6709765 37.7340778499573 -122.491319932369 (37.7340778499573, -122.491319932369) 1 8 3 64 35
104513 19428 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1200X Sloat Blvd 1 Median : Cutout Tree DPW 1   11/13/2007 12:00:00 AM 3 20   5987947.5018995 2095985.7700738 37.7344827526385 -122.484106799366 (37.7344827526385, -122.484106799366) 1 8 3 64 35
133551 19423 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 880X Sloat Blvd 1 Median : Cutout Tree DPW 1   11/13/2007 12:00:00 AM 3 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
144405 92861 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2245 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2009 12:00:00 AM 11 3x3   6006750.86672 2118980.24307 37.7986969721415 -122.420729101491 (37.7986969721415, -122.420729101491) 13 9 10 28858 32
30283 94848 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 55X Heron St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2010 12:00:00 AM 3 3x3 Permit Number 53927 6009970 2109980 37.7741653653004 -122.408954458449 (37.7741653653004, -122.408954458449) 8 2 9 28853 34
48458 16693 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900X NORIEGA ST 4 Median : Cutout Tree DPW 1   11/07/2014 11:22:00 AM 3 8   5991142.4 2103205.1 37.7544906639436 -122.473587529216 (37.7544906639436, -122.473587529216) 1 8 4 56 12
77824 16690 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 950X Noriega St 1 Median : Cutout Tree DPW 1   11/07/2014 11:22:00 AM 3 8   5991053.49575 2103158.03284 37.7543562808184 -122.473891546652 (37.7543562808184, -122.473891546652) 1 8 4 56 12
45933 33219 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Vasquez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37411 5995201.63425474 2099773.01638321 37.7453012719366 -122.459301205113 (37.7453012719366, -122.459301205113) 1 8 4 59 40
68568 33184 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 585 Dewey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37394 5994051.93950389 2099322.38418157 37.7439977822914 -122.463243935185 (37.7439977822914, -122.463243935185) 1 8 4 59 40
82317 206370 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Hernandez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1996 12:00:00 AM 13 Width 3ft Permit Number 37411 5995131.60036 2099773.99475 37.7452999315413 -122.45954343988 (37.7452999315413, -122.45954343988) 1 8 4 59 40
126326 33217 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Vasquez Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37411 5995201.63425474 2099773.01638321 37.7453012719366 -122.459301205113 (37.7453012719366, -122.459301205113) 1 8 4 59 40
129877 33185 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 585 Dewey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37394 5994051.93950389 2099322.38418157 37.7439977822914 -122.463243935185 (37.7439977822914, -122.463243935185) 1 8 4 59 40
136387 33218 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Vasquez Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37411 5995201.63425474 2099773.01638321 37.7453012719366 -122.459301205113 (37.7453012719366, -122.459301205113) 1 8 4 59 40
150835 206374 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Vasquez Ave 2 Sidewalk: Curb side : Yard Tree Private 2   11/06/1996 12:00:00 AM 16 Width 3ft Permit Number 37411 5995150.27092 2099717.15619 37.7451449406021 -122.459474764954 (37.7451449406021, -122.459474764954) 1 8 4 59 40
161760 33216 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Vasquez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37411 5995201.63425474 2099773.01638321 37.7453012719366 -122.459301205113 (37.7453012719366, -122.459301205113) 1 8 4 59 40
80097 53212 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 132 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2006 12:00:00 AM     Permit Number 49185 6004089.5020644 2108196.64307491 37.7689375443291 -122.42916895785 (37.7689375443291, -122.42916895785) 7 9 5 28862 3
58279 44162 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 853 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/03/2001 12:00:00 AM     Permit Number 43636 6002495.49530521 2109506.13705466 37.7724427273552 -122.434776169901 (37.7724427273552, -122.434776169901) 15 5 11 29492 9
87222 32939 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1419 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 26   Permit Number 37259 6013402.96511 2105197.8174 37.7612262595052 -122.39674381647 (37.7612262595052, -122.39674381647) 10 3 8 28856 29
141117 32978 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 570 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 29   Permit Number 37291 6014355.15854 2104463.28183 37.759262335301 -122.393399153246 (37.759262335301, -122.393399153246) 10 3 8 28856 29
136155 38838 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 201 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1998 12:00:00 AM     Permit Number 40667 5994882.83677024 2114872.91229278 37.7867433187024 -122.461498056095 (37.7867433187024, -122.461498056095) 11 6 1 54 11
57864 99459 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 550X Miramar Ave 5 Median : Cutout Tree Private 2   10/28/2014 12:00:00 AM 3 15x280 Permit Number 772553 5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
97346 99476 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 650X Miramar Ave 2 Median : Cutout Tree Private 2   10/28/2014 12:00:00 AM 3 15x280 Permit Number 772553 5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
74962 5084 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2567 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/1994 12:00:00 AM 12 3X3   6002282.63151 2096922.4202 37.7378787673769 -122.434612531259 (37.7378787673769, -122.434612531259) 2 7 5 63 7
44167 141431 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 501 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2005 12:00:00 AM 17 Width 0ft Permit Number 48304 6005404.7905 2110954.8993 37.7765854191309 -122.424815713066 (37.7765854191309, -122.424815713066) 7 9 11 28852 10
79926 52113 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 501 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM   4x4 Permit Number 48304 6005450.41519372 2110958.1148217 37.7765968250138 -122.424658112662 (37.7765968250138, -122.424658112662) 7 9 11 28852 10
108047 57553 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 601 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1976 12:00:00 AM 18 3x3 Permit Number 16416 6004949.77312 2110889.41028 37.7763798917414 -122.426385087108 (37.7763798917414, -122.426385087108) 7 9 11 28852 10
179000 55340 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1570 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1972 12:00:00 AM     Permit Number 769406 5992478.56101588 2104770.1953725 37.7588652973721 -122.469080674313 (37.7588652973721, -122.469080674313) 1 8 4 56 12
29279 86893 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2500 Mason St 12 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2007 12:00:00 AM   3x3 Permit Number 49821 6008765 2122158 37.8075356107649 -122.413984454109 (37.8075356107649, -122.413984454109) 3 1 10 308 23
36447 57112 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM   3x3 Permit Number 14382 6001372.84758587 2109038.85294203 37.7710958809442 -122.438626020879 (37.7710958809442, -122.438626020879) 15 5 11 29492 9
111727 245879 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 100 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 20 Width 0ft Permit Number 14382 6001380 2109122 37.7713245889133 -122.438607239112 (37.7713245889133, -122.438607239112) 15 5 11 29492 9
163450 57140 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 3224 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 22 4x4 Permit Number 14415 6007386 2102705 37.7540448270925 -122.417377329228 (37.7540448270925, -122.417377329228) 2 4 7 28859 19
174457 57060 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1969 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 23   Permit Number 14324 6000588.88106555 2112021.36574223 37.7792404783104 -122.441551843076 (37.7792404783104, -122.441551843076) 15 5 11 29490 41
94218 50448 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 303on BOCANA Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM     Permit Number 47095 6006949.39342482 2097361.11055858 37.7393471377686 -122.418508317181 (37.7393471377686, -122.418508317181) 2 7 7 28859 2
57366 57042 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 201@ Page Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/1974 12:00:00 AM     Permit Number 14305. Tree 1 on Page St 5999842.06289616 2109172.2578569 37.7713749769665 -122.443930626832 (37.7713749769665, -122.443930626832) 15 5 11 29492 9
4157 52083 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 770 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2005 12:00:00 AM     Permit Number 48281 6010080.56543171 2116389.03640526 37.7917692527785 -122.409024297587 (37.7917692527785, -122.409024297587) 5 1 10 28857 21
29446 50634 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2900 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM     Permit Number 47740 6014120.76360854 2090918.26429059 37.7220575083684 -122.393261977074 (37.7220575083684, -122.393261977074) 10 3 8 58 1
102301 50635 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2900 Jennings St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM     Permit Number 47740 6014120.76360854 2090918.26429059 37.7220575083684 -122.393261977074 (37.7220575083684, -122.393261977074) 10 3 8 58 1
118360 50633 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2900 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM 7   Permit Number 47740 6014091.6306 2090874.9645 37.721936997211 -122.393359654849 (37.721936997211, -122.393359654849) 10 3 8 58 1
153999 67625 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1281 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/1992 12:00:00 AM 16   Permit Number 31211 6007384.19721 2118457.03367 37.7972960451262 -122.418500450146 (37.7972960451262, -122.418500450146) 5 1 10 28858 32
31243 212222 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1120 Bosworth St 15 Sidewalk: Property side : Yard Tree DPW 1   10/13/2014 11:02:00 AM 16     6000900.61271 2095850.79313 37.7348577764545 -122.439314043907 (37.7348577764545, -122.439314043907) 2 7 5 63 7
161476 85112 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 4201 22nd St   Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51811 6001198 2102882 37.7541807256906 -122.438789558922 (37.7541807256906, -122.438789558922) 2 4 5 28862 22
171436 65393 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1345 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/1989 12:00:00 AM 22   Permit Number 28235 6008898.78625 2117545.17326 37.7948774497893 -122.41319505442 (37.7948774497893, -122.41319505442) 5 1 10 28857 21
149432 53401 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 730 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/1969 12:00:00 AM 19   Permit Number 6300 5990392.09793 2110392.49513 37.7741818356132 -122.476707321825 (37.7741818356132, -122.476707321825) 11 6 2 55 26
17411 12539 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 210 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/01/2019 12:00:00 AM 3 3x3   5994802.33005 2114932.67469 37.7869027759417 -122.461780923147 (37.7869027759417, -122.461780923147) 11 6 1 54 11
88292 53058 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 235@ FOLSOM Main St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2006 12:00:00 AM     Permit Number 49035 6014758.5845738 2115729.7936401 37.7902200672067 -122.392792095849 (37.7902200672067, -122.392792095849) 6 2 9 28855 6
124291 53057 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 235@ FOLSOM Main St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2006 12:00:00 AM     Permit Number 49035 6014758.5845738 2115729.7936401 37.7902200672067 -122.392792095849 (37.7902200672067, -122.392792095849) 6 2 9 28855 6
185288 64666 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2649 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/28/1988 12:00:00 AM 20   Permit Number 25599 6000212.56039 2118841.15322 37.7979443906796 -122.443343666786 (37.7979443906796, -122.443343666786) 13 9 1 57 17
72747 68295 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 25 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 17   Permit Number 32104 5991131.60478 2114879.69838 37.7865453253482 -122.47447679418 (37.7865453253482, -122.47447679418) 11 6 1 54 33
148936 68216 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 371 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 13 4x4 Permit Number 32003 5991199.85508 2112923.89297 37.7811791800837 -122.474097911754 (37.7811791800837, -122.474097911754) 11 6 2 54 26
29844 53048 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 65@ APPLETON Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2006 12:00:00 AM     Permit Number 49026 6005683.68607987 2097324.15915168 37.7391743410359 -122.422881952522 (37.7391743410359, -122.422881952522) 2 7 7 28859 2
36198 39935 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 601X Rutland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/25/2013 12:00:00 AM 12 3x3 Permit Number 770539 6010138.7177 2087941.04422 37.713660642495 -122.406817269312 (37.713660642495, -122.406817269312) 9 7 8 309 39
146351 71451 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1329 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/1982 12:00:00 AM 14 3x3   6007730.91514483 2101916.84218349 37.7519001247372 -122.416128711613 (37.7519001247372, -122.416128711613) 2 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);