290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by qAddress

View and edit SQL

Police Districts

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)
49312 227087 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009571.14847 2096096.9094 37.7360231620273 -122.409354219042 (37.7360231620273, -122.409354219042) 10 7 7 28859 2
81876 227086 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   6009619.77164 2096165.81934 37.7362150980513 -122.409190969587 (37.7362150980513, -122.409190969587) 10 7 7 28859 2
83192 227092 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 30 Sidewalk: Curb side : Yard Tree Private 2     3 Width 9ft   6009197.49082 2095788.04823 37.7351541534232 -122.410624304588 (37.7351541534232, -122.410624304588) 10 7 7 28859 2
83985 227091 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 29 Sidewalk: Curb side : Yard Tree Private 2     8 Width 5ft   6009293.03444 2095834.73547 37.735287702767 -122.410297269721 (37.735287702767, -122.410297269721) 10 7 7 28859 2
89299 227085 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009638.60709 2096225.80995 37.7363808745699 -122.409130079214 (37.7363808745699, -122.409130079214) 10 7 7 28859 2
98535 227088 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 12 Sidewalk: Curb side : Yard Tree Private 2     2 Width 5ft   6009533.30641 2096029.17809 37.7358350661275 -122.409480276115 (37.7358350661275, -122.409480276115) 10 7 7 28859 2
110146 227090 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 22 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   6009411.625 2095915.20486 37.7355153013828 -122.409892935407 (37.7355153013828, -122.409892935407) 10 7 7 28859 2
145000 227089 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 17 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6009456.29094 2095946.49023 37.7356037074354 -122.409740715285 (37.7356037074354, -122.409740715285) 10 7 7 28859 2
148726 227093 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 31 Sidewalk: Curb side : Yard Tree Private 2     3 Width 9ft   6009184.48132 2095791.05398 37.7351616771725 -122.410669495512 (37.7351616771725, -122.410669495512) 10 7 7 28859 2
164477 227094 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 35 Sidewalk: Curb side : Yard Tree Private 2     2     6009153.63089 2095762.56962 37.7350817355269 -122.410774146024 (37.7350817355269, -122.410774146024) 10 7 7 28859 2
171342 47598 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2003 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555) 10 7 7 28859 2
184322 47592 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555) 10 7 7 28859 2
55846 227161 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Leese St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005575.79788 2096114.93647 37.7358479983778 -122.423169051236 (37.7358479983778, -122.423169051236) 2 7 7 28859 2
62739 227079 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 7ft   6006194.41732 2099504.07308 37.7451886989034 -122.421270828796 (37.7451886989034, -122.421270828796) 2 7 5 28859 2
154918 52292 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 100 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48451 6006201.82590602 2099532.89904471 37.7452682661505 -122.421247257698 (37.7452682661505, -122.421247257698) 2 7 5 28859 2
14976 160069 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.78789 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684) 9 7 6 28861 25
41454 253116 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
80180 160063 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:07:00 AM 3 Width 0ft   6000471.59074 2090857.95331 37.7211241647202 -122.440439349407 (37.7211241647202, -122.440439349407) 9 7 6 28861 25
96295 253108 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
104234 160065 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.67913 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839) 9 7 6 28861 25
117585 160061 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:02:00 AM 3 Width 0ft   6000547.45442 2091000.21878 37.7215191128017 -122.440187308101 (37.7215191128017, -122.440187308101) 9 7 6 28861 25
122431 160059 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 10:50:00 AM 3 Width 0ft   6000588.55744 2091082.64129 37.7217477663201 -122.440051133668 (37.7217477663201, -122.440051133668) 9 7 6 28861 25
143452 160073 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.99934 2090399.7386 37.7198438772755 -122.441749724582 (37.7198438772755, -122.441749724582) 9 7 6 28861 25
156762 253110 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
165323 160071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827) 9 7 6 28861 25
172760 253118 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
173524 253112 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
182173 253114 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
29210 176917 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 9 Median : Yard Tree DPW 1     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224) 9 7 6 28861 5
44017 116540 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 3 Median : Yard Tree DPW 1     3 3x3   6001555.50616 2088195.95431 37.7138765688354 -122.436502141754 (37.7138765688354, -122.436502141754) 9 7 6 28861 5
58866 116551 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 7 Median : Yard Tree DPW 1     4 3x3   6001523.56178 2088140.13665 37.713721490625 -122.436608560332 (37.713721490625, -122.436608560332) 9 7 6 28861 5
65853 116538 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 1 Median : Yard Tree DPW 1     1 3x3   6001578.10158 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612) 9 7 6 28861 5
123255 116550 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001534.78323 2088160.34451 37.7137776146169 -122.436571220504 (37.7137776146169, -122.436571220504) 9 7 6 28861 5
138388 116548 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 4 Median : Yard Tree DPW 1     3 3x3   6001544.87474 2088178.15499 37.7138270917124 -122.436537614614 (37.7138270917124, -122.436537614614) 9 7 6 28861 5
138570 116539 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001567.48738 2088213.72569 37.7139260459311 -122.436462001442 (37.7139260459311, -122.436462001442) 9 7 6 28861 5
19897 102064 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 102 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2009 12:00:00 AM   3x3 Permit Number 52559 6007929.8 2098099.2 37.7414289135067 -122.415170728099 (37.7414289135067, -122.415170728099) 2 7 7 28859 2
130620 227108 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007939.95228 2098099.81155 37.7414311632286 -122.415135668203 (37.7414311632286, -122.415135668203) 2 7 7 28859 2
7686 116544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 7 Median : Yard Tree DPW 1     5 3x3   6001586.02621 2088182.95127 37.7138425996209 -122.436395723209 (37.7138425996209, -122.436395723209) 9 7 6 28861 5
17357 116552 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 8 Median : Yard Tree DPW 1     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838) 9 7 6 28861 5
69235 116543 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001574.84931 2088164.89401 37.7137923832878 -122.43643306305 (37.7137923832878, -122.43643306305) 9 7 6 28861 5
95040 116547 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 3 Median : Yard Tree DPW 1     4 3x3   6001554.67745 2088129.8106 37.7136949057732 -122.436500274771 (37.7136949057732, -122.436500274771) 9 7 6 28861 5
116664 116546 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001545.43478 2088113.86518 37.7136505979649 -122.436531080144 (37.7136505979649, -122.436531080144) 9 7 6 28861 5
139455 116549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 5 Median : Yard Tree DPW 1     4 3x3   6001562.82912 2088145.24079 37.7137377368707 -122.436473203396 (37.7137377368707, -122.436473203396) 9 7 6 28861 5
144424 116545 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 1 Median : Yard Tree DPW 1     2 3x3   6001537.05763 2088100.5912 37.7136136745151 -122.436559085032 (37.7136136745151, -122.436559085032) 9 7 6 28861 5
155326 176918 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 9 Median : Yard Tree DPW 1     4     6001604.80367 2088215.91202 37.7139341694897 -122.436333178956 (37.7139341694897, -122.436333178956) 9 7 6 28861 5
81845 227152 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 105 Manchester St 12 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6008289 2099369 37.7449356835318 -122.414018543543 (37.7449356835318, -122.414018543543) 2 7 7 28859 2
178337 227110 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 105 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6008268.06848 2099378.06711 37.7449594041621 -122.41409156248 (37.7449594041621, -122.41409156248) 2 7 7 28859 2
188729 227153 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 105 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008266.03922 2099383.96222 37.7449754768472 -122.414098996293 (37.7449754768472, -122.414098996293) 2 7 7 28859 2
28945 157260 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1059 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2018 12:00:00 AM 3 Width 0ft Permit Number 781960 5995594.16193 2098091.79633 37.7407076181758 -122.457822284089 (37.7407076181758, -122.457822284089) 9 7 4 59 40
93865 109578 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 10X Santa Rosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2015 12:00:00 AM 3 3x3 Permit Number 775018 6002262.55573 2092599.72242 37.7260084870829 -122.434372977031 (37.7260084870829, -122.434372977031) 9 7 6 28861 25
186425 109577 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 10X Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2015 12:00:00 AM 3 3x3 Permit Number 775018 6002290.3134 2092582.02308 37.72596146424 -122.434275755847 (37.72596146424, -122.434275755847) 9 7 6 28861 25
138739 82870 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 110 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2009 12:00:00 AM 8 3x3 Permit Number 53934 6006630.39976 2094273.0498 37.730850041274 -122.419392243064 (37.730850041274, -122.419392243064) 9 7 7 309 5
48472 207040 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 115 Greenwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5996029.16987 2093727.86128 37.7287502942706 -122.456002788314 (37.7287502942706, -122.456002788314) 9 7 4 28861 40
84873 69398 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1174 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.44104 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606) 9 7 6 28861 5
21610 83554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 117X Peru Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003920.58239 2093359.59743 37.7281889086723 -122.428695428367 (37.7281889086723, -122.428695428367) 9 7 6 28861 5
48782 83518 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 117X Peru Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003951.4498 2093338.17621 37.7281318376981 -122.428587192249 (37.7281318376981, -122.428587192249) 9 7 6 28861 5
171605 83555 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 117X Peru Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003936.82497 2093347.62291 37.7281569485605 -122.428638423918 (37.7281569485605, -122.428638423918) 9 7 6 28861 5
167819 176886 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 119 Theresa St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002169.33644 2093633.71931 37.7288423165165 -122.434769138285 (37.7288423165165, -122.434769138285) 9 7 6 28861 25
102249 176892 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 128 Craut St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004016.19178 2094155.91914 37.7303808407035 -122.428421637873 (37.7303808407035, -122.428421637873) 9 7 6 28861 5
148035 176891 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 128 Craut St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004014.42285 2094241.19444 37.7306148874672 -122.428433829062 (37.7306148874672, -122.428433829062) 9 7 6 28861 5
148114 227117 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 129 Rousseau St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003535.84775 2095026.78251 37.7327448417949 -122.430144356698 (37.7327448417949, -122.430144356698) 9 7 5 28861 25
164972 59404 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 129 Rousseau St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM     Permit Number 770892 6003547.68037437 2095024.45734525 37.7327391275899 -122.430103282559 (37.7327391275899, -122.430103282559) 9 7 5 28861 25
30949 176888 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 13 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002306.40089 2092528.29831 37.7258148612434 -122.434216303453 (37.7258148612434, -122.434216303453) 9 7 6 28861 25
65213 176887 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 13 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6002286.64114 2092541.40018 37.7258497144844 -122.434285547657 (37.7258497144844, -122.434285547657) 9 7 6 28861 25
102299 82807 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 8 3x3 Permit Number 52471 6006613.17369 2094127.50126 37.7304494265868 -122.419441474643 (37.7304494265868, -122.419441474643) 9 7 7 309 5
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
154340 176919 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 140 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6001505.61042 2087336.29034 37.7115132862848 -122.436613103724 (37.7115132862848, -122.436613103724) 9 7 6 28861 5
70068 207041 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1414 Plymouth Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5995889.45634 2093373.14104 37.727768297568 -122.456460143934 (37.727768297568, -122.456460143934) 9 7 4 28861 40
173908 251743 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 143 Cordova St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001773 2087479 37.7119203272299 -122.43569914015 (37.7119203272299, -122.43569914015) 9 7 6 28861 5
15346 262448 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 145 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3 3x3   6001496 2093037 37.7271656105126 -122.43705419947 (37.7271656105126, -122.43705419947) 9 7 6 28861 25
136658 227102 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1451 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6003961.99133 2099782.46881 37.7458269972341 -122.4290100202 (37.7458269972341, -122.4290100202) 2 7 5 63 22
86000 37052 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 156 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49822 6005524.96145532 2099948.44891125 37.7463710884027 -122.423617283508 (37.7463710884027, -122.423617283508) 2 7 5 28859 22
162043 227159 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 156 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6005558.07312 2099948.5227 37.7463731599945 -122.423502792335 (37.7463731599945, -122.423502792335) 2 7 5 28859 22
45819 207011 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 16 Circular Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001351.22893 2094512.68179 37.7312092646733 -122.437660309391 (37.7312092646733, -122.437660309391) 9 7 4 63 40
53980 207012 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 16 Circular Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001339.26796 2094505.80603 37.731189705325 -122.437701168268 (37.731189705325, -122.437701168268) 9 7 4 63 40
64767 227098 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1646 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009270.38668 2099790.72722 37.7461487242839 -122.410654850958 (37.7461487242839, -122.410654850958) 2 7 7 28859 2
134804 82755 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1646 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50226 6009275.52393785 2099776.98643755 37.746111283151 -122.410636116717 (37.746111283151, -122.410636116717) 2 7 7 28859 2
125722 82079 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1648 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50227 6009276.07844564 2099765.78028808 37.7460805446245 -122.410633408071 (37.7460805446245, -122.410633408071) 2 7 7 28859 2
86875 227097 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1650 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009272.78227 2099754.56661 37.7460495695343 -122.410644014106 (37.7460495695343, -122.410644014106) 2 7 7 28859 2
175025 115381 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1657X York St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 775521 6010720.61658 2099977.21326 37.7467419766429 -122.405653246985 (37.7467419766429, -122.405653246985) 2 7 7 28859 2
9404 176900 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005606.72127 2092829.97134 37.7268299557374 -122.422828750447 (37.7268299557374, -122.422828750447) 9 7 7 309 5
25424 176901 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005600.43917 2092849.05844 37.7268820102711 -122.422851823466 (37.7268820102711, -122.422851823466) 9 7 7 309 5
55754 176898 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005619.38027 2092788.13013 37.7267157831975 -122.422782016296 (37.7267157831975, -122.422782016296) 9 7 7 309 5
153956 176899 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005613.54422 2092807.28897 37.7267680598911 -122.422803552358 (37.7267680598911, -122.422803552358) 9 7 7 309 5
192118 96065 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 168 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767690 6005459.8 2096128.8 37.7358795176789 -122.423571087421 (37.7358795176789, -122.423571087421) 2 7 7 28859 2
82967 25763 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1682 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/20/2015 06:02:00 PM 3 2X3   6004184.86566 2087196.38583 37.711281031873 -122.427342931648 (37.711281031873, -122.427342931648) 9 7 6 28861 5
31769 227126 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1689 Noe St 2 Sidewalk: Curb side : Pot Tree Private 2     9 Width 4ft   6003395.21055 2098417.4445 37.742046857971 -122.430872467617 (37.742046857971, -122.430872467617) 2 7 5 63 22
171991 47551 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1689 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45415 6003395.23441175 2098403.20907691 37.7420077721371 -122.430871369414 (37.7420077721371, -122.430871369414) 2 7 5 63 22
139943 115757 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1718 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.21291 37.7151093927473 -122.448405831859 (37.7151093927473, -122.448405831859) 9 7 6 28861 25
115282 207013 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 178 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6000221.87075 2094376.84303 37.7307720044131 -122.441554946711 (37.7307720044131, -122.441554946711) 9 7 4 63 40
57710 181021 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 179 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 12:49:00 PM 3 8x6   6000934.69942 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076) 9 7 6 28861 5
80751 176890 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 18 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003663.21456 2093989.9827 37.7299052360341 -122.429630099158 (37.7299052360341, -122.429630099158) 9 7 6 28861 5
117385 181020 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 183 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.93011 37.7144764921819 -122.438602919392 (37.7144764921819, -122.438602919392) 9 7 6 28861 5
104233 102092 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 19 Stoneman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM   3x3 Permit Number 769735 6008292.3 2099391 37.7449962759915 -122.414008688761 (37.7449962759915, -122.414008688761) 2 7 7 28859 2
167721 102093 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 19 Stoneman St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM   3x3 Permit Number 769735 6008292.3 2099391 37.7449962759915 -122.414008688761 (37.7449962759915, -122.414008688761) 2 7 7 28859 2
172275 227111 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 19 Stoneman St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008285.63801 2099411.47629 37.7450521251663 -122.414033173096 (37.7450521251663, -122.414033173096) 2 7 7 28859 2
51610 176885 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rey St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008580.05361 2087004.56736 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652) 9 7 8 309 39
109143 181019 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.7144296473919 -122.438501549606 (37.7144296473919, -122.438501549606) 9 7 6 28861 5
106936 227147 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 195 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008297.42871 2097716.19697 37.7403979249162 -122.413872504709 (37.7403979249162, -122.413872504709) 2 7 7 28859 2
117931 74157 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 195 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM     Permit Number 768269 6008310.54477322 2097714.64471242 37.740394399357 -122.413827044611 (37.740394399357, -122.413827044611) 2 7 7 28859 2

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