trees
1,985 rows where qSpecies_id = 83 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 328 | 197129 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 11 | : | Tree | Private 2 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.7412122331485 | -122.387337958305 | (37.7412122331485, -122.387337958305) | 10 | 3 | 8 | 58 | 1 | |||
| 2378 | 239239 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | : | Tree | Private 2 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | 15 | 5 | 11 | 29492 | 9 | |||
| 2621 | 202038 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 75 Crane St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.399639484201 | (37.7219600944649, -122.399639484201) | 10 | 3 | 8 | 58 | 1 | |||
| 15928 | 197140 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 53 Pomona St | 2 | : | Tree | Private 2 | 3 | Width 5ft | 6014151.58684 | 2094423.96338 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | 10 | 3 | 8 | 58 | 1 | |||
| 21693 | 197124 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 12 | : | Tree | Private 2 | 3 | Width 4ft | 6013733.0286 | 2100130.55294 | 37.7473310072149 | -122.395247287949 | (37.7473310072149, -122.395247287949) | 10 | 3 | 8 | 58 | 1 | |||
| 23672 | 247568 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 322 Alemany Blvd | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.7340714901943 | -122.412356334971 | (37.7340714901943, -122.412356334971) | 10 | 7 | 7 | 28859 | 2 | |||
| 23938 | 237023 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 4 | : | Tree | DPW 1 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | 7 | 9 | 11 | 28852 | 10 | ||
| 24941 | 239241 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Potrero Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | 10 | 4 | 8 | 28859 | 19 | |||
| 29832 | 197131 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 17 | : | Tree | Private 2 | 5 | Width 3ft | 6015885.54456 | 2097735.33833 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | 10 | 3 | 8 | 58 | 1 | |||
| 34480 | 197115 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1231 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011991.85547 | 2102642.48446 | 37.7541312380906 | -122.401444683423 | (37.7541312380906, -122.401444683423) | 10 | 3 | 8 | 28856 | 29 | |||
| 50390 | 197136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Newhall St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6015282.23394 | 2096844.32451 | 37.7383937389821 | -122.38966071649 | (37.7383937389821, -122.38966071649) | 10 | 3 | 8 | 58 | 1 | |||
| 50430 | 197123 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 9 | : | Tree | Private 2 | 4 | Width 4ft | 6013823.14287 | 2100134.69381 | 37.7473473883884 | -122.39493596693 | (37.7473473883884, -122.39493596693) | 10 | 3 | 8 | 58 | 1 | |||
| 50518 | 246963 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 238 Noe St | 2 | : | Tree | Private 2 | 8 | Width 4ft | 6002871.51875 | 2106887.24062 | 37.7652732203948 | -122.433288301134 | (37.7652732203948, -122.433288301134) | 15 | 5 | 5 | 28862 | 3 | |||
| 55893 | 246962 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 238 Noe St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6002859.87984 | 2106886.32393 | 37.7652700431031 | -122.43332849182 | (37.7652700431031, -122.43332849182) | 15 | 5 | 5 | 28862 | 3 | |||
| 70513 | 197128 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Newhall St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016765.19641 | 2098282.20265 | 37.7424239805909 | -122.384633436999 | (37.7424239805909, -122.384633436999) | 10 | 3 | 8 | 58 | 1 | |||
| 73172 | 202037 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 75 Crane St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012270.31182 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | 10 | 3 | 8 | 58 | 1 | |||
| 74630 | 197133 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Newhall St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6016812.93414 | 2098272.11729 | 37.7423989281583 | -122.384467670355 | (37.7423989281583, -122.384467670355) | 10 | 3 | 8 | 58 | 1 | |||
| 81020 | 197127 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Newhall St | 13 | : | Tree | Private 2 | 3 | Width 3ft | 6017303.08049 | 2098110.93394 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | 10 | 3 | 8 | 58 | 1 | |||
| 82155 | 197139 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 139 Venus St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012870.02823 | 2094155.13741 | 37.7308757367127 | -122.397812425111 | (37.7308757367127, -122.397812425111) | 10 | 3 | 8 | 58 | 1 | |||
| 84699 | 197118 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Texas St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6013784.73559 | 2105658.04133 | 37.7625111748734 | -122.395455668042 | (37.7625111748734, -122.395455668042) | 10 | 3 | 8 | 28856 | 29 | |||
| 98388 | 247567 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 320 Alemany Blvd | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6008730.40268 | 2095427.8255 | 37.7341388611064 | -122.412213751984 | (37.7341388611064, -122.412213751984) | 10 | 7 | 7 | 28859 | 2 | |||
| 100200 | 237022 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 3 | : | Tree | DPW 1 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.13323 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | 7 | 9 | 11 | 28852 | 10 | ||
| 102932 | 237024 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 5 | : | Tree | DPW 1 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334131 | -122.423466764586 | (37.772478334131, -122.423466764586) | 7 | 9 | 11 | 28852 | 10 | ||
| 103131 | 249400 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 230 Hyde St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6008085.57169 | 2113256.87585 | 37.7830571448252 | -122.415705117997 | (37.7830571448252, -122.415705117997) | 7 | 10 | 9 | 28852 | 36 | |||
| 103344 | 239243 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Potrero Ave | 4 | : | Tree | Private 2 | 15 | Width 3ft | 6010651.82009 | 2101663.18223 | 37.7513674307674 | -122.406009892161 | (37.7513674307674, -122.406009892161) | 10 | 4 | 8 | 28859 | 19 | |||
| 105749 | 197116 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1015 Rhode Island St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6011950.21534 | 2103491.63171 | 37.7564604866852 | -122.40164836548 | (37.7564604866852, -122.40164836548) | 10 | 3 | 8 | 28856 | 29 | |||
| 109926 | 239242 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Potrero Ave | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6010651.99768 | 2101656.70763 | 37.7513496628741 | -122.406008821959 | (37.7513496628741, -122.406008821959) | 10 | 4 | 8 | 28859 | 19 | |||
| 111401 | 197137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1611 Kirkwood Ave | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6015105.04683 | 2096793.47619 | 37.7382442932251 | -122.390269796717 | (37.7382442932251, -122.390269796717) | 10 | 3 | 8 | 58 | 1 | |||
| 111876 | 246509 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 241 Duncan St | 2 | : | Tree | Private 2 | 7 | Width 6ft | 6004948.2324 | 2099866.59265 | 37.7461137586439 | -122.425605722044 | (37.7461137586439, -122.425605722044) | 2 | 7 | 5 | 63 | 22 | |||
| 113145 | 239261 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1400 Utah St | 5 | : | Tree | Private 2 | 14 | Width 3ft | 6010855.2107 | 2101671.833 | 37.7514025574059 | -122.405307149322 | (37.7514025574059, -122.405307149322) | 10 | 4 | 8 | 28859 | 19 | |||
| 113716 | 246508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 241 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | 2 | 7 | 5 | 63 | 22 | |||
| 118288 | 197120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014065.79704 | 2105649.96536 | 37.7625046287026 | -122.394483006312 | (37.7625046287026, -122.394483006312) | 10 | 3 | 8 | 28856 | 29 | |||
| 127187 | 249399 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 222 Hyde St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6008090.57738 | 2113215.48771 | 37.7829437843643 | -122.41568486887 | (37.7829437843643, -122.41568486887) | 7 | 10 | 9 | 28852 | 36 | |||
| 129166 | 197132 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Newhall St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.7424121931718 | -122.384551543811 | (37.7424121931718, -122.384551543811) | 10 | 3 | 8 | 58 | 1 | |||
| 130419 | 197121 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 3 | : | Tree | Private 2 | 3 | Width 4ft | 6014057.88074 | 2100147.50711 | 37.747395620823 | -122.39412515077 | (37.747395620823, -122.39412515077) | 10 | 3 | 8 | 58 | 1 | |||
| 135447 | 247564 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 316 Alemany Blvd | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6008777.64172 | 2095456.26862 | 37.7342196103425 | -122.412052440585 | (37.7342196103425, -122.412052440585) | 10 | 7 | 7 | 28859 | 2 | |||
| 136697 | 239151 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Octavia St | 2 | : | Tree | DPW 1 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | 7 | 9 | 11 | 28852 | 10 | ||
| 136753 | 197134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Newhall St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6016745.12895 | 2098337.97655 | 37.7425760145669 | -122.384706709273 | (37.7425760145669, -122.384706709273) | 10 | 3 | 8 | 58 | 1 | |||
| 152145 | 247569 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Alemany Blvd | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.412460251663 | (37.7340198862064, -122.412460251663) | 10 | 7 | 7 | 28859 | 2 | |||
| 154474 | 237028 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 9 | : | Tree | DPW 1 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | 7 | 9 | 11 | 28852 | 10 | ||
| 162131 | 197119 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 309 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014067.1485 | 2105627.53504 | 37.7624431150761 | -122.394476761399 | (37.7624431150761, -122.394476761399) | 10 | 3 | 8 | 28856 | 29 | |||
| 167220 | 247563 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 316 Alemany Blvd | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.7342387227265 | -122.412013774222 | (37.7342387227265, -122.412013774222) | 10 | 7 | 7 | 28859 | 2 | |||
| 173937 | 197122 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 4 | : | Tree | Private 2 | 5 | Width 4ft | 6013973.73168 | 2100142.08459 | 37.7473760542581 | -122.394415755007 | (37.7473760542581, -122.394415755007) | 10 | 3 | 8 | 58 | 1 | |||
| 175370 | 197130 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 16 | : | Tree | Private 2 | 5 | Width 3ft | 6015893.18708 | 2097747.64492 | 37.7409079313583 | -122.387611324313 | (37.7409079313583, -122.387611324313) | 10 | 3 | 8 | 58 | 1 | |||
| 175567 | 197117 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 315 Texas St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013789.95131 | 2105605.10268 | 37.7623661070381 | -122.395433919764 | (37.7623661070381, -122.395433919764) | 10 | 3 | 8 | 28856 | 29 | |||
| 182772 | 247566 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 318 Alemany Blvd | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6008741.21767 | 2095435.43504 | 37.7341603621059 | -122.412176898651 | (37.7341603621059, -122.412176898651) | 10 | 7 | 7 | 28859 | 2 | |||
| 185801 | 197135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Newhall St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015262.92854 | 2096819.74111 | 37.7383251674823 | -122.389725749154 | (37.7383251674823, -122.389725749154) | 10 | 3 | 8 | 58 | 1 | |||
| 16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
| 89508 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 401X Newhall St | 1 | Front Yard : | Tree | Private 2 | 6 | 3x3 | 6016081.14502 | 2097910.94016 | 37.7413667159929 | -122.386972815546 | (37.7413667159929, -122.386972815546) | 10 | 3 | 8 | 58 | 1 | |||
| 132540 | 87073 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 4 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 134671 | 87072 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 3 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 39382 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
| 78664 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
| 90740 | 112843 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1415 EVANS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016481 | 2097724 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | 10 | 3 | 8 | 58 | 1 | |||||
| 129559 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 766 Anderson St | Front Yard : Yard | Tree | Private 2 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723 | 2095324 | 37.7337971999422 | -122.415689321062 | (37.7337971999422, -122.415689321062) | 2 | 7 | 7 | 28859 | 2 | |||
| 151874 | 249824 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Kearny St | 6 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010866.76079 | 2120642.67591 | 37.8034927229673 | -122.40660393394 | (37.8034927229673, -122.40660393394) | 3 | 1 | 10 | 308 | 23 | |||
| 152541 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
| 191414 | 247591 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 800 Tompkins Ave | 12 | Front Yard : Yard | Tree | Private 2 | 10 | 6008974.65943 | 2096434.52097 | 37.7369167320297 | -122.411440373668 | (37.7369167320297, -122.411440373668) | 10 | 7 | 7 | 28859 | 2 | ||||
| 86813 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1753 Noe St | 1 | Hanging basket : Yard | Tree | Private 2 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | 2 | 7 | 5 | 63 | 7 | |||
| 49154 | 87400 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 87382 | 16010 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 2 | 4 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | |||
| 88049 | 87399 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 105100 | 26760 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 930X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5995872.4804074 | 2094645.0571617 | 37.731259698358 | -122.456610772668 | (37.731259698358, -122.456610772668) | 9 | 7 | 4 | 59 | 40 | ||
| 108418 | 16156 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | |||
| 140866 | 27681 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | |||
| 151311 | 16159 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | |||
| 154177 | 16331 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 800X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996797.9550648 | 2094752.6454838 | 37.7316082025531 | -122.453419021963 | (37.7316082025531, -122.453419021963) | 9 | 7 | 4 | 59 | 40 | ||
| 162505 | 16161 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 7 | Median : Cutout | Tree | DPW 1 | 04/06/1998 12:00:00 AM | 3 | G | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | ||
| 168120 | 87401 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 11 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
| 381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
| 611 | 10613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.5018076 | 2095595.9312574 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | 10 | 3 | 8 | 58 | 1 | ||
| 670 | 197144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.7173688854414 | -122.397447893917 | (37.7173688854414, -122.397447893917) | 10 | 3 | 8 | 58 | 1 | |||
| 691 | 199940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | 10 | 3 | 8 | 58 | 1 | |||
| 737 | 8938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4649X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5992558.61151 | 2112698.79101 | 37.7806397269512 | -122.469380940837 | (37.7806397269512, -122.469380940837) | 11 | 6 | 2 | 54 | 11 | |||
| 810 | 75303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.406566076957 | (37.7648621726769, -122.406566076957) | 8 | 4 | 8 | 28853 | 19 | |||
| 971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
| 1044 | 139272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 765 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004185.2644 | 2111476.3212 | 37.7779481591061 | -122.429071593475 | (37.7779481591061, -122.429071593475) | 7 | 9 | 11 | 28852 | 10 | |||
| 1241 | 140612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917235 | -122.431458329369 | (37.777573917235, -122.431458329369) | 7 | 9 | 11 | 29492 | 10 | |||
| 1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
| 1294 | 136237 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | |||
| 1330 | 239316 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | 2 | 4 | 7 | 28859 | 19 | |||
| 1477 | 112866 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990595 | 2097751 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | 1 | 8 | 4 | 29491 | 40 | ||||
| 1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
| 1561 | 24107 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
| 1601 | 39981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935122 | (37.7325519363025, -122.39310935122) | 10 | 3 | 8 | 58 | 1 | |
| 1699 | 5933 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
| 1758 | 73714 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012133.53509 | 2102840.64813 | 37.7546832563417 | -122.400968639917 | (37.7546832563417, -122.400968639917) | 10 | 3 | 8 | 28856 | 29 | |||
| 1920 | 213973 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995027.24606 | 2091045.40909 | 37.7213273674346 | -122.459272306869 | (37.7213273674346, -122.459272306869) | 9 | 8 | 6 | 28861 | 24 | |||
| 1933 | 193325 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015584.15702 | 2102639.39931 | 37.7543225481714 | -122.389021302106 | (37.7543225481714, -122.389021302106) | 10 | 3 | 8 | 28856 | 29 | |||
| 2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
| 2159 | 23089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1992 12:00:00 AM | 3 | 3X3 | 6006386.45124 | 2101639.17827 | 37.751062036612 | -122.420758355385 | (37.751062036612, -122.420758355385) | 2 | 4 | 5 | 28859 | 19 | ||
| 2453 | 49617 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
| 2522 | 239885 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007768.4049 | 2096536.44279 | 37.7371288550961 | -122.415618157155 | (37.7371288550961, -122.415618157155) | 2 | 7 | 7 | 28859 | 2 | |||
| 2567 | 239301 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1277 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010336.55809 | 2101801.57143 | 37.7517297793105 | -122.407109863745 | (37.7517297793105, -122.407109863745) | 10 | 4 | 7 | 28859 | 19 | |||
| 2641 | 262546 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Apollo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 6012643 | 2094250 | 37.731123564074 | -122.398603958182 | (37.731123564074, -122.398603958182) | 10 | 3 | 8 | 58 | 1 | |||
| 2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
| 2769 | 81793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.423593274768 | (37.7767477786156, -122.423593274768) | 7 | 9 | 11 | 28852 | 10 | ||
| 2819 | 70680 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | 8 | 4 | 8 | 28853 | 19 | |||
| 3017 | 136252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006854.74284 | 2121556.78092 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | 5 | 1 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );