trees
1,813 rows where qSpecies_id = 149 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
894 | 260859 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 739 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985675.22385 | 2110852.85567 | 37.7751711283725 | -122.493057514378 | (37.7751711283725, -122.493057514378) | 11 | 6 | 2 | 55 | 26 | |||
1145 | 180443 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 599 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008502.54989 | 2091553.3243 | 37.7234875219066 | -122.412727694727 | (37.7234875219066, -122.412727694727) | 9 | 3 | 7 | 309 | 28 | |||
1670 | 79959 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1719 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014649.30917 | 2095031.35513 | 37.7333805797332 | -122.39172235292 | (37.7333805797332, -122.39172235292) | 10 | 3 | 8 | 58 | 1 | |||
1706 | 124216 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.455757897014 | (37.7796587851836, -122.455757897014) | 11 | 6 | 2 | 54 | 16 | |||
1921 | 70333 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 143 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009984.51803 | 2093871.67123 | 37.7299362833339 | -122.407768169286 | (37.7299362833339, -122.407768169286) | 10 | 3 | 7 | 309 | 28 | |||
2092 | 262061 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
2160 | 29663 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2200X Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991214.62649 | 2094785.74836 | 37.7313774711782 | -122.472723912001 | (37.7313774711782, -122.472723912001) | 1 | 8 | 4 | 64 | 40 | |||
2592 | 6305 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.7815803152054 | -122.434887466275 | (37.7815803152054, -122.434887466275) | 15 | 5 | 11 | 29490 | 41 | ||
2606 | 242331 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 206 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004526.0717 | 2099598.82102 | 37.7453546561933 | -122.427046431465 | (37.7453546561933, -122.427046431465) | 2 | 7 | 5 | 63 | 22 | |||
3156 | 115362 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101X Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6012895.14842 | 2106528.52357 | 37.7648518070998 | -122.398593533074 | (37.7648518070998, -122.398593533074) | 14 | 3 | 8 | 28856 | 29 | |||
3214 | 70482 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 935 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005101.62772 | 2092066.92628 | 37.7247062894408 | -122.424520594648 | (37.7247062894408, -122.424520594648) | 9 | 7 | 6 | 28861 | 5 | |||
3376 | 25308 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 279X Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6000039.97311 | 2091577.86047 | 37.7230762793257 | -122.441982968035 | (37.7230762793257, -122.441982968035) | 9 | 7 | 6 | 28861 | 25 | ||
3493 | 90355 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.15342 | 2111367.69142 | 37.7770236721988 | -122.466960976467 | (37.7770236721988, -122.466960976467) | 11 | 6 | 2 | 54 | 11 | ||
3607 | 262063 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
4214 | 70336 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 324 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009735.9866 | 2094035.87413 | 37.7303732333298 | -122.408638954927 | (37.7303732333298, -122.408638954927) | 10 | 3 | 7 | 309 | 28 | |||
4299 | 74119 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 164 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.394734525092 | (37.7811839433263, -122.394734525092) | 6 | 2 | 9 | 28856 | 6 | |||
4398 | 149806 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1095 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2020 12:00:00 AM | 3 | Width 4 | 6015039.51636 | 2103405.11411 | 37.7563948325734 | -122.390958336561 | (37.7563948325734, -122.390958336561) | 10 | 3 | 8 | 28856 | 29 | ||
4483 | 262070 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
4510 | 262317 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1508 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013158 | 2096333 | 37.7368717300177 | -122.396969492274 | (37.7368717300177, -122.396969492274) | 10 | 3 | 8 | 58 | 1 | ||||
4520 | 80637 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 706 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011239.20103 | 2105002.70461 | 37.7605698551303 | -122.404213664555 | (37.7605698551303, -122.404213664555) | 10 | 3 | 8 | 28856 | 29 | |||
4636 | 260858 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985713.16819 | 2110906.59773 | 37.7753209078179 | -122.492930217758 | (37.7753209078179, -122.492930217758) | 11 | 6 | 2 | 55 | 26 | |||
4659 | 262488 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 609 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008980.84457 | 2093750.19118 | 37.7295464865785 | -122.411229423312 | (37.7295464865785, -122.411229423312) | 9 | 3 | 7 | 309 | 28 | ||||
4807 | 90317 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2201 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988709.47334 | 2111203.76821 | 37.7763116232267 | -122.482587210366 | (37.7763116232267, -122.482587210366) | 11 | 6 | 2 | 55 | 26 | ||
4863 | 78532 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 501 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010074.13409 | 2092167.4028 | 37.7252617368386 | -122.407338256469 | (37.7252617368386, -122.407338256469) | 10 | 3 | 7 | 309 | 28 | |||
4895 | 117122 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2550 34TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2016 12:00:00 AM | 3 | 3x3 | 5985875 | 2097864 | 37.7395189911199 | -122.491410221624 | (37.7395189911199, -122.491410221624) | 1 | 8 | 3 | 29491 | 35 | ||
5066 | 262068 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
5282 | 10014 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 224 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:44:00 AM | 3 | 2x3 | 6005430.43675 | 2107671.80391 | 37.7675722796594 | -122.424493411759 | (37.7675722796594, -122.424493411759) | 8 | 4 | 5 | 28853 | 19 | ||
5851 | 242898 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009967.25969 | 2103043.92706 | 37.7551203376501 | -122.408474577742 | (37.7551203376501, -122.408474577742) | 2 | 4 | 7 | 28859 | 19 | |||
5907 | 70407 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | 9 | 7 | 7 | 309 | 5 | |||
6205 | 70404 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 218 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6006477.26442 | 2092881.04144 | 37.7270192639056 | -122.419822921186 | (37.7270192639056, -122.419822921186) | 9 | 7 | 7 | 309 | 5 | |||
6744 | 259097 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 801 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
6865 | 10095 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2015 12:00:00 AM | 3 | 2X2 | 6005664.236 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | 2 | 4 | 5 | 28859 | 19 | ||
7065 | 198271 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Pennsylvania Ave | 17 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.67834 | 2106481.09805 | 37.7648010700346 | -122.393649256519 | (37.7648010700346, -122.393649256519) | 14 | 3 | 8 | 310 | 29 | ||||
7186 | 262074 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 14 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
7232 | 262073 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 13 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
7652 | 180469 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 599 University St | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008151.81482 | 2092695.50031 | 37.7266040019517 | -122.414020889251 | (37.7266040019517, -122.414020889251) | 9 | 3 | 7 | 309 | 28 | |||
7671 | 82808 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 637 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992833.07706 | 2111118.80762 | 37.7763173780733 | -122.468316464164 | (37.7763173780733, -122.468316464164) | 11 | 6 | 2 | 54 | 11 | |||
7705 | 106005 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | 10 | 3 | 8 | 58 | 1 | ||
7840 | 74171 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 466 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011049.67315 | 2111947.37062 | 37.7796277285636 | -122.405358235294 | (37.7796277285636, -122.405358235294) | 14 | 2 | 9 | 28853 | 34 | |||
7854 | 70573 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 862 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5982961.78283 | 2109923.12422 | 37.772459289826 | -122.502374937437 | (37.772459289826, -122.502374937437) | 11 | 6 | 2 | 55 | 26 | |||
8020 | 95515 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | 11 | 6 | 2 | 55 | 26 | |||
8058 | 117668 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4826 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5983640.52001 | 2111755.82857 | 37.7775312233534 | -122.500162667158 | (37.7775312233534, -122.500162667158) | 11 | 6 | 2 | 55 | 26 | |||
8124 | 21894 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1999 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | 14 | 3 | 8 | 28856 | 29 | ||
8445 | 180433 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 25 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6003815.49396 | 2093259.77079 | 37.7279088588998 | -122.429051608444 | (37.7279088588998, -122.429051608444) | 9 | 7 | 6 | 28861 | 5 | |||
8450 | 79034 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.408471225064 | (37.7780689795412, -122.408471225064) | 14 | 2 | 9 | 28853 | 34 | |||
8649 | 198312 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 81 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014325.56305 | 2114147.83058 | 37.7858523015842 | -122.394179529164 | (37.7858523015842, -122.394179529164) | 6 | 2 | 9 | 28855 | 6 | |||
8849 | 180406 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 23 Gorham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002284.81507 | 2094188.81681 | 37.7303730435723 | -122.43440959294 | (37.7303730435723, -122.43440959294) | 9 | 7 | 5 | 28861 | 25 | |||
9122 | 114471 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2351 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009306.05236 | 2121599.38823 | 37.806032175519 | -122.412072506246 | (37.806032175519, -122.412072506246) | 3 | 1 | 10 | 308 | 23 | |||
9144 | 254818 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
9363 | 262072 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
9571 | 72258 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 230 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6002786.80425 | 2092214.20259 | 37.7249796797621 | -122.432533160192 | (37.7249796797621, -122.432533160192) | 9 | 7 | 6 | 28861 | 5 | |||
9771 | 8890 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4300 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1996 12:00:00 AM | 3 | 3X3 | 5993676.36815 | 2112846.77323 | 37.7811105766569 | -122.465524870362 | (37.7811105766569, -122.465524870362) | 11 | 6 | 2 | 54 | 11 | ||
9978 | 100882 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 91 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013366.22546 | 2111763.75465 | 37.7792528084154 | -122.397331345366 | (37.7792528084154, -122.397331345366) | 6 | 2 | 9 | 28856 | 34 | |||
10179 | 120186 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 172 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987746.67951 | 2114854.71533 | 37.7862800304413 | -122.48618581827 | (37.7862800304413, -122.48618581827) | 11 | 6 | 1 | 55 | 33 | |||
10287 | 114729 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1930 35TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 12/03/2015 12:00:00 AM | 4x4 | 5985421 | 2102058 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | 1 | 8 | 3 | 29491 | 35 | |||
10363 | 10190 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2015 09:38:00 AM | 3 | 3x3 | 6005734.23383 | 2102203.68607 | 37.7525752625596 | -122.42305391193 | (37.7525752625596, -122.42305391193) | 2 | 4 | 5 | 28859 | 19 | ||
10471 | 93394 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3077 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996268.61185 | 2111428.40102 | 37.7773652699243 | -122.456454460594 | (37.7773652699243, -122.456454460594) | 11 | 6 | 2 | 54 | 16 | ||
10477 | 111395 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2142 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2015 12:00:00 AM | 3 | 3x3 | 5985780.6 | 2100633.8 | 37.7471186003164 | -122.491940478624 | (37.7471186003164, -122.491940478624) | 1 | 8 | 3 | 29491 | 35 | ||
10870 | 27147 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1745 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6011162.37541 | 2095219.41257 | 37.7337027663166 | -122.403790951032 | (37.7337027663166, -122.403790951032) | 10 | 3 | 8 | 58 | 1 | |||
10891 | 253432 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703 | 2090930 | 37.721448793681 | -122.432731166998 | (37.721448793681, -122.432731166998) | 9 | 7 | 6 | 28861 | 5 | ||
10965 | 22743 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1575 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2001 12:00:00 AM | 6 | 3x3 | 6002621.38954 | 2112212.2211 | 37.7798801065849 | -122.434534214215 | (37.7798801065849, -122.434534214215) | 15 | 5 | 11 | 29490 | 41 | ||
11030 | 70481 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | 9 | 7 | 6 | 28861 | 5 | |||
11232 | 74369 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 535 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 8x4 | 6009942.57894 | 2111988.44029 | 37.7796785357608 | -122.409191067621 | (37.7796785357608, -122.409191067621) | 14 | 2 | 9 | 28853 | 34 | ||
11235 | 70562 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 164 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.394743030892 | (37.7810958034577, -122.394743030892) | 6 | 2 | 9 | 28856 | 6 | |||
11457 | 180432 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 245 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000158.15201 | 2091623.21289 | 37.7232075404877 | -122.44157770136 | (37.7232075404877, -122.44157770136) | 9 | 7 | 6 | 28861 | 25 | |||
11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
11777 | 259096 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 801 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
11843 | 25286 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2232X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1996 12:00:00 AM | 6 | 2X3 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | 9 | 8 | 4 | 59 | 40 | ||
11894 | 10016 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 236 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:59:00 AM | 3 | 3x3 | 6005434.04749 | 2107587.52272 | 37.7673410675527 | -122.42447492707 | (37.7673410675527, -122.42447492707) | 8 | 4 | 5 | 28853 | 19 | ||
12079 | 70402 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6006462.64225 | 2092921.27798 | 37.7271289209396 | -122.419876323835 | (37.7271289209396, -122.419876323835) | 9 | 7 | 7 | 309 | 5 | |||
12260 | 261771 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1226 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2020 12:00:00 AM | 3 | 6009218.99272 | 2102008.59221 | 37.7522356073302 | -122.410989189307 | (37.7522356073302, -122.410989189307) | 2 | 4 | 7 | 28859 | 19 | |||
12358 | 262066 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
12654 | 262069 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
12784 | 262064 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
12901 | 123712 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 417 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994293.79243 | 2111404.14299 | 37.7771850921392 | -122.463284192691 | (37.7771850921392, -122.463284192691) | 11 | 6 | 2 | 54 | 11 | |||
12916 | 70149 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989468.1167 | 2110177.57013 | 37.7735380729812 | -122.479887770247 | (37.7735380729812, -122.479887770247) | 11 | 6 | 2 | 55 | 26 | |||
12924 | 72281 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982929.24288 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | 11 | 6 | 2 | 55 | 26 | |||
13147 | 78531 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 501 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010098.32429 | 2092174.05375 | 37.7252813528324 | -122.407255101567 | (37.7252813528324, -122.407255101567) | 10 | 3 | 7 | 309 | 28 | |||
13286 | 12121 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1400X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6016540.00349 | 2094984.34395 | 37.7333562692663 | -122.385182357979 | (37.7333562692663, -122.385182357979) | 10 | 3 | 8 | 58 | 1 | |||
13312 | 78262 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 501 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010118.26182 | 2092179.11054 | 37.7252963535388 | -122.407186535437 | (37.7252963535388, -122.407186535437) | 10 | 3 | 7 | 309 | 28 | |||
13522 | 253158 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 700 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 07:47:00 AM | 3 | 3x3 | 6004446 | 2092174 | 37.7249632430066 | -122.426794641082 | (37.7249632430066, -122.426794641082) | 9 | 7 | 6 | 28861 | 5 | ||
13558 | 262071 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
13701 | 112515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2646 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6000218.93903 | 2118886.71439 | 37.7980698532985 | -122.443324869154 | (37.7980698532985, -122.443324869154) | 13 | 9 | 1 | 57 | 17 | |||
14137 | 146694 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 771 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2019 12:00:00 AM | 3 | Width 3ft | 5985370.98107 | 2110639.11062 | 37.7745664475164 | -122.494094186017 | (37.7745664475164, -122.494094186017) | 11 | 6 | 2 | 55 | 26 | ||
14220 | 198261 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 401 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015349.85102 | 2107166.49289 | 37.7667399832017 | -122.390147846856 | (37.7667399832017, -122.390147846856) | 14 | 3 | 9 | 310 | 29 | |||
14993 | 262065 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
15066 | 262075 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 15 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
15112 | 122876 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2701X Alemany Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997494 | 2087981 | 37.7130547225267 | -122.450524664488 | (37.7130547225267, -122.450524664488) | 9 | 7 | 6 | 28861 | 25 | ||||
15131 | 242346 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1353 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006282.63157 | 2108802.50666 | 37.7707250086772 | -122.421626092471 | (37.7707250086772, -122.421626092471) | 8 | 2 | 9 | 28853 | 19 | |||
15260 | 143979 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 742 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2019 12:00:00 AM | 3 | Width 4ft | 5985411.16302 | 2110814.81325 | 37.7750512279633 | -122.493968142431 | (37.7750512279633, -122.493968142431) | 11 | 6 | 2 | 55 | 26 | |
15661 | 242884 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 798 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007497.35986 | 2105057.20463 | 37.7605097057872 | -122.417158883772 | (37.7605097057872, -122.417158883772) | 2 | 4 | 7 | 28859 | 19 | |||
15672 | 75766 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009894.26848 | 2094011.07374 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | 10 | 3 | 7 | 309 | 28 | |||
16306 | 260886 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 709 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985981.28564 | 2111059.97075 | 37.7757577023633 | -122.492014045289 | (37.7757577023633, -122.492014045289) | 11 | 6 | 2 | 55 | 26 | |||
16459 | 136926 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3835 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6000573.99959 | 2121502.15962 | 37.805271409309 | -122.442284116143 | (37.805271409309, -122.442284116143) | 13 | 9 | 1 | 57 | 17 | |||
16468 | 21845 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 211X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 5994919.33893 | 2111427.06219 | 37.7772840400997 | -122.461121905578 | (37.7772840400997, -122.461121905578) | 11 | 6 | 2 | 54 | 11 | |||
16493 | 137733 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000662.3069 | 2112624.2642 | 37.7809000665618 | -122.441341105044 | (37.7809000665618, -122.441341105044) | 15 | 5 | 1 | 29490 | 16 | |||
16840 | 180428 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 223 San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001082.08541 | 2092350.7648 | 37.7252578292825 | -122.438435950363 | (37.7252578292825, -122.438435950363) | 9 | 7 | 6 | 28861 | 25 | |||
17222 | 78535 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 62 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007981.72204 | 2093794.71481 | 37.7296126541786 | -122.41468665108 | (37.7296126541786, -122.41468665108) | 9 | 3 | 7 | 309 | 28 | |||
17278 | 198390 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 120 Minna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6011047.10464 | 2113083.17782 | 37.7827462455888 | -122.405447134184 | (37.7827462455888, -122.405447134184) | 12 | 2 | 9 | 28853 | 34 | |||
17370 | 25217 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2395 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5992118.57098 | 2094231.7213 | 37.7299085366508 | -122.469558520109 | (37.7299085366508, -122.469558520109) | 9 | 8 | 4 | 59 | 40 |
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) );