trees
2,694 rows where qSpecies_id = 84 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
13830 | 62681 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 59 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23015 | 6002832.11131033 | 2108737.08241022 | 37.7703501979341 | -122.433556812869 | (37.7703501979341, -122.433556812869) | 15 | 5 | 5 | 29492 | 9 | ||
13963 | 63055 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 3 | Permit Number 29651 | 6010016.44472 | 2110878.7775 | 37.7766358001278 | -122.408857221277 | (37.7766358001278, -122.408857221277) | 8 | 2 | 9 | 28853 | 34 | |
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14300 | 261393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 661 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010427.0314 | 2118523.75657 | 37.7976500791874 | -122.407976127788 | (37.7976500791874, -122.407976127788) | 3 | 1 | 10 | 308 | 4 | |||||
14311 | 71226 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987603.3648 | 2099853.8795 | 37.7450835205099 | -122.485580358953 | (37.7450835205099, -122.485580358953) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
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 | ||
15474 | 67662 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.387193890351 | (37.739521017402, -122.387193890351) | 10 | 3 | 8 | 58 | 1 | ||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
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 | ||
16087 | 71214 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2131 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100799.6289 | 37.7477145531771 | -122.483615701045 | (37.7477145531771, -122.483615701045) | 1 | 8 | 3 | 29491 | 35 | |||
16091 | 261396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010229.17248 | 2118537.87531 | 37.7976777662505 | -122.408661772909 | (37.7976777662505, -122.408661772909) | 3 | 1 | 10 | 308 | 4 | |||||
16092 | 63589 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 718 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1987 12:00:00 AM | Permit Number 24217 | 6007364.81298333 | 2095596.86962092 | 37.734526298545 | -122.416947010477 | (37.734526298545, -122.416947010477) | 2 | 7 | 7 | 28859 | 2 | ||
16201 | 38115 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1342 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 5 | Permit Number 40279 | 5987120.6367 | 2106124.4711 | 37.7622727278914 | -122.487710118761 | (37.7622727278914, -122.487710118761) | 1 | 8 | 3 | 56 | 35 | |
16400 | 60155 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1668 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 19686 | 5990610.46669896 | 2104039.03153173 | 37.7567495994005 | -122.475487960344 | (37.7567495994005, -122.475487960344) | 1 | 8 | 4 | 56 | 12 | ||
16412 | 66973 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 154 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 2 | Permit Number 30316 | 5997837.7074 | 2109963.7906 | 37.773433785241 | -122.450920838457 | (37.773433785241, -122.450920838457) | 15 | 5 | 11 | 29492 | 16 | |
16541 | 73456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009946.95062 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | 8 | 2 | 9 | 28853 | 34 | |||
16616 | 43283 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.38579 | 37.7211473420438 | -122.404247572584 | (37.7211473420438, -122.404247572584) | 10 | 3 | 7 | 309 | 28 | |
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17013 | 70667 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009828.97228 | 2111081.01172 | 37.7771805851524 | -122.409520022524 | (37.7771805851524, -122.409520022524) | 8 | 2 | 9 | 28853 | 34 | |||
17102 | 64930 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2306 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25958 | 5991495.59202308 | 2099725.9184431 | 37.7449581828883 | -122.47211252761 | (37.7449581828883, -122.47211252761) | 1 | 8 | 4 | 29491 | 40 | ||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
17467 | 50541 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
17474 | 71170 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2127 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5987570.8389 | 2100801.7844 | 37.747684319575 | -122.485762384494 | (37.747684319575, -122.485762384494) | 1 | 8 | 3 | 29491 | 35 | |||
17492 | 43352 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4184 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | 2 | 4 | 5 | 28862 | 3 | ||
17531 | 64923 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2326 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25951 | 5991484.88147917 | 2099641.61135178 | 37.744726077495 | -122.472143418263 | (37.744726077495, -122.472143418263) | 1 | 8 | 4 | 29491 | 40 | ||
17648 | 261398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 711 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010187.59569 | 2118491.78545 | 37.7975488860672 | -122.408802387211 | (37.7975488860672, -122.408802387211) | 3 | 1 | 10 | 308 | 4 | |||||
17765 | 47693 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
18252 | 60819 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1607 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 1 | Permit Number 20497 | 5989955.2951 | 2101733.4508 | 37.7503810843418 | -122.477585243781 | (37.7503810843418, -122.477585243781) | 1 | 8 | 3 | 29491 | 35 | |
18344 | 40022 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | 10 | 3 | 8 | 58 | 1 | |
18360 | 32820 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.437176476876 | (37.7526444703409, -122.437176476876) | 2 | 4 | 5 | 28862 | 22 | ||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18397 | 41870 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42249 | 6003816.33085796 | 2108205.89422295 | 37.76894747793 | -122.430114498812 | (37.76894747793, -122.430114498812) | 7 | 9 | 5 | 28862 | 3 | ||
18564 | 73527 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2119 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988189.2832 | 2100871.8604 | 37.747912746917 | -122.483629001347 | (37.747912746917, -122.483629001347) | 1 | 8 | 3 | 29491 | 35 | |||
19155 | 80023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.439687650862 | (37.7762172841329, -122.439687650862) | 15 | 5 | 11 | 29492 | 10 | |||
19171 | 71227 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.485435173986 | (37.7450642803204, -122.485435173986) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
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 | ||
19672 | 39059 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2112 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40773 | 6009544.26649418 | 2104935.53582208 | 37.7602905710121 | -122.410070953081 | (37.7602905710121, -122.410070953081) | 2 | 4 | 7 | 28859 | 19 | ||
19730 | 45264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 679 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44110 | 6007437.04043274 | 2095812.31493778 | 37.7351219268063 | -122.416712553249 | (37.7351219268063, -122.416712553249) | 2 | 7 | 7 | 28859 | 2 | ||
20130 | 68264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 381 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32070 | 6009731.82582651 | 2092664.31257859 | 37.72660698205 | -122.408556624594 | (37.72660698205, -122.408556624594) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
21001 | 37006 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.7548622220933 | -122.411084752447 | (37.7548622220933, -122.411084752447) | 2 | 4 | 7 | 28859 | 19 | ||
21133 | 66926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 125 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30248 | 6007619.27051621 | 2098065.9648769 | 37.7413202009481 | -122.416242081144 | (37.7413202009481, -122.416242081144) | 2 | 7 | 7 | 28859 | 2 | ||
21420 | 47310 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | 10 | 4 | 7 | 28859 | 19 | ||
21463 | 43354 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43105 | 6002331.77416149 | 2104155.95516802 | 37.757743138206 | -122.434959796908 | (37.757743138206, -122.434959796908) | 2 | 4 | 5 | 28862 | 3 | ||
21733 | 37264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
21824 | 67193 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 115 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30643 | 5997981.64121917 | 2106794.49458323 | 37.764739946577 | -122.450194465027 | (37.764739946577, -122.450194465027) | 15 | 5 | 11 | 29492 | 9 | ||
22144 | 39140 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1084 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40818 | 6007412.89120014 | 2100999.62033196 | 37.749363754725 | -122.417163498301 | (37.749363754725, -122.417163498301) | 2 | 4 | 7 | 28859 | 19 | ||
22570 | 50789 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | 11 | 6 | 2 | 55 | 26 | ||
22689 | 65805 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2255 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28773 | 5991004.89132243 | 2100060.8750428 | 37.7458494782853 | -122.473833696019 | (37.7458494782853, -122.473833696019) | 1 | 8 | 4 | 29491 | 40 | ||
22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
22941 | 63176 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1438 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23713 | 5992757.94867175 | 2105669.22551201 | 37.7613499376947 | -122.468179830058 | (37.7613499376947, -122.468179830058) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
23223 | 63267 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2679 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1986 12:00:00 AM | 4 | Permit Number 23823 | 5988937.7362 | 2097128.8354 | 37.7376789174614 | -122.480766928043 | (37.7376789174614, -122.480766928043) | 1 | 8 | 3 | 29491 | 35 | ||
23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
23384 | 31717 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | 15 | 5 | 11 | 29492 | 12 | ||
23393 | 63604 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 900 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | 3 | Permit Number 24240 | 5999553.7216 | 2111620.759 | 37.7780814851393 | -122.445104066804 | (37.7780814851393, -122.445104066804) | 15 | 5 | 11 | 29490 | 16 | |
23564 | 64920 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2320 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1989 12:00:00 AM | Permit Number 25948 | 5991486.61980938 | 2099663.95831255 | 37.7447875370964 | -122.472139036095 | (37.7447875370964, -122.472139036095) | 1 | 8 | 4 | 29491 | 40 | ||
23610 | 135902 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | 5 | 1 | 10 | 308 | 32 | ||||
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 | ||||
23723 | 30734 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34629 | 6005251.19976575 | 2109714.98569866 | 37.7731722414546 | -122.425258776803 | (37.7731722414546, -122.425258776803) | 7 | 9 | 11 | 28852 | 10 | ||
23944 | 45075 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2118 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 5 | Permit Number 43957 | 5987613.4283 | 2100841.7317 | 37.7477964857794 | -122.485618045831 | (37.7477964857794, -122.485618045831) | 1 | 8 | 3 | 29491 | 35 | |
23950 | 113748 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | ||||
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 | ||||
24309 | 50229 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1346 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 1 | Permit Number 46937 | 5987742.4672 | 2106112.8615 | 37.7622771009273 | -122.485558616267 | (37.7622771009273, -122.485558616267) | 1 | 8 | 3 | 56 | 35 | |
24348 | 41338 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | 11 | 6 | 1 | 54 | 31 | ||
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 | ||
24406 | 64516 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 709 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 15 | Permit Number 25397 | 6000497.1651 | 2111433.2992 | 37.7776205716937 | -122.441826907997 | (37.7776205716937, -122.441826907997) | 15 | 5 | 11 | 29490 | 16 | |
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 | ||
24534 | 39765 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 668 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41131 | 6003653.48498832 | 2104383.93868728 | 37.7584440838148 | -122.430405042836 | (37.7584440838148, -122.430405042836) | 2 | 4 | 5 | 28862 | 3 | ||
24548 | 32852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 764 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41115 | 6001471.9166257 | 2102062.60736984 | 37.7519464500754 | -122.437783607007 | (37.7519464500754, -122.437783607007) | 2 | 4 | 5 | 28862 | 22 | ||
24598 | 50059 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46789 | 6002684.4080652 | 2104459.13376981 | 37.7585956098381 | -122.433761913311 | (37.7585956098381, -122.433761913311) | 2 | 4 | 5 | 28862 | 3 | ||
24657 | 41587 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 48 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/2000 12:00:00 AM | Permit Number 42095 | 6000324.11613416 | 2101399.22119137 | 37.7500596186155 | -122.441705249653 | (37.7500596186155, -122.441705249653) | 2 | 4 | 5 | 28862 | 22 | ||
24908 | 50538 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006096 | 2099195 | 37.7443345051857 | -122.421589192303 | (37.7443345051857, -122.421589192303) | 2 | 7 | 7 | 28859 | 2 | |||
24996 | 31758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2646 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35244 | 5989596.3538 | 2097340.4362 | 37.738298177735 | -122.478505265789 | (37.738298177735, -122.478505265789) | 1 | 8 | 3 | 29491 | 35 | |
25255 | 64036 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24793 | 6008741.54974036 | 2096719.77289509 | 37.7376868940515 | -122.412266495463 | (37.7376868940515, -122.412266495463) | 10 | 7 | 7 | 28859 | 2 | ||
25731 | 39751 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 168 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41119 | 6003201.65884895 | 2105082.75168604 | 37.7603372525468 | -122.432017558659 | (37.7603372525468, -122.432017558659) | 2 | 4 | 5 | 28862 | 3 | ||
25901 | 37268 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
25943 | 32174 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.494335637657 | (37.7296472241819, -122.494335637657) | 1 | 8 | 4 | 64 | 35 | ||
26082 | 50547 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
26346 | 35087 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1594 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38628 | 5992484.06042474 | 2104613.58351728 | 37.7584355999938 | -122.469050257237 | (37.7584355999938, -122.469050257237) | 1 | 8 | 4 | 56 | 12 | ||
26690 | 68135 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1640 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | 1 | Permit Number 767463 | 6000632.1236 | 2114329.1398 | 37.7855794974585 | -122.441567904047 | (37.7855794974585, -122.441567904047) | 15 | 6 | 1 | 29490 | 27 | ||
26877 | 39166 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 301x Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003629 | 2104450 | 37.7586240854401 | -122.430494436391 | (37.7586240854401, -122.430494436391) | 2 | 4 | 5 | 28862 | 3 | ||
26887 | 43353 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4184 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | 2 | 4 | 5 | 28862 | 3 | ||
27351 | 31579 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1766 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 10 | Permit Number 35118 | 5989083.5648 | 2103328.988 | 37.7547113797178 | -122.480716506349 | (37.7547113797178, -122.480716506349) | 1 | 8 | 3 | 56 | 35 | |
27625 | 42210 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 937 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.402609526252 | (37.7783260063796, -122.402609526252) | 14 | 2 | 9 | 28856 | 34 | ||
27655 | 64929 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2356 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25957 | 5991487.94157663 | 2099507.48973939 | 37.744357991135 | -122.472123062807 | (37.744357991135, -122.472123062807) | 1 | 8 | 4 | 29491 | 40 | ||
27709 | 35069 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1616 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38623 | 5992799.70916091 | 2104452.91029535 | 37.7580126662258 | -122.467946926218 | (37.7580126662258, -122.467946926218) | 1 | 8 | 4 | 56 | 12 | ||
28066 | 60426 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 419 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31497 | 6003853.1521524 | 2098925.15717718 | 37.7434668562001 | -122.42932524739 | (37.7434668562001, -122.42932524739) | 2 | 7 | 5 | 63 | 22 |
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) );