trees

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

✎ View and edit SQL

This data as json, CSV (advanced)

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)
2103 262299 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
3652 248155 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 235 Rutledge St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010048.23979 2099492.44346 37.7453732829604 -122.40794409015 (37.7453732829604, -122.40794409015) 2 7 7 28859 2
5588 227150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 808 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008185.20329 2095640.92661 37.7346933830922 -122.414113755053 (37.7346933830922, -122.414113755053) 2 7 7 28859 2
15368 262300 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
17906 219682 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 250 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3   6008245.78846 2097431.26822 37.7396126728914 -122.414030905009 (37.7396126728914, -122.414030905009) 2 7 7 28859 2
19865 227149 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 530 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007719.36141 2095678.53729 37.7347704774588 -122.415726995823 (37.7347704774588, -122.415726995823) 2 7 7 28859 2
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
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
39385 227113 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201 Ogden Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6007896.8692 2096132.1903 37.736026086627 -122.415145389863 (37.736026086627, -122.415145389863) 2 7 7 28859 2
41225 82433 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 235 Rutledge St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2008 12:00:00 AM   3x3 Permit Number 50249 6010057.43217179 2099484.04645755 37.745350741274 -122.407911712216 (37.745350741274, -122.407911712216) 2 7 7 28859 2
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
45396 227112 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 82 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007863.71848 2099963.32211 37.7465436642568 -122.41553116305 (37.7465436642568, -122.41553116305) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
108010 858 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 400X Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   07/24/2015 09:41:00 AM 3 3x3   6008130.35725 2095075.26223 37.7331371107843 -122.414263368055 (37.7331371107843, -122.414263368055) 2 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
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
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
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
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
136013 227148 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 401 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008617.64213 2096897.82478 37.7381688320284 -122.412707488766 (37.7381688320284, -122.412707488766) 10 7 7 28859 2
144492 116789 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 530 CRESCENT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007719 2095661 37.7347223035732 -122.415727003996 (37.7347223035732, -122.415727003996) 2 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
145329 110718 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 201x OGDEN AVE 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007843 2096159 37.7360966727045 -122.415333535238 (37.7360966727045, -122.415333535238) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
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
190265 227118 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 29th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005870.45988 2099040.93392 37.7438987545141 -122.422358119057 (37.7438987545141, -122.422358119057) 2 7 7 28859 2
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
193291 45368 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 201x OGDEN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2001 12:00:00 AM     Permit Number 44193 6007843 2096159 37.7360966727045 -122.415333535238 (37.7360966727045, -122.415333535238) 2 7 7 28859 2
1269 262440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
1415 171287 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 339 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003711.94249 2092708.61039 37.7263896332495 -122.429370301207 (37.7263896332495, -122.429370301207) 9 7 6 28861 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
1882 170658 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 4x6   6000800.50336 2092551.29112 37.7257924078835 -122.439423717141 (37.7257924078835, -122.439423717141) 9 7 6 28861 25
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
2939 262442 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
3013 109184 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2015 12:00:00 AM 3 3x3 Permit Number 774827 6002270 2092514.4 37.7257746335194 -122.434341145327 (37.7257746335194, -122.434341145327) 9 7 6 28861 25
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
10101 180653 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 245 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2   10/11/2017 07:56:00 AM 3 Width 6ft   6002847.75966 2086772.69306 37.7100419513527 -122.431934068713 (37.7100419513527, -122.431934068713) 9 7 6 28861 5
10461 170660 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2020 12:00:00 AM 3 Width 3ft   6000886.10189 2092489.73569 37.7256282618212 -122.439123400224 (37.7256282618212, -122.439123400224) 9 7 6 28861 25
10786 95722 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
12664 45661 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 315 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/2001 12:00:00 AM 6   Permit Number 44357 6002302.86118 2091870.52112 37.7240085522374 -122.434181537449 (37.7240085522374, -122.434181537449) 9 7 6 28861 5
12813 207010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 305 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5999351.3193 2094355.62728 37.7306641145479 -122.444563045861 (37.7306641145479, -122.444563045861) 9 7 4 28861 40
12847 171236 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 39 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003761.27522 2093172.4115 37.7276659205371 -122.429232817353 (37.7276659205371, -122.429232817353) 9 7 6 28861 5
12906 27193 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 284 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2009 12:00:00 AM 6 3X3   6003096.09594 2093601.65823 37.7288068562446 -122.431562981455 (37.7288068562446, -122.431562981455) 9 7 6 28861 25
13726 80104 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 425 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 52309 6003144.80516 2091503.70271 37.7230491006299 -122.43124489935 (37.7230491006299, -122.43124489935) 9 7 6 28861 5
13775 68397 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 88 Lyell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2020 12:00:00 AM 3   Permit Number 785230 6003105.95459 2094517.30646 37.7313215783119 -122.43159424368 (37.7313215783119, -122.43159424368) 9 7 5 28861 25
14207 176903 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 290 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005283.95555 2093790.15237 37.7294481843731 -122.424012796049 (37.7294481843731, -122.424012796049) 9 7 6 28861 5
14410 170659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 6x4   6000830.95965 2092528.01217 37.7257302224446 -122.439316764384 (37.7257302224446, -122.439316764384) 9 7 6 28861 25
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
15013 170657 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 Width 3ft   6000770.58972 2092571.08998 37.7258450685777 -122.439528544816 (37.7258450685777, -122.439528544816) 9 7 6 28861 25
15310 262443 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
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
15599 262439 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
17284 81630 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 Paulding St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5999996.8419 2093367.66723 37.7279882186648 -122.44226048643 (37.7279882186648, -122.44226048643) 9 7 6 28861 25
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
17874 170661 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 Width 3ft   6000920.86362 2092466.57168 37.7255666366796 -122.439001572678 (37.7255666366796, -122.439001572678) 9 7 6 28861 25
18371 27202 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003502.33889 2093475.71167 37.7284840526724 -122.430149591636 (37.7284840526724, -122.430149591636) 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
21651 27207 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003623.95003 2093470.28644 37.7284760433174 -122.429728788952 (37.7284760433174, -122.429728788952) 9 7 6 28861 5
24139 95719 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
25141 95718 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
26675 207018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 466 Staples Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5997114.73821 2093838.00202 37.7291149630685 -122.452257872798 (37.7291149630685, -122.452257872798) 9 7 4 28861 40
27543 83558 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 483 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 7 3x3 Permit Number 52321 6001949.50225 2090800.06366 37.7210492547906 -122.435326507535 (37.7210492547906, -122.435326507535) 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
28544 159338 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.448328017142 (37.7108995709325, -122.448328017142) 9 7 6 28861 25
29101 176889 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 277 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004392.5622 2091665.65248 37.7235644112504 -122.426943181195 (37.7235644112504, -122.426943181195) 9 7 6 28861 5
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
30385 181018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.04691 37.7143947132291 -122.43841724089 (37.7143947132291, -122.43841724089) 9 7 6 28861 5
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
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
35156 26976 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 504X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM 3 3x3   6004631.39194 2093482.01374 37.7285652398765 -122.426246843332 (37.7285652398765, -122.426246843332) 9 7 6 28861 5
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
39381 181028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.46766 37.7151323074928 -122.440070279342 (37.7151323074928, -122.440070279342) 9 7 6 28861 5
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
41858 83563 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 422 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2012 12:00:00 AM 5 3x3 Permit Number 769753 6002333.87212 2090986.92404 37.7215841526661 -122.434011205875 (37.7215841526661, -122.434011205875) 9 7 6 28861 5
42520 27117 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 415 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/03/2009 12:00:00 AM 3 3X3   6004172.1589 2093507.51269 37.7286092859714 -122.427836253857 (37.7286092859714, -122.427836253857) 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
46761 27182 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 214 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/03/2015 07:50:00 AM 3 2X3   6002674.64617 2093876.57211 37.7295378108224 -122.433039593603 (37.7295378108224, -122.433039593603) 9 7 6 28861 25

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