trees
835 rows where qSpecies_id = 122 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183393 | 113369 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x9 | 6009304 | 2096928 | 37.7382901856605 | -122.410336525414 | (37.7382901856605, -122.410336525414) | 10 | 7 | 7 | 28859 | 2 | |||
| 8738 | 44456 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.7103071803111 | -122.432895389109 | (37.7103071803111, -122.432895389109) | 9 | 7 | 6 | 28861 | 5 | |
| 120603 | 95590 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767380 | 6002599.7 | 2086870.1 | 37.7102953437444 | -122.432798364191 | (37.7102953437444, -122.432798364191) | 9 | 7 | 6 | 28861 | 5 | |
| 124853 | 220670 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 948 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | 2 | 4 | 7 | 28859 | 19 | |||
| 191328 | 39196 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 948 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40848 | 6009924.75641086 | 2103679.40260243 | 37.7568628308131 | -122.408666394738 | (37.7568628308131, -122.408666394738) | 2 | 4 | 7 | 28859 | 19 | ||
| 109457 | 34758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 8 | Permit Number 38402 | 6007966.74070994 | 2102458.08144685 | 37.7533995021275 | -122.415351503246 | (37.7533995021275, -122.415351503246) | 2 | 4 | 7 | 28859 | 19 | |
| 43377 | 23032 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2003 12:00:00 AM | 8 | 3X3 | 6006338.92475 | 2104110.62405 | 37.7578453778742 | -122.421098173366 | (37.7578453778742, -122.421098173366) | 2 | 4 | 7 | 28859 | 19 | ||
| 143279 | 64600 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1988 12:00:00 AM | Permit Number 25502 | 6006331.29758425 | 2104145.47167682 | 37.7579406313954 | -122.42112702569 | (37.7579406313954, -122.42112702569) | 2 | 4 | 7 | 28859 | 19 | ||
| 69760 | 219989 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 936 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998793.85425 | 2106724.38466 | 37.7645938887298 | -122.447380197361 | (37.7645938887298, -122.447380197361) | 15 | 5 | 11 | 29492 | 9 | |||
| 81424 | 219988 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | 15 | 5 | 11 | 29492 | 9 | |||
| 101675 | 64665 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 933 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/1991 12:00:00 AM | Permit Number 25595 | 6006330.05327332 | 2104167.32767008 | 37.7580005727281 | -122.42113288094 | (37.7580005727281, -122.42113288094) | 2 | 4 | 7 | 28859 | 19 | ||
| 15282 | 220063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.7541717777287 | -122.432223106309 | (37.7541717777287, -122.432223106309) | 2 | 4 | 5 | 28862 | 22 | |||
| 151699 | 82779 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50449 | 6003096.61110421 | 2102822.62624393 | 37.7541255317067 | -122.432219457549 | (37.7541255317067, -122.432219457549) | 2 | 4 | 5 | 28862 | 22 | ||
| 78564 | 220007 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.43116 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | 2 | 4 | 7 | 28859 | 19 | |
| 133075 | 220697 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | 15 | 5 | 11 | 29492 | 9 | |||
| 88379 | 220041 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 890 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000667.40596 | 2102598.56375 | 37.7533722777334 | -122.440604151054 | (37.7533722777334, -122.440604151054) | 2 | 4 | 5 | 28862 | 22 | |||
| 102510 | 220042 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 890 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6000646.62015 | 2102597.34113 | 37.7533677370469 | -122.440675944861 | (37.7533677370469, -122.440675944861) | 2 | 4 | 5 | 28862 | 22 | |||
| 80471 | 220023 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 89 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001002.01011 | 2101166.3716 | 37.7494588706364 | -122.439344371761 | (37.7494588706364, -122.439344371761) | 2 | 4 | 5 | 28862 | 22 | |||
| 118749 | 220006 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 887 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007588.24314 | 2104555.69787 | 37.7591377962992 | -122.416809028616 | (37.7591377962992, -122.416809028616) | 2 | 4 | 7 | 28859 | 19 | |||
| 193476 | 67801 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 881 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31447 | 6000722.4252572 | 2102556.2611987 | 37.7532592580737 | -122.440410849633 | (37.7532592580737, -122.440410849633) | 2 | 4 | 5 | 28862 | 22 | ||
| 123669 | 92754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 880 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52983 | 6005536.79298 | 2091854.05704 | 37.7241463625482 | -122.423001157676 | (37.7241463625482, -122.423001157676) | 9 | 7 | 6 | 309 | 5 | |
| 44339 | 220001 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | 2 | 7 | 7 | 28859 | 2 | |||
| 110083 | 66324 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.7331642137768 | -122.439505779041 | (37.7331642137768, -122.439505779041) | 9 | 7 | 5 | 63 | 40 | ||
| 61974 | 37714 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 879 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3x3 | Permit Number 40084 | 6007585.89861945 | 2104551.15151716 | 37.7591251811896 | -122.416816815015 | (37.7591251811896, -122.416816815015) | 2 | 4 | 7 | 28859 | 19 | |
| 133467 | 37713 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 879 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3x3 | Permit Number 40084 | 6007585.89861945 | 2104551.15151716 | 37.7591251811896 | -122.416816815015 | (37.7591251811896, -122.416816815015) | 2 | 4 | 7 | 28859 | 19 | |
| 143747 | 53682 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 879 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30735 | 5984157.5341821 | 2109855.55736393 | 37.7723439568609 | -122.49823378959 | (37.7723439568609, -122.49823378959) | 11 | 6 | 2 | 55 | 26 | ||
| 52547 | 65160 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | 2 | 4 | 5 | 28862 | 22 | ||
| 158212 | 65158 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 873 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27138 | 6000770.17128477 | 2102558.89498752 | 37.7532692083278 | -122.440245923397 | (37.7532692083278, -122.440245923397) | 2 | 4 | 5 | 28862 | 22 | ||
| 71243 | 50520 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | 11 | 6 | 2 | 54 | 16 | |
| 122748 | 35134 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 849 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38664 | 6001545.25839951 | 2089134.40240899 | 37.716452756426 | -122.43660469328 | (37.716452756426, -122.43660469328) | 9 | 7 | 6 | 28861 | 5 | ||
| 178756 | 139655 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 848 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000491.15 | 2111934.8144 | 37.7789972619427 | -122.441883720544 | (37.7789972619427, -122.441883720544) | 15 | 5 | 11 | 29490 | 41 | |||
| 76417 | 66117 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.7760279254083 | -122.430248650411 | (37.7760279254083, -122.430248650411) | 7 | 9 | 11 | 29492 | 10 | ||
| 161910 | 64510 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 838 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 12 | Permit Number 25391 | 6000497.2416 | 2111874.2369 | 37.7788312786865 | -122.441858298358 | (37.7788312786865, -122.441858298358) | 15 | 5 | 11 | 29490 | 41 | |
| 58988 | 64511 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 833 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 11 | Permit Number 25392 | 6000435.9873 | 2111865.4379 | 37.7788036283278 | -122.442069568781 | (37.7788036283278, -122.442069568781) | 15 | 5 | 11 | 29490 | 16 | |
| 157378 | 66111 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29166 | 6003876.46719342 | 2110790.67622638 | 37.776048062614 | -122.430090907355 | (37.776048062614, -122.430090907355) | 7 | 9 | 11 | 29492 | 10 | ||
| 185574 | 10632 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003878.786 | 2110787.057 | 37.7760382564385 | -122.430082627746 | (37.7760382564385, -122.430082627746) | 7 | 9 | 11 | 29492 | 10 | ||
| 193919 | 10634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.430214699132 | (37.7760227838468, -122.430214699132) | 7 | 9 | 11 | 29492 | 10 | ||
| 77821 | 64512 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | Permit Number 25393 | 6000501.90082075 | 2111793.8331913 | 37.7786107760856 | -122.441836408094 | (37.7786107760856, -122.441836408094) | 15 | 5 | 11 | 29490 | 41 | ||
| 117664 | 66114 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29169 | 6003892.81016511 | 2110740.45474073 | 37.7759110923795 | -122.430030789321 | (37.7759110923795, -122.430030789321) | 7 | 9 | 11 | 29492 | 10 | ||
| 173155 | 10631 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1990 12:00:00 AM | 18 | 3X3 | 6003873.4823 | 2110738.4269 | 37.7759044297862 | -122.430097504694 | (37.7759044297862, -122.430097504694) | 7 | 9 | 11 | 29492 | 10 | ||
| 111234 | 67937 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 82 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31650 | 6004338.16538286 | 2095684.17990183 | 37.7345953163648 | -122.427417358908 | (37.7345953163648, -122.427417358908) | 2 | 7 | 5 | 28861 | 2 | ||
| 139408 | 65155 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 819 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27134 | 6001092.45713826 | 2102576.67307125 | 37.7533363665416 | -122.439132669576 | (37.7533363665416, -122.439132669576) | 2 | 4 | 5 | 28862 | 22 | ||
| 64962 | 66113 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | 7 | 9 | 11 | 29492 | 10 | ||
| 44119 | 220040 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 816 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001002.40026 | 2102614.77247 | 37.7534358534934 | -122.439446835117 | (37.7534358534934, -122.439446835117) | 2 | 4 | 5 | 28862 | 22 | |||
| 28804 | 44452 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 81 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002608.32736 | 2086901.11124 | 37.7103809831624 | -122.432770760164 | (37.7103809831624, -122.432770760164) | 9 | 7 | 6 | 28861 | 5 | ||
| 182859 | 44451 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.7103729108497 | -122.43278970978 | (37.7103729108497, -122.43278970978) | 9 | 7 | 6 | 28861 | 5 | |
| 150711 | 44091 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 807 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2000 12:00:00 AM | 6 | Permit Number 43606 | 6011323.91393 | 2104520.92035 | 37.7592517161218 | -122.40388677626 | (37.7592517161218, -122.40388677626) | 10 | 3 | 8 | 28856 | 29 | ||
| 135408 | 188518 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | 10 | 3 | 8 | 28856 | 29 | |||
| 81972 | 35001 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 8028 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.505415750841 | (37.7792165374199, -122.505415750841) | 11 | 6 | 2 | 55 | 26 | |||
| 138584 | 35000 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 8028 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.505415750841 | (37.7792165374199, -122.505415750841) | 11 | 6 | 2 | 55 | 26 | |||
| 68986 | 35558 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 801 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | 2 | 4 | 5 | 28859 | 19 | ||
| 177578 | 35559 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 801 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | 2 | 4 | 5 | 28859 | 19 | ||
| 160558 | 219997 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 80 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007927.7529 | 2099409.54394 | 37.7450267121064 | -122.41527054312 | (37.7450267121064, -122.41527054312) | 2 | 7 | 7 | 28859 | 2 | |||
| 168449 | 219996 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 80 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007954.3059 | 2099409.52418 | 37.7450281501379 | -122.415178725923 | (37.7450281501379, -122.415178725923) | 2 | 7 | 7 | 28859 | 2 | |||
| 120281 | 1913 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 8 Bell Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016615.0158523 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | 10 | 3 | 8 | 58 | 1 | ||
| 32895 | 109672 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
| 95101 | 109671 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
| 14481 | 123124 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992601.67217 | 2110090.43708 | 37.773480381816 | -122.469042091828 | (37.773480381816, -122.469042091828) | 11 | 6 | 2 | 54 | 11 | ||
| 17237 | 123125 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992603.0812 | 2110069.8115 | 37.7734238309341 | -122.469035716481 | (37.7734238309341, -122.469035716481) | 11 | 6 | 2 | 54 | 11 | ||
| 50159 | 98340 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
| 182428 | 98341 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
| 5053 | 247838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 79 Nevada St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | 6009045.88807 | 2098099.79815 | 37.7414932155318 | -122.411311709481 | (37.7414932155318, -122.411311709481) | 10 | 7 | 7 | 28859 | 2 | ||||
| 6049 | 35103 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.435437534334 | (37.7168332689419, -122.435437534334) | 9 | 7 | 6 | 28861 | 5 | ||
| 114089 | 140100 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 785 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999576.3959 | 2111131.7395 | 37.7767400570235 | -122.444990464885 | (37.7767400570235, -122.444990464885) | 15 | 5 | 11 | 29492 | 16 | |||
| 15295 | 220081 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.7564461523878 | -122.432443698342 | (37.7564461523878, -122.432443698342) | 2 | 4 | 5 | 28862 | 3 | |||
| 125867 | 220082 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 780 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003052.51993 | 2103630.15774 | 37.7563403210743 | -122.432429608637 | (37.7563403210743, -122.432429608637) | 2 | 4 | 5 | 28862 | 3 | |||
| 178676 | 220017 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001185.23014 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | 2 | 7 | 5 | 63 | 7 | |||
| 131584 | 140101 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 771 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999584.518 | 2111094.1746 | 37.7766373769699 | -122.44495966716 | (37.7766373769699, -122.44495966716) | 15 | 5 | 11 | 29492 | 16 | |||
| 185050 | 39226 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.07298 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | 11 | 6 | 2 | 55 | 26 | ||
| 147177 | 220086 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 77 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001721.7342 | 2105412.03314 | 37.7611573669292 | -122.437159494936 | (37.7611573669292, -122.437159494936) | 15 | 4 | 5 | 28862 | 3 | |||
| 113238 | 43731 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | 9 | 8 | 6 | 28861 | 24 | ||
| 9093 | 33190 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 | ||
| 153429 | 33189 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 | ||
| 172731 | 70953 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2008 12:00:00 AM | 3x3 | Permit Number 50393 | 5992532.60289704 | 2098624.81220808 | 37.7419947820759 | -122.468446668857 | (37.7419947820759, -122.468446668857) | 1 | 8 | 4 | 29491 | 40 | ||
| 100046 | 203638 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994537.11563 | 2090599.09131 | 37.7200736945131 | -122.460934206371 | (37.7200736945131, -122.460934206371) | 9 | 8 | 6 | 28861 | 24 | |||
| 162646 | 61325 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 750 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1984 12:00:00 AM | Permit Number 21228 | 5999633.66350661 | 2111045.76132591 | 37.7765072512287 | -122.444786178283 | (37.7765072512287, -122.444786178283) | 15 | 5 | 11 | 29492 | 16 | ||
| 100700 | 139501 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 750 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999619.0371 | 2111147.3069 | 37.7767852347068 | -122.444844076108 | (37.7767852347068, -122.444844076108) | 15 | 5 | 11 | 29492 | 16 | |||
| 124471 | 34441 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 75 Swiss Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38185 | 6001277.80934276 | 2096614.82991295 | 37.7369771019142 | -122.438064658249 | (37.7369771019142, -122.438064658249) | 2 | 7 | 5 | 63 | 7 | ||
| 102174 | 41993 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.464472962263 | (37.7278059137082, -122.464472962263) | 9 | 8 | 4 | 59 | 40 | ||
| 43083 | 248977 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 748 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999650 | 2111146 | 37.7767834132689 | -122.444736872581 | (37.7767834132689, -122.444736872581) | 15 | 5 | 11 | 29492 | 16 | ||||
| 83570 | 139500 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 748 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999620.0523 | 2111133.4316 | 37.7767471946184 | -122.444839566612 | (37.7767471946184, -122.444839566612) | 15 | 5 | 11 | 29492 | 16 | ||||
| 173134 | 115807 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | 15 | 5 | 11 | 29492 | 16 | |||
| 110529 | 36509 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 734 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39386 | 6007727.24180812 | 2095500.96385803 | 37.7342833425639 | -122.415687181505 | (37.7342833425639, -122.415687181505) | 2 | 7 | 7 | 28859 | 2 | ||
| 90150 | 63606 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 717 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24243 | 5999597.4131629 | 2110926.64814812 | 37.7761781281102 | -122.444903013727 | (37.7761781281102, -122.444903013727) | 15 | 5 | 11 | 29492 | 16 | ||
| 171717 | 39894 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41176 | 5999001.16721708 | 2108236.78492637 | 37.7687584031098 | -122.446771991368 | (37.7687584031098, -122.446771991368) | 15 | 5 | 11 | 29492 | 9 | |||
| 22337 | 43381 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 706 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43129 | 6001854.12345529 | 2102032.01903245 | 37.7518841875031 | -122.436459694241 | (37.7518841875031, -122.436459694241) | 2 | 4 | 5 | 28862 | 22 | ||
| 24531 | 43380 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43128 | 6001853.17321705 | 2102048.95584272 | 37.751930637944 | -122.436464192392 | (37.751930637944, -122.436464192392) | 2 | 4 | 5 | 28862 | 22 | ||
| 61503 | 64794 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | 2 | 7 | 5 | 63 | 22 | ||
| 68402 | 220016 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.7455556250083 | -122.446286498542 | (37.7455556250083, -122.446286498542) | 2 | 7 | 5 | 63 | 22 | |||
| 81536 | 220015 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.446260245536 | (37.745576384946, -122.446260245536) | 2 | 7 | 5 | 63 | 22 | |||
| 16365 | 203647 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993596.72892 | 2093377.09996 | 37.7276472749004 | -122.464386369131 | (37.7276472749004, -122.464386369131) | 9 | 8 | 4 | 59 | 40 | |||
| 31049 | 66174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.7386095323365 | -122.410309598587 | (37.7386095323365, -122.410309598587) | 10 | 7 | 7 | 28859 | 2 | ||
| 114869 | 64176 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.7270022179247 | -122.466730800624 | (37.7270022179247, -122.466730800624) | 9 | 8 | 4 | 59 | 40 | ||
| 24313 | 36920 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900 | 2102596 | 37.7534353511669 | -122.436341406283 | (37.7534353511669, -122.436341406283) | 2 | 4 | 5 | 28862 | 22 | ||
| 81889 | 36919 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 699 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900 | 2102596 | 37.7534353511669 | -122.436341406283 | (37.7534353511669, -122.436341406283) | 2 | 4 | 5 | 28862 | 22 | ||
| 146171 | 220087 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | 15 | 4 | 5 | 28862 | 3 | |||
| 37455 | 220026 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | 2 | 4 | 5 | 28862 | 22 | |||
| 90348 | 220027 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001922.66093 | 2102622.77824 | 37.7535101653675 | -122.436264956357 | (37.7535101653675, -122.436264956357) | 2 | 4 | 5 | 28862 | 22 | |||
| 191999 | 220028 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | 2 | 4 | 5 | 28862 | 22 | |||
| 16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 |
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) );