Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164981 | 164981 | 197167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6017931.28632 | 2093542.2184 | 37.729473341113895 | -122.380272067717 | (37.7294733411139, -122.380272067717) | |||
| 84362 | 84362 | 85635 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017893.31364 | 2092631.421507 | 37.7269703746724 | -122.38034007025401 | (37.7269703746724, -122.380340070254) | ||
| 49202 | 49202 | 197168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017908.19776 | 2093591.9406 | 37.729608594643004 | -122.38035534224899 | (37.729608594643, -122.380355342249) | |||
| 161134 | 161134 | 199943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | |||
| 35501 | 35501 | 197166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017812.186480001 | 2093598.1535200002 | 37.729620355985205 | -122.380687698389 | (37.7296203559852, -122.380687698389) | |||
| 123953 | 123953 | 1701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761566999 | 2093643.6318374001 | 37.7297441585391 | -122.38075801318199 | (37.7297441585391, -122.380758013182) | ||
| 122622 | 122622 | 1699 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1999 12:00:00 AM | 3 | 3X3 | 6017775.3254178 | 2093648.0174938 | 37.7297552383916 | -122.380818597255 | (37.7297552383916, -122.380818597255) | ||
| 97591 | 97591 | 1700 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 43 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 6 | 3X3 | 6017768.2322395 | 2093598.2442303002 | 37.7296181792492 | -122.380839660676 | (37.7296181792492, -122.380839660676) | ||
| 16510 | 16510 | 85610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1132 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017745.1516 | 2092811.7191 | 37.727457260594704 | -122.38086479752899 | (37.7274572605947, -122.380864797529) | ||
| 88473 | 88473 | 1698 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6017750.796090401 | 2093602.6298867 | 37.72962925906 | -122.380900244658 | (37.72962925906, -122.380900244658) | ||
| 129542 | 129542 | 199942 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1151 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017725.4053 | 2092742.7421 | 37.7272667732913 | -122.38092826799401 | (37.7272667732913, -122.380928267994) | |||
| 15328 | 15328 | 85611 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1150 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017700.249 | 2092841.4739 | 37.7275364831055 | -122.381022095395 | (37.7275364831055, -122.381022095395) | ||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
| 75609 | 75609 | 38463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.727590590458604 | -122.38112356357 | (37.7275905904586, -122.38112356357) | ||
| 108331 | 108331 | 1688 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1993 12:00:00 AM | 6 | 3X3 | 6017679.592279 | 2093598.3775556 | 37.7296136527509 | -122.381146110708 | (37.7296136527509, -122.381146110708) | ||
| 84224 | 84224 | 1689 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 03:07:00 PM | 3 | 3X3 | 6017662.008057199 | 2093645.2163419998 | 37.729741292224205 | -122.381210157278 | (37.7297412922242, -122.381210157278) | ||
| 138771 | 138771 | 199941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017637.7639999995 | 2092806.0386 | 37.7274357354826 | -122.38123564590401 | (37.7274357354826, -122.381235645904) | |||
| 128443 | 128443 | 85636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017631.370144 | 2092826.6872430001 | 37.727492079674896 | -122.381259184857 | (37.7274920796749, -122.381259184857) | ||
| 96513 | 96513 | 85612 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017578.234449 | 2092916.188247 | 37.7277348985577 | -122.381449098373 | (37.7277348985577, -122.381449098373) | ||
| 136478 | 136478 | 199940 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | |||
| 116614 | 116614 | 85637 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017561.518521 | 2092878.7581240002 | 37.7276311998388 | -122.381504284348 | (37.7276311998388, -122.381504284348) | ||
| 14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
| 92125 | 92125 | 85615 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017380.895351999 | 2093063.294675 | 37.7281279271047 | -122.38214153905899 | (37.7281279271047, -122.382141539059) | ||
| 165380 | 165380 | 85614 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 5 | 3x3 | 6017331.5604 | 2093113.8652 | 37.728264058993396 | -122.382315610259 | (37.7282640589934, -122.382315610259) | ||
| 16538 | 16538 | 85640 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017322.9044 | 2093043.5358 | 37.7280704700942 | -122.382340643729 | (37.7280704700942, -122.382340643729) | ||
| 16642 | 16642 | 85639 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017307.7565 | 2093058.1427 | 37.7281097410693 | -122.382394026885 | (37.7281097410693, -122.382394026885) | ||
| 135819 | 135819 | 197165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017366.51517 | 2096051.5594799998 | 37.7363323183867 | -122.382399074074 | (37.7363323183867, -122.382399074074) | |||
| 95631 | 95631 | 18654 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 125389 | 125389 | 18655 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 16579 | 16579 | 85638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017293.1497 | 2093067.8806 | 37.728135672587904 | -122.382445200849 | (37.7281356725879, -122.382445200849) | ||
| 88760 | 88760 | 18652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 80 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 6017340.7956251 | 2096041.6846083999 | 37.7363037832445 | -122.38248731128701 | (37.7363037832445, -122.382487311287) | |||
| 14255 | 14255 | 85641 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017274.7558 | 2093081.4055 | 37.72817179324429 | -122.382509730509 | (37.7281717932443, -122.382509730509) | ||
| 82778 | 82778 | 18650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017333.617127299 | 2096134.4813376998 | 37.736558188021704 | -122.38251858534201 | (37.7365581880217, -122.382518585342) | ||
| 107927 | 107927 | 18649 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 70 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1999 12:00:00 AM | 3 | 3X4 | 6017298.515724 | 2096054.3606827 | 37.7363362535881 | -122.382634373709 | (37.7363362535881, -122.382634373709) | ||
| 119720 | 119720 | 85642 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1227 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017224.2236089995 | 2093130.194602 | 37.7283029670068 | -122.38268781752501 | (37.7283029670068, -122.382687817525) | ||
| 25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
| 169823 | 169823 | 197148 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017233.106869999 | 2094952.3109 | 37.7333066302946 | -122.382783854412 | (37.7333066302946, -122.382783854412) | |||
| 13802 | 13802 | 85643 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.38287210620199 | (37.7283695937915, -122.382872106202) | ||
| 33109 | 33109 | 197147 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017204.67342 | 2094944.70699 | 37.7332841805136 | -122.38288162868099 | (37.7332841805136, -122.382881628681) | |||
| 183412 | 183412 | 197149 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017152.11734 | 2094978.18509 | 37.7333732007951 | -122.38306566055401 | (37.7333732007951, -122.383065660554) | |||
| 98845 | 98845 | 18641 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2000 12:00:00 AM | 3 | 3X4 | 6017167.4480367005 | 2096189.4017781997 | 37.7366998078586 | -122.38309692991999 | (37.7366998078586, -122.38309692992) | ||
| 16358 | 16358 | 85616 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1258 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017082.7023 | 2093297.2628 | 37.7287538840188 | -122.383188691469 | (37.7287538840188, -122.383188691469) | ||
| 171836 | 171836 | 197146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017111.39408 | 2094922.05635 | 37.733216832081396 | -122.383202548153 | (37.7332168320814, -122.383202548153) | |||
| 104613 | 104613 | 18637 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
| 113449 | 113449 | 18638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
| 38430 | 38430 | 197164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017108.5730800005 | 2096118.78323 | 37.7365026499645 | -122.383295574057 | (37.7365026499645, -122.383295574057) | |||
| 161550 | 161550 | 199972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017032.2494 | 2092637.585 | 37.7269397498685 | -122.38331721142401 | (37.7269397498685, -122.383317211424) | |||
| 110618 | 110618 | 18636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2000 12:00:00 AM | 3 | 3X3 | 6017095.3922155 | 2096110.4018038001 | 37.736478907812 | -122.38334056309999 | (37.736478907812, -122.3833405631) | ||
| 128586 | 128586 | 18635 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 0 | 3X3 | 6017095.3922155 | 2096110.4018038001 | 37.736478907812 | -122.38334056309999 | (37.736478907812, -122.3833405631) | ||
| 83510 | 83510 | 18634 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017078.2420673 | 2096202.8624203 | 37.736731838359795 | -122.383406293435 | (37.7367318383598, -122.383406293435) | ||
| 149879 | 149879 | 197163 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017071.14695 | 2096120.91017 | 37.7365064217414 | -122.383425121372 | (37.7365064217414, -122.383425121372) | |||
| 13415 | 13415 | 85617 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | ||
| 15002 | 15002 | 85644 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1275 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016975.0441 | 2093297.8038 | 37.728749419657 | -122.383560914081 | (37.728749419657, -122.383560914081) | ||
| 60939 | 60939 | 197154 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 18 Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017001.63224 | 2095478.16332 | 37.734737725070204 | -122.383620731122 | (37.7347377250702, -122.383620731122) | |||
| 97607 | 97607 | 4924 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 195X Newhall St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 9083 | 9083 | 10613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.501807599 | 2095595.9312573997 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | ||
| 164209 | 164209 | 197155 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 36 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016950.769830001 | 2095599.6717299998 | 37.73506855147429 | -122.38380503909401 | (37.7350685514743, -122.383805039094) | |||
| 13377 | 13377 | 10610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6016939.384330001 | 2095525.0457799998 | 37.7348630141201 | -122.38383920883801 | (37.7348630141201, -122.383839208838) | ||
| 9296 | 9296 | 11461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1992 12:00:00 AM | 12 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 105262 | 105262 | 11462 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/1992 12:00:00 AM | 6 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 13999 | 13999 | 10614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2001 12:00:00 AM | 3 | 3X3 | 6016916.49156 | 2095577.9947400002 | 37.7350071358711 | -122.383922043589 | (37.7350071358711, -122.383922043589) | ||
| 152226 | 152226 | 197145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6016890.6542 | 2094912.19179 | 37.7331775451961 | -122.38396502668199 | (37.7331775451961, -122.383965026682) | |||
| 14210 | 14210 | 11472 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6016881.34744 | 2095602.56066 | 37.7350726460825 | -122.384045260583 | (37.7350726460825, -122.384045260583) | |||
| 15393 | 15393 | 11470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6016849.3995 | 2095607.3792400002 | 37.7350841106266 | -122.38415605258001 | (37.7350841106266, -122.38415605258) | |||
| 15847 | 15847 | 11469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 9 | 3X3 | 6016835.012019999 | 2095606.77415 | 37.735081653692 | -122.38420575361401 | (37.735081653692, -122.384205753614) | ||
| 15074 | 15074 | 11468 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.735066095427705 | -122.384265809434 | (37.7350660954277, -122.384265809434) | ||
| 16554 | 16554 | 85618 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1314 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016773.2527 | 2093530.9730000002 | 37.729378500955896 | -122.384274758873 | (37.7293785009559, -122.384274758873) | ||
| 14147 | 14147 | 11467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.1573400002 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | ||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 14099 | 14099 | 11466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.967569999 | 2095560.66167 | 37.73495227093311 | -122.384375566285 | (37.7349522709331, -122.384375566285) | ||
| 9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
| 180496 | 180496 | 197133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016812.9341400005 | 2098272.11729 | 37.742398928158295 | -122.384467670355 | (37.7423989281583, -122.384467670355) | |||
| 144773 | 144773 | 16496 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016807.79285 | 2098273.5495599997 | 37.7424025765764 | -122.384485547297 | (37.7424025765764, -122.384485547297) | ||
| 107005 | 107005 | 16495 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016789.27845 | 2098277.7028 | 37.7424129566932 | -122.384549854363 | (37.7424129566932, -122.384549854363) | ||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 9215 | 9215 | 10617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 74 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1992 12:00:00 AM | 6 | 3X3 | 6016731.0735863 | 2095616.8317798001 | 37.7351035225916 | -122.38456580983299 | (37.7351035225916, -122.384565809833) | ||
| 168340 | 168340 | 197156 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 70 Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016728.211 | 2095612.50382 | 37.73509148057529 | -122.38457540555001 | (37.7350914805753, -122.38457540555) | |||
| 175020 | 175020 | 197153 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016721.84036 | 2095568.4819 | 37.734970252878796 | -122.384594365947 | (37.7349702528788, -122.384594365947) | |||
| 16855 | 16855 | 85645 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1313 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016677.8494 | 2093524.29 | 37.7293548752151 | -122.384604114815 | (37.7293548752151, -122.384604114815) | ||
| 97346 | 97346 | 16494 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016769.452380001 | 2098282.55627 | 37.7424251869258 | -122.384618745617 | (37.7424251869258, -122.384618745617) | ||
| 49322 | 49322 | 197128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016765.196409999 | 2098282.20265 | 37.7424239805909 | -122.384633436999 | (37.7424239805909, -122.384633436999) | |||
| 77015 | 77015 | 197152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016707.19345 | 2095564.5930700002 | 37.734958764918396 | -122.384644735176 | (37.7349587649184, -122.384644735176) | |||
| 13371 | 13371 | 24145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | |||
| 14904 | 14904 | 24147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | |||
| 13600 | 13600 | 85619 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.729628945087704 | -122.384695012523 | (37.7296289450877, -122.384695012523) | ||
| 183028 | 183028 | 197134 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016745.12895 | 2098337.97655 | 37.7425760145669 | -122.38470670927299 | (37.7425760145669, -122.384706709273) | |||
| 61184 | 61184 | 197150 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 102 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016678.04362 | 2095528.85162 | 37.7348590139212 | -122.38474302838999 | (37.7348590139212, -122.38474302839) | |||
| 13554 | 13554 | 85620 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | ||
| 14204 | 14204 | 85646 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1321 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016609.4363 | 2093572.233 | 37.7294827335965 | -122.38484396608999 | (37.7294827335965, -122.38484396609) | ||
| 54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
| 64108 | 64108 | 83143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 1 | 6016637.512159999 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | ||
| 15041 | 15041 | 24179 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 5x3 | 6016625.58798 | 2095312.02915 | 37.7342607615082 | -122.38490928693199 | (37.7342607615082, -122.384909286932) | ||
| 14061 | 14061 | 24180 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6016621.33395 | 2095295.74377 | 37.7342158098126 | -122.384922860422 | (37.7342158098126, -122.384922860422) | |||
| 14634 | 14634 | 24178 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 4 | 4x3 | 6016619.186290001 | 2095310.93644 | 37.7342574070589 | -122.384931343733 | (37.7342574070589, -122.384931343733) | ||
| 9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
| 15458 | 15458 | 85621 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1356 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016575.2959 | 2093679.014 | 37.7297740447744 | -122.38496943038601 | (37.7297740447744, -122.384969430386) | ||
| 33428 | 33428 | 197157 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016598.7871900005 | 2095669.6865 | 37.7352413346217 | -122.385026857123 | (37.7352413346217, -122.385026857123) | |||
| 13961 | 13961 | 85647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1351 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016557.1838 | 2093613.7118 | 37.7295937360014 | -122.385027498588 | (37.7295937360014, -122.385027498588) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");