trees
1,377 rows where qSpecies_id = 61
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19333 | 244143 | DPW Maintained 1 | Tristania conferta :: 61 | 423 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004418.4707 | 2109613.03 | 37.7728452161751 | -122.428132029093 | (37.7728452161751, -122.428132029093) | 7 | 9 | 11 | 28852 | 10 | |||
19450 | 200924 | DPW Maintained 1 | Tristania conferta :: 61 | 4100 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015492.5641 | 2097476.9144 | 37.7401423621251 | -122.38897764491 | (37.7401423621251, -122.38897764491) | 10 | 3 | 8 | 58 | 1 | |||
19570 | 7045 | DPW Maintained 1 | Tristania conferta :: 61 | 1300 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001075.5825 | 2110054.6953 | 37.7738682146278 | -122.439727109686 | (37.7738682146278, -122.439727109686) | 15 | 5 | 11 | 29492 | 10 | ||
19744 | 138921 | DPW Maintained 1 | Tristania conferta :: 61 | 631 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004505.2517 | 2110712.757 | 37.7758697074358 | -122.427910221054 | (37.7758697074358, -122.427910221054) | 7 | 9 | 11 | 28852 | 10 | |||
19778 | 137930 | DPW Maintained 1 | Tristania conferta :: 61 | 1977 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004477.3196 | 2115333.9095 | 37.7885566643943 | -122.428336281189 | (37.7885566643943, -122.428336281189) | 13 | 9 | 11 | 28858 | 27 | |||
19889 | 248530 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.451165239168 | (37.7674964457612, -122.451165239168) | 15 | 5 | 11 | 29492 | 9 | |||
19972 | 200895 | DPW Maintained 1 | Tristania conferta :: 61 | 4247 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015445.3265 | 2097019.6548 | 37.7388842023405 | -122.389109055705 | (37.7388842023405, -122.389109055705) | 10 | 3 | 8 | 58 | 1 | |||
20396 | 246241 | DPW Maintained 1 | Tristania conferta :: 61 | 1395 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999547.9215 | 2107815.4823 | 37.7676328306769 | -122.444850527256 | (37.7676328306769, -122.444850527256) | 15 | 5 | 11 | 29492 | 9 | |||
20401 | 140131 | Permitted Site 7 | Tristania conferta :: 61 | 501 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 5 | Width 0ft | 6005847.0047 | 2111508.1975 | 37.7781296085056 | -122.423325305774 | (37.7781296085056, -122.423325305774) | 7 | 9 | 11 | 28852 | 10 | ||
20510 | 142108 | DPW Maintained 1 | Tristania conferta :: 61 | 758 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001607.3106 | 2111115.6492 | 37.7768115789366 | -122.437963788403 | (37.7768115789366, -122.437963788403) | 15 | 5 | 11 | 29492 | 10 | |||
20544 | 200187 | DPW Maintained 1 | Tristania conferta :: 61 | 2999 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014602.6431 | 2090373.0881 | 37.720587322073 | -122.391558129174 | (37.720587322073, -122.391558129174) | 10 | 3 | 8 | 58 | 1 | |||
20668 | 142244 | DPW Maintained 1 | Tristania conferta :: 61 | 419 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005364 | 2110769 | 37.7760726809274 | -122.424943590033 | (37.7760726809274, -122.424943590033) | 7 | 9 | 11 | 28852 | 10 | |||
20708 | 200514 | DPW Maintained 1 | Tristania conferta :: 61 | 5701 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6013926.9791 | 2092225.4991 | 37.7256361452498 | -122.39402331403 | (37.7256361452498, -122.39402331403) | 10 | 3 | 8 | 58 | 1 | |||
21270 | 139936 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005717.7716 | 2112456.4224 | 37.7807259079437 | -122.423839812492 | (37.7807259079437, -122.423839812492) | 7 | 9 | 11 | 28852 | 41 | |||
21423 | 143427 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.7932130339503 | -122.407090272453 | (37.7932130339503, -122.407090272453) | 3 | 1 | 10 | 28857 | 4 | |||
21688 | 24501 | DPW Maintained 1 | Tristania conferta :: 61 | 901 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003042.5941 | 2110274.0021 | 37.7745821407981 | -122.43293857186 | (37.7745821407981, -122.43293857186) | 15 | 5 | 11 | 29492 | 10 | ||
21708 | 30437 | DPW Maintained 1 | Tristania conferta :: 61 | 567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046 | (37.8004413456091, -122.40871589046) | 3 | 1 | 10 | 308 | 23 | ||
21816 | 29421 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6015238.3862 | 2091224.5002 | 37.7229603992916 | -122.389419974154 | (37.7229603992916, -122.389419974154) | 10 | 3 | 8 | 58 | 1 | ||
21861 | 22334 | DPW Maintained 1 | Tristania conferta :: 61 | 5201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/2015 02:59:00 PM | 3 | 3X3 | 6014532.0059 | 2093984.9826 | 37.7305009408534 | -122.392054756971 | (37.7305009408534, -122.392054756971) | 10 | 3 | 8 | 58 | 1 | ||
22006 | 6951 | DPW Maintained 1 | Tristania conferta :: 61 | 603 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/1990 12:00:00 AM | 6 | 3x3 | 6004469.2574 | 2110472.8506 | 37.7752089468863 | -122.428017634821 | (37.7752089468863, -122.428017634821) | 7 | 9 | 11 | 28852 | 10 | ||
22022 | 30026 | DPW Maintained 1 | Tristania conferta :: 61 | 6190X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6013442.0581 | 2091191.4573 | 37.7227699118645 | -122.395627242562 | (37.7227699118645, -122.395627242562) | 10 | 3 | 8 | 58 | 1 | ||
22324 | 141816 | DPW Maintained 1 | Tristania conferta :: 61 | 1218 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004565.725 | 2112968.4018 | 37.7820665729689 | -122.427861790691 | (37.7820665729689, -122.427861790691) | 7 | 9 | 11 | 29490 | 41 | |||
22349 | 29469 | DPW Maintained 1 | Tristania conferta :: 61 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.384094597711 | (37.7288867261126, -122.384094597711) | 10 | 3 | 8 | 58 | 1 | ||
22456 | 25279 | DPW Maintained 1 | Tristania conferta :: 61 | 1940 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993856.5207 | 2092712.5569 | 37.7258375734043 | -122.463440067194 | (37.7258375734043, -122.463440067194) | 9 | 8 | 4 | 59 | 40 | |||
22745 | 200928 | DPW Maintained 1 | Tristania conferta :: 61 | 4101 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015535.5503 | 2097321.9752 | 37.7397193134396 | -122.388818200912 | (37.7397193134396, -122.388818200912) | 10 | 3 | 8 | 58 | 1 | |||
22953 | 244944 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005861.1541 | 2110670.4754 | 37.775830225555 | -122.423216794436 | (37.775830225555, -122.423216794436) | 7 | 9 | 11 | 28852 | 10 | |||
23140 | 142358 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005410.0165 | 2113384.468 | 37.7832567141838 | -122.424970534924 | (37.7832567141838, -122.424970534924) | 7 | 9 | 11 | 28858 | 41 | |||
23142 | 22404 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6013789.3037 | 2092097.7658 | 37.7252777625947 | -122.394490310229 | (37.7252777625947, -122.394490310229) | 10 | 3 | 8 | 58 | 1 | |||
23279 | 22495 | DPW Maintained 1 | Tristania conferta :: 61 | 6315 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | 6013233.044 | 2090405.2973 | 37.7205996457096 | -122.396294690849 | (37.7205996457096, -122.396294690849) | 10 | 3 | 8 | 58 | 1 | ||
23304 | 29532 | DPW Maintained 1 | Tristania conferta :: 61 | 2302X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015618.3638 | 2091811.707 | 37.7245938134403 | -122.388147417672 | (37.7245938134403, -122.388147417672) | 10 | 3 | 8 | 58 | 1 | ||
23416 | 201883 | DPW Maintained 1 | Tristania conferta :: 61 | 199 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015205.3081 | 2115545.7503 | 37.7897395282145 | -122.391233582889 | (37.7897395282145, -122.391233582889) | 6 | 2 | 9 | 28855 | 6 | |||
23965 | 141511 | DPW Maintained 1 | Tristania conferta :: 61 | 29 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997955.5108 | 2111504.1279 | 37.7776698962407 | -122.450624415537 | (37.7776698962407, -122.450624415537) | 15 | 6 | 2 | 54 | 16 | |||
24168 | 142357 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005388.7452 | 2113384.468 | 37.7832555126318 | -122.425044125193 | (37.7832555126318, -122.425044125193) | 7 | 9 | 11 | 28858 | 41 | |||
24345 | 29560 | DPW Maintained 1 | Tristania conferta :: 61 | 3100X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 16 | 3X3 | 6014251.2078 | 2089975.3633 | 37.7194757354442 | -122.39274513029 | (37.7194757354442, -122.39274513029) | 10 | 3 | 8 | 58 | 1 | ||
24535 | 141271 | DPW Maintained 1 | Tristania conferta :: 61 | 381 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997841.2227 | 2112537.9666 | 37.7805020054221 | -122.45109434754 | (37.7805020054221, -122.45109434754) | 15 | 6 | 2 | 54 | 16 | |||
24537 | 142352 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005138.142 | 2113344.5842 | 37.783131842304 | -122.425908272817 | (37.783131842304, -122.425908272817) | 7 | 9 | 11 | 28858 | 41 | |||
24618 | 51914 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406377 | (37.8007048866604, -122.43013406377) | 13 | 9 | 1 | 57 | 17 | |
24694 | 200893 | DPW Maintained 1 | Tristania conferta :: 61 | 825 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015466.1111 | 2097093.8178 | 37.7390889909368 | -122.389042368279 | (37.7390889909368, -122.389042368279) | 10 | 3 | 8 | 58 | 1 | |||
24711 | 138398 | DPW Maintained 1 | Tristania conferta :: 61 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.7876414218449 | -122.435543840756 | (37.7876414218449, -122.435543840756) | 13 | 6 | 11 | 29490 | 27 | |||
24759 | 200143 | DPW Maintained 1 | Tristania conferta :: 61 | 6215 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6013445.5739 | 2090955.2697 | 37.7221215837156 | -122.395598549244 | (37.7221215837156, -122.395598549244) | 10 | 3 | 8 | 58 | 1 | |||
24778 | 115380 | Permitted Site 7 | Tristania conferta :: 61 | 1657X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
25002 | 141440 | DPW Maintained 1 | Tristania conferta :: 61 | 10 Roselyn Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998236.4031 | 2111655.6366 | 37.7781019737431 | -122.449663638425 | (37.7781019737431, -122.449663638425) | 15 | 6 | 2 | 54 | 16 | |||
25025 | 12266 | DPW Maintained 1 | Tristania conferta :: 61 | 649 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1991 12:00:00 AM | 16 | 3X3 | 6004915.2268 | 2111219.2684 | 37.7772836485499 | -122.426528085844 | (37.7772836485499, -122.426528085844) | 7 | 9 | 11 | 28852 | 10 | ||
25063 | 139453 | DPW Maintained 1 | Tristania conferta :: 61 | 901 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001959.1383 | 2111617.5381 | 37.7782096409436 | -122.436782648878 | (37.7782096409436, -122.436782648878) | 15 | 5 | 11 | 29490 | 41 | |||
25196 | 138756 | DPW Maintained 1 | Tristania conferta :: 61 | 2323 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001466.9262 | 2114221.5245 | 37.7853315391503 | -122.438672022334 | (37.7853315391503, -122.438672022334) | 15 | 6 | 11 | 29490 | 13 | |||
25766 | 245935 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997227.0394 | 2107780.5055 | 37.7674040687868 | -122.452875596673 | (37.7674040687868, -122.452875596673) | 15 | 5 | 11 | 29492 | 9 | |||
25849 | 10432 | DPW Maintained 1 | Tristania conferta :: 61 | 1441 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1999 12:00:00 AM | 18 | 3X3 | 5999180.1356 | 2108696.8663 | 37.7700318922285 | -122.446186054388 | (37.7700318922285, -122.446186054388) | 15 | 5 | 11 | 29492 | 9 | ||
25859 | 140097 | DPW Maintained 1 | Tristania conferta :: 61 | 515 GOUGH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005837.56 | 2111570.1127 | 37.7782990795293 | -122.423362381053 | (37.7782990795293, -122.423362381053) | 7 | 9 | 11 | 28852 | 10 | |||
25862 | 29433 | DPW Maintained 1 | Tristania conferta :: 61 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) | 10 | 3 | 8 | 58 | 1 | ||
26175 | 138912 | DPW Maintained 1 | Tristania conferta :: 61 | 719 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004292.6341 | 2110798.4737 | 37.7760930338959 | -122.428651831595 | (37.7760930338959, -122.428651831595) | 7 | 9 | 11 | 28852 | 10 | |||
26320 | 6186 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005445.8524 | 2113436.2606 | 37.783400948036 | -122.424850242823 | (37.783400948036, -122.424850242823) | 7 | 9 | 11 | 28858 | 41 | |||
26470 | 200925 | DPW Maintained 1 | Tristania conferta :: 61 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | 10 | 3 | 8 | 58 | 1 | ||
26472 | 6077 | DPW Maintained 1 | Tristania conferta :: 61 | 1966 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2007 12:00:00 AM | 18 | 4X4 | 6001073.8278 | 2112479.7581 | 37.7805267238289 | -122.439907091482 | (37.7805267238289, -122.439907091482) | 15 | 5 | 11 | 29490 | 41 | ||
26474 | 6905 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005791.8208 | 2110660.0754 | 37.7757977566382 | -122.423455896757 | (37.7757977566382, -122.423455896757) | 7 | 9 | 11 | 28852 | 10 | |||
26557 | 7067 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5999719.0796 | 2109864.829 | 37.7732695858551 | -122.444405811275 | (37.7732695858551, -122.444405811275) | 15 | 5 | 11 | 29492 | 16 | ||
26593 | 65948 | DPW Maintained 1 | Tristania conferta :: 61 | 550 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 12 | Permit Number 28969 | 6007606.7794 | 2113206.8791 | 37.7828929393541 | -122.417358003683 | (37.7828929393541, -122.417358003683) | 7 | 9 | 9 | 28852 | 36 | |
26636 | 29439 | DPW Maintained 1 | Tristania conferta :: 61 | 2303X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015640.8979 | 2091772.6846 | 37.7244879141293 | -122.388066797622 | (37.7244879141293, -122.388066797622) | 10 | 3 | 8 | 58 | 1 | ||
26662 | 139042 | DPW Maintained 1 | Tristania conferta :: 61 | 1434 BAKER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6000193.0745 | 2113977.6097 | 37.7845892631082 | -122.443061626662 | (37.7845892631082, -122.443061626662) | 15 | 6 | 11 | 29490 | 13 | |||
26711 | 6184 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | 7 | 9 | 11 | 28858 | 41 | |||
26846 | 15288 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.7721477499918 | -122.419195888407 | (37.7721477499918, -122.419195888407) | 8 | 2 | 9 | 28853 | 19 | ||
26936 | 10692 | DPW Maintained 1 | Tristania conferta :: 61 | 1249 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001880.3859 | 2110463.9678 | 37.7750377503654 | -122.436972474402 | (37.7750377503654, -122.436972474402) | 15 | 5 | 11 | 29492 | 10 | |||
27028 | 68142 | DPW Maintained 1 | Tristania conferta :: 61 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | 15 | 6 | 1 | 29490 | 27 | |
27103 | 200991 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015446.9463 | 2115775.0495 | 37.7903825381625 | -122.390413559192 | (37.7903825381625, -122.390413559192) | 6 | 2 | 9 | 28855 | 6 | |||
27170 | 68157 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1994 12:00:00 AM | 8 | Permit Number 33474 | 6005184.9642 | 2114742.2338 | 37.7869720870456 | -122.425845804507 | (37.7869720870456, -122.425845804507) | 13 | 9 | 11 | 28858 | 13 | ||
27181 | 9604 | DPW Maintained 1 | Tristania conferta :: 61 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | 15 | 9 | 11 | 29490 | 41 | |||
27258 | 139975 | DPW Maintained 1 | Tristania conferta :: 61 | 1000 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001951.2709 | 2111948.8589 | 37.7791189172983 | -122.436833589276 | (37.7791189172983, -122.436833589276) | 15 | 5 | 11 | 29490 | 41 | |||
27373 | 139930 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005698.3365 | 2112597.5586 | 37.7811123361694 | -122.423917086976 | (37.7811123361694, -122.423917086976) | 7 | 9 | 11 | 28852 | 41 | |||
27421 | 140039 | DPW Maintained 1 | Tristania conferta :: 61 | 555 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005821.2941 | 2111685.5479 | 37.7786151184258 | -122.423426859428 | (37.7786151184258, -122.423426859428) | 7 | 9 | 11 | 28852 | 10 | |||
27583 | 140342 | DPW Maintained 1 | Tristania conferta :: 61 | 1335 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004604.4556 | 2113518.6258 | 37.7835795423556 | -122.42776701682 | (37.7835795423556, -122.42776701682) | 7 | 9 | 11 | 29490 | 41 | |||
27653 | 141272 | DPW Maintained 1 | Tristania conferta :: 61 | 365 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997908.5687 | 2112548.4577 | 37.7805346667324 | -122.450862123717 | (37.7805346667324, -122.450862123717) | 15 | 6 | 2 | 54 | 16 | |||
27716 | 15565 | DPW Maintained 1 | Tristania conferta :: 61 | 2871 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6007116.1618 | 2101629.0258 | 37.7510752616521 | -122.418234216284 | (37.7510752616521, -122.418234216284) | 2 | 4 | 7 | 28859 | 19 | ||
27759 | 245990 | DPW Maintained 1 | Tristania conferta :: 61 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.7694936874367 | -122.443942497819 | (37.7694936874367, -122.443942497819) | 15 | 5 | 11 | 29492 | 9 | |
27995 | 139342 | DPW Maintained 1 | Tristania conferta :: 61 | 1400 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005040.0715 | 2114155.1684 | 37.7853519625541 | -122.426305287483 | (37.7853519625541, -122.426305287483) | 13 | 9 | 11 | 28858 | 13 | |||
28057 | 29382 | DPW Maintained 1 | Tristania conferta :: 61 | 3199X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014237.1991 | 2089885.2205 | 37.7192274430768 | -122.392787250675 | (37.7192274430768, -122.392787250675) | 10 | 3 | 8 | 58 | 1 | ||
28143 | 7043 | Permitted Site 7 | Tristania conferta :: 61 | 1300 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2010 12:00:00 AM | 12 | 3X3 | 6001130.7028 | 2110062.144 | 37.773891804124 | -122.439536974078 | (37.773891804124, -122.439536974078) | 15 | 5 | 11 | 29492 | 10 | ||
28152 | 138780 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003615.8018 | 2114245.3723 | 37.785519029862 | -122.431239269571 | (37.785519029862, -122.431239269571) | 13 | 9 | 11 | 29490 | 13 | |||
28177 | 22470 | DPW Maintained 1 | Tristania conferta :: 61 | 6227 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/1995 12:00:00 AM | 5 | 3x3 | 6013423.3351 | 2090899.6727 | 37.7219676884588 | -122.395671530407 | (37.7219676884588, -122.395671530407) | 10 | 3 | 8 | 58 | 1 | ||
28272 | 141813 | DPW Maintained 1 | Tristania conferta :: 61 | 631 WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004531.7581 | 2113098.1631 | 37.7824209436961 | -122.42798855036 | (37.7824209436961, -122.42798855036) | 7 | 9 | 11 | 29490 | 41 | |||
28616 | 248567 | DPW Maintained 1 | Tristania conferta :: 61 | 809 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997620.5658 | 2107720.8482 | 37.7672628081675 | -122.451510146252 | (37.7672628081675, -122.451510146252) | 15 | 5 | 11 | 29492 | 9 | |||
29000 | 142193 | DPW Maintained 1 | Tristania conferta :: 61 | 1642 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999555.7794 | 2109844.0818 | 37.7732033006663 | -122.444969195074 | (37.7732033006663, -122.444969195074) | 15 | 5 | 11 | 29492 | 16 | |||
29504 | 138720 | DPW Maintained 1 | Tristania conferta :: 61 | 2921 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:10:00 PM | 2 | Width 0ft | 5999959.1608 | 2114707.5789 | 37.7865802293131 | -122.443923351787 | (37.7865802293131, -122.443923351787) | 15 | 6 | 1 | 29490 | 31 | ||
29646 | 10511 | DPW Maintained 1 | Tristania conferta :: 61 | 1800 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2007 12:00:00 AM | 6 | 3X3 | 5997484.5237 | 2108509.319 | 37.7694199557275 | -122.452037587086 | (37.7694199557275, -122.452037587086) | 15 | 5 | 11 | 29492 | 9 | ||
29736 | 12282 | DPW Maintained 1 | Tristania conferta :: 61 | 745 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x10 | 6004875.3929 | 2111529.8441 | 37.7781341613075 | -122.426688006249 | (37.7781341613075, -122.426688006249) | 7 | 9 | 11 | 28852 | 10 | |||
30175 | 139929 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005694.4032 | 2112619.0761 | 37.7811711958921 | -122.423932224805 | (37.7811711958921, -122.423932224805) | 7 | 9 | 11 | 28852 | 41 | |||
30192 | 184232 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983211.3452 | 2104903.2019 | 37.7586906757833 | -122.501140335143 | (37.7586906757833, -122.501140335143) | 1 | 8 | 3 | 56 | 35 | |||
30243 | 13145 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | 13 | 9 | 1 | 57 | 17 | ||
30290 | 13100 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852 | -122.426586143087 | (37.800932566852, -122.426586143087) | 13 | 9 | 1 | 57 | 17 | ||
30389 | 29432 | DPW Maintained 1 | Tristania conferta :: 61 | 2401X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015452.0518 | 2091514.7509 | 37.7237692145382 | -122.38870162152 | (37.7237692145382, -122.38870162152) | 10 | 3 | 8 | 58 | 1 | ||
30412 | 139853 | DPW Maintained 1 | Tristania conferta :: 61 | 735 GOUGH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005744.0619 | 2112263.2548 | 37.7801970011251 | -122.423735122838 | (37.7801970011251, -122.423735122838) | 7 | 9 | 11 | 28852 | 41 | |||
30494 | 199816 | DPW Maintained 1 | Tristania conferta :: 61 | 2240 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015734.8816 | 2091975.4915 | 37.7250499884833 | -122.387756049526 | (37.7250499884833, -122.387756049526) | 10 | 3 | 8 | 58 | 1 | |||
30683 | 6223 | DPW Maintained 1 | Tristania conferta :: 61 | 1220 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/1997 12:00:00 AM | 12 | 3X4 | 6005122.7706 | 2113389.4093 | 37.7832540522328 | -122.425964643575 | (37.7832540522328, -122.425964643575) | 7 | 9 | 11 | 28858 | 41 | ||
30694 | 248608 | DPW Maintained 1 | Tristania conferta :: 61 | 432 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997774.403 | 2107510.382 | 37.7666937298525 | -122.450962870008 | (37.7666937298525, -122.450962870008) | 15 | 5 | 11 | 29492 | 9 | |||
31069 | 50648 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | 6 | 2 | 9 | 28856 | 34 | ||
31234 | 141807 | DPW Maintained 1 | Tristania conferta :: 61 | 1398 WILLOW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004301.1437 | 2113069.4068 | 37.7823289364611 | -122.428784324512 | (37.7823289364611, -122.428784324512) | 7 | 9 | 11 | 29490 | 41 | |||
31384 | 61393 | DPW Maintained 1 | Tristania conferta :: 61 | 926 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50349 | 5990253.2983 | 2099081.9773 | 37.7431181185655 | -122.476361078322 | (37.7431181185655, -122.476361078322) | 1 | 8 | 3 | 29491 | 35 | |
31489 | 8187 | DPW Maintained 1 | Tristania conferta :: 61 | 1255 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001743.6158 | 2111134.8252 | 37.7768719817661 | -122.437493642173 | (37.7768719817661, -122.437493642173) | 15 | 5 | 11 | 29492 | 10 | |||
31759 | 141280 | DPW Maintained 1 | Tristania conferta :: 61 | 327 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998124.1433 | 2112580.2694 | 37.7806343517008 | -122.450118646064 | (37.7806343517008, -122.450118646064) | 15 | 6 | 2 | 54 | 16 | |||
31794 | 13264 | DPW Maintained 1 | Tristania conferta :: 61 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | 13 | 9 | 1 | 57 | 17 | ||
31804 | 7089 | DPW Maintained 1 | Tristania conferta :: 61 | 1874 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5998459.5467 | 2109686.5004 | 37.7727079965007 | -122.448749840415 | (37.7727079965007, -122.448749840415) | 15 | 5 | 11 | 29492 | 16 | ||
31903 | 138226 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998572.2138 | 2112635.4321 | 37.7808114442344 | -122.448572536471 | (37.7808114442344, -122.448572536471) | 15 | 6 | 2 | 54 | 16 |
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) );