trees
1,121 rows where qSpecies_id = 6 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57763 | 207044 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 755 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | 9 | 7 | 4 | 59 | 40 | |||
16338 | 261024 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 751 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989703 | 2110237 | 37.773714894321 | -122.479079631213 | (37.773714894321, -122.479079631213) | 11 | 6 | 2 | 55 | 26 | |||
106113 | 27044 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 750 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1999 12:00:00 AM | 3 | 3X3 | 6006334.59281 | 2093563.79094 | 37.7288859066417 | -122.42036457476 | (37.7288859066417, -122.42036457476) | 9 | 7 | 7 | 309 | 5 | ||
30613 | 227099 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.405954501114 | (37.7470444571367, -122.405954501114) | 2 | 7 | 7 | 28859 | 2 | |||
174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
149522 | 106431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | 8 | 2 | 9 | 28853 | 34 | |||
170818 | 120009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5986962.57059 | 2110820.51914 | 37.775157546008 | -122.488601975561 | (37.775157546008, -122.488601975561) | 11 | 6 | 2 | 55 | 26 | |||
12651 | 261028 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 743 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3 | 3x3 | 5989712 | 2110287 | 37.7738527032106 | -122.479052157213 | (37.7738527032106, -122.479052157213) | 11 | 6 | 2 | 55 | 26 | ||
102379 | 84816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 736 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53031 | 6008319.93046 | 2115035.61847 | 37.7879543130824 | -122.415020270782 | (37.7879543130824, -122.415020270782) | 5 | 1 | 10 | 28858 | 21 | |
19579 | 71337 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 734 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982620.59121 | 2110750.54443 | 37.7747110919712 | -122.503616418137 | (37.7747110919712, -122.503616418137) | 11 | 6 | 2 | 55 | 26 | |||
82708 | 117883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | 11 | 6 | 2 | 55 | 26 | |||
136110 | 27042 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006159.18902 | 2093550.73679 | 37.7288401770086 | -122.420970032554 | (37.7288401770086, -122.420970032554) | 9 | 7 | 7 | 309 | 5 | ||
142268 | 129380 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008321.92773 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | 5 | 1 | 10 | 28858 | 21 | |||
178481 | 117431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.11578 | 2091567.32576 | 37.7232841663055 | -122.427563407639 | (37.7232841663055, -122.427563407639) | 9 | 7 | 6 | 28861 | 5 | ||
107198 | 50036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.62107 | 2093714.43935 | 37.7293838567558 | -122.415196429982 | (37.7293838567558, -122.415196429982) | 9 | 3 | 7 | 309 | 28 | |
114989 | 50035 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.415140074598 | (37.7293219318135, -122.415140074598) | 9 | 3 | 7 | 309 | 28 | ||
63727 | 207043 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994097.83418 | 2093287.06293 | 37.7274289275879 | -122.46264752637 | (37.7274289275879, -122.46264752637) | 9 | 8 | 4 | 59 | 40 | |||
122988 | 27089 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 725 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6006167.96193 | 2093597.45552 | 37.728968950933 | -122.420943019604 | (37.728968950933, -122.420943019604) | 9 | 7 | 6 | 28861 | 5 | ||
81750 | 129385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | 5 | 1 | 10 | 28857 | 21 | |||
44532 | 227109 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 72 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008318.15108 | 2098296.22562 | 37.741991719651 | -122.41384187381 | (37.741991719651, -122.41384187381) | 2 | 7 | 7 | 28859 | 2 | |||
146189 | 227583 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002133.89525 | 2108814.30402 | 37.7705225892763 | -122.435977464701 | (37.7705225892763, -122.435977464701) | 15 | 5 | 11 | 29492 | 9 | |||
193498 | 47037 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | Permit Number 776491 | 6002280.60768666 | 2108833.96933031 | 37.7705849188534 | -122.435471392977 | (37.7705849188534, -122.435471392977) | 15 | 5 | 11 | 29492 | 9 | ||
92859 | 96110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 714 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767765 | 5982615.54512 | 2110891.71154 | 37.7750983990599 | -122.503644329704 | (37.7750983990599, -122.503644329704) | 11 | 6 | 2 | 55 | 26 |
87299 | 27282 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 710 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006026.1077 | 2093547.18457 | 37.7288229208214 | -122.421429852322 | (37.7288229208214, -122.421429852322) | 9 | 7 | 7 | 309 | 5 | ||
131735 | 227081 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 71 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006508.23754 | 2108096.29045 | 37.7687986257867 | -122.420795571254 | (37.7687986257867, -122.420795571254) | 8 | 4 | 7 | 28853 | 19 | |||
68030 | 68546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 707 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767769 | 5982568.02637 | 2110928.64305 | 37.7751970082773 | -122.503811440592 | (37.7751970082773, -122.503811440592) | 11 | 6 | 2 | 55 | 26 |
76667 | 95935 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.4875820769 | (37.7758745231149, -122.4875820769) | 11 | 6 | 2 | 55 | 26 |
37676 | 176896 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005242.33299 | 2091887.73518 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | 9 | 7 | 6 | 28861 | 5 | |||
56393 | 176895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.7244291336757 | -122.42394810962 | (37.7244291336757, -122.42394810962) | 9 | 7 | 6 | 28861 | 5 | |||
89273 | 38913 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
154355 | 38914 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
77796 | 83657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 7 | Permit Number 769748 | 6003905.60089 | 2093401.91906 | 37.728304266518 | -122.428750235745 | (37.728304266518, -122.428750235745) | 9 | 7 | 6 | 28861 | 5 | |
162239 | 94098 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2010 12:00:00 AM | 4 | Permit Number 53474 | 6007925.01702 | 2094192.51392 | 37.7307017385741 | -122.414910830466 | (37.7307017385741, -122.414910830466) | 9 | 3 | 7 | 309 | 28 | ||
178384 | 120804 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 689 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989715.19561 | 2110680.27165 | 37.774932704327 | -122.479069875733 | (37.774932704327, -122.479069875733) | 11 | 6 | 2 | 55 | 26 | |||
169270 | 27286 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 682 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6005885.56477 | 2093523.1174 | 37.7287489124796 | -122.421914010506 | (37.7287489124796, -122.421914010506) | 9 | 7 | 7 | 309 | 5 | ||
101773 | 176894 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 La Grande Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005238.00808 | 2092009.90059 | 37.7245574102793 | -122.424045090732 | (37.7245574102793, -122.424045090732) | 9 | 7 | 6 | 28861 | 5 | |||
123988 | 176893 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005229.89136 | 2092027.90961 | 37.7246064008395 | -122.424074429316 | (37.7246064008395, -122.424074429316) | 9 | 7 | 6 | 28861 | 5 | |||
78745 | 176904 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 Cambridge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006443.50632 | 2094472.10137 | 37.7313860651023 | -122.420052485745 | (37.7313860651023, -122.420052485745) | 9 | 7 | 7 | 28861 | 5 | |||
177530 | 176905 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 Cambridge St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006453.00873 | 2094472.53688 | 37.7313877962987 | -122.420019664972 | (37.7313877962987, -122.420019664972) | 9 | 7 | 7 | 28861 | 5 | |||
139841 | 176902 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 676 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005861.55708 | 2093540.19411 | 37.7287944473924 | -122.421998219354 | (37.7287944473924, -122.421998219354) | 9 | 7 | 7 | 309 | 5 | |||
6137 | 82588 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 675 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | 4 | 3x3 | Permit Number 52676 | 5983177.86359 | 2111217.50955 | 37.7760259908371 | -122.501723286949 | (37.7760259908371, -122.501723286949) | 11 | 6 | 2 | 55 | 26 | |
33674 | 27102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | 9 | 7 | 6 | 28861 | 5 | ||
29381 | 94673 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53809 | 5997706.3 | 2095032.9 | 37.7324297402139 | -122.450298904109 | (37.7324297402139, -122.450298904109) | 9 | 7 | 4 | 59 | 40 | |
147878 | 207049 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997703.56918 | 2095007.7992 | 37.7323606631136 | -122.450306536421 | (37.7323606631136, -122.450306536421) | 9 | 7 | 4 | 59 | 40 | |||
2314 | 227584 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 660 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002549.44678 | 2108867.98451 | 37.7706935809695 | -122.434543909369 | (37.7706935809695, -122.434543909369) | 15 | 5 | 11 | 29492 | 9 | |||
6051 | 207048 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 772511 | 5997718.79866 | 2095007.66028 | 37.7323611532403 | -122.450253874818 | (37.7323611532403, -122.450253874818) | 9 | 7 | 4 | 59 | 40 | |
79056 | 94672 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.450213143469 | (37.732430335747, -122.450213143469) | 9 | 7 | 4 | 59 | 40 | |
19808 | 207047 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997739.24902 | 2095008.66176 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | 9 | 7 | 4 | 59 | 40 | |||
109198 | 94671 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
173911 | 207046 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | 9 | 7 | 4 | 59 | 40 | |||
189614 | 94670 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
81975 | 207014 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 651 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 1ft | Permit Number 771866 | 5997782.54111 | 2094977.36202 | 37.7322816090925 | -122.450031320482 | (37.7322816090925, -122.450031320482) | 9 | 7 | 4 | 59 | 40 | |
67542 | 95712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) | 9 | 7 | 6 | 28861 | 5 |
2299 | 27284 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | 9 | 7 | 7 | 309 | 5 | ||
102876 | 119072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | Width 4ft | Permit Number 778557 | 5981931.09212 | 2111414.85236 | 37.7764945246953 | -122.506050759134 | (37.7764945246953, -122.506050759134) | 11 | 6 | 2 | 55 | 26 | |
91948 | 109136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.47436 | 2111505.41074 | 37.7768703987748 | -122.498566890903 | (37.7768703987748, -122.498566890903) | 11 | 6 | 2 | 55 | 26 |
128256 | 117895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | 11 | 6 | 2 | 55 | 26 | |||
139523 | 254363 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 634 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 772779 | 5981973.79907 | 2111426.3014 | 37.7765284742444 | -122.505903875162 | (37.7765284742444, -122.505903875162) | 11 | 6 | 2 | 55 | 26 | |
111974 | 206992 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 633 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992553.59441 | 2105897.35752 | 37.761964523762 | -122.468903201544 | (37.761964523762, -122.468903201544) | 1 | 8 | 4 | 56 | 12 | |||
160467 | 27283 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 630 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2008 12:00:00 AM | 6 | 3X3 | 6005560.76907 | 2093525.90712 | 37.7287382496569 | -122.423037049614 | (37.7287382496569, -122.423037049614) | 9 | 7 | 7 | 309 | 5 | ||
1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
32912 | 94410 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.437511336741 | (37.7694955715896, -122.437511336741) | 15 | 5 | 5 | 29492 | 9 | ||
9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
16718 | 262177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
19327 | 262176 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
8275 | 123462 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995351.08305 | 2111296.01241 | 37.7769490481008 | -122.459618879478 | (37.7769490481008, -122.459618879478) | 11 | 6 | 2 | 54 | 11 | |||
2654 | 108556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) | 9 | 7 | 6 | 28861 | 25 |
15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
179045 | 19350 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781612 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | 9 | 8 | 6 | 64 | 24 | |
133037 | 206993 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 615 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992617.51095 | 2105899.81469 | 37.7619749630815 | -122.468682319958 | (37.7619749630815, -122.468682319958) | 1 | 8 | 4 | 56 | 12 | |||
68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
65509 | 247762 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 61 Alpine Ter | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6001652.09386 | 2108463.90123 | 37.7695330877219 | -122.437618918075 | (37.7695330877219, -122.437618918075) | 15 | 5 | 5 | 29492 | 9 | |||
161683 | 207045 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998977.59415 | 2096753.43976 | 37.7372266087217 | -122.446027465895 | (37.7372266087217, -122.446027465895) | 9 | 7 | 4 | 59 | 40 | |||
44650 | 206994 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992653.289 | 2105901.13559 | 37.761980656709 | -122.468558674846 | (37.761980656709, -122.468558674846) | 1 | 8 | 4 | 56 | 12 | |||
113377 | 115939 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 607 34TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777685 | 5985316 | 2111712 | 37.7775090776113 | -122.494363475489 | (37.7775090776113, -122.494363475489) | 11 | 6 | 2 | 55 | 26 | |
176365 | 68842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.393375500204 | (37.7588942535933, -122.393375500204) | 10 | 3 | 8 | 28856 | 29 |
121056 | 251749 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 601 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002875 | 2087693 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | 9 | 7 | 6 | 28861 | 5 | |||||
12222 | 31158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 600 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Permit Number 785248 | 5993522.80361 | 2089878.90243 | 37.7180378119737 | -122.464388049089 | (37.7180378119737, -122.464388049089) | 9 | 8 | 6 | 64 | 24 | |
148332 | 113418 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007207 | 2095355 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | 2 | 7 | 7 | 28859 | 2 | |||
108745 | 92226 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||
178195 | 227115 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007890.87999 | 2104550.47449 | 37.7591404717772 | -122.415761992927 | (37.7591404717772, -122.415761992927) | 2 | 4 | 7 | 28859 | 19 | |||
192907 | 255098 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 585 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 5987788 | 2112008 | 37.7784661663567 | -122.485833843864 | (37.7784661663567, -122.485833843864) | 11 | 6 | 2 | 55 | 26 | ||||
47522 | 84344 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.43921 | 2112041.11408 | 37.7785579296732 | -122.485786324881 | (37.7785579296732, -122.485786324881) | 11 | 6 | 2 | 55 | 26 | |
181931 | 102200 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769774 | 6002583.2 | 2103808 | 37.7568020093443 | -122.434065390673 | (37.7568020093443, -122.434065390673) | 2 | 4 | 5 | 28862 | 3 |
187092 | 227571 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002573.48599 | 2103832.36646 | 37.7568683624992 | -122.434100727063 | (37.7568683624992, -122.434100727063) | 2 | 4 | 5 | 28862 | 3 | |||
186495 | 57147 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 578 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2012 12:00:00 AM | 6 | 4x4 | Permit Number 14422 | 6001353.29798 | 2090440.69811 | 37.7200286411902 | -122.4373616868 | (37.7200286411902, -122.4373616868) | 9 | 7 | 6 | 28861 | 5 |
19677 | 39613 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | 15 | 5 | 11 | 29492 | 12 | ||
63992 | 39614 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | 15 | 5 | 11 | 29492 | 12 | ||
163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
43943 | 227551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.7598958878974 | -122.432585790315 | (37.7598958878974, -122.432585790315) | 2 | 4 | 5 | 28862 | 3 | |||
159117 | 51978 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50788 | 6003031.54377055 | 2104930.91129788 | 37.7599106895436 | -122.432595060758 | (37.7599106895436, -122.432595060758) | 2 | 4 | 5 | 28862 | 3 | ||
177874 | 42963 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.507066636025 | (37.7778257173711, -122.507066636025) | 11 | 6 | 2 | 55 | 26 | ||
119734 | 227100 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004326.55063 | 2108840.26945 | 37.7707182026243 | -122.428394902803 | (37.7707182026243, -122.428394902803) | 7 | 9 | 11 | 28852 | 10 | |||
178838 | 88733 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51668 | 6004334 | 2108794 | 37.7705915794801 | -122.428365836994 | (37.7705915794801, -122.428365836994) | 7 | 9 | 11 | 28852 | 10 | ||
140777 | 27106 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 559 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6005090.49243 | 2093546.0118 | 37.7287669038667 | -122.424664256843 | (37.7287669038667, -122.424664256843) | 9 | 7 | 6 | 28861 | 5 | ||
148373 | 129381 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.413883591577 | (37.7856101663154, -122.413883591577) | 7 | 10 | 9 | 28852 | 36 | |||
175351 | 27251 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X3 | 6005015.49022 | 2093543.05731 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | 9 | 7 | 6 | 28861 | 5 | |||
192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
177745 | 78252 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.57122 | 2090471.02112 | 37.7202064317688 | -122.431607573443 | (37.7202064317688, -122.431607573443) | 9 | 7 | 6 | 28861 | 5 |
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) );