trees
306 rows where qSpecies_id = 143 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7870 | 19800 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100 STAIRWAY21 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
10112 | 19818 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100 STAIRWAY25 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
13905 | 20322 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 101X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
83606 | 194591 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1301 Minnesota St | 6 | Front Yard : Yard | Tree | Private 2 | 16 | 6015395.46497 | 2102261.8945 | 37.7532755385605 | -122.389647488355 | (37.7532755385605, -122.389647488355) | 10 | 3 | 8 | 28856 | 29 | ||||
170174 | 194592 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1098 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014470.31991 | 2105301.99437 | 37.7615716558409 | -122.393059550356 | (37.7615716558409, -122.393059550356) | 10 | 3 | 8 | 28856 | 29 | |||
135899 | 194593 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1 01st St | 21 | : Yard | Tree | Private 2 | 19 | 6014441.96314 | 2105885.02123 | 37.7631709453925 | -122.393198423694 | (37.7631709453925, -122.393198423694) | 14 | 3 | 8 | 28856 | 29 | ||||
78579 | 194594 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1 01st St | 22 | : Yard | Tree | Private 2 | 10 | 6014433.28496 | 2105898.16367 | 37.7632065495547 | -122.393229358544 | (37.7632065495547, -122.393229358544) | 14 | 3 | 8 | 28856 | 29 | ||||
20454 | 194601 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 560 Missouri St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 22 | Width 2ft | 6013524.11994 | 2104470.94675 | 37.7592371740688 | -122.396273844275 | (37.7592371740688, -122.396273844275) | 10 | 3 | 8 | 28856 | 29 | |||
186242 | 194600 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 560 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 2ft | 6013514.76966 | 2104470.05867 | 37.7592342153015 | -122.396306120039 | (37.7592342153015, -122.396306120039) | 10 | 3 | 8 | 28856 | 29 | |||
51880 | 194599 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 560 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 2ft | 6013504.76514 | 2104470.26142 | 37.7592342153007 | -122.396340734951 | (37.7592342153007, -122.396340734951) | 10 | 3 | 8 | 28856 | 29 | |||
82461 | 194597 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1501 22nd St | 16 | Front Yard : Yard | Tree | Private 2 | 13 | 6013352.62113 | 2103844.18935 | 37.7575066904871 | -122.396823033261 | (37.7575066904871, -122.396823033261) | 10 | 3 | 8 | 28856 | 29 | ||||
184947 | 194598 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1501 22nd St | 17 | Front Yard : Yard | Tree | Private 2 | 6 | 6013347.3325 | 2103843.81837 | 37.7575053774884 | -122.396841297588 | (37.7575053774884, -122.396841297588) | 10 | 3 | 8 | 28856 | 29 | ||||
144327 | 194596 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 800 Wisconsin St | 7 | : | Tree | Private 2 | 12 | Width 3ft | 6012720.64304 | 2103613.29363 | 37.7568375049672 | -122.398992475934 | (37.7568375049672, -122.398992475934) | 10 | 3 | 8 | 28856 | 29 | |||
78154 | 194595 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 790 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012100.88773 | 2104713.90073 | 37.7598249745702 | -122.401213170068 | (37.7598249745702, -122.401213170068) | 10 | 3 | 8 | 28856 | 29 | |||
97494 | 67866 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 525 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2008 12:00:00 AM | 10 | 3x3 | Permit Number 51918 | 6011810.47286 | 2105913.7518 | 37.763103292118 | -122.402301941482 | (37.763103292118, -122.402301941482) | 8 | 3 | 8 | 28856 | 29 | |
8011 | 260843 | Planning Code 138.1 required 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1015 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779771 | 6011450.48648 | 2090129.50026 | 37.719743011404 | -122.402437083292 | (37.719743011404, -122.402437083292) | 10 | 7 | 8 | 309 | 28 | |
15036 | 178409 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 747 Olmstead St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 6009504.75205 | 2090542.56388 | 37.7207683848267 | -122.409191957952 | (37.7207683848267, -122.409191957952) | 9 | 3 | 7 | 309 | 28 | |||
28810 | 132415 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 4 | Back Yard : Yard | Tree | Private 2 | 8 | Width 10ft | 6009831.3064 | 2117286.6196 | 37.7942198322406 | -122.409950127822 | (37.7942198322406, -122.409950127822) | 3 | 1 | 10 | 28857 | 21 | |||
112538 | 132414 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 5 | Back Yard : Yard | Tree | Private 2 | 15 | Width 10ft | 6009830.16346 | 2117290.71414 | 37.7942310107947 | -122.409954371722 | (37.7942310107947, -122.409954371722) | 3 | 1 | 10 | 28857 | 21 | |||
110593 | 132412 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 7 | Back Yard : Yard | Tree | Private 2 | 6 | Width 10ft | 6009828.26061 | 2117303.30498 | 37.7942654755313 | -122.409961845076 | (37.7942654755313, -122.409961845076) | 3 | 1 | 10 | 28857 | 21 | |||
137325 | 132413 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 6 | Back Yard : Yard | Tree | Private 2 | 11 | Width 10ft | 6009827.38182 | 2117300.98565 | 37.7942590579634 | -122.409964721995 | (37.7942590579634, -122.409964721995) | 3 | 1 | 10 | 28857 | 21 | |||
44687 | 234009 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008979.27122 | 2097211.07769 | 37.7390492467314 | -122.411479275665 | (37.7390492467314, -122.411479275665) | 10 | 7 | 7 | 28859 | 2 | |||
97135 | 132425 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 941 Vallejo St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6008897.86349 | 2118673.31668 | 37.79797500181 | -122.413278063645 | (37.79797500181, -122.413278063645) | 3 | 1 | 10 | 308 | 21 | ||||
110538 | 132424 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Vallejo St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 6008826.96262 | 2118671.13776 | 37.7979650382118 | -122.413523247611 | (37.7979650382118, -122.413523247611) | 3 | 1 | 10 | 308 | 21 | ||||
111610 | 132423 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Vallejo St | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.413555471214 | (37.7979513838133, -122.413555471214) | 3 | 1 | 10 | 308 | 21 | ||||
70640 | 132422 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Vallejo St | 1 | Side Yard : Yard | Tree | Private 2 | 5 | 6008806.49903 | 2118647.23011 | 37.7978982446696 | -122.413592365905 | (37.7978982446696, -122.413592365905) | 3 | 1 | 10 | 308 | 21 | ||||
105644 | 29762 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 530 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008749.3255 | 2121116.482 | 37.8046749842608 | -122.413964972943 | (37.8046749842608, -122.413964972943) | 3 | 1 | 10 | 308 | 23 | |||
190212 | 233993 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 105 Manchester St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008275.13966 | 2099356.88691 | 37.7449016452007 | -122.414065613435 | (37.7449016452007, -122.414065613435) | 2 | 7 | 7 | 28859 | 2 | |||
98104 | 132438 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 9 | Side Yard : Yard | Tree | Private 2 | 6 | 6008636.9513 | 2118981.46679 | 37.7988064538179 | -122.414202710601 | (37.7988064538179, -122.414202710601) | 5 | 1 | 10 | 308 | 21 | ||||
102924 | 132437 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 7 | Side Yard : Yard | Tree | Private 2 | 15 | 6008631.99788 | 2118976.07541 | 37.7987913721926 | -122.414219469452 | (37.7987913721926, -122.414219469452) | 5 | 1 | 10 | 308 | 21 | ||||
31372 | 142705 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 550 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008670.6587 | 2121106.7911 | 37.8046439570216 | -122.41423652198 | (37.8046439570216, -122.41423652198) | 3 | 1 | 10 | 308 | 23 | |||
72792 | 132436 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 6 | Side Yard : Yard | Tree | Private 2 | 4 | 6008624.64494 | 2118991.49832 | 37.7988333066551 | -122.414246004875 | (37.7988333066551, -122.414246004875) | 5 | 1 | 10 | 308 | 21 | ||||
91301 | 132435 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 5 | Side Yard : Yard | Tree | Private 2 | 3 | 6008622.60306 | 2118990.33445 | 37.7988299962621 | -122.414252988079 | (37.7988299962621, -122.414252988079) | 5 | 1 | 10 | 308 | 21 | ||||
149677 | 132434 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 4 | Side Yard : Yard | Tree | Private 2 | 3 | 6008620.99227 | 2118990.50136 | 37.7988303640752 | -122.414258573772 | (37.7988303640752, -122.414258573772) | 5 | 1 | 10 | 308 | 21 | ||||
138247 | 132433 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 1 | Side Yard : Yard | Tree | Private 2 | 2 | 6008619.19252 | 2118974.8638 | 37.7987873261227 | -122.414263694525 | (37.7987873261227, -122.414263694525) | 5 | 1 | 10 | 308 | 21 | ||||
182907 | 132431 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | 6008617.41774 | 2118989.29744 | 37.7988268576225 | -122.414270857625 | (37.7988268576225, -122.414270857625) | 5 | 1 | 10 | 308 | 21 | ||||
25980 | 132432 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 2 | Side Yard : Yard | Tree | Private 2 | 2 | 6008616.66785 | 2118981.63248 | 37.7988057694225 | -122.41427290989 | (37.7988057694225, -122.41427290989) | 5 | 1 | 10 | 308 | 21 | ||||
6754 | 132428 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6008612.46815 | 2118979.35525 | 37.7987992808082 | -122.414287281056 | (37.7987992808082, -122.414287281056) | 5 | 1 | 10 | 308 | 21 | ||||
103880 | 132430 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6008611.92512 | 2118990.49099 | 37.7988298262824 | -122.414289948436 | (37.7988298262824, -122.414289948436) | 5 | 1 | 10 | 308 | 21 | ||||
130643 | 132429 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | 6008611.37888 | 2118984.10383 | 37.7988122580431 | -122.414291386455 | (37.7988122580431, -122.414291386455) | 5 | 1 | 10 | 308 | 21 | ||||
57506 | 132427 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6008608.8618 | 2118977.06556 | 37.7987927913102 | -122.414299598148 | (37.7987927913102, -122.414299598148) | 5 | 1 | 10 | 308 | 21 | ||||
180305 | 132426 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6008604.37776 | 2118975.38502 | 37.798787925083 | -122.414314995462 | (37.798787925083, -122.414314995462) | 5 | 1 | 10 | 308 | 21 | ||||
186976 | 132444 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 14 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008522.99961 | 2119161.32617 | 37.7992939016597 | -122.414609756357 | (37.7992939016597, -122.414609756357) | 5 | 1 | 10 | 308 | 32 | ||||
68567 | 132445 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 44 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6008457.55549 | 2119152.19379 | 37.7992651494321 | -122.414835569802 | (37.7992651494321, -122.414835569802) | 5 | 1 | 10 | 308 | 32 | ||||
191681 | 132443 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 45 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6008455.947 | 2119141.60156 | 37.7992359754255 | -122.414840385693 | (37.7992359754255, -122.414840385693) | 5 | 1 | 10 | 308 | 32 | ||||
118801 | 107944 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 44x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008447.49259 | 2119151.63001 | 37.7992630360091 | -122.414870351108 | (37.7992630360091, -122.414870351108) | 5 | 1 | 10 | 308 | 32 | |||
19582 | 88779 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 52 MacOndray Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 51696 | 6008424.66952 | 2119147.16935 | 37.7992495057053 | -122.414949011194 | (37.7992495057053, -122.414949011194) | 5 | 1 | 10 | 308 | 32 | ||
150891 | 132416 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6008344.60372 | 2117052.50272 | 37.7934935703107 | -122.415077721275 | (37.7934935703107, -122.415077721275) | 5 | 1 | 10 | 28858 | 21 | |||
190542 | 132418 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6008344.17641 | 2117062.85198 | 37.7935219628191 | -122.415079932693 | (37.7935219628191, -122.415079932693) | 5 | 1 | 10 | 28858 | 21 | |||
128063 | 132419 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6008343.95149 | 2117067.4702 | 37.7935346306753 | -122.415081037978 | (37.7935346306753, -122.415081037978) | 5 | 1 | 10 | 28858 | 21 | |||
105428 | 132417 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6008339.95613 | 2117059.59753 | 37.7935127897381 | -122.415094304772 | (37.7935127897381, -122.415094304772) | 5 | 1 | 10 | 28858 | 21 | |||
134868 | 132442 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 71 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6008356.32962 | 2119132.553 | 37.7992055324734 | -122.415184456397 | (37.7992055324734, -122.415184456397) | 5 | 1 | 10 | 308 | 32 | ||||
7319 | 132441 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 81 MacOndray Ln | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6008314.49413 | 2119120.93621 | 37.7991712844751 | -122.41532839919 | (37.7991712844751, -122.41532839919) | 5 | 1 | 10 | 308 | 32 | |||
8155 | 132440 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 81 MacOndray Ln | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6008307.79025 | 2119116.80012 | 37.7991595510226 | -122.415351304015 | (37.7991595510226, -122.415351304015) | 5 | 1 | 10 | 308 | 32 | |||
145340 | 132439 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 81 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6008287.04594 | 2119113.40278 | 37.7991490568479 | -122.415422845983 | (37.7991490568479, -122.415422845983) | 5 | 1 | 10 | 308 | 32 | |||
50032 | 233992 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 26 Aztec St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007767.83381 | 2099565.63824 | 37.7454463231873 | -122.415834567334 | (37.7454463231873, -122.415834567334) | 2 | 7 | 7 | 28859 | 2 | |||
27417 | 132421 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 93 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6008147.86247 | 2119098.46526 | 37.7991002182645 | -122.415903411311 | (37.7991002182645, -122.415903411311) | 5 | 1 | 10 | 308 | 32 | ||||
110877 | 132420 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 95 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6008112.06223 | 2119093.98922 | 37.7990859154301 | -122.416026975472 | (37.7990859154301, -122.416026975472) | 5 | 1 | 10 | 308 | 32 | ||||
3617 | 116648 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
34392 | 116650 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
48753 | 116652 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
50056 | 116646 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
147519 | 116647 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
162602 | 116651 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
190766 | 116649 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
74863 | 4115 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 3405 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006973.82506 | 2100523.56194 | 37.7480318958107 | -122.418648047426 | (37.7480318958107, -122.418648047426) | 2 | 4 | 7 | 28859 | 2 | |||
65310 | 233994 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006556.89538 | 2097283.64243 | 37.7391123233744 | -122.419859908531 | (37.7391123233744, -122.419859908531) | 2 | 7 | 7 | 28859 | 2 | |||
24844 | 95247 | Undocumented 4 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2626 Larkin St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
67455 | 95245 | Undocumented 4 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2626 Larkin St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
164939 | 95246 | Undocumented 4 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2626 Larkin St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
44671 | 233979 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 984 Valencia St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6006291.32527 | 2103870.13031 | 37.7571823544938 | -122.421245715219 | (37.7571823544938, -122.421245715219) | 2 | 4 | 5 | 28859 | 19 | |||
127625 | 233980 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1609 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | Width 3ft | 6005332.72592 | 2098929.24645 | 37.7435617380791 | -122.424209538959 | (37.7435617380791, -122.424209538959) | 2 | 7 | 5 | 28859 | 22 | |||
136296 | 233983 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 107 Valley St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6005148.37303 | 2099292.84889 | 37.7445496964121 | -122.424872849196 | (37.7445496964121, -122.424872849196) | 2 | 7 | 5 | 63 | 22 | |||
136853 | 233978 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1100 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6004853.46612 | 2096726.8825 | 37.7374874741536 | -122.42570998044 | (37.7374874741536, -122.42570998044) | 2 | 7 | 5 | 63 | 7 | ||||
155032 | 233982 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 3849 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004873.93248 | 2100447.57279 | 37.7477047978586 | -122.425903990303 | (37.7477047978586, -122.425903990303) | 2 | 4 | 5 | 63 | 22 | |||
95366 | 28241 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 3849 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X6 | 6004869.33528 | 2100447.66741 | 37.7477047978577 | -122.425919893915 | (37.7477047978577, -122.425919893915) | 2 | 4 | 5 | 63 | 22 | |||
88278 | 233981 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 3846 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6004869.8512 | 2100493.03902 | 37.7478294069984 | -122.425921339098 | (37.7478294069984, -122.425921339098) | 2 | 4 | 5 | 63 | 22 | |||
20522 | 234012 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 671 Church St | 44 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004318.00864 | 2105152.47097 | 37.7605919110103 | -122.428161593486 | (37.7605919110103, -122.428161593486) | 2 | 4 | 5 | 28862 | 3 | |||
168587 | 234013 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 671 Church St | 45 | Front Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 6004317.78072 | 2105162.37038 | 37.7606190795398 | -122.428163087265 | (37.7606190795398, -122.428163087265) | 2 | 4 | 5 | 28862 | 3 | |||
66170 | 234011 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 671 Church St | 40 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004316.16134 | 2105104.75601 | 37.7604607925581 | -122.428164581925 | (37.7604607925581, -122.428164581925) | 2 | 4 | 5 | 28862 | 3 | |||
47243 | 234014 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 671 Church St | 46 | Front Yard : Yard | Tree | Private 2 | 10 | Width 3ft | 6004316.35459 | 2105177.02697 | 37.7606592423591 | -122.428169064147 | (37.7606592423591, -122.428169064147) | 2 | 4 | 5 | 28862 | 3 | |||
103273 | 137943 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1934 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003936.5354 | 2115120.5913 | 37.7879403315763 | -122.430192087218 | (37.7879403315763, -122.430192087218) | 13 | 9 | 11 | 29490 | 27 | |||
174090 | 234004 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1300 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003211.15019 | 2100572.61203 | 37.7479540161859 | -122.431662723473 | (37.7479540161859, -122.431662723473) | 2 | 4 | 5 | 63 | 22 | |||
53113 | 234003 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500x 27th St | 17 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6002888.7683 | 2100065.98913 | 37.7465446697175 | -122.432741319957 | (37.7465446697175, -122.432741319957) | 2 | 7 | 5 | 63 | 22 | |||
109254 | 16748 | Permitted Site 7 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1760 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002837.5906882 | 2113421.7446697 | 37.7832134248204 | -122.433872756894 | (37.7832134248204, -122.433872756894) | 13 | 9 | 11 | 29490 | 41 | |||
66559 | 233977 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 79 Scott St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002355.60896 | 2108678.85755 | 37.7701632795355 | -122.435200866851 | (37.7701632795355, -122.435200866851) | 15 | 5 | 5 | 29492 | 9 | |||
171981 | 233976 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 85 Scott St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002352.16344 | 2108701.24422 | 37.7702245521494 | -122.435214386342 | (37.7702245521494, -122.435214386342) | 15 | 5 | 5 | 29492 | 9 | |||
86285 | 234007 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 3978 22nd St | 1 | : | Tree | Private 2 | 12 | 6001985.80169 | 2102958.64311 | 37.7544359571599 | -122.436070634474 | (37.7544359571599, -122.436070634474) | 2 | 4 | 5 | 28862 | 22 | ||||
110270 | 178410 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300x Winding Way | 4 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6001531.44731 | 2086487.39833 | 37.7091838838906 | -122.43646308602 | (37.7091838838906, -122.43646308602) | 9 | 7 | 6 | 28861 | 5 | |||
108250 | 178418 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6001657.79965 | 2094178.37716 | 37.7303087672308 | -122.43657652199 | (37.7303087672308, -122.43657652199) | 9 | 7 | 6 | 28861 | 25 | ||||
100190 | 178417 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6001651.54923 | 2094173.30469 | 37.7302944841952 | -122.436597767571 | (37.7302944841952, -122.436597767571) | 9 | 7 | 6 | 28861 | 25 | ||||
154998 | 178408 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6001651.19856 | 2094173.31719 | 37.7302944985896 | -122.436598980777 | (37.7302944985896, -122.436598980777) | 9 | 7 | 6 | 28861 | 25 | ||||
165208 | 178407 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6001645.05047 | 2094167.64617 | 37.730278577884 | -122.436619829756 | (37.730278577884, -122.436619829756) | 9 | 7 | 6 | 28861 | 25 | ||||
102274 | 178416 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6001641.53674 | 2094164.63815 | 37.7302701188701 | -122.436631761946 | (37.7302701188701, -122.436631761946) | 9 | 7 | 6 | 28861 | 25 | ||||
110033 | 178406 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001639.75964 | 2094163.19973 | 37.7302660683079 | -122.436637802688 | (37.7302660683079, -122.436637802688) | 9 | 7 | 6 | 28861 | 25 | ||||
167989 | 233998 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 642 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6001746.28209 | 2099445.10181 | 37.7447749981684 | -122.43664747132 | (37.7447749981684, -122.43664747132) | 2 | 7 | 5 | 63 | 22 | ||||
101762 | 178405 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6001634.24365 | 2094157.92996 | 37.7302512852578 | -122.436656495109 | (37.7302512852578, -122.436656495109) | 9 | 7 | 6 | 28861 | 25 | ||||
83578 | 178415 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001633.0697 | 2094156.39849 | 37.730247013477 | -122.436660444024 | (37.730247013477, -122.436660444024) | 9 | 7 | 6 | 28861 | 25 | ||||
35895 | 178404 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001626.60618 | 2094150.6328 | 37.7302308148923 | -122.436682376683 | (37.7302308148923, -122.436682376683) | 9 | 7 | 6 | 28861 | 25 | ||||
47540 | 178414 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6001625.71874 | 2094150.12483 | 37.7302293696897 | -122.436685408329 | (37.7302293696897, -122.436685408329) | 9 | 7 | 6 | 28861 | 25 |
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) );