trees
331 rows where qSpecies_id = 166 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26681 | 178114 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 251 De Long St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993733.77465 | 2086791.33154 | 37.709572236344 | -122.463434879221 | (37.709572236344, -122.463434879221) | 9 | 8 | 6 | 28861 | 25 | |||
| 90116 | 178121 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1186 Munich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001045.2474 | 2087209.5115 | 37.7111390073292 | -122.438195159605 | (37.7111390073292, -122.438195159605) | 9 | 7 | 6 | 28861 | 5 | |||
| 107110 | 178115 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 47 Payson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991818.21291 | 2087759.03799 | 37.7121187737221 | -122.470125748026 | (37.7121187737221, -122.470125748026) | 9 | 8 | 4 | 64 | 24 | |||
| 36709 | 178111 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 200 Morse St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6000616.29497 | 2087881.86398 | 37.712960731619 | -122.439725892934 | (37.712960731619, -122.439725892934) | 9 | 7 | 6 | 28861 | 5 | |||
| 57825 | 178110 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 200 Morse St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000629.25093 | 2087886.03147 | 37.712972912055 | -122.439681411561 | (37.712972912055, -122.439681411561) | 9 | 7 | 6 | 28861 | 5 | |||
| 1409 | 178109 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 200 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6000643.20698 | 2087890.67148 | 37.7129864468306 | -122.439633507395 | (37.7129864468306, -122.439633507395) | 9 | 7 | 6 | 28861 | 5 | |||
| 97220 | 178108 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 200 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000658.1626 | 2087895.78339 | 37.7130013342097 | -122.439582182182 | (37.7130013342097, -122.439582182182) | 9 | 7 | 6 | 28861 | 5 | |||
| 34337 | 210951 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 82 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5992475.08919 | 2088464.23706 | 37.7140930338539 | -122.467906672658 | (37.7140930338539, -122.467906672658) | 9 | 8 | 6 | 64 | 24 | |||
| 143715 | 210952 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 82 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992474.65853 | 2088476.64416 | 37.7141270758919 | -122.467909063055 | (37.7141270758919, -122.467909063055) | 9 | 8 | 6 | 64 | 24 | |||
| 78409 | 210953 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 82 Vernon St | 5 | : | Tree | Private 2 | 5 | Width 2ft | 5992464.38924 | 2088481.68139 | 37.7141403138917 | -122.467944923523 | (37.7141403138917, -122.467944923523) | 9 | 8 | 6 | 64 | 24 | |||
| 180498 | 210945 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5996140.80305 | 2088701.93983 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | 9 | 8 | 6 | 28861 | 24 | ||||
| 38104 | 210946 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 78 Lobos St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5996128.66217 | 2088702.9665 | 37.714958832754 | -122.455295843853 | (37.714958832754, -122.455295843853) | 9 | 8 | 6 | 28861 | 24 | ||||
| 171529 | 210947 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 171 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992177.81487 | 2089015.33856 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | 9 | 8 | 6 | 64 | 24 | |||
| 180357 | 15063 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1X Minerva St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5995983.74533 | 2089004.6361 | 37.7157788310068 | -122.455818528899 | (37.7157788310068, -122.455818528899) | 9 | 8 | 6 | 28861 | 24 | |||
| 109791 | 210944 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 471 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994007.18286 | 2089638.21665 | 37.7174048556293 | -122.462696322689 | (37.7174048556293, -122.462696322689) | 9 | 8 | 6 | 64 | 24 | |||
| 167586 | 178118 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988803.05395 | 2089760.98409 | 37.7174408474004 | -122.480693357611 | (37.7174408474004, -122.480693357611) | 1 | 8 | 4 | 64 | 14 | ||||
| 69616 | 178117 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988789.57342 | 2089765.12974 | 37.7174514468002 | -122.480740256365 | (37.7174514468002, -122.480740256365) | 1 | 8 | 4 | 64 | 14 | ||||
| 191812 | 178116 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988774.08393 | 2089765.94009 | 37.7174527715132 | -122.480793855056 | (37.7174527715132, -122.480793855056) | 1 | 8 | 4 | 64 | 14 | ||||
| 107067 | 45330 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 471 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44163 | 5993999.8706027 | 2089674.33515151 | 37.7175036072534 | -122.462724216271 | (37.7175036072534, -122.462724216271) | 9 | 8 | 6 | 64 | 24 | ||
| 140740 | 210943 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 901 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995890.03888 | 2089972.39061 | 37.718430679009 | -122.456212350133 | (37.718430679009, -122.456212350133) | 9 | 8 | 6 | 28861 | 24 | |||
| 70555 | 210942 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 901 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995890.68132 | 2090003.12019 | 37.7185150920717 | -122.456212350116 | (37.7185150920717, -122.456212350116) | 9 | 8 | 6 | 28861 | 24 | |||
| 114291 | 210941 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 901 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995891.34278 | 2090020.28633 | 37.718562264216 | -122.456211304216 | (37.718562264216, -122.456211304216) | 9 | 8 | 6 | 28861 | 24 | |||
| 3518 | 70351 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 427 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003975.14457 | 2089961.04418 | 37.7188603202322 | -122.428264690885 | (37.7188603202322, -122.428264690885) | 9 | 7 | 6 | 28861 | 5 | |||
| 39170 | 210950 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 454 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 6ft | 5993793.80309 | 2090199.81591 | 37.7189345808405 | -122.463474604969 | (37.7189345808405, -122.463474604969) | 9 | 8 | 6 | 64 | 24 | |||
| 111872 | 210940 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 71 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994126.22956 | 2090303.05992 | 37.7192372117057 | -122.462333029842 | (37.7192372117057, -122.462333029842) | 9 | 8 | 6 | 28861 | 24 | |||
| 34800 | 210939 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 73 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994126.41089 | 2090335.91077 | 37.719327422704 | -122.462334784419 | (37.719327422704, -122.462334784419) | 9 | 8 | 6 | 28861 | 24 | |||
| 123845 | 44381 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 71 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2002 12:00:00 AM | Permit Number 45656 | 5994124.44612639 | 2090395.30324918 | 37.7194903870698 | -122.462345881218 | (37.7194903870698, -122.462345881218) | 9 | 8 | 6 | 28861 | 24 | ||
| 154993 | 45308 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 73 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2001 12:00:00 AM | Permit Number 44146 | 5994124.56129727 | 2090407.79680159 | 37.7195246979994 | -122.462346388785 | (37.7195246979994, -122.462346388785) | 9 | 8 | 6 | 28861 | 24 | ||
| 80504 | 45316 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 739 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44153 | 5992112.57362646 | 2090471.95346901 | 37.719584794705 | -122.46930570018 | (37.719584794705, -122.46930570018) | 9 | 8 | 6 | 64 | 24 | ||
| 173756 | 210949 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 521 Victoria St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5993238.50439 | 2090644.65607 | 37.7201239945015 | -122.465426336151 | (37.7201239945015, -122.465426336151) | 9 | 8 | 6 | 64 | 24 | |||
| 154827 | 210938 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 140 Jules Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994485.61815 | 2090821.98023 | 37.7206827307129 | -122.461128361887 | (37.7206827307129, -122.461128361887) | 9 | 8 | 6 | 28861 | 24 | |||
| 181209 | 210948 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 466 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992243.02346 | 2090933.92849 | 37.7208608027661 | -122.468888386993 | (37.7208608027661, -122.468888386993) | 9 | 8 | 6 | 64 | 24 | |||
| 100098 | 30932 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 507 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 4 | Permit Number 34745 | 5995284.50806 | 2091206.784 | 37.7217852518603 | -122.458394705264 | (37.7217852518603, -122.458394705264) | 9 | 8 | 6 | 28861 | 24 | |
| 111444 | 210937 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 200 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996251.40401 | 2091280.47926 | 37.7220431189884 | -122.455057739344 | (37.7220431189884, -122.455057739344) | 9 | 8 | 4 | 28861 | 24 | |||
| 57143 | 40741 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 60 Alviso St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1999 12:00:00 AM | Permit Number 41718 | 5992200.51411552 | 2091694.39813825 | 37.7229464099622 | -122.469090645099 | (37.7229464099622, -122.469090645099) | 9 | 8 | 4 | 59 | 40 | |||
| 184467 | 178119 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 463 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007549.64537 | 2091584.69252 | 37.7235201223396 | -122.416023942951 | (37.7235201223396, -122.416023942951) | 9 | 3 | 7 | 309 | 28 | |||
| 188193 | 178120 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007489.47996 | 2091618.13072 | 37.7236085535687 | -122.416234291698 | (37.7236085535687, -122.416234291698) | 9 | 3 | 7 | 309 | 28 | |||
| 119179 | 40793 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 456 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41742 | 5992180.76921934 | 2091949.45696534 | 37.7236455979149 | -122.469177453156 | (37.7236455979149, -122.469177453156) | 9 | 8 | 4 | 59 | 40 | ||
| 127289 | 40755 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 128 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41724 | 5993008.60966906 | 2092048.1240652 | 37.723964314455 | -122.46632294355 | (37.723964314455, -122.46632294355) | 9 | 8 | 4 | 59 | 40 | ||
| 158429 | 40754 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 128 Corona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41724 | 5993008.60966906 | 2092048.1240652 | 37.723964314455 | -122.46632294355 | (37.723964314455, -122.46632294355) | 9 | 8 | 4 | 59 | 40 | ||
| 132999 | 178099 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 475 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009870.22482 | 2092198.24037 | 37.7253349956071 | -122.408045327735 | (37.7253349956071, -122.408045327735) | 10 | 3 | 7 | 309 | 28 | |||
| 42953 | 178100 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009850.68827 | 2092261.77394 | 37.7255083516043 | -122.408117342734 | (37.7255083516043, -122.408117342734) | 10 | 3 | 7 | 309 | 28 | |||
| 99203 | 178101 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009849.55094 | 2092272.62028 | 37.7255380696985 | -122.408122039001 | (37.7255380696985, -122.408122039001) | 10 | 3 | 7 | 309 | 28 | |||
| 185539 | 178102 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009843.47083 | 2092285.37144 | 37.7255727412698 | -122.408143956404 | (37.7255727412698, -122.408143956404) | 10 | 3 | 7 | 309 | 28 | |||
| 77609 | 178103 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009835.80068 | 2092308.97785 | 37.7256371300447 | -122.408172135737 | (37.7256371300447, -122.408172135737) | 10 | 3 | 7 | 309 | 28 | |||
| 79405 | 178104 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009831.59561 | 2092324.84748 | 37.725680469262 | -122.408187791139 | (37.725680469262, -122.408187791139) | 10 | 3 | 7 | 309 | 28 | |||
| 101821 | 178105 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009827.37216 | 2092339.81548 | 37.7257213317608 | -122.408203446535 | (37.7257213317608, -122.408203446535) | 10 | 3 | 7 | 309 | 28 | |||
| 167202 | 43262 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 449 Holyoke St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
| 37281 | 178106 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009819.25849 | 2092363.88194 | 37.7257869588856 | -122.408233191632 | (37.7257869588856, -122.408233191632) | 10 | 3 | 7 | 309 | 28 | |||
| 65794 | 37767 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 125876 | 37766 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 141478 | 37768 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 161644 | 37769 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 185781 | 37765 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 91582 | 178125 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 753 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6001422.11728 | 2092653.05494 | 37.7261071849737 | -122.437282130958 | (37.7261071849737, -122.437282130958) | 9 | 7 | 6 | 28861 | 25 | |||
| 140894 | 178107 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 409 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009776.35122 | 2092502.75191 | 37.7261658639547 | -122.408391310431 | (37.7261658639547, -122.408391310431) | 10 | 3 | 7 | 309 | 28 | |||
| 42929 | 178112 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 557 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009785.47339 | 2092559.58187 | 37.7263224179212 | -122.408363782157 | (37.7263224179212, -122.408363782157) | 10 | 3 | 7 | 309 | 28 | |||
| 169609 | 178113 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 557 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009795.00603 | 2092562.31425 | 37.7263304542784 | -122.408331020778 | (37.7263304542784, -122.408331020778) | 10 | 3 | 7 | 309 | 28 | |||
| 36160 | 48578 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 600 Beacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2002 12:00:00 AM | Permit Number 45891 | 6009717.95437721 | 2092589.77747592 | 37.7264015474603 | -122.408599322266 | (37.7264015474603, -122.408599322266) | 10 | 3 | 7 | 309 | 28 | |||
| 166519 | 37797 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 407 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 1 | Permit Number 40124 | 6010065.36404 | 2092583.86022 | 37.7264047508705 | -122.407397920192 | (37.7264047508705, -122.407397920192) | 10 | 3 | 7 | 309 | 28 | |
| 108156 | 37796 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 407 Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 7 | Permit Number 40124 | 6010061.01823 | 2092600.5122 | 37.7264502304769 | -122.407414116969 | (37.7264502304769, -122.407414116969) | 10 | 3 | 7 | 309 | 28 | |
| 152702 | 68362 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 536 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1993 12:00:00 AM | 4 | Permit Number 32183 | 6009840.43675 | 2092622.33967 | 37.7264978154083 | -122.408178199862 | (37.7264978154083, -122.408178199862) | 10 | 3 | 7 | 309 | 28 | |
| 87283 | 40750 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 50 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41721 | 5992599.375194 | 2093012.15972087 | 37.7265876981878 | -122.467807672314 | (37.7265876981878, -122.467807672314) | 9 | 8 | 4 | 59 | 40 | ||
| 54364 | 210968 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 11 Manor Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993371.33986 | 2093065.25444 | 37.7267780288588 | -122.465142895042 | (37.7267780288588, -122.465142895042) | 9 | 8 | 4 | 59 | 40 | |||
| 21082 | 178126 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 71 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6004930.04073 | 2092988.42256 | 37.7272268238432 | -122.425179289615 | (37.7272268238432, -122.425179289615) | 9 | 7 | 6 | 28861 | 5 | ||||
| 100534 | 37781 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 274 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 6 | Permit Number 40116 | 6009257.34688 | 2093021.85403 | 37.7275621306623 | -122.410222120555 | (37.7275621306623, -122.410222120555) | 9 | 3 | 7 | 309 | 28 | |
| 129354 | 68093 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 90 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 3 | Permit Number 31837 | 6000727.60055 | 2093275.1865 | 37.7277759094216 | -122.439727611555 | (37.7277759094216, -122.439727611555) | 9 | 7 | 6 | 28861 | 25 | |
| 29779 | 178122 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 96 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000711.67641 | 2093287.85237 | 37.7278097805844 | -122.439783569175 | (37.7278097805844, -122.439783569175) | 9 | 7 | 6 | 28861 | 25 | |||
| 165657 | 27311 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2660 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2000 12:00:00 AM | 4 | 1x1 | 6011096.5026246 | 2093175.2702825 | 37.7280862997813 | -122.403874899606 | (37.7280862997813, -122.403874899606) | 10 | 3 | 7 | 309 | 28 | ||
| 85510 | 210936 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 147 Edna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 5998728.75297 | 2093448.46825 | 37.7281377246652 | -122.446650099831 | (37.7281377246652, -122.446650099831) | 9 | 7 | 4 | 28861 | 40 | |||
| 57120 | 210956 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 231 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998549.59415 | 2093771.86816 | 37.7290154692857 | -122.447292722094 | (37.7290154692857, -122.447292722094) | 9 | 7 | 4 | 28861 | 40 | ||||
| 39494 | 210982 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995118.54931 | 2093932.6722 | 37.7292603465805 | -122.459165665284 | (37.7292603465805, -122.459165665284) | 9 | 7 | 4 | 28861 | 40 | |||
| 171363 | 210983 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995109.5477 | 2093940.82362 | 37.7292822109006 | -122.459197374461 | (37.7292822109006, -122.459197374461) | 9 | 7 | 4 | 28861 | 40 | |||
| 129813 | 210984 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995106.2955 | 2093942.76552 | 37.7292873559157 | -122.459208758092 | (37.7292873559157, -122.459208758092) | 9 | 7 | 4 | 28861 | 40 | |||
| 18902 | 210985 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995102.57343 | 2093944.71693 | 37.7292925000285 | -122.459221766785 | (37.7292925000285, -122.459221766785) | 9 | 7 | 4 | 28861 | 40 | |||
| 84112 | 210986 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995099.57616 | 2093947.59024 | 37.7293002171239 | -122.45923233653 | (37.7293002171239, -122.45923233653) | 9 | 7 | 4 | 28861 | 40 | |||
| 1056 | 210964 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995081.73888 | 2093960.6107 | 37.7293349426397 | -122.459294943706 | (37.7293349426397, -122.459294943706) | 9 | 7 | 4 | 28861 | 40 | |||
| 148160 | 210967 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 4 | Width 3ft | Permit Number 32251 | 5992728.19812 | 2094135.00675 | 37.7296781967805 | -122.467443955276 | (37.7296781967805, -122.467443955276) | 9 | 8 | 4 | 59 | 40 | |
| 96238 | 194413 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 98 Ceres St | 3 | : | Tree | Private 2 | 5 | Width 1ft | 6013801.43313 | 2093700.7478 | 37.7296799009949 | -122.394560576406 | (37.7296799009949, -122.394560576406) | 10 | 3 | 8 | 58 | 1 | |||
| 38619 | 194412 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 98 Ceres St | 2 | : | Tree | Private 2 | 2 | Width 1ft | 6013804.87459 | 2093712.07344 | 37.729711190223 | -122.394549471574 | (37.729711190223, -122.394549471574) | 10 | 3 | 8 | 58 | 1 | |||
| 121658 | 194411 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 98 Ceres St | 1 | : | Tree | Private 2 | 1 | Width 1ft | 6013808.40909 | 2093727.99468 | 37.729755103205 | -122.394538366753 | (37.729755103205, -122.394538366753) | 10 | 3 | 8 | 58 | 1 | |||
| 141261 | 11330 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1239 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1999 12:00:00 AM | 80 | 3X3 | 6017503.8498875 | 2093941.8686813 | 37.7305471093878 | -122.381777557673 | (37.7305471093878, -122.381777557673) | 10 | 3 | 8 | 58 | 1 | ||
| 143268 | 119909 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2x Lucy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6014143.19985 | 2094023.91332 | 37.7305862422565 | -122.393401649772 | (37.7305862422565, -122.393401649772) | 10 | 3 | 8 | 58 | 1 | |||
| 86593 | 101730 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 90 Rotteck St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003358.27479 | 2094550.48416 | 37.7314269752556 | -122.430724293513 | (37.7314269752556, -122.430724293513) | 9 | 7 | 5 | 28861 | 25 | |||
| 95296 | 178123 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 7 Still St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003166.62203 | 2094649.98003 | 37.7316893083954 | -122.431393972765 | (37.7316893083954, -122.431393972765) | 9 | 7 | 5 | 28861 | 25 | |||
| 178247 | 178124 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 7 Still St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003171.4318 | 2094651.692 | 37.7316942816694 | -122.431377466599 | (37.7316942816694, -122.431377466599) | 9 | 7 | 5 | 28861 | 25 | |||
| 88385 | 210955 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 222 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6000597.13244 | 2094707.94452 | 37.7317025050644 | -122.440281346627 | (37.7317025050644, -122.440281346627) | 9 | 7 | 4 | 63 | 40 | |||
| 64712 | 210954 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 462 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5999009.76671 | 2094995.92761 | 37.7324027333808 | -122.445789872203 | (37.7324027333808, -122.445789872203) | 9 | 7 | 4 | 59 | 40 | |||
| 98597 | 24851 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2380 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/1996 12:00:00 AM | 3 | 6010563.145169 | 2094856.3578366 | 37.7326724006804 | -122.405837111499 | (37.7326724006804, -122.405837111499) | 10 | 3 | 7 | 309 | 28 | |||
| 130877 | 24847 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2324 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/1996 12:00:00 AM | 12 | 3X3 | 6010395.35004 | 2095202.85551 | 37.733614424434 | -122.40644163018 | (37.733614424434, -122.40644163018) | 10 | 3 | 7 | 309 | 28 | ||
| 32810 | 194410 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1700x Quesada Ave | 42 | Median : Yard | Tree | DPW 1 | 2 | 6014359.99018 | 2095279.52622 | 37.7340459422739 | -122.392739972669 | (37.7340459422739, -122.392739972669) | 10 | 3 | 8 | 58 | 1 | ||||
| 36947 | 200712 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1200 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015805.2319 | 2095319.882 | 37.7342369150004 | -122.387746093722 | (37.7342369150004, -122.387746093722) | 10 | 3 | 8 | 58 | 1 | |||
| 111196 | 26894 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1245X Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4 | 6015870.9547371 | 2095407.1210845 | 37.7344800964063 | -122.387524951 | (37.7344800964063, -122.387524951) | 10 | 3 | 8 | 58 | 1 | |||
| 150161 | 3779 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 7 Carpenter Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/1997 12:00:00 AM | 5 | 3X3 | 6016553.62516 | 2095504.97734 | 37.7347865780402 | -122.385171527445 | (37.7347865780402, -122.385171527445) | 10 | 3 | 8 | 58 | 1 | ||
| 30967 | 234439 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 6 Roscoe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006835.46113 | 2095729.05936 | 37.7348594716865 | -122.418786531675 | (37.7348594716865, -122.418786531675) | 2 | 7 | 7 | 28859 | 2 | |||
| 114640 | 194418 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1548 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015914.23421 | 2095920.15434 | 37.7358911793201 | -122.38741109564 | (37.7358911793201, -122.38741109564) | 10 | 3 | 8 | 58 | 1 | |||
| 80373 | 194419 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1548 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015902.62004 | 2095929.89737 | 37.7359172884615 | -122.387451930266 | (37.7359172884615, -122.387451930266) | 10 | 3 | 8 | 58 | 1 | |||
| 102113 | 234449 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 322 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001539.15917 | 2096239.21679 | 37.7359606150995 | -122.437134171803 | (37.7359606150995, -122.437134171803) | 2 | 7 | 5 | 63 | 7 | |||
| 126858 | 234447 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 55 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002027.69076 | 2096295.05115 | 37.7361416809875 | -122.435449118386 | (37.7361416809875, -122.435449118386) | 2 | 7 | 5 | 63 | 7 | |||
| 18400 | 200778 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1630 McKinnon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 |
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) );