trees
2,694 rows where qSpecies_id = 84 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
3508 | 95024 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | 9 | 7 | 8 | 309 | 39 | |||
4251 | 42457 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.7329900693173 | -122.450477464919 | (37.7329900693173, -122.450477464919) | 9 | 7 | 4 | 59 | 40 |
4260 | 178882 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | 9 | 7 | 6 | 28861 | 5 | |||
4426 | 42126 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42422 | 5999645.50083885 | 2093804.90397788 | 37.7291687386678 | -122.44350647351 | (37.7291687386678, -122.44350647351) | 9 | 7 | 4 | 63 | 40 | ||
4627 | 36424 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | 9 | 7 | 4 | 28861 | 40 | |||
4762 | 84963 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51615 | 5999235.1 | 2094032 | 37.7297688774613 | -122.444941576876 | (37.7297688774613, -122.444941576876) | 9 | 7 | 4 | 28861 | 40 | ||
5000 | 42437 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.453230305718 | (37.7285785035344, -122.453230305718) | 9 | 7 | 4 | 28861 | 40 | ||
5081 | 69491 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 57 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 3 | Permit Number 33613 | 6002842.65111 | 2094614.47792 | 37.7315734613241 | -122.43251146945 | (37.7315734613241, -122.43251146945) | 9 | 7 | 5 | 28861 | 25 | |
5446 | 36410 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.458350621736 | (37.7273922712597, -122.458350621736) | 9 | 7 | 4 | 28861 | 40 | ||
5687 | 66315 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29430 | 6001458.61740114 | 2094962.10093841 | 37.7324493716412 | -122.43732121741 | (37.7324493716412, -122.43732121741) | 9 | 7 | 5 | 63 | 40 | ||
5974 | 62490 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | 9 | 7 | 6 | 28861 | 25 | ||
6548 | 178944 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 202 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004727.85531 | 2094036.32936 | 37.7300927194874 | -122.425952806385 | (37.7300927194874, -122.425952806385) | 9 | 7 | 6 | 28861 | 5 | |||
7234 | 43732 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | 9 | 8 | 6 | 28861 | 24 | ||
7567 | 78659 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998369.99191 | 2089313.52564 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | 9 | 7 | 6 | 28861 | 25 | |||
7633 | 65608 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.7295075388181 | -122.425251826139 | (37.7295075388181, -122.425251826139) | 9 | 7 | 6 | 28861 | 5 | ||
8785 | 178959 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007585.1415 | 2091886.23741 | 37.7243500958617 | -122.415922582174 | (37.7243500958617, -122.415922582174) | 9 | 3 | 7 | 309 | 28 | |||
8869 | 45450 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
9212 | 259382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
11410 | 25472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.7142087634879 | -122.464599140586 | (37.7142087634879, -122.464599140586) | 9 | 8 | 6 | 64 | 24 | ||
11497 | 26788 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.405187615188 | (37.711819305554, -122.405187615188) | 9 | 7 | 8 | 309 | 39 | ||
11895 | 36362 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.457220086151 | (37.7283834402433, -122.457220086151) | 9 | 7 | 4 | 28861 | 40 | ||
12839 | 43336 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.19433 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | 9 | 7 | 6 | 28861 | 5 | |
12911 | 25471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | 9 | 8 | 6 | 64 | 24 | ||
13647 | 43721 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.7181608417184 | -122.457759993154 | (37.7181608417184, -122.457759993154) | 9 | 8 | 6 | 28861 | 24 | ||
13767 | 38951 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | 9 | 8 | 4 | 59 | 40 | ||
13781 | 40472 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
14515 | 214414 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 659 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5997734.91386 | 2094962.25156 | 37.7322373939404 | -122.450194889199 | (37.7322373939404, -122.450194889199) | 9 | 7 | 4 | 59 | 40 | ||||
14580 | 33345 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | 9 | 7 | 5 | 63 | 40 | ||
14620 | 65548 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 335 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28447 | 5995087.51239517 | 2097484.61184976 | 37.7390113196181 | -122.459530109112 | (37.7390113196181, -122.459530109112) | 9 | 7 | 4 | 59 | 40 | ||
15294 | 178876 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 1 | Width 2ft | Permit Number 48053 | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | 9 | 7 | 6 | 28861 | 5 | |
15708 | 36338 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.457336855787 | (37.7264778306363, -122.457336855787) | 9 | 7 | 4 | 28861 | 40 | ||
17072 | 259381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
18214 | 46802 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.7635246 | 2095973.46470501 | 37.7348144532504 | -122.462282494227 | (37.7348144532504, -122.462282494227) | 9 | 8 | 4 | 59 | 40 | ||
19203 | 65549 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28448 | 5995107.08134396 | 2097533.05659271 | 37.7391454621224 | -122.45946595669 | (37.7391454621224, -122.45946595669) | 9 | 7 | 4 | 59 | 40 | ||
19506 | 42439 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 550 Judson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.453230305718 | (37.7285785035344, -122.453230305718) | 9 | 7 | 4 | 28861 | 40 | ||
19543 | 70633 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6003062.45597 | 2090620.05211 | 37.720618125211 | -122.431466512079 | (37.720618125211, -122.431466512079) | 9 | 7 | 6 | 28861 | 5 | ||
19566 | 178881 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | 9 | 7 | 6 | 28861 | 5 | |||
19600 | 70126 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.90902 | 37.7205675887031 | -122.431509104887 | (37.7205675887031, -122.431509104887) | 9 | 7 | 6 | 28861 | 5 | |
20153 | 36371 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 149 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39320 | 5995639.30235658 | 2093700.91704077 | 37.7286539269724 | -122.45734862822 | (37.7286539269724, -122.45734862822) | 9 | 7 | 4 | 28861 | 40 | ||
20169 | 36359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 131 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39315 | 5995616.87742593 | 2093562.88394601 | 37.728273633306 | -122.457416169824 | (37.728273633306, -122.457416169824) | 9 | 7 | 4 | 28861 | 40 | ||
20299 | 43280 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 731 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43050 | 6009363.88058907 | 2092426.70066476 | 37.7259339362736 | -122.409811838204 | (37.7259339362736, -122.409811838204) | 9 | 3 | 7 | 309 | 28 | ||
22237 | 214456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001455.73616 | 2094912.80793 | 37.7323138605989 | -122.437327650168 | (37.7323138605989, -122.437327650168) | 9 | 7 | 4 | 63 | 40 | |||
22982 | 34096 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.6434081 | 2093328.34737639 | 37.7276180343437 | -122.458098329779 | (37.7276180343437, -122.458098329779) | 9 | 7 | 4 | 28861 | 40 | |||
23329 | 178962 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 217 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007226.63785 | 2092632.02114 | 37.7263776956646 | -122.417214704709 | (37.7263776956646, -122.417214704709) | 9 | 3 | 7 | 309 | 28 | |||
23692 | 214476 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 270 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998285.21453 | 2093571.32939 | 37.7284497264529 | -122.448192264458 | (37.7284497264529, -122.448192264458) | 9 | 7 | 4 | 28861 | 40 | ||||
24056 | 62182 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 15 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1985 12:00:00 AM | Permit Number 22299 | 6000249.38294622 | 2091710.97820224 | 37.7234537213114 | -122.44126862873 | (37.7234537213114, -122.44126862873) | 9 | 7 | 6 | 28861 | 25 | ||
24064 | 178910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | 9 | 8 | 6 | 28861 | 25 | ||||
24390 | 66242 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 283 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29340 | 5997754.61642905 | 2090213.33999682 | 37.7191991265322 | -122.449784665644 | (37.7191991265322, -122.449784665644) | 9 | 8 | 6 | 28861 | 24 | ||
24462 | 38952 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | 9 | 8 | 4 | 59 | 40 | ||
25564 | 178956 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1393 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007451.98675 | 2091842.90418 | 37.724223625092 | -122.416379812775 | (37.724223625092, -122.416379812775) | 9 | 3 | 7 | 309 | 28 | |||
26182 | 26785 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.404311642231 | (37.7114882765061, -122.404311642231) | 9 | 7 | 8 | 309 | 39 | ||
27605 | 178906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009976.78188 | 2089389.92306 | 37.7176299046612 | -122.407479066904 | (37.7176299046612, -122.407479066904) | 9 | 7 | 8 | 309 | 39 | |||
27765 | 37839 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.01474 | 2090473.5929 | 37.7202497170415 | -122.42939741397 | (37.7202497170415, -122.42939741397) | 9 | 7 | 6 | 28861 | 5 |
28270 | 26791 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.7120981579726 | -122.405883520018 | (37.7120981579726, -122.405883520018) | 9 | 7 | 8 | 309 | 39 | ||
29335 | 91571 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 511 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52143 | 6010245.73036 | 2088527.63553 | 37.7152772898907 | -122.40648870199 | (37.7152772898907, -122.40648870199) | 9 | 7 | 8 | 309 | 39 | |
29496 | 36373 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 150 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39321 | 5995693.36220348 | 2093704.91985042 | 37.7286680225798 | -122.457162030727 | (37.7286680225798, -122.457162030727) | 9 | 7 | 4 | 28861 | 40 | ||
29518 | 88278 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
30288 | 42394 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 531 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42554 | 5997433.46765796 | 2095082.84468997 | 37.7325512585551 | -122.451245745641 | (37.7325512585551, -122.451245745641) | 9 | 7 | 4 | 59 | 40 | ||
30723 | 120885 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6009830 | 2087548 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | 9 | 7 | 8 | 309 | 39 | ||||
30961 | 84824 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.452485832408 | (37.7198962296133, -122.452485832408) | 9 | 8 | 6 | 28861 | 24 | |||
32036 | 36316 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 155 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39293 | 5996114.57806126 | 2093980.3628315 | 37.7294485047064 | -122.455725773063 | (37.7294485047064, -122.455725773063) | 9 | 7 | 4 | 28861 | 40 | ||
32055 | 178918 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993792.01538 | 2086765.64003 | 37.7095050489005 | -122.46323172778 | (37.7095050489005, -122.46323172778) | 9 | 8 | 6 | 28861 | 25 | ||||
32809 | 237984 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 124 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004243.12433 | 2095170.90257 | 37.7331805965962 | -122.427709389171 | (37.7331805965962, -122.427709389171) | 9 | 7 | 5 | 28861 | 25 | |||
33286 | 43735 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | 9 | 8 | 6 | 28861 | 24 | ||
34261 | 66261 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 664 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29364 | 5999010.17243929 | 2096448.16198822 | 37.736390248788 | -122.445892878707 | (37.736390248788, -122.445892878707) | 9 | 7 | 4 | 59 | 40 | ||
35343 | 36360 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 131 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39315 | 5995616.87742593 | 2093562.88394601 | 37.728273633306 | -122.457416169824 | (37.728273633306, -122.457416169824) | 9 | 7 | 4 | 28861 | 40 | ||
35498 | 36349 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | 9 | 7 | 4 | 28861 | 40 | ||
35572 | 43334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 358 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43091 | 6004071.7464537 | 2091218.44428208 | 37.7223183305946 | -122.428020331334 | (37.7223183305946, -122.428020331334) | 9 | 7 | 6 | 28861 | 5 | ||
36059 | 38916 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 151 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40727 | 5991915.78904323 | 2089537.41535132 | 37.7170074074891 | -122.469917900123 | (37.7170074074891, -122.469917900123) | 9 | 8 | 6 | 64 | 24 | ||
36061 | 26792 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 128 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2002 12:00:00 AM | 3 | 3x3 | 6010340.5785 | 2087395.6982 | 37.7121745258223 | -122.406081165572 | (37.7121745258223, -122.406081165572) | 9 | 7 | 8 | 309 | 39 | ||
36216 | 36431 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 435 Montecito Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | 9 | 7 | 4 | 28861 | 40 | ||
36657 | 214421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 447 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5993467.53824 | 2088847.90842 | 37.7152037640188 | -122.464504257681 | (37.7152037640188, -122.464504257681) | 9 | 8 | 6 | 64 | 24 | |||
36933 | 18597 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | 9 | 8 | 6 | 64 | 24 | ||
37304 | 45397 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 191 Corona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2001 12:00:00 AM | Permit Number 44207 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | |||
37447 | 36344 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 86 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | 9 | 7 | 4 | 28861 | 40 | ||
37714 | 120886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.7126603570018 | -122.407979633406 | (37.7126603570018, -122.407979633406) | 9 | 7 | 8 | 309 | 39 | |||
37726 | 80612 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 750 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51159 | 5998159.10810907 | 2095953.56501818 | 37.7349835709176 | -122.448799737577 | (37.7349835709176, -122.448799737577) | 9 | 7 | 4 | 59 | 40 | ||
38192 | 95028 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | 9 | 7 | 8 | 309 | 39 | |||
38370 | 62480 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 71 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22651 | 6000586.99465063 | 2092917.02407193 | 37.7267844734873 | -122.440188014338 | (37.7267844734873, -122.440188014338) | 9 | 7 | 6 | 28861 | 25 | ||
39802 | 36343 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 86 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | 9 | 7 | 4 | 28861 | 40 | ||
39804 | 36386 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 701 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965564 | 37.7258484957944 | -122.459920281258 | (37.7258484957944, -122.459920281258) | 9 | 7 | 4 | 28861 | 40 | ||
39863 | 36365 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 142 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39318 | 5995680.445182 | 2093645.04501164 | 37.7285028788434 | -122.457202355833 | (37.7285028788434, -122.457202355833) | 9 | 7 | 4 | 28861 | 40 | ||
40414 | 214471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000292.89042 | 2094938.17921 | 37.7323173490585 | -122.441349683656 | (37.7323173490585, -122.441349683656) | 9 | 7 | 4 | 63 | 40 | |||
41852 | 49121 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46253 | 5995746.37464462 | 2094397.74678667 | 37.7305734027094 | -122.457028858359 | (37.7305734027094, -122.457028858359) | 9 | 7 | 4 | 28861 | 40 | ||
41956 | 178886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.429146369125 | (37.7205786116989, -122.429146369125) | 9 | 7 | 6 | 28861 | 5 | |||
42126 | 42571 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42653 | 5992105.55983914 | 2095227.71522931 | 37.7326425353626 | -122.469675980927 | (37.7326425353626, -122.469675980927) | 9 | 8 | 4 | 59 | 40 | |||
42192 | 88277 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
42540 | 46639 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 670 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.464887145032 | (37.7226788173129, -122.464887145032) | 9 | 8 | 4 | 59 | 40 | |||
42679 | 68828 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 331 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 7.5x10.5 | Permit Number 774473 | 5998736.29521219 | 2093886.16964896 | 37.7293399809502 | -122.446655505447 | (37.7293399809502, -122.446655505447) | 9 | 7 | 4 | 28861 | 40 | ||
43412 | 49133 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | 9 | 7 | 4 | 28861 | 40 | |||
43431 | 31127 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 121 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5.5x4 | Permit Number 34844 | 5998074.93385537 | 2093867.82881443 | 37.7292518204306 | -122.448940561252 | (37.7292518204306, -122.448940561252) | 9 | 7 | 4 | 28861 | 40 | |
43496 | 52333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.404400279817 | (37.7115198939825, -122.404400279817) | 9 | 7 | 8 | 309 | 39 | ||
43805 | 62483 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 80 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22654 | 6000518.46428182 | 2092901.19185659 | 37.7267370999864 | -122.440423786349 | (37.7267370999864, -122.440423786349) | 9 | 7 | 6 | 28861 | 25 | ||
44234 | 50018 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46752 | 5992447.36096557 | 2090326.79664317 | 37.7192055701762 | -122.468137918171 | (37.7192055701762, -122.468137918171) | 9 | 8 | 6 | 64 | 24 | ||
44352 | 178912 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5993780.74611 | 2086770.03775 | 37.7095164747811 | -122.463270994886 | (37.7095164747811, -122.463270994886) | 9 | 8 | 6 | 28861 | 25 | ||||
44363 | 178888 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003758.58722 | 2090633.91893 | 37.7206956305865 | -122.429061193425 | (37.7206956305865, -122.429061193425) | 9 | 7 | 6 | 28861 | 5 | |||
44551 | 36446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1266 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39349 | 5995876.3540718 | 2092492.32516722 | 37.7253490358477 | -122.456441772407 | (37.7253490358477, -122.456441772407) | 9 | 7 | 4 | 28861 | 40 | ||
45797 | 178925 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001853.21575 | 2094253.68382 | 37.73052664507 | -122.435906329212 | (37.73052664507, -122.435906329212) | 9 | 7 | 6 | 28861 | 25 | |||
45950 | 36374 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 154 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39322 | 5995692.70135689 | 2093744.11562313 | 37.72877560678 | -122.457167149483 | (37.72877560678, -122.457167149483) | 9 | 7 | 4 | 28861 | 40 |
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) );