trees

290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by Neighborhoods (old)

✎ 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
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
108454 227082 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4021 Mission St 1 : Tree Private 2     4 Width 4ft   6004538.86235 2095169.33967 37.7331930297319 -122.426686831253 (37.7331930297319, -122.426686831253) 2 7 7 28861 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
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
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
59014 95404 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 395 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767278 6003403.3 2099172.9 37.7441216223731 -122.430898399301 (37.7441216223731, -122.430898399301) 2 7 5 63 22
59553 237223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 478 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2018 12:00:00 AM 3 Width 3ft Permit Number 781633 6003374.63036 2100117.41801 37.7467134247776 -122.431064932422 (37.7467134247776, -122.431064932422) 2 7 5 63 22
72338 227121 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 791 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001433.87774 2099966.59062 37.7461891245209 -122.437765046244 (37.7461891245209, -122.437765046244) 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
101817 227101 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 395 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003382.77934 2099193.25446 37.7441763482743 -122.430970807578 (37.7441763482743, -122.430970807578) 2 7 5 63 22
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
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
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
181974 227119 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022) 2 7 5 63 22
189084 247053 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 507 Valley St 1 : Tree Private 2     3 Width 2ft   6002585.44242 2099146.18361 37.744001891474 -122.433724457916 (37.744001891474, -122.433724457916) 2 7 5 63 22
192824 227120 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6001486.23397 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743) 2 7 5 63 22
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
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
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
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
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
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
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
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
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
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
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
57846 159339 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.45786 2087195.02696 37.7109327990681 -122.44828212563 (37.7109327990681, -122.44828212563) 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
75681 227160 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 236 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003812.10722 2095285.7669 37.7334715974377 -122.429207719083 (37.7334715974377, -122.429207719083) 2 7 5 28861 25
76315 27177 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 241 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2005 12:00:00 AM 3 2X3   6002847.37275 2093824.85102 37.7294055924915 -122.432438768257 (37.7294055924915, -122.432438768257) 9 7 6 28861 25
76325 253875 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 274 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2017 12:00:00 AM 3 3x3 Permit Number 777423 6003013.5236 2093666.24958 37.728979528994 -122.431853049446 (37.728979528994, -122.431853049446) 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
81002 159346 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.80621 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285) 9 7 6 28861 25
84495 52937 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 436@THERESA Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 9   Permit Number 48924 6002078.69882 2093873.61529 37.7294958700207 -122.435099629266 (37.7294958700207, -122.435099629266) 9 7 6 28861 25
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
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
112076 27237 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 279 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2007 12:00:00 AM 3 3X3   6003060.07524 2093688.79098 37.7290440614247 -122.431693725785 (37.7290440614247, -122.431693725785) 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
122783 159336 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 523 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352) 9 7 6 28861 25
125710 27179 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 231 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/27/2009 12:00:00 AM 3 2X3   6002801.57598 2093850.95144 37.7294746613043 -122.432598955494 (37.7294746613043, -122.432598955494) 9 7 6 28861 25
131707 52954 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 975 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.11633 37.7224704120511 -122.439451120374 (37.7224704120511, -122.439451120374) 9 7 6 28861 25
132775 180842 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 87 Laura St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.451155786013 (37.710473721248, -122.451155786013) 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)
);