trees

11,761 rows where qSpecies_id = 17 sorted by PermitNotes descending

✎ View and edit SQL

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)
66828 54096 Permitted Site 7 Tree(s) :: 17 117 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1972 12:00:00 AM     Permit Number 9823 6000482.70518522 2104870.11449829 37.7595988825678 -122.441405867103 (37.7595988825678, -122.441405867103) 2 4 5 28862 3
25467 54095 Permitted Site 7 Tree(s) :: 17 111 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1972 12:00:00 AM     Permit Number 9822 6000511.11725358 2104871.80553599 37.7596051442907 -122.441307725593 (37.7596051442907, -122.441307725593) 2 4 5 28862 3
185945 54094 Permitted Site 7 Tree(s) :: 17 140 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1972 12:00:00 AM     Permit Number 9821 5991851.44721454 2095243.83587633 37.7326721081232 -122.470555676048 (37.7326721081232, -122.470555676048) 9 8 4 59 40
131184 54091 Permitted Site 7 Tree(s) :: 17 120 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1972 12:00:00 AM     Permit Number 9818 5991857.39291324 2095334.42590853 37.7329211894262 -122.470541716027 (37.7329211894262, -122.470541716027) 9 8 4 59 40
1357 54090 Permitted Site 7 Tree(s) :: 17 115 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1972 12:00:00 AM     Permit Number 9817 5991911.06498332 2095358.19732765 37.7329895631391 -122.47035789011 (37.7329895631391, -122.47035789011) 9 8 4 59 40
148563 54089 Permitted Site 7 Tree(s) :: 17 2045 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1972 12:00:00 AM     Permit Number 9815 5992026.97147266 2095387.75792656 37.733077429943 -122.469959326356 (37.733077429943, -122.469959326356) 9 8 4 59 40
117042 54088 Permitted Site 7 Tree(s) :: 17 229 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1972 12:00:00 AM     Permit Number 9814 6003645.03280335 2101545.85493043 37.7506508977166 -122.430231799677 (37.7506508977166, -122.430231799677) 2 4 5 28862 22
140618 54081 Permitted Site 7 Tree(s) :: 17 230 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1972 12:00:00 AM     Permit Number 9804 6003629.85128226 2101597.09604643 37.7507907339032 -122.430287953983 (37.7507907339032, -122.430287953983) 2 4 5 28862 22
172012 54078 Permitted Site 7 Tree(s) :: 17 1549 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1972 12:00:00 AM     Permit Number 9801 5998741.99793712 2089243.04009374 37.7165913487597 -122.446301913894 (37.7165913487597, -122.446301913894) 9 7 6 28861 25
93525 54074 Permitted Site 7 Tree(s) :: 17 1671 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9797 5981259.23298317 2103705.89858469 37.7552883992367 -122.507802660949 (37.7552883992367, -122.507802660949) 1 8 3 56 35
97119 54068 Permitted Site 7 Tree(s) :: 17 1643 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9791 5981252.96111373 2103888.20574043 37.7557885932785 -122.507837878985 (37.7557885932785, -122.507837878985) 1 8 3 56 35
159291 54067 Permitted Site 7 Tree(s) :: 17 1637 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9790 5981251.61714201 2103927.27155082 37.7558957776852 -122.507845425767 (37.7558957776852, -122.507845425767) 1 8 3 56 35
34483 54062 Permitted Site 7 Tree(s) :: 17 334 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9785 5988746.98730455 2113069.95091128 37.7814378207275 -122.482594221964 (37.7814378207275, -122.482594221964) 11 6 2 55 26
48580 54054 Permitted Site 7 Tree(s) :: 17 3920 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9776 6003673.71636522 2101895.43443972 37.7516123856509 -122.4301575457 (37.7516123856509, -122.4301575457) 2 4 5 28862 22
90050 54053 Permitted Site 7 Tree(s) :: 17 866 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9775 6003077.10918179 2103173.87360147 37.7550888677615 -122.432311984146 (37.7550888677615, -122.432311984146) 2 4 5 28862 22
79408 54051 Permitted Site 7 Tree(s) :: 17 439 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1972 12:00:00 AM     Permit Number 9773 6010735.95376867 2120301.35601681 37.8025482234186 -122.407032527097 (37.8025482234186, -122.407032527097) 3 1 10 308 23
43536 54049 Permitted Site 7 Tree(s) :: 17 606 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9771 6001837.75949921 2102323.68819229 37.7526841114374 -122.43653715738 (37.7526841114374, -122.43653715738) 2 4 5 28862 22
127532 54048 Permitted Site 7 Tree(s) :: 17 4186 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/1972 12:00:00 AM     Permit Number 9770 6002689.85524021 2100375.46527315 37.7473831353694 -122.433451251005 (37.7473831353694, -122.433451251005) 2 4 5 63 22
142308 54047 Permitted Site 7 Tree(s) :: 17 149 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1972 12:00:00 AM     Permit Number 9769 6001443.27762787 2107418.20108086 37.7666499791028 -122.438266279926 (37.7666499791028, -122.438266279926) 15 5 5 28862 3
39706 54045 Permitted Site 7 Tree(s) :: 17 249 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1972 12:00:00 AM     Permit Number 9767 6003973.30133773 2097690.21555937 37.7400827913309 -122.42882178061 (37.7400827913309, -122.42882178061) 2 7 5 63 7
28818 54037 Permitted Site 7 Tree(s) :: 17 957 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM     Permit Number 9759 6004410.3613312 2103324.76407224 37.755578684868 -122.427711961591 (37.755578684868, -122.427711961591) 2 4 5 28862 22
37378 54036 Permitted Site 7 Tree(s) :: 17 951 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM     Permit Number 9758 6004408.42863104 2103358.76023259 37.7556719210005 -122.427721067579 (37.7556719210005, -122.427721067579) 2 4 5 28862 22
84746 54035 Permitted Site 7 Tree(s) :: 17 947 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM     Permit Number 9757 6004406.78180474 2103387.71419535 37.7557513286139 -122.427728825706 (37.7557513286139, -122.427728825706) 2 4 5 28862 22
85036 54034 Permitted Site 7 Tree(s) :: 17 943 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM     Permit Number 9756 6004405.4756405 2103410.67410596 37.7558142972394 -122.427734978669 (37.7558142972394, -122.427734978669) 2 4 5 28862 22
192830 54032 Permitted Site 7 Tree(s) :: 17 66 Amethyst Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1972 12:00:00 AM     Permit Number 9753 5998878.1050637 2100036.15651635 37.7462344787497 -122.446607558642 (37.7462344787497, -122.446607558642) 2 7 5 63 22
59967 54031 Permitted Site 7 Tree(s) :: 17 4276 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9752 6002113.94458334 2100636.20352521 37.7480663698437 -122.435461356458 (37.7480663698437, -122.435461356458) 2 4 5 28862 22
109194 54028 Permitted Site 7 Tree(s) :: 17 264 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1972 12:00:00 AM     Permit Number 9748 6004582.37362854 2103989.04460947 37.7574123715722 -122.427164403132 (37.7574123715722, -122.427164403132) 2 4 5 28862 3
174807 54024 Permitted Site 7 Tree(s) :: 17 17 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9743 6004515.37720485 2094826.50302411 37.7322503493267 -122.426743619627 (37.7322503493267, -122.426743619627) 2 7 7 28861 2
44471 54022 Permitted Site 7 Tree(s) :: 17 887 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1972 12:00:00 AM     Permit Number 9741 5985088.31647594 2109836.96189757 37.7723474319633 -122.495012803738 (37.7723474319633, -122.495012803738) 11 6 2 55 26
103114 54021 Permitted Site 7 Tree(s) :: 17 867 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1972 12:00:00 AM     Permit Number 9740 5985083.5692131 2109967.43951948 37.7727054084533 -122.495038847537 (37.7727054084533, -122.495038847537) 11 6 2 55 26
100322 54019 Permitted Site 7 Tree(s) :: 17 851 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1972 12:00:00 AM     Permit Number 9738 5985079.77140319 2110071.82160726 37.7729917895981 -122.495059682755 (37.7729917895981, -122.495059682755) 11 6 2 55 26
31729 54013 Permitted Site 7 Tree(s) :: 17 826 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1972 12:00:00 AM     Permit Number 9732 5985126.04030428 2110230.28544197 37.7734295947154 -122.494911321492 (37.7734295947154, -122.494911321492) 11 6 2 55 26
114005 54012 Permitted Site 7 Tree(s) :: 17 807 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1972 12:00:00 AM     Permit Number 9731 5985069.32742571 2110358.87235474 37.7737793376693 -122.495116980435 (37.7737793376693, -122.495116980435) 11 6 2 55 26
192618 54011 Permitted Site 7 Tree(s) :: 17 800 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1972 12:00:00 AM     Permit Number 9730 5985119.86886295 2110399.9063407 37.7738949640602 -122.494945178336 (37.7738949640602, -122.494945178336) 11 6 2 55 26
2705 54005 Permitted Site 7 Tree(s) :: 17 515 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9724 6003024.81931846 2102680.10849791 37.7537301410207 -122.432457552268 (37.7537301410207, -122.432457552268) 2 4 5 28862 22
140039 54004 Permitted Site 7 Tree(s) :: 17 401 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9723 6010575.52114861 2089232.04917118 37.7172299105084 -122.405398373942 (37.7172299105084, -122.405398373942) 9 7 8 309 39
118813 54002 Permitted Site 7 Tree(s) :: 17 399 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9722 6010620.95767158 2089215.29601049 37.7171864501074 -122.405240141431 (37.7171864501074, -122.405240141431) 9 7 8 309 39
103048 54003 Permitted Site 7 Tree(s) :: 17 396 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9721 6010657.19723206 2089257.35604389 37.7173039643732 -122.405117837759 (37.7173039643732, -122.405117837759) 10 7 8 309 39
193811 53999 Permitted Site 7 Tree(s) :: 17 14 Rutland St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9717 6010652.24723851 2089463.80706867 37.7178705599695 -122.405149476877 (37.7178705599695, -122.405149476877) 10 7 8 309 39
188797 53998 Permitted Site 7 Tree(s) :: 17 454 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9716 6012173.03294287 2086634.80813642 37.7101875959303 -122.399694233991 (37.7101875959303, -122.399694233991) 10 3 8 309 1
68926 53995 Permitted Site 7 Tree(s) :: 17 398 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9713 5992170.59878547 2094287.10092219 37.7300636021007 -122.469382684951 (37.7300636021007, -122.469382684951) 9 8 4 59 40
49073 53994 Permitted Site 7 Tree(s) :: 17 395 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9712 5992229.29567186 2094283.64216057 37.7300574970899 -122.469179512663 (37.7300574970899, -122.469179512663) 9 8 4 59 40
31770 53991 Permitted Site 7 Tree(s) :: 17 360 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9708 5992285.41610232 2094514.39697292 37.7306943350618 -122.469002285783 (37.7306943350618, -122.469002285783) 9 8 4 59 40
25703 53990 Permitted Site 7 Tree(s) :: 17 357 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9707 5992343.56493698 2094523.11480129 37.7307216316192 -122.468801892212 (37.7307216316192, -122.468801892212) 9 8 4 59 40
177269 53989 Permitted Site 7 Tree(s) :: 17 351 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9706 5992356.23714956 2094565.87758863 37.7308397796874 -122.468761193301 (37.7308397796874, -122.468761193301) 9 8 4 59 40
75552 53988 Permitted Site 7 Tree(s) :: 17 350 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9705 5992305.2883762 2094576.28059266 37.7308654002405 -122.468938086616 (37.7308654002405, -122.468938086616) 9 8 4 59 40
153418 53987 Permitted Site 7 Tree(s) :: 17 344 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9704 5992313.52457448 2094616.6174221 37.7309766309839 -122.468912547276 (37.7309766309839, -122.468912547276) 9 8 4 59 40
29609 53986 Permitted Site 7 Tree(s) :: 17 340 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9702 5992319.01537675 2094643.50865847 37.7310507848548 -122.468895520996 (37.7310507848548, -122.468895520996) 9 8 4 59 40
188584 53983 Permitted Site 7 Tree(s) :: 17 329 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9699 5992379.62413839 2094718.17407428 37.7312592989912 -122.468691418905 (37.7312592989912, -122.468691418905) 9 8 4 59 40
156593 53982 Permitted Site 7 Tree(s) :: 17 325 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9698 5992381.52130426 2094745.55449723 37.7313345884109 -122.468686851674 (37.7313345884109, -122.468686851674) 9 8 4 59 40
184487 53976 Permitted Site 7 Tree(s) :: 17 525 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9692 5988408.9040175 2112421.31347223 37.7796371706278 -122.483716240359 (37.7796371706278, -122.483716240359) 11 6 2 55 26
24102 53973 Permitted Site 7 Tree(s) :: 17 841 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9688 6002477.92455493 2103315.74098949 37.7554444087469 -122.434394277885 (37.7554444087469, -122.434394277885) 2 4 5 28862 22
68445 53971 Permitted Site 7 Tree(s) :: 17 1368 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1972 12:00:00 AM     Permit Number 9686 5988681.47007693 2106013.82476823 37.7620598380854 -122.482303740785 (37.7620598380854, -122.482303740785) 1 8 3 56 35
37895 53967 Permitted Site 7 Tree(s) :: 17 3459 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1972 12:00:00 AM     Permit Number 9682 6006479.89752856 2105505.0667154 37.7616821386032 -122.420709620586 (37.7616821386032, -122.420709620586) 2 4 7 28859 19
98531 53966 Permitted Site 7 Tree(s) :: 17 753 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9681 6001547.2592482 2102014.72686373 37.7518192655261 -122.43751963345 (37.7518192655261, -122.43751963345) 2 4 5 28862 22
35275 53964 Permitted Site 7 Tree(s) :: 17 2088 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9679 6009537.86783876 2105063.04371184 37.7606403201023 -122.410102085162 (37.7606403201023, -122.410102085162) 2 4 7 28859 19
186255 53962 Permitted Site 7 Tree(s) :: 17 75 Williar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9677 5997104.31730915 2090598.44872467 37.7202193170784 -122.452060261271 (37.7202193170784, -122.452060261271) 9 8 6 28861 24
156671 53957 Permitted Site 7 Tree(s) :: 17 194 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM     Permit Number 9672 6009484.95843622 2095054.99214285 37.733157451413 -122.409578698867 (37.733157451413, -122.409578698867) 10 3 7 309 28
192738 53956 Permitted Site 7 Tree(s) :: 17 190 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM     Permit Number 9671 6009508.96553833 2095063.67854365 37.7331826476158 -122.409496312348 (37.7331826476158, -122.409496312348) 10 3 7 309 28
176085 53954 Permitted Site 7 Tree(s) :: 17 182 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM     Permit Number 9669 6009556.97969767 2095081.05132901 37.7332330398012 -122.409331539297 (37.7332330398012, -122.409331539297) 10 3 7 309 28
157219 53951 Permitted Site 7 Tree(s) :: 17 142 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM     Permit Number 9666 6009797.05060656 2095167.91529639 37.7334849973832 -122.408507670304 (37.7334849973832, -122.408507670304) 10 3 7 309 28
162641 53950 Permitted Site 7 Tree(s) :: 17 138 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM     Permit Number 9665 6009821.05770867 2095176.60169719 37.7335101928358 -122.408425283059 (37.7335101928358, -122.408425283059) 10 3 7 309 28
44602 53946 Permitted Site 7 Tree(s) :: 17 67 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1972 12:00:00 AM     Permit Number 9661 6001480.05186496 2107831.5893902 37.7677871327705 -122.438168700915 (37.7677871327705, -122.438168700915) 15 5 5 29492 3
58841 53944 Permitted Site 7 Tree(s) :: 17 4070 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM     Permit Number 9658 6002544.78402189 2104753.64842713 37.7593963523413 -122.434265851077 (37.7593963523413, -122.434265851077) 2 4 5 28862 3
53823 53943 Permitted Site 7 Tree(s) :: 17 240 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM     Permit Number 9657 5992873.02577787 2095176.69066124 37.7325467627575 -122.46701897745 (37.7325467627575, -122.46701897745) 9 8 4 59 40
59559 53942 Permitted Site 7 Tree(s) :: 17 220 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM     Permit Number 9656 5992865.68977665 2095267.73249022 37.7327963175434 -122.467050956231 (37.7327963175434, -122.467050956231) 9 8 4 59 40
65398 53940 Permitted Site 7 Tree(s) :: 17 3817 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM     Permit Number 9654 6002996.21606096 2102972.71027225 37.7545319339945 -122.432577367551 (37.7545319339945, -122.432577367551) 2 4 5 28862 22
158328 53939 Permitted Site 7 Tree(s) :: 17 521 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM     Permit Number 9653 6002955.55567058 2103261.19256157 37.7553217318092 -122.432738588314 (37.7553217318092, -122.432738588314) 2 4 5 28862 22
154927 53931 Permitted Site 7 Tree(s) :: 17 139 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM     Permit Number 9645 5993015.75586068 2114566.26757855 37.7857937149213 -122.467935345446 (37.7857937149213, -122.467935345446) 11 6 2 54 11
73584 53930 Permitted Site 7 Tree(s) :: 17 129 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1972 12:00:00 AM     Permit Number 9644 5993013.40641648 2114631.46227635 37.7859725859971 -122.467948217527 (37.7859725859971, -122.467948217527) 11 6 2 54 11
177542 53928 Permitted Site 7 Tree(s) :: 17 3852 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1972 12:00:00 AM     Permit Number 9641 5995768.44791549 2115856.1450508 37.789493944485 -122.4585052716 (37.789493944485, -122.4585052716) 11 6 1 54 31
62254 53926 Permitted Site 7 Tree(s) :: 17 382 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1972 12:00:00 AM     Permit Number 9639 6001771.47359122 2103624.69636773 37.7562526004215 -122.436859513363 (37.7562526004215, -122.436859513363) 2 4 5 28862 3
72433 53925 Permitted Site 7 Tree(s) :: 17 3824 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM     Permit Number 9638 6005030.2296144 2100503.25438218 37.7478665183798 -122.42536748474 (37.7478665183798, -122.42536748474) 2 4 5 63 22
9349 53924 Permitted Site 7 Tree(s) :: 17 1430 Sunnyvale St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1972 12:00:00 AM     Permit Number 9637                    
80727 53923 Permitted Site 7 Tree(s) :: 17 207 Hahn St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1972 12:00:00 AM     Permit Number 9636 6007472.80547598 2087293.96509204 37.7117343695123 -122.415985858012 (37.7117343695123, -122.415985858012) 9 7 8 309 39
111629 53921 Permitted Site 7 Tree(s) :: 17 889 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1972 12:00:00 AM     Permit Number 9634 6003134.84181126 2103072.06561399 37.7548126005787 -122.432105058248 (37.7548126005787, -122.432105058248) 2 4 5 28862 22
14480 53919 Permitted Site 7 Tree(s) :: 17 891 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1972 12:00:00 AM     Permit Number 9631 6003135.47209331 2103060.71359863 37.7547814663748 -122.432102067939 (37.7547814663748, -122.432102067939) 2 4 5 28862 22
9677 53915 Permitted Site 7 Tree(s) :: 17 3595 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1972 12:00:00 AM     Permit Number 9627 6004401.37110519 2103635.02076765 37.7564300681564 -122.427765157805 (37.7564300681564, -122.427765157805) 2 4 5 28862 22
126011 53913 Permitted Site 7 Tree(s) :: 17 3570 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1972 12:00:00 AM     Permit Number 9625 6004548.77022736 2103695.23569564 37.7566037411736 -122.427259688737 (37.7566037411736, -122.427259688737) 2 4 5 28862 3
186792 53912 Permitted Site 7 Tree(s) :: 17 3567 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1972 12:00:00 AM     Permit Number 9624 6004576.68019914 2103644.69705224 37.7564665523151 -122.427159566274 (37.7564665523151, -122.427159566274) 2 4 5 28862 22
54351 53911 Permitted Site 7 Tree(s) :: 17 3560 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1972 12:00:00 AM     Permit Number 9623 6004611.38062133 2103698.69151174 37.7566167706603 -122.42704340551 (37.7566167706603, -122.42704340551) 2 4 5 28862 3
95014 53910 Permitted Site 7 Tree(s) :: 17 232 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1972 12:00:00 AM     Permit Number 9622 6001726.41660076 2104485.17459628 37.7586127047057 -122.43707693972 (37.7586127047057, -122.43707693972) 2 4 5 28862 3
151138 53909 Permitted Site 7 Tree(s) :: 17 2404 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9621 6003193.48200181 2116561.98782327 37.7918559250749 -122.432865928537 (37.7918559250749, -122.432865928537) 13 9 1 29490 27
74401 53908 Permitted Site 7 Tree(s) :: 17 216 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/1972 12:00:00 AM     Permit Number 9620 6006132.14303179 2101894.29726124 37.7517481980214 -122.421655898526 (37.7517481980214, -122.421655898526) 2 4 5 28859 19
51743 53907 Permitted Site 7 Tree(s) :: 17 212 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1972 12:00:00 AM     Permit Number 9619 5996187.77481724 2091236.82449145 37.7219196027591 -122.455274535119 (37.7219196027591, -122.455274535119) 9 8 4 28861 24
36903 53906 Permitted Site 7 Tree(s) :: 17 15 Aloha Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9618 5991839.95737291 2104435.45077433 37.7579092573691 -122.471264852785 (37.7579092573691, -122.471264852785) 1 8 4 56 12
141934 53903 Permitted Site 7 Tree(s) :: 17 1074 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9615 6011197.6983662 2089774.5548034 37.7187542883478 -122.403285930888 (37.7187542883478, -122.403285930888) 10 7 8 309 28
120988 53902 Permitted Site 7 Tree(s) :: 17 1069 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9614 6011239.61540818 2089815.14164773 37.7188680725453 -122.403143893058 (37.7188680725453, -122.403143893058) 10 7 8 309 28
101074 53901 Permitted Site 7 Tree(s) :: 17 1068 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9613 6011189.91522021 2089799.84814203 37.7188233040066 -122.40331461262 (37.7188233040066, -122.40331461262) 10 7 8 309 28
144931 53900 Permitted Site 7 Tree(s) :: 17 1063 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9612 6011231.83225249 2089840.43501788 37.7189370883234 -122.403172574739 (37.7189370883234, -122.403172574739) 10 7 8 309 28
51697 53898 Permitted Site 7 Tree(s) :: 17 1056 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9610 6011174.34891369 2089850.43486657 37.7189613354299 -122.403371976299 (37.7189613354299, -122.403371976299) 10 7 8 309 28
155153 53897 Permitted Site 7 Tree(s) :: 17 1050 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9609 6011166.56576285 2089875.72822097 37.7190303511085 -122.403400658209 (37.7190303511085, -122.403400658209) 10 7 8 309 28
178925 30502 Permitted Site 7 Tree(s) :: 17 1045 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9608 6011208.48279998 2089916.31508106 37.7191441354823 -122.403258620046 (37.7191441354823, -122.403258620046) 10 7 8 309 28
154785 53896 Permitted Site 7 Tree(s) :: 17 1044 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9607 6011158.78261202 2089901.02157536 37.7190993667793 -122.403429340173 (37.7190993667793, -122.403429340173) 10 7 8 309 28
72552 53895 Permitted Site 7 Tree(s) :: 17 1033 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9606 6011192.91649345 2089966.9018056 37.7192821669258 -122.403315983869 (37.7192821669258, -122.403315983869) 10 7 8 309 28
189494 53893 Permitted Site 7 Tree(s) :: 17 1026 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9604 6011135.43315465 2089976.90165429 37.7193064137882 -122.403515386401 (37.7193064137882, -122.403515386401) 10 7 8 309 28
186558 53892 Permitted Site 7 Tree(s) :: 17 1021 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9603 6011177.35018936 2090017.48852226 37.7194201983168 -122.403373347895 (37.7194201983168, -122.403373347895) 10 7 8 309 28
83054 53891 Permitted Site 7 Tree(s) :: 17 1020 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9602 6011127.65000139 2090002.19501656 37.7193754294495 -122.403544068587 (37.7193754294495, -122.403544068587) 10 7 8 309 28
145850 53890 Permitted Site 7 Tree(s) :: 17 1015 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/1972 12:00:00 AM     Permit Number 9601 6011169.56703731 2090042.78188059 37.7194892140007 -122.403402029988 (37.7194892140007, -122.403402029988) 10 7 8 309 28
63968 53885 Permitted Site 7 Tree(s) :: 17 4348 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/1972 12:00:00 AM     Permit Number 9596 6000926.96857606 2102325.00369629 37.7526359251797 -122.439686920744 (37.7526359251797, -122.439686920744) 2 4 5 28862 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);