trees
268 rows where qSpecies_id = 77 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173613 | 238599 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007470.12204 | 2105516.97902 | 37.7617706074473 | -122.417285669309 | (37.7617706074473, -122.417285669309) | 2 | 4 | 7 | 28859 | 19 | |||
174055 | 4162 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3754 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2011 12:00:00 AM | 3 | 3X3 | 6005539.04385 | 2100528.63943 | 37.7479649537167 | -122.423609831438 | (37.7479649537167, -122.423609831438) | 2 | 4 | 5 | 28859 | 19 | ||
174611 | 239023 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 4093 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003318.18687 | 2100656.24769 | 37.7481897266866 | -122.431298564594 | (37.7481897266866, -122.431298564594) | 2 | 4 | 5 | 63 | 22 | |||
180974 | 239003 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2392 Bryant St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6009661.58461 | 2103420.7224 | 37.7561378099155 | -122.409558287803 | (37.7561378099155, -122.409558287803) | 2 | 4 | 7 | 28859 | 19 | |||
183729 | 239026 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1340 Treat Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008687.9198 | 2100899.65847 | 37.7491609288407 | -122.412747338613 | (37.7491609288407, -122.412747338613) | 2 | 4 | 7 | 28859 | 19 | |||
183984 | 239022 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 927 Church St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6004402.67666 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | 2 | 4 | 5 | 28862 | 22 | |||
188738 | 238595 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006430.43554 | 2107395.44142 | 37.7668698749586 | -122.421014915008 | (37.7668698749586, -122.421014915008) | 8 | 4 | 7 | 28853 | 19 | |||
188992 | 44050 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
189062 | 238596 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006429.49363 | 2107423.62513 | 37.7669472076635 | -122.421020174242 | (37.7669472076635, -122.421020174242) | 8 | 4 | 7 | 28853 | 19 | |||
189744 | 10006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 165 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1991 12:00:00 AM | 6 | 3X2 | 6005478.90232 | 2108028.91066 | 37.7685555462362 | -122.42435117769 | (37.7685555462362, -122.42435117769) | 8 | 4 | 5 | 28853 | 19 | ||
24045 | 141370 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001204.6932 | 2110218.0701 | 37.7743241488087 | -122.439292208301 | (37.7743241488087, -122.439292208301) | 15 | 5 | 11 | 29492 | 10 | |||
69930 | 57837 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2009 12:00:00 AM | 3x3 | Permit Number 52005 | 5994540.33028408 | 2106409.85629846 | 37.763486295989 | -122.46206907635 | (37.763486295989, -122.46206907635) | 1 | 5 | 11 | 56 | 12 | ||
143442 | 141371 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001203.2035 | 2110227.5052 | 37.7743499704497 | -122.439298037861 | (37.7743499704497, -122.439298037861) | 15 | 5 | 11 | 29492 | 10 | |||
15965 | 136043 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3425 Jackson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997844.87788 | 2116098.17267 | 37.7902776009696 | -122.451338548042 | (37.7902776009696, -122.451338548042) | 11 | 6 | 1 | 54 | 31 | |||
17624 | 120418 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 779 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988805.2712 | 2110017.74707 | 37.7730607113316 | -122.482168912555 | (37.7730607113316, -122.482168912555) | 11 | 6 | 2 | 55 | 26 | |||
19457 | 96917 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2151X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768104 | 5988894.20073 | 2110528.61903 | 37.7744685962766 | -122.481898727171 | (37.7744685962766, -122.481898727171) | 11 | 6 | 2 | 55 | 26 | |
22137 | 120283 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 139 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988317.15466 | 2115062.63745 | 37.786884157218 | -122.484227400222 | (37.786884157218, -122.484227400222) | 11 | 6 | 1 | 55 | 33 | ||||
22259 | 31877 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 457 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984054.95538 | 2112747.63581 | 37.7802787535999 | -122.498802308795 | (37.7802787535999, -122.498802308795) | 11 | 6 | 2 | 55 | 26 | ||
24291 | 123575 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 118 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994297.68738 | 2114732.87451 | 37.7863251158785 | -122.463512352181 | (37.7863251158785, -122.463512352181) | 11 | 6 | 1 | 54 | 11 | |||
25738 | 97483 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989920.47182 | 2114841.78 | 37.7863709666179 | -122.478664195663 | (37.7863709666179, -122.478664195663) | 11 | 6 | 1 | 55 | 33 | ||
36420 | 124156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995846.07339 | 2112226.83412 | 37.7795332890719 | -122.457973944713 | (37.7795332890719, -122.457973944713) | 11 | 6 | 2 | 54 | 16 | |||
39652 | 124172 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 81 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995886.79128 | 2112251.90704 | 37.7796044719959 | -122.457834899878 | (37.7796044719959, -122.457834899878) | 11 | 6 | 2 | 54 | 16 | |||
43016 | 51309 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 518 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 7 | Permit Number 47675 | 5989718.85945 | 2111803.87155 | 37.7780180115133 | -122.479139410746 | (37.7780180115133, -122.479139410746) | 11 | 6 | 2 | 55 | 26 | ||
43837 | 124379 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 37 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5996169.18438 | 2114263.97819 | 37.785145303794 | -122.457003563892 | (37.785145303794, -122.457003563892) | 11 | 6 | 1 | 54 | 31 | |||
51211 | 122964 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 5993049.94359 | 2114912.63546 | 37.7867467201865 | -122.467842267803 | (37.7867467201865, -122.467842267803) | 11 | 6 | 1 | 54 | 11 | |||
56484 | 122199 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 171 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991475.81854 | 2114309.23252 | 37.7849989216744 | -122.473244290329 | (37.7849989216744, -122.473244290329) | 11 | 6 | 2 | 54 | 26 | |||
59098 | 98408 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 24 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | 11 | 6 | 1 | 55 | 33 | ||
59809 | 45688 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 614 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2001 12:00:00 AM | 6 | Permit Number 44373 | 5988813.86357 | 2111116.63856 | 37.7760784619734 | -122.482219714975 | (37.7760784619734, -122.482219714975) | 11 | 6 | 2 | 55 | 26 | ||
60025 | 124684 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3899 Jackson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5995566.4285 | 2115772.64492 | 37.7892530636592 | -122.459198183151 | (37.7892530636592, -122.459198183151) | 11 | 6 | 1 | 54 | 31 | |||
63795 | 124683 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3899 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5995553.12452 | 2115771.60073 | 37.7892494317403 | -122.459244137371 | (37.7892494317403, -122.459244137371) | 11 | 6 | 1 | 54 | 31 | |||
65368 | 50856 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 743 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47371 | 5985677.37672 | 2110827.17931 | 37.7751007543065 | -122.493048175392 | (37.7751007543065, -122.493048175392) | 11 | 6 | 2 | 55 | 26 | ||
70516 | 123029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991968.39214 | 2110452.13533 | 37.7744368966539 | -122.471259036935 | (37.7744368966539, -122.471259036935) | 11 | 6 | 2 | 54 | 11 | |||
79691 | 124155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995858.43793 | 2112228.39454 | 37.7795382839593 | -122.457931283713 | (37.7795382839593, -122.457931283713) | 11 | 6 | 2 | 54 | 16 | |||
80211 | 122200 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 171 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991476.58631 | 2114290.78647 | 37.784948318391 | -122.473240288339 | (37.784948318391, -122.473240288339) | 11 | 6 | 2 | 54 | 26 | |||
83042 | 123363 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994763.50549 | 2110414.96281 | 37.7744961151162 | -122.461587583233 | (37.7744961151162, -122.461587583233) | 11 | 6 | 2 | 54 | 11 | |||
83158 | 57747 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3425 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1977 12:00:00 AM | 8 | Permit Number 16667 | 5997831.65027 | 2116097.2527 | 37.7902743175622 | -122.45138424801 | (37.7902743175622, -122.45138424801) | 11 | 6 | 1 | 54 | 31 | ||
84948 | 107672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 184 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773528 | 5997643.33289 | 2112648.90363 | 37.7807952777935 | -122.45178694364 | (37.7807952777935, -122.45178694364) | 15 | 6 | 2 | 54 | 16 | |
90085 | 136045 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5997979.66837 | 2116375.74786 | 37.7910474656235 | -122.45089220822 | (37.7910474656235, -122.45089220822) | 13 | 6 | 1 | 54 | 31 | |||
97447 | 84400 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 611-613 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51577 | 5993447.66428 | 2111301.75717 | 37.7768551863663 | -122.466203752377 | (37.7768551863663, -122.466203752377) | 11 | 6 | 2 | 54 | 11 | |
102636 | 124378 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 37 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5996168.03045 | 2114275.5227 | 37.7851769356666 | -122.457008391438 | (37.7851769356666, -122.457008391438) | 11 | 6 | 1 | 54 | 31 | |||
102967 | 39863 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 55 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 14 | Permit Number 41168 | 5997961.8347 | 2116210.86321 | 37.7905937153799 | -122.450942017156 | (37.7905937153799, -122.450942017156) | 11 | 6 | 1 | 54 | 31 | |
103313 | 122967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993050.69162 | 2114890.11462 | 37.7866849273422 | -122.467838041215 | (37.7866849273422, -122.467838041215) | 11 | 6 | 1 | 54 | 11 | |||
106048 | 61899 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 335 Maple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1985 12:00:00 AM | 5 | Permit Number 21942 | 5996649.71832 | 2115128.18725 | 37.7875457744774 | -122.455403556547 | (37.7875457744774, -122.455403556547) | 11 | 6 | 1 | 54 | 31 | ||
108435 | 98407 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 24 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989919.44776 | 2114906.64899 | 37.7865490191546 | -122.478672484402 | (37.7865490191546, -122.478672484402) | 11 | 6 | 1 | 55 | 33 | ||
116368 | 118026 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Shore View Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5984344.44515 | 2112788.18454 | 37.780407063583 | -122.49780384034 | (37.780407063583, -122.49780384034) | 11 | 6 | 2 | 55 | 26 | |||
118474 | 136041 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3399 Jackson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5998034.28644 | 2116116.08829 | 37.7903376361102 | -122.450684503481 | (37.7903376361102, -122.450684503481) | 13 | 6 | 1 | 54 | 31 | |||
118812 | 90480 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 139 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988320.04401 | 2115047.37952 | 37.7868424315213 | -122.484216284461 | (37.7868424315213, -122.484216284461) | 11 | 6 | 1 | 55 | 33 | ||
119804 | 136040 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 55 Laurel St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5997963.88145 | 2116192.9912 | 37.7905447607719 | -122.450933646298 | (37.7905447607719, -122.450933646298) | 11 | 6 | 1 | 54 | 31 | |||
120741 | 31876 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 457 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984053.55944 | 2112762.76101 | 37.7803202011246 | -122.498808255642 | (37.7803202011246, -122.498808255642) | 11 | 6 | 2 | 55 | 26 | ||
120911 | 118028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Shore View Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984316.15967 | 2112798.24876 | 37.780433038793 | -122.49790243493 | (37.780433038793, -122.49790243493) | 11 | 6 | 2 | 55 | 26 | |||
121681 | 120334 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 16 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5988822.29899 | 2115016.65173 | 37.7867872922875 | -122.482476367259 | (37.7867872922875, -122.482476367259) | 11 | 6 | 1 | 55 | 33 | |||
122239 | 97484 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989917.9579 | 2114856.79796 | 37.7864120557494 | -122.4786739918 | (37.7864120557494, -122.4786739918) | 11 | 6 | 1 | 55 | 33 | ||
135030 | 84901 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3710 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2007 12:00:00 AM | 5 | Permit No. 49300 | 5996951.85595 | 2115692.33884 | 37.7891121155896 | -122.454398994017 | (37.7891121155896, -122.454398994017) | 11 | 6 | 1 | 54 | 31 | ||
135365 | 124512 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2656 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996425.61433 | 2110792.8133 | 37.7756291250409 | -122.455865383128 | (37.7756291250409, -122.455865383128) | 11 | 6 | 2 | 54 | 16 | |||
136645 | 94793 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 5 | Permit Number 53892 | 5997982.2072 | 2116362.36591 | 37.7910108676939 | -122.450882458672 | (37.7910108676939, -122.450882458672) | 13 | 6 | 1 | 54 | 31 | ||
140943 | 38818 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 221 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2005 12:00:00 AM | 4 | Permit Number 47857 | 5994895.35063 | 2113953.79381 | 37.7842203879728 | -122.461388106023 | (37.7842203879728, -122.461388106023) | 11 | 6 | 2 | 54 | 11 | |
141006 | 120282 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 129 24th Ave | 12 | Front Yard : Yard | Tree | Private 2 | 10 | 5988304.19862 | 2115114.50046 | 37.7870258038912 | -122.484276029631 | (37.7870258038912, -122.484276029631) | 11 | 6 | 1 | 55 | 33 | ||||
146029 | 98235 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 42 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 01/09/2012 12:00:00 AM | 3 | Permit Number 768620 | 5989920.54745 | 2114876.26257 | 37.7864656504451 | -122.47866645673 | (37.7864656504451, -122.47866645673) | 11 | 6 | 1 | 55 | 33 | ||
147580 | 136044 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5997978.05362 | 2116388.40928 | 37.7910821380693 | -122.450898708531 | (37.7910821380693, -122.450898708531) | 13 | 6 | 1 | 54 | 31 | |||
152029 | 123081 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 756 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992285.07246 | 2110293.11916 | 37.7740185941965 | -122.470152007973 | (37.7740185941965, -122.470152007973) | 11 | 6 | 2 | 54 | 11 | |||
158164 | 120284 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 139 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5988322.78334 | 2115034.52421 | 37.7868072939982 | -122.484205864007 | (37.7868072939982, -122.484205864007) | 11 | 6 | 1 | 55 | 33 | ||||
158227 | 136042 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3399 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998049.07867 | 2116118.00061 | 37.7903437335326 | -122.450633461567 | (37.7903437335326, -122.450633461567) | 13 | 6 | 1 | 54 | 31 | |||
164743 | 119967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 536 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987220.23089 | 2112258.31491 | 37.7791203589842 | -122.487816341376 | (37.7791203589842, -122.487816341376) | 11 | 6 | 2 | 55 | 26 | |||
174624 | 122059 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5990228.03289 | 2114906.05857 | 37.7865653101026 | -122.47760482414 | (37.7865653101026, -122.47760482414) | 11 | 6 | 1 | 55 | 33 | |||
182789 | 123365 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994764.07466 | 2110395.82025 | 37.7744435874791 | -122.461584226231 | (37.7744435874791, -122.461584226231) | 11 | 6 | 2 | 54 | 11 | |||
183292 | 123364 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994764.09915 | 2110406.2546 | 37.7744722388497 | -122.461584898177 | (37.7744722388497, -122.461584898177) | 11 | 6 | 2 | 54 | 11 | |||
183821 | 63200 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 450 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2015 12:00:00 AM | 3 | Permit Number 775741 | 5984716.80521 | 2112828.61382 | 37.7805398924486 | -122.496518676344 | (37.7805398924486, -122.496518676344) | 11 | 6 | 2 | 55 | 26 | |
187703 | 99226 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 112 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768858 | 5992130.04894 | 2114624.94934 | 37.7859036525669 | -122.47100389023 | (37.7859036525669, -122.47100389023) | 11 | 6 | 2 | 54 | 11 | |
192755 | 52450 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 672 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48563 | 5992577.48944 | 2110887.44098 | 37.7756673423473 | -122.469183761515 | (37.7756673423473, -122.469183761515) | 11 | 6 | 2 | 54 | 11 |
10454 | 106790 | Undocumented 4 | Prunus x yedoensis :: Yoshino Cherry 77 | 174 FAIRMOUNT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6004503.2 | 2097272.2 | 37.7389649933023 | -122.426959842808 | (37.7389649933023, -122.426959842808) | 2 | 7 | 5 | 63 | 7 | |||
33456 | 239029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003326.30087 | 2097748.91757 | 37.7402073325128 | -122.431063031234 | (37.7402073325128, -122.431063031234) | 2 | 7 | 5 | 63 | 7 | |||
35888 | 239027 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6003403.2403 | 2097795.09814 | 37.740338493218 | -122.430800300593 | (37.740338493218, -122.430800300593) | 2 | 7 | 5 | 63 | 7 | ||||
43615 | 114880 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1687 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 3x3 | 6009362.4 | 2099644 | 37.7457510020701 | -122.4103263211 | (37.7457510020701, -122.4103263211) | 2 | 7 | 7 | 28859 | 2 | |||
61657 | 246464 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 212 Duncan St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005064.93111 | 2099921.35386 | 37.7462707137301 | -122.425206088515 | (37.7462707137301, -122.425206088515) | 2 | 7 | 5 | 63 | 22 | |||
64342 | 35854 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
67181 | 239028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003397.86036 | 2097787.1303 | 37.7403163105472 | -122.430818333806 | (37.7403163105472, -122.430818333806) | 2 | 7 | 5 | 63 | 7 | ||||
75784 | 82345 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 254 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774176 | 6003940.30685 | 2088972.31262 | 37.7161435078943 | -122.428314680584 | (37.7161435078943, -122.428314680584) | 9 | 7 | 6 | 28861 | 5 | |
96537 | 239010 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010651.97236 | 2100432.84922 | 37.747989214748 | -122.405922704693 | (37.747989214748, -122.405922704693) | 2 | 7 | 7 | 28859 | 2 | |||
97109 | 239025 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 323 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006919.22148 | 2096314.31292 | 37.7364711647048 | -122.41853842942 | (37.7364711647048, -122.41853842942) | 2 | 7 | 7 | 28859 | 2 | |||
107927 | 239012 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 417 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009194 | 2100253 | 37.7474137401608 | -122.410951632147 | (37.7474137401608, -122.410951632147) | 2 | 7 | 7 | 28859 | 2 | |||
113704 | 239024 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 389 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004038.85397 | 2100110.5602 | 37.7467322107326 | -122.428767625048 | (37.7467322107326, -122.428767625048) | 2 | 7 | 5 | 63 | 22 | |||
124046 | 44512 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 10 | 4x4 | Permit Number 43806 | 6004687.03371464 | 2097226.29740092 | 37.7388493482812 | -122.426320962915 | (37.7388493482812, -122.426320962915) | 2 | 7 | 5 | 63 | 7 |
127095 | 32222 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 623 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 15 | Permit Number 35543 | 6009718.6984 | 2100387.54672 | 37.7478125842885 | -122.40914674543 | (37.7478125842885, -122.40914674543) | 2 | 7 | 7 | 28859 | 2 | |
127131 | 239002 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Mirabel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007267.34733 | 2099764.86466 | 37.7459652050335 | -122.417579291677 | (37.7459652050335, -122.417579291677) | 2 | 7 | 7 | 28859 | 2 | ||||
128052 | 238581 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 18 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006358.36528 | 2099816.491 | 37.7460557694506 | -122.420726098652 | (37.7460557694506, -122.420726098652) | 2 | 7 | 5 | 28859 | 2 | |||
130605 | 35852 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
131277 | 179170 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 179 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001259.83204 | 2087347.33172 | 37.7115296332658 | -122.437463366848 | (37.7115296332658, -122.437463366848) | 9 | 7 | 6 | 28861 | 5 | |||
138650 | 239009 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010637.01006 | 2100427.5195 | 37.7479737436878 | -122.405974068569 | (37.7479737436878, -122.405974068569) | 2 | 7 | 7 | 28859 | 2 | |||
140665 | 246630 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3320 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6009028.43524 | 2099278.75412 | 37.7447293908617 | -122.411455327621 | (37.7447293908617, -122.411455327621) | 2 | 7 | 7 | 28859 | 2 | ||||
169272 | 35855 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
187043 | 239011 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010666.51854 | 2100440.55381 | 37.7480111833878 | -122.405872946996 | (37.7480111833878, -122.405872946996) | 2 | 7 | 7 | 28859 | 2 | |||
192435 | 5697 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1551 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2007 12:00:00 AM | 3 | 6X6 | 6005311.69042 | 2099268.6032 | 37.7444923466503 | -122.424306405838 | (37.7444923466503, -122.424306405838) | 2 | 7 | 5 | 28859 | 22 | ||
4262 | 213721 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 2 | Median : Yard | Tree | DPW 1 | 1 | 5993647.57824 | 2097426.08398 | 37.7387677148629 | -122.464504452814 | (37.7387677148629, -122.464504452814) | 1 | 8 | 4 | 59 | 40 | ||||
63461 | 213724 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 8 | Median : Yard | Tree | DPW 1 | 8 | 5993565.41473 | 2097500.59466 | 37.7389675657933 | -122.46479394281 | (37.7389675657933, -122.46479394281) | 1 | 8 | 4 | 59 | 40 | ||||
88338 | 213729 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 150 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993589.16073 | 2101660.48807 | 37.7503909504883 | -122.465013883688 | (37.7503909504883, -122.465013883688) | 1 | 8 | 4 | 29491 | 40 | |||
99174 | 213728 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x San Lorenzo Way | 13 | Median : Yard | Tree | DPW 1 | 2 | 5993678.60033 | 2097499.69771 | 37.7389716280322 | -122.464402537152 | (37.7389716280322, -122.464402537152) | 1 | 8 | 4 | 59 | 40 | ||||
105268 | 213731 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 72 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994987.04868 | 2099905.16215 | 37.7456517715262 | -122.460052772716 | (37.7456517715262, -122.460052772716) | 1 | 8 | 4 | 59 | 40 | |||
115364 | 105908 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1237 NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772682 | 5990134.3 | 2103036.1 | 37.7539682014274 | -122.477061416534 | (37.7539682014274, -122.477061416534) | 1 | 8 | 3 | 56 | 35 | |
123293 | 213726 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x San Lorenzo Way | 11 | Median : Yard | Tree | DPW 1 | 7 | 5993681.50314 | 2097480.63072 | 37.7389194421692 | -122.464391116668 | (37.7389194421692, -122.464391116668) | 1 | 8 | 4 | 59 | 40 | ||||
128274 | 213723 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 6 | Median : Yard | Tree | DPW 1 | 3 | 5993589.39355 | 2097453.93432 | 37.7388408306314 | -122.46470764836 | (37.7388408306314, -122.46470764836) | 1 | 8 | 4 | 59 | 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) );