trees
48 rows where Fire Prevention Districts = 3 and qSpecies_id = 177 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5642 | 13071 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
5671 | 13046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.410413314112 | (37.8032072253646, -122.410413314112) | 3 | 1 | 10 | 308 | 23 | |||
6110 | 13007 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.407780718516 | (37.8034055135257, -122.407780718516) | 3 | 1 | 10 | 308 | 23 | ||
8763 | 13089 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | 3 | 1 | 10 | 308 | 23 | |||
9548 | 13006 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | 3 | 1 | 10 | 308 | 23 | ||
10133 | 12999 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 349 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 09:03:00 AM | 3 | 3X3 | 6010644.3554 | 2120634.1907 | 37.8034569792808 | -122.407372982577 | (37.8034569792808, -122.407372982577) | 3 | 1 | 10 | 308 | 23 | ||
11154 | 13008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.8034189676022 | -122.407688696484 | (37.8034189676022, -122.407688696484) | 3 | 1 | 10 | 308 | 23 | ||
11709 | 13039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | 3 | 1 | 10 | 308 | 23 | |||
13587 | 13088 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 06:03:00 AM | 3 | 3X3 | 6008925.6016 | 2120449.3844 | 37.8028531997518 | -122.413307745784 | (37.8028531997518, -122.413307745784) | 3 | 1 | 10 | 308 | 23 | ||
16151 | 13005 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | 3 | 1 | 10 | 308 | 23 | ||
16281 | 13043 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 526 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 11:51:00 AM | 3 | 3x3 | 6009812.0026 | 2120568.2515 | 37.8032293051326 | -122.410248727784 | (37.8032293051326, -122.410248727784) | 3 | 1 | 10 | 308 | 23 | ||
17402 | 12986 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.406869163124 | (37.8036540726688, -122.406869163124) | 3 | 1 | 10 | 308 | 23 | ||
19019 | 13004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | 3 | 1 | 10 | 308 | 23 | ||
22838 | 143258 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.411677153186 | (37.8029290843214, -122.411677153186) | 3 | 1 | 10 | 308 | 23 | |||
34675 | 13072 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
35337 | 143011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650-654 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2017 12:26:00 PM | 3 | Width 0ft | 6009188.4253 | 2120483.2963 | 37.8029610657241 | -122.412400635876 | (37.8029610657241, -122.412400635876) | 3 | 1 | 10 | 308 | 23 | ||
35355 | 13022 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.8033024923724 | -122.408642082138 | (37.8033024923724, -122.408642082138) | 3 | 1 | 10 | 308 | 23 | ||
37778 | 104607 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1839 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 3x3 | Permit Number 770939 | 6009882.8 | 2120354 | 37.8026449918113 | -122.409988596173 | (37.8026449918113, -122.409988596173) | 3 | 1 | 10 | 308 | 23 | ||
45752 | 143037 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 510 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:44:00 AM | 19 | Width 0ft | 6009884.4437 | 2120577.0857 | 37.8032576219869 | -122.409998666067 | (37.8032576219869, -122.409998666067) | 3 | 1 | 10 | 308 | 23 | ||
53358 | 12988 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.8036421292086 | -122.407016292062 | (37.8036421292086, -122.407016292062) | 3 | 1 | 10 | 308 | 23 | ||
58253 | 13040 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | 3 | 1 | 10 | 308 | 23 | ||
61397 | 13017 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 412 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3X3 | 6010331 | 2120658 | 37.8035048104324 | -122.408459047408 | (37.8035048104324, -122.408459047408) | 3 | 1 | 10 | 308 | 23 | ||
63720 | 13009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 378 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 02:11:00 PM | 3 | 4X4 | 6010539.0395 | 2120665.4782 | 37.8035369920045 | -122.407739641802 | (37.8035369920045, -122.407739641802) | 3 | 1 | 10 | 308 | 23 | ||
68237 | 13015 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2016 12:00:00 AM | 12 | 3X3 | 6010332.686 | 2120602.2788 | 37.8033519082048 | -122.408449280112 | (37.8033519082048, -122.408449280112) | 3 | 1 | 10 | 308 | 23 | ||
69900 | 254752 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
70827 | 13016 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | 3 | 1 | 10 | 308 | 23 | ||
72042 | 13024 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801149 | (37.8032939775537, -122.40885801149) | 3 | 1 | 10 | 308 | 23 | ||
72976 | 13010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.8035349377887 | -122.407866624342 | (37.8035349377887, -122.407866624342) | 3 | 1 | 10 | 308 | 23 | ||
76872 | 13011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524598 | (37.8035195251148, -122.40795524598) | 3 | 1 | 10 | 308 | 23 | ||
77866 | 13055 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 08:41:00 AM | 3 | 3x3 | 6009605.5749 | 2120542.0431 | 37.8031457701614 | -122.410961227909 | (37.8031457701614, -122.410961227909) | 3 | 1 | 10 | 308 | 23 | ||
78246 | 143041 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2000 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780933 | 6009568.471 | 2120534.3867 | 37.8031226669303 | -122.411089086343 | (37.8031226669303, -122.411089086343) | 3 | 1 | 10 | 308 | 23 | |
83725 | 13075 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |
91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
94001 | 143039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 520 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6009841.4502 | 2120571.1962 | 37.8032390411539 | -122.410147031042 | (37.8032390411539, -122.410147031042) | 3 | 1 | 10 | 308 | 23 | |||
111732 | 12989 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 325 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780097 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | |
116521 | 143019 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 410 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010368.5125 | 2120644.4743 | 37.8034697728784 | -122.408328278578 | (37.8034697728784, -122.408328278578) | 3 | 1 | 10 | 308 | 23 | |||
120504 | 254750 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
123811 | 13034 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 490 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:07:00 PM | 3 | 3x3 | 6010037.8987 | 2120598.0598 | 37.8033238110836 | -122.409469108899 | (37.8033238110836, -122.409469108899) | 3 | 1 | 10 | 308 | 23 | ||
126183 | 13014 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 02:25:00 PM | 3 | 3X3 | 6010352 | 2120661 | 37.8035142236954 | -122.408386587386 | (37.8035142236954, -122.408386587386) | 3 | 1 | 10 | 308 | 23 | ||
128647 | 255530 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 301 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | ||||
128671 | 13042 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:23:00 AM | 3 | 3x3 | 6009844.8077 | 2120534.1734 | 37.8031375739168 | -122.410132796901 | (37.8031375739168, -122.410132796901) | 3 | 1 | 10 | 308 | 23 | ||
137875 | 13025 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 451 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2016 07:02:00 AM | 3 | 3X3 | 6010198.7145 | 2120581.4625 | 37.8032872483458 | -122.40891142592 | (37.8032872483458, -122.40891142592) | 3 | 1 | 10 | 308 | 23 | ||
138508 | 13083 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 660 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 11:06:00 AM | 3 | 3X3 | 6009215.12 | 2120489.4566 | 37.8029794783612 | -122.412308693696 | (37.8029794783612, -122.412308693696) | 3 | 1 | 10 | 308 | 23 | ||
154814 | 13082 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 10:37:00 AM | 3 | 3x3 | 6009219.60633 | 2120572.31429 | 37.8032072366716 | -122.412299028441 | (37.8032072366716, -122.412299028441) | 3 | 1 | 10 | 308 | 23 | ||
167419 | 254751 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
175454 | 29909 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:29:00 AM | 3 | 3x3 | 6009867.8709 | 2120537.6157 | 37.8031483182934 | -122.410053228903 | (37.8031483182934, -122.410053228903) | 3 | 1 | 10 | 308 | 23 | ||
177836 | 13081 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650-654 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2017 12:08:00 PM | 3 | 3x3 | 6009251.0552 | 2120493.5635 | 37.8029927712959 | -122.412184629201 | (37.8029927712959, -122.412184629201) | 3 | 1 | 10 | 308 | 23 | ||
190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 |
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) );